MigrationController::actionUpData() - Code Metrics - Inspection of "Get column comment" - tmukherjee13/yii2-reverse-migration - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Pull Request — master (#14)

unknown
created 2018-06-02 17:46 UTC
MigrationController::actionUpData() A

↳ Parent: Project
Complexity

Conditions	1
Paths	1
Size

Total Lines	5
Code Lines	3
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
dl	0
loc	5
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	3
nc	1
nop	1
<?php
namespace tmukherjee13\migration\console\controllers;

use Yii;
use yii\console\controllers\MigrateController;
use yii\console\Exception;
use yii\db\Connection;
use yii\db\Query;
use yii\helpers\ArrayHelper;
use yii\helpers\Console;
use yii\helpers\FileHelper;

class MigrationController extends MigrateController
{
    use \tmukherjee13\migration\console\components\Formatter;

    /**
     * @inheritdoc
     */
    public $defaultAction = 'migrate';

    /**
     * @var string a migration table name
     */
    public $migrationTable = 'migration';

    /**
     * @var string a migration path
     */
    public $migrationPath = "@app/migrations";

    /**
     * @var string путь к данным
     */
    public $dataMigrationFolder = 'data';

    /**
     * @var bool использовать путь к данным
     */
    public $useDataMigrationFolder = true;

    /** @var string template file to use for generation */
    public $templateFile = "@tmukherjee13/migration";

    /**
     * @var string class name
     */
    protected $class = "";

    /**
     * @var string table name
     */
    protected $table = "";

    /**
     * @var string table columns
     */
    public $fields = "";

    /**
     * @var string file name
     */
    protected $fileName = '';

    /**
     * @var Connection|string the DB connection object or the application component ID of the DB connection.
     */
    public $db = 'db';

    /**
     * @inheritdoc
     */
    public function options($actionID)
    {
        return array_merge(parent::options($actionID), ['migrationTable', 'db']);
    }

    /**
     * @inheritdoc
     */
    public function beforeAction($action)
    {

        if (parent::beforeAction($action)) {
            if (is_string($this->db)) {
                $this->db = Yii::$app->get($this->db);
            }
            if (!$this->db instanceof Connection) {
                throw new Exception("The 'db' option must refer to the application component ID of a DB connection.");
            }

            $path = (string)Yii::getAlias($this->migrationPath);


            if (!is_dir($path)) {
                if ($action->id !== 'table') {

                    throw new Exception("Migration failed. Directory specified in migrationPath doesn't exist: {$this->migrationPath}");
                }
                FileHelper::createDirectory($path);
            }
            $this->migrationPath = $path;

            $version = Yii::getVersion();
            $this->stdout("Yii Database Migration Tool (based on Yii v{$version})\n", Console::FG_YELLOW);

            return true;
        }
        return false;
    }

    /**
     * Collects the foreign key column details for the given table.
     * @param TableSchema $table the table metadata
     */
    protected function findConstraints($table)
    {
        $sql = <<<SQL
            SELECT
                kcu.constraint_name,
                kcu.column_name,
                kcu.referenced_table_name,
                kcu.referenced_column_name,
                rc.DELETE_RULE,
                rc.UPDATE_RULE

            FROM information_schema.referential_constraints AS rc
            JOIN information_schema.key_column_usage AS kcu ON
                (
                    kcu.constraint_catalog = rc.constraint_catalog OR
                    (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
                ) AND
                kcu.constraint_schema = rc.constraint_schema AND
                kcu.constraint_name = rc.constraint_name
            WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
            AND rc.table_name = :tableName AND kcu.table_name = :tableName
SQL;
        try {

            $rows = $this->db->createCommand($sql, [':tableName' => $table->name])->queryAll();

            $constraints        = [];
            $table->foreignKeys = [];
            foreach ($rows as $row) {
                $constraints[$row['constraint_name']]['referenced_table_name']        = $row['referenced_table_name'];
                $constraints[$row['constraint_name']]['columns'][$row['column_name']] = $row['referenced_column_name'];

                $table->foreignKeys[$row['constraint_name']]['table']      = $row['referenced_table_name'];
                $table->foreignKeys[$row['constraint_name']]['column']     = $row['column_name'];
                $table->foreignKeys[$row['constraint_name']]['ref_column'] = $row['referenced_column_name'];
                $table->foreignKeys[$row['constraint_name']]['delete']     = $row['DELETE_RULE'];
                $table->foreignKeys[$row['constraint_name']]['update']     = $row['UPDATE_RULE'];
            }

            return $constraints;
        } catch (\Exception $e) {
            $previous = $e->getPrevious();
            if (!$previous instanceof \PDOException || strpos($previous->getMessage(), 'SQLSTATE[42S02') === false) {
                throw $e;
            }

            // table does not exist, try to determine the foreign keys using the table creation sql
            $sql    = $this->getCreateTableSql($table);
            $regexp = '/FOREIGN KEY\s+\(([^\)]+)\)\s+REFERENCES\s+([^\(^\s]+)\s*\(([^\)]+)\)/mi';
            if (preg_match_all($regexp, $sql, $matches, PREG_SET_ORDER)) {
                foreach ($matches as $match) {
                    $fks        = array_map('trim', explode(',', str_replace('`', '', $match[1])));
                    $pks        = array_map('trim', explode(',', str_replace('`', '', $match[3])));
                    $constraint = [str_replace('`', '', $match[2])];
                    foreach ($fks as $k => $name) {
                        $constraint[$name] = $pks[$k];
                    }
                    $table->foreignKeys[md5(serialize($constraint))] = $constraint;
                }
                $table->foreignKeys = array_values($table->foreignKeys);
            }
        }
    }

    /**
     * Gets the CREATE TABLE sql string.
     * @param TableSchema $table the table metadata
     * @return string $sql the result of 'SHOW CREATE TABLE'
     */
    protected function getCreateTableSql($table)
    {
        $row = $this->db->createCommand('SHOW CREATE TABLE ' . $this->quoteTableName($table->fullName))->queryOne();
        if (isset($row['Create Table'])) {
            $sql = $row['Create Table'];
        } else {
            $row = array_values($row);
            $sql = $row[1];
        }
        return $sql;
    }

    public function quoteTableName($name)
    {
        return strpos($name, '`') !== false ? $name : "`$name`";
    }

    /**
     * Up data
     *
     * @param int $limit
     * @return int
     */
    public function actionUpData($limit = 0)
    {
        $this->migrationPath .= DIRECTORY_SEPARATOR . $this->dataMigrationFolder;
        return parent::actionUp($limit);
class Daddy
{
    protected function getFirstName()
    {
        return "Eidur";
    }

    protected function getSurName()
    {
        return "Gudjohnsen";
    }
}

class Son
{
    public function getFirstName()
    {
        return parent::getSurname();
    }
}
    }

    /**
     * Creates migration based on table
     * @method actionTable
     * @param  array       $tables Name of the table to create migration
     * @return mixed
     * @author Tarun Mukherjee (https://github.com/tmukherjee13)
     */

    public function actionTable(array $tables)
    {

        if ($this->confirm('Create the migration ' . "?")) {

            foreach ($tables as $key => $tableName) {

                $this->class = 'create_table_' . $tableName;

                try {

                    $table = $this->db->getTableSchema($tableName);
                } catch (Exception $e) {
                    throw new Exception("There has been an error processing the file. Please try after some time.");
                }

                if (empty($table)) {
                    throw new Exception("Table doesn't exists");
                }
                $this->findConstraints($table);

                $this->getCreateTableSql($table);

                $compositePrimaryKeyCols = array();

                $addForeignKeys  = "";
                $dropForeignKeys = "";
                $up              = "";

                $this->table = $this->getTableName($table);

                foreach ($table->columns as $col) {
                    $up .= "\t\t\t" . '\'' . $col->name . '\'=>"' . $this->getColType($col) . '",' . "\n";
                    if ($col->isPrimaryKey) {
                        // Add column to composite primary key array
                        $compositePrimaryKeyCols[] = $col->name;
                    }
                }

                $ukeys = $this->db->schema->findUniqueIndexes($table);
                if (!empty($ukeys)) {
                    $indexArr =[];
                    foreach ($ukeys as $key => $value) {
                        $indexKey = $key;
                        foreach ($value as $id => $field) {
                            $indexArr[] = $field;
                        }
                    }
                    $indexStr = implode(',', $indexArr);
                    $up .= "\t\t" . '$this->createIndex(\'idx_' . $indexKey . "', '" . $this->getTableName($table) . "', '$indexStr', TRUE);\n";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}

                }

                if (!empty($table->foreignKeys)):

                    foreach ($table->foreignKeys as $fkName => $fk) {
                        $addForeignKeys .= "\t\t" . '$this->addForeignKey("' . $fkName . '", "' . $table->name . '", "' . $fk['column'] . '","' . $fk['table'] . '","' . $fk['ref_column'] . '", "' . $fk['delete'] . '", "' . $fk['update'] . '");' . "\n";
                        $dropForeignKeys .= '$this->dropForeignKey(' . "'$fkName', '$table->name');";
                    }

                endif;

                $this->fields = $table->columns;

                $fields = $this->parseFields();

                $this->prepareFile(['up' => '', 'down' => '', 'foreignKeys' => $table->foreignKeys, 'fields' => $fields]) . "\n\n";

            }

        }
        return;
    }

    /**
     * Returns the name of the data migration file created
     * @param array $tables the list of tables
     * @return integer|null
     */
    public function actionData(array $tables)
    {

        if ($this->confirm('Create the migration ' . "?", true)) {
            foreach ($tables as $key => $args) {

                $table              = $args;
                $this->class        = 'insert_data_into_' . $table;
                $this->table        = $table;
                $this->templateFile = '@tmukherjee13/migration/views/dataTemplate.php';

                $columns = $this->db->getTableSchema($table);
                $prefix  = $this->db->tablePrefix;
                $table   = str_replace($prefix, '', $table);
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $table   = $columns;

                $this->table = $this->getTableName($table);

                $prepared_columns = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $up               = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $down             = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $prepared_data    = [];

                $name = $this->getFileName();
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

                if (!empty($table)) {

                    $query = new Query;
                    $query->select('*')
                        ->from($table->name);
                    $command = $query->createCommand();
                    $data    = $command->queryAll();

                    $pcolumns = '';
                    foreach ($columns->columns as $column) {
                        $pcolumns .= "'" . $column->name . "',";
                    }
                    foreach ($data as $row) {
                        array_push($prepared_data, $row);
                    }

                    if (empty($prepared_data)) {
                        $this->stdout("\nTable '{$table->name}' doesn't contain any data.\n\n", Console::FG_RED);
                    } else {
                        $pcolumns = $this->prepareColumns($pcolumns);
                        $prows    = $this->prepareData($prepared_data);

                        $this->prepareFile(['columns' => $pcolumns, 'rows' => $prows]);
                    }
                    // return self::EXIT_CODE_ERROR;

                }
            }
            return self::EXIT_CODE_NORMAL;
        }
    }

    /**
     * Returns the name of the database migration file created
     * @param string $args the schema name
     * @return integer
     */
    public function actionSchema($args)
    {

        $schema      = $args;
        $this->class = 'dump_database_' . $schema;

        // $tables = $this->db->schema->getTableNames($schema);


        $tables          = $this->db->schema->getTableSchemas($schema);
        $addForeignKeys  = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $dropForeignKeys = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $up              = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $down            = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $hasPrimaryKey   = false;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $name            = $this->getFileName();
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $tablePrefix     = $this->db->tablePrefix;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $generateTables  = [];

        foreach ($tables as $table) {
            if ($table->name === $this->db->tablePrefix . $this->migrationTable) {
                continue;
            }
            $generateTables[] = $table->name;
        }
        $this->actionTable($generateTables);
        return self::EXIT_CODE_NORMAL;

    }

    public function getFileName()
    {
        return 'm' . gmdate('ymd_His') . '_' . $this->class;
    }

    public function setFileName()
    {
        $this->fileName = $this->getFileName();
    }

    public function prepareFile($data)
    {
        if ($this->useDataMigrationFolder) {
            FileHelper::createDirectory($this->migrationPath . DIRECTORY_SEPARATOR . $this->dataMigrationFolder);
        }
        $file = $this->migrationPath . DIRECTORY_SEPARATOR . ($this->useDataMigrationFolder ? $this->dataMigrationFolder . DIRECTORY_SEPARATOR : null) . $this->getFileName() . '.php';
        try {

            $data['table']     = $this->table;
            $data['className'] = $this->getFileName();
            $content           = $this->renderFile(Yii::getAlias($this->templateFile), $data);

            file_put_contents($file, $content);
            $this->stdout("\nNew migration {$this->getFileName()} successfully created.\nRun yii migrate to apply migrations.\n", Console::FG_GREEN);
            return $file;
        } catch (Exception $e) {
            throw new Exception("There has been an error processing the file. Please try after some time.");
        }
    }

    

    /**
     * @inheritdoc
     */
    protected function getMigrationHistory($limit)
    {
        if ($this->db->schema->getTableSchema($this->migrationTable, true) === null) {
            $this->createMigrationHistoryTable();
        }
        $query = new Query;
        $rows  = $query->select(['version', 'apply_time'])
            ->from($this->migrationTable)
            ->orderBy('apply_time DESC, version DESC')
            ->limit($limit)
            ->createCommand($this->db)
/**
 * @return array|string
 */
function returnsDifferentValues($x) {
    if ($x) {
        return 'foo';
    }

    return array();
}

$x = returnsDifferentValues($y);
if (is_array($x)) {
    // $x is an array.
}
            ->queryAll();
        $history = ArrayHelper::map($rows, 'version', 'apply_time');
        unset($history[self::BASE_MIGRATION]);

        return $history;
    }

    /**
     * @inheritdoc
     */
    protected function addMigrationHistory($version)
    {
        $command = $this->db->createCommand();
        $command->insert($this->migrationTable, [
            'version'    => $version,
            'apply_time' => time(),
        ])->execute();
    }

    /**
     * @inheritdoc
     */
    protected function removeMigrationHistory($version)
    {
        $command = $this->db->createCommand();
        $command->delete($this->migrationTable, [
            'version' => $version,
        ])->execute();
    }

    /**
     * @inheritdoc
     */
    protected function parseFields()
    {
        $fields = [];

        foreach ($this->fields as $column => $schema) {

            $chunks = [];

            $columns = $this->formatCol($schema);

            foreach ($columns as $key => $chunk) {
                if (!preg_match('/^(.+?)\(([^)]+)\)$/', $chunk)) {
                    $chunk .= '()';
                }
                $chunks[] = $chunk;
            }
            $fields[] = [
                'property'   => $column,
                'decorators' => implode('->', $chunks),
            ];
        }
        return $fields;
    }
}

GitHub Access Token became invalid

Pull Request — master (#14)

MigrationController::actionUpData() A

Complexity

Size

Duplication

Importance

Available Fixes

1			<?php
2			namespace tmukherjee13\migration\console\controllers;
3
4			use Yii;
5			use yii\console\controllers\MigrateController;
6			use yii\console\Exception;
7			use yii\db\Connection;
8			use yii\db\Query;
9			use yii\helpers\ArrayHelper;
10			use yii\helpers\Console;
11			use yii\helpers\FileHelper;
12
13			class MigrationController extends MigrateController
14			{
15			use \tmukherjee13\migration\console\components\Formatter;
16
17			/**
18			* @inheritdoc
19			*/
20			public $defaultAction = 'migrate';
21
22			/**
23			* @var string a migration table name
24			*/
25			public $migrationTable = 'migration';
26
27			/**
28			* @var string a migration path
29			*/
30			public $migrationPath = "@app/migrations";
31
32			/**
33			* @var string путь к данным
34			*/
35			public $dataMigrationFolder = 'data';
36
37			/**
38			* @var bool использовать путь к данным
39			*/
40			public $useDataMigrationFolder = true;
tmukherjee13 / yii2-reverse-migration

GitHub Access Token became invalid

Pull Request — master (#14)

MigrationController::actionUpData() A

Complexity

Size

Duplication

Importance

Available Fixes

Duplication Side-by-Side

Filter issues like
