tmukherjee13 / yii2-reverse-migration

console/components/Formatter.php

Spacing +6 added lines, -6 removed lines

@@ -43,7 +43,7 @@ 
 
     public function getTableName($table)
     {
-        return '{{%' . str_replace($this->db->tablePrefix, '', $table->name) . '}}';
+        return '{{%'.str_replace($this->db->tablePrefix, '', $table->name).'}}';
     }
 
 
@@ -52,7 +52,7 @@ 
     {
 
         
-        return '$this->batchInsert("{{%test}}", ' . $rows . ', ' . $columns . ');';
+        return '$this->batchInsert("{{%test}}", '.$rows.', '.$columns.');';
     }
 
     /**
@@ -76,9 +76,9 @@ 
         foreach ($data as $row) {
             $rows = '';
             foreach ($row as $value) {
-                $rows .= "'" . addslashes($value) . "',";
+                $rows .= "'".addslashes($value)."',";
             }
-            self::$rows .= "\n\t\t\t" . self::dataFormat($rows) . ",";
+            self::$rows .= "\n\t\t\t".self::dataFormat($rows).",";
         }
         if (!empty(self::$rows)) {
             return self::dataFormat(self::$rows);
@@ -96,7 +96,7 @@ 
         if (null !== $trim) {
             $data = rtrim($data, $trim);
         }
-        return self::$dataEncloser[0] . $data . self::$dataEncloser[1];
+        return self::$dataEncloser[0].$data.self::$dataEncloser[1];
     }
 
     /**
@@ -110,7 +110,7 @@ 
             $data = rtrim($data, $trim);
         }
 
-        return self::$columnEncloser[0] . rtrim($data, $trim) . self::$columnEncloser[1];
+        return self::$columnEncloser[0].rtrim($data, $trim).self::$columnEncloser[1];
     }
 
     /**

console/controllers/MigrationController.php

Spacing +19 added lines, -19 removed lines

@@ -89,7 +89,7 @@ 
                 throw new Exception("The 'db' option must refer to the application component ID of a DB connection.");
             }
 
-            $path = (string)Yii::getAlias($this->migrationPath);
+            $path = (string) Yii::getAlias($this->migrationPath);
 
 
             if (!is_dir($path)) {
@@ -184,7 +184,7 @@ 
      */
     protected function getCreateTableSql($table)
     {
-        $row = $this->db->createCommand('SHOW CREATE TABLE ' . $this->quoteTableName($table->fullName))->queryOne();
+        $row = $this->db->createCommand('SHOW CREATE TABLE '.$this->quoteTableName($table->fullName))->queryOne();
         if (isset($row['Create Table'])) {
             $sql = $row['Create Table'];
         } else {
@@ -207,7 +207,7 @@ 
      */
     public function actionUpData($limit = 0)
     {
-        $this->migrationPath .= DIRECTORY_SEPARATOR . $this->dataMigrationFolder;
+        $this->migrationPath .= DIRECTORY_SEPARATOR.$this->dataMigrationFolder;
         return parent::actionUp($limit);
     }
 
@@ -222,11 +222,11 @@ 
     public function actionTable(array $tables)
     {
 
-        if ($this->confirm('Create the migration ' . "?")) {
+        if ($this->confirm('Create the migration '."?")) {
 
             foreach ($tables as $key => $tableName) {
 
-                $this->class = 'create_table_' . $tableName;
+                $this->class = 'create_table_'.$tableName;
 
                 try {
 
@@ -251,7 +251,7 @@ 
                 $this->table = $this->getTableName($table);
 
                 foreach ($table->columns as $col) {
-                    $up .= "\t\t\t" . '\'' . $col->name . '\'=>"' . $this->getColType($col) . '",' . "\n";
+                    $up .= "\t\t\t".'\''.$col->name.'\'=>"'.$this->getColType($col).'",'."\n";
                     if ($col->isPrimaryKey) {
                         // Add column to composite primary key array
                         $compositePrimaryKeyCols[] = $col->name;
@@ -260,7 +260,7 @@ 
 
                 $ukeys = $this->db->schema->findUniqueIndexes($table);
                 if (!empty($ukeys)) {
-                    $indexArr =[];
+                    $indexArr = [];
                     foreach ($ukeys as $key => $value) {
                         $indexKey = $key;
                         foreach ($value as $id => $field) {
@@ -268,15 +268,15 @@ 
                         }
                     }
                     $indexStr = implode(',', $indexArr);
-                    $up .= "\t\t" . '$this->createIndex(\'idx_' . $indexKey . "', '" . $this->getTableName($table) . "', '$indexStr', TRUE);\n";
+                    $up .= "\t\t".'$this->createIndex(\'idx_'.$indexKey."', '".$this->getTableName($table)."', '$indexStr', TRUE);\n";
 
                 }
 
                 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');";
+                        $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;
@@ -285,7 +285,7 @@ 
 
                 $fields = $this->parseFields();
 
-                $this->prepareFile(['up' => '', 'down' => '', 'foreignKeys' => $table->foreignKeys, 'fields' => $fields]) . "\n\n";
+                $this->prepareFile(['up' => '', 'down' => '', 'foreignKeys' => $table->foreignKeys, 'fields' => $fields])."\n\n";
 
             }
 
@@ -301,11 +301,11 @@ 
     public function actionData(array $tables)
     {
 
-        if ($this->confirm('Create the migration ' . "?", true)) {
+        if ($this->confirm('Create the migration '."?", true)) {
             foreach ($tables as $key => $args) {
 
                 $table              = $args;
-                $this->class        = 'insert_data_into_' . $table;
+                $this->class        = 'insert_data_into_'.$table;
                 $this->table        = $table;
                 $this->templateFile = '@tmukherjee13/migration/views/dataTemplate.php';
 
@@ -333,7 +333,7 @@ 
 
                     $pcolumns = '';
                     foreach ($columns->columns as $column) {
-                        $pcolumns .= "'" . $column->name . "',";
+                        $pcolumns .= "'".$column->name."',";
                     }
                     foreach ($data as $row) {
                         array_push($prepared_data, $row);
@@ -346,7 +346,7 @@ 
                         $prows    = $this->prepareData($prepared_data);
 
                         if ($this->useDataMigrationFolder) {
-                            $path = $this->migrationPath . DIRECTORY_SEPARATOR . $this->dataMigrationFolder;
+                            $path = $this->migrationPath.DIRECTORY_SEPARATOR.$this->dataMigrationFolder;
                             FileHelper::createDirectory($path);
                             $this->migrationPath = $path;
                         }
@@ -368,7 +368,7 @@ 
     {
 
         $schema      = $args;
-        $this->class = 'dump_database_' . $schema;
+        $this->class = 'dump_database_'.$schema;
 
         // $tables = $this->db->schema->getTableNames($schema);
 
@@ -383,7 +383,7 @@ 
         $generateTables  = [];
 
         foreach ($tables as $table) {
-            if ($table->name === $this->db->tablePrefix . $this->migrationTable) {
+            if ($table->name === $this->db->tablePrefix.$this->migrationTable) {
                 continue;
             }
             $generateTables[] = $table->name;
@@ -395,7 +395,7 @@ 
 
     public function getFileName()
     {
-        return 'm' . gmdate('ymd_His') . '_' . $this->class;
+        return 'm'.gmdate('ymd_His').'_'.$this->class;
     }
 
     public function setFileName()
@@ -405,7 +405,7 @@ 
 
     public function prepareFile($data)
     {
-        $file = $this->migrationPath . DIRECTORY_SEPARATOR . $this->getFileName() . '.php';
+        $file = $this->migrationPath.DIRECTORY_SEPARATOR.$this->getFileName().'.php';
         try {
 
             $data['table']     = $this->table;