FixLongPmaVersions

Complexity

Total Complexity

5

Size/Duplication

Total Lines	48
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	2	1
A	up()	0	9	1
A	_sanitizeVersionsInTable()	0	23	3

<?php

use Phinx\Migration\AbstractMigration;
use Cake\ORM\Locator\TableLocator;
use Cake\Log\Log;

class FixLongPmaVersions extends AbstractMigration
{

    /**
     * This migration strips the phpMyAdmin version of Debian,
     * Ubuntu and other suffixes in version strings
     *
     */
    public function up()
    {
        // Strip phpMyAdmin versions in `reports` table
        $count = $this->_sanitizeVersionsInTable('reports');
        Log::debug($count . ' reports updated');

        // Strip phpMyAdmin versions in `incidents` table
        $count = $this->_sanitizeVersionsInTable('incidents');
        Log::debug($count . ' incidents updated');
    }

    public function down()
    {
        // Once applied, this migration can't be reversed
        // but the migration itself is idempotent
    }

    private function _sanitizeVersionsInTable($table)
    {
        $sql = 'SELECT `id`, `pma_version` FROM `' . $table . '`';
        $count = 0;
        $incidentsTable = TableRegistry::get('Incidents');

The type TableRegistry was not found. Maybe you did not declare it correctly or list all dependencies?

        $result = $this->query($sql);

        while ($row = $result->fetch()) {
            $strippedVersionString
                = $incidentsTable->getStrippedPmaVersion(
                    $row['pma_version']
                );

            if ($strippedVersionString !== $row['pma_version']) {
                $this->execute('UPDATE ' . $table . ' SET `pma_version` = \''
                    . $strippedVersionString . '\' WHERE `id` = \''
                    . $row['id'] . '\'');

                ++$count;
            }
        }

        return $count;
    }
}