tmukherjee13 / yii2-reverse-migration

console/controllers/MigrationController.php

Braces +23 added lines, -40 removed lines

@@ -12,8 +12,7 @@ 
 use yii\console\controllers\MigrateController;
 
 
-class MigrationController extends MigrateController
-{
+class MigrationController extends MigrateController {
     use \tmukherjee13\migration\console\components\Formatter;
     
     /**
@@ -54,16 +53,14 @@ 
     /**
      * @inheritdoc
      */
-    public function options($actionID)
-    {
+    public function options($actionID) {
         return array_merge(parent::options($actionID), ['migrationTable', 'db']);
     }
     
     /**
      * @inheritdoc
      */
-    public function beforeAction($action)
-    {
+    public function beforeAction($action) {
         
         if (parent::beforeAction($action)) {
             if (is_string($this->db)) {
@@ -100,8 +97,7 @@ 
      *
      * @return int
      */
-    public function actionUpData($limit = 0)
-    {
+    public function actionUpData($limit = 0) {
         $this->migrationPath .= DIRECTORY_SEPARATOR . $this->dataMigrationFolder;
         return parent::actionUp($limit);
     }
@@ -116,8 +112,7 @@ 
      * @throws \yii\console\Exception
      * @throws \yii\db\Exception
      */
-    public function actionData(array $tables)
-    {
+    public function actionData(array $tables) {
         if ($this->confirm('Create the migration ' . "?", TRUE)) {
             foreach ($tables as $key => $args) {
                 
@@ -158,7 +153,8 @@ 
                     
                     if (empty($prepared_data)) {
                         $this->stdout("\nTable '{$table->name}' doesn't contain any data.\n\n", Console::FG_RED);
-                    } else {
+                    }
+                    else {
                         $pcolumns = $this->prepareColumns($pcolumns);
                         $prows = $this->prepareData($prepared_data);
                         
@@ -179,16 +175,14 @@ 
     /**
      * @return string
      */
-    public function getFileName()
-    {
+    public function getFileName() {
         return 'm' . gmdate('ymd_His') . '_' . $this->class;
     }
     
     /**
      *
      */
-    public function setFileName()
-    {
+    public function setFileName() {
         $this->fileName = $this->getFileName();
     }
     
@@ -198,8 +192,7 @@ 
      * @return string
      * @throws \yii\console\Exception
      */
-    public function prepareFile($data)
-    {
+    public function prepareFile($data) {
         $file = $this->migrationPath . DIRECTORY_SEPARATOR . $this->getFileName() . '.php';
         try {
             
@@ -222,8 +215,7 @@ 
      * @return int
      * @throws \yii\console\Exception
      */
-    public function actionSchema($args)
-    {
+    public function actionSchema($args) {
         
         $schema = $args;
         $this->class = 'dump_database_' . $schema;
@@ -257,8 +249,7 @@ 
      * @return mixed
      * @author Tarun Mukherjee (https://github.com/tmukherjee13)
      */
-    public function actionTable(array $tables)
-    {
+    public function actionTable(array $tables) {
         
         if (!$this->confirm('Create the migration ' . "?")) {
             return;
@@ -343,8 +334,7 @@ 
      * @return array
      * @throws \yii\db\Exception
      */
-    protected function findConstraints($table)
-    {
+    protected function findConstraints($table) {
         $sql = <<<SQL
             SELECT
                 kcu.constraint_name,
@@ -415,12 +405,12 @@ 
      * @return mixed
      * @throws \yii\db\Exception
      */
-    protected function getCreateTableSql(TableSchema $table)
-    {
+    protected function getCreateTableSql(TableSchema $table) {
         $row = $this->db->createCommand('SHOW CREATE TABLE ' . $this->quoteTableName($table->fullName))->queryOne();
         if (isset($row['Create Table'])) {
             $sql = $row['Create Table'];
-        } else {
+        }
+        else {
             $row = array_values($row);
             $sql = $row[1];
         }
@@ -432,16 +422,14 @@ 
      *
      * @return string
      */
-    public function quoteTableName($name)
-    {
+    public function quoteTableName($name) {
         return strpos($name, '`') !== FALSE ? $name : "`$name`";
     }
     
     /**
      * @inheritdoc
      */
-    protected function parseFields()
-    {
+    protected function parseFields() {
         $fields = [];
         
         foreach ($this->fields as $column => $schema) {
@@ -480,8 +468,7 @@ 
      *
      * @return array|void
      */
-    protected function findIndexes(TableSchema $table)
-    {
+    protected function findIndexes(TableSchema $table) {
         $sql = "SHOW INDEX FROM `{$table->name}`";
         
         try {
@@ -506,8 +493,7 @@ 
      *
      * @return array
      */
-    public function filterKeyIndex($table, array $rows = [])
-    {
+    public function filterKeyIndex($table, array $rows = []) {
         $return = [];
         foreach ($rows as $row) {
             
@@ -542,8 +528,7 @@ 
     /**
      * @inheritdoc
      */
-    protected function getMigrationHistory($limit)
-    {
+    protected function getMigrationHistory($limit) {
         if ($this->db->schema->getTableSchema($this->migrationTable, TRUE) === NULL) {
             $this->createMigrationHistoryTable();
         }
@@ -563,8 +548,7 @@ 
     /**
      * @inheritdoc
      */
-    protected function addMigrationHistory($version)
-    {
+    protected function addMigrationHistory($version) {
         $command = $this->db->createCommand();
         $command->insert($this->migrationTable, [
             'version'    => $version,
@@ -575,8 +559,7 @@ 
     /**
      * @inheritdoc
      */
-    protected function removeMigrationHistory($version)
-    {
+    protected function removeMigrationHistory($version) {
         $command = $this->db->createCommand();
         $command->delete($this->migrationTable, [
             'version' => $version,

console/components/Formatter.php

Braces +27 added lines, -27 removed lines

@@ -7,8 +7,7 @@ 
 /**
  * Table class
  */
-trait Formatter
-{
+trait Formatter {
     /**
      * @var array column enclosing literal
      */
@@ -43,8 +42,7 @@ 
      * @return string
      * @author Tarun Mukherjee (https://github.com/tmukherjee13)
      */
-    public function getTableName($table)
-    {
+    public function getTableName($table) {
         return '{{%' . str_replace($this->db->tablePrefix, '', $table->name) . '}}';
     }
     
@@ -54,8 +52,7 @@ 
      *
      * @return string
      */
-    public function prepareInsert($rows, $columns)
-    {
+    public function prepareInsert($rows, $columns) {
         return '$this->batchInsert("{{%test}}", ' . $rows . ', ' . $columns . ');';
     }
     
@@ -66,8 +63,7 @@ 
      *
      * @return string
      */
-    public function prepareColumns($data, $trim = ',')
-    {
+    public function prepareColumns($data, $trim = ',') {
         return self::columnFormat($data, $trim);
     }
     
@@ -78,8 +74,7 @@ 
      *
      * @return string
      */
-    public function columnFormat($data, $trim = ',')
-    {
+    public function columnFormat($data, $trim = ',') {
         if (NULL !== $trim) {
             $data = rtrim($data, $trim);
         }
@@ -94,8 +89,7 @@ 
      *
      * @return string
      */
-    public function prepareData($data = [])
-    {
+    public function prepareData($data = []) {
         self::$rows = '';
         foreach ($data as $row) {
             $rows = '';
@@ -117,8 +111,7 @@ 
      *
      * @return string
      */
-    public function dataFormat($data, $trim = ',')
-    {
+    public function dataFormat($data, $trim = ',') {
         if (NULL !== $trim) {
             $data = rtrim($data, $trim);
         }
@@ -135,8 +128,7 @@ 
      * @author Tarun Mukherjee (https://github.com/tmukherjee13)
      */
     
-    public function formatCol($col)
-    {
+    public function formatCol($col) {
         if (!empty($col->enumValues)) {
             return $this->getColType($col);
         }
@@ -144,14 +136,18 @@ 
         $decorator = [];
         if ($col->isPrimaryKey && $col->autoIncrement) {
             $decorator[] = 'primaryKey';
-        } elseif (in_array($col->type, self::$colTypes)) {
+        }
+        elseif (in_array($col->type, self::$colTypes)) {
             $decorator[] = "{$this->modifyColType($col->dbType)}";
-        } elseif ($col->type == 'decimal') {
+        }
+        elseif ($col->type == 'decimal') {
             $decorator[] = "{$col->dbType}";
-        } else {
+        }
+        else {
             if (!empty($col->size) && $col->size == 1 && $col->type != 'char') {
                 $column = "boolean";
-            } else {
+            }
+            else {
                 $column = "{$col->type}";
                 if (!empty($col->size)) {
                     $column .= "({$col->size})";
@@ -171,9 +167,11 @@ 
         // default value.
         if (is_a($col->defaultValue, Expression::class)) {
             $decorator[] = "defaultExpression('{$col->defaultValue}')";
-        } elseif (is_numeric($col->defaultValue)) {
+        }
+        elseif (is_numeric($col->defaultValue)) {
             $decorator[] = "defaultValue({$col->defaultValue})";
-        } elseif (!empty($col->defaultValue)) {
+        }
+        elseif (!empty($col->defaultValue)) {
             $decorator[] = "defaultValue('{$col->defaultValue}')";
         }
         
@@ -193,8 +191,7 @@ 
      * @return string
      * @author Tarun Mukherjee (https://github.com/tmukherjee13)
      */
-    public function getColType($col)
-    {
+    public function getColType($col) {
         if ($col->isPrimaryKey && $col->autoIncrement) {
             return 'pk';
         }
@@ -205,11 +202,14 @@ 
         }
         if ($col->defaultValue != NULL && 'timestamp' != $col->dbType) {
             $result .= " DEFAULT '{$col->defaultValue}'";
-        } elseif ($col->defaultValue == 'CURRENT_TIMESTAMP' && 'timestamp' == $col->dbType) {
+        }
+        elseif ($col->defaultValue == 'CURRENT_TIMESTAMP' && 'timestamp' == $col->dbType) {
             $result .= " DEFAULT {$col->defaultValue}";
-        } elseif ($col->defaultValue != NULL && 'timestamp' == $col->dbType) {
+        }
+        elseif ($col->defaultValue != NULL && 'timestamp' == $col->dbType) {
             $result .= " DEFAULT '{$col->defaultValue}'";
-        } elseif ($col->allowNull) {
+        }
+        elseif ($col->allowNull) {
             $result .= ' DEFAULT NULL';
         }
         return $result;

views/_dropIndexes.php

Braces +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 /* @var $table string the name table */
 /* @var $indexes array the foreign keys */
 
-if($indexes){
+if($indexes) {
         foreach ($indexes as $key => $index): ?>
                 $this->dropIndex('<?= $key ?>', $this->tableName);
         <?php endforeach;

views/_addIndexes.php

Braces +11 added lines, -5 removed lines

@@ -8,16 +8,22 @@
 
 //dd( $indexes );
 
-if($indexes){
+if($indexes) {
         foreach ($indexes as $index):
         if(is_string($index['Column_name'])): ?>
         <?php if($index['Non_unique'] == 0): ?>
                 $this->createIndex('<?= str_replace('_UNIQUE', '', $index['Key_name'])?>', $this->tableName, '<?= $index['Column_name'] ?>', true);
-        <?php else: ?>
+        <?php else {
+    : ?>
                 $this->createIndex('<?= $index['Key_name']  ?>', $this->tableName, '<?= $index['Column_name'] ?>');
-        <?php endif; ?>
-        <?php else: ?>
+        <?php endif;
+}
+?>
+        <?php else {
+    : ?>
                 $this->createIndex('<?= $index['Key_name']  ?>', $this->tableName, ['<?= implode("','",$index['Column_name']) ?>']);
-        <?php endif; ?>
+        <?php endif;
+}
+?>
         <?php endforeach;
 }

views/_createTable.php

Braces +3 added lines, -1 removed lines

@@ -15,9 +15,11 @@
         <?= "'{$field['property']}' => \$this->{$field['decorators']}" ?>,
     <?php elseif(!empty('raw')): ?>
         <?=$field['raw'] ?>,
-    <?php else: ?>
+    <?php else {
+    : ?>
         '<?= $field['property'] ?>',
     <?php endif;
+}
 endforeach; ?>
     ], $collation);