Yapeal\Configuration\SqlWiring::wire()

Complexity

Conditions	7
Paths	8

Size

Total Lines	79
Code Lines	49

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    public function wire(ContainerInterface $dic)
    {
        if (empty($dic['Yapeal.Sql.CommonQueries'])) {
            $dic['Yapeal.Sql.CommonQueries'] = function ($dic) {
                return new $dic['Yapeal.Sql.sharedSql'](
                    $dic['Yapeal.Sql.database'], $dic['Yapeal.Sql.tablePrefix']
                );
            };
        }
        if (!empty($dic['Yapeal.Sql.Connection'])) {
            return $this;
        }
        if ('mysql' !== $dic['Yapeal.Sql.platform']) {
            $mess = 'Unknown platform, was given ' . $dic['Yapeal.Sql.platform'];
            throw new YapealDatabaseException($mess);
        }
        $dic['Yapeal.Sql.Connection'] = function ($dic) {
            $dsn = $dic['Yapeal.Sql.platform'] . ':host=' . $dic['Yapeal.Sql.hostName'] . ';charset=utf8';
            if (!empty($dic['Yapeal.Sql.port'])) {
                $dsn .= ';port=' . $dic['Yapeal.Sql.port'];
            }
            /**
             * @var PDO $database
             */
            $database = new $dic['Yapeal.Sql.class'](
                $dsn, $dic['Yapeal.Sql.userName'], $dic['Yapeal.Sql.password']
            );
            $database->setAttribute(
                PDO::ATTR_ERRMODE,
                PDO::ERRMODE_EXCEPTION
            );
            $database->exec('SET SESSION SQL_MODE=\'ANSI,TRADITIONAL\'');
            $database->exec('SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE');
            $database->exec('SET SESSION TIME_ZONE=\'+00:00\'');
            $database->exec('SET NAMES utf8mb4 COLLATE utf8mb4_unicode_520_ci');
            $database->exec('SET COLLATION_CONNECTION=utf8mb4_unicode_520_ci');
            $database->exec('SET DEFAULT_STORAGE_ENGINE=' . $dic['Yapeal.Sql.engine']);
            return $database;
        };
        if (empty($dic['Yapeal.Sql.Creator'])) {
            $dic['Yapeal.Sql.Creator'] = $dic->factory(
                function ($dic) {
                    $loader = new Twig_Loader_Filesystem($dic['Yapeal.Sql.dir']);
                    $twig = new Twig_Environment(
                        $loader, ['debug' => true, 'strict_variables' => true, 'autoescape' => false]
                    );
                    $filter = new Twig_SimpleFilter(
                        'ucFirst', function ($value) {
                        return ucfirst($value);
                    }
                    );
                    $twig->addFilter($filter);
                    $filter = new Twig_SimpleFilter(
                        'lcFirst', function ($value) {
                        return lcfirst($value);
                    }
                    );
                    $twig->addFilter($filter);
                    /**
                     * @var \Yapeal\Sql\Creator $create
                     */
                    $create = new $dic['Yapeal.Sql.create']($twig, $dic['Yapeal.Sql.dir'], $dic['Yapeal.Sql.platform']);
                    if (array_key_exists('Yapeal.Create.overwrite', $dic)) {
                        $create->setOverwrite($dic['Yapeal.Create.overwrite']);
                    }
                    return $create;
                }
            );
        }
        /**
         * @var \Yapeal\Event\MediatorInterface $mediator
         */
        $mediator = $dic['Yapeal.Event.Mediator'];
        $mediator->addServiceSubscriberByEventList(
            'Yapeal.Sql.Creator',
            ['Yapeal.EveApi.create' => ['createSql', 'last']]
        );
        return $this;
    }
}