Zikula\RoutesModule\RoutesModuleInstaller::upgrade()

Complexity

Conditions	5
Paths	5

Size

Total Lines	35
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function upgrade($oldVersion)
    {
        switch ($oldVersion) {
            case '1.0.0':

There must be a comment when fall-through is intentional in a non-empty case body

                // routes of system modules are not stored in database anymore
                $sql = '
                    DELETE FROM `zikula_routes_route`
                    WHERE `userRoute` = 0
                ';
                $this->entityManager->getConnection()->exec($sql);

                // update table to meet entity structure
                $this->schemaTool->update(['Zikula\RoutesModule\Entity\Historical\v110\RouteEntity']);
            case '1.0.1':
                // nothing
            case '1.1.0':

There must be a comment when fall-through is intentional in a non-empty case body

                // rename createdUserId field to createdBy_id
                $sql = '
                    ALTER TABLE `zikula_routes_route`
                    CHANGE `createdUserId` `createdBy_id` int(11) NOT NULL
                ';
                $this->entityManager->getConnection()->exec($sql);

                // rename updatedUserId field to updatedBy_id
                $sql = '
                    ALTER TABLE `zikula_routes_route`
                    CHANGE `updatedUserId` `updatedBy_id` int(11) NOT NULL
                ';
                $this->entityManager->getConnection()->exec($sql);
            case '1.1.1':
                // current version
        }

        return true;
    }
}