php-resta / resta-core

src/resta/Database/Migration/Src/Resource/PullManager/Pulling.php

Spacing +47 added lines, -47 removed lines

@@ -21,7 +21,7 @@ 
 
         $list = [];
 
-        foreach ($migrations as $table=>$item){
+        foreach ($migrations as $table=>$item) {
             $list[] = strtolower($table);
         }
         
@@ -30,7 +30,7 @@ 
         echo 'Toplam : '.count($dbtables).' Table';
         echo PHP_EOL;
 
-        foreach ($dbtables as $dbtablekey=>$dbtable){
+        foreach ($dbtables as $dbtablekey=>$dbtable) {
             
             $dbtablekey = $dbtablekey+1;
             
@@ -39,34 +39,34 @@ 
             $dbtable = ucfirst($dbtable);
             $makeDirectory = $directory.''.DIRECTORY_SEPARATOR.''.$dbtable;
             
-            if(!file_exists($makeDirectory)){
-                files()->makeDirectory($makeDirectory,0755,true);
-                $exist=false;
+            if (!file_exists($makeDirectory)) {
+                files()->makeDirectory($makeDirectory, 0755, true);
+                $exist = false;
             }
-            else{
-                $exist=true;
+            else {
+                $exist = true;
             }
 
             $migrationName = time().'_'.$dbtable.'';
 
-            if($exist===false){
+            if ($exist===false) {
 
-                $content = $this->getContentFile($this->getStubPath().''.DIRECTORY_SEPARATOR.'pullCreate.stub',[
+                $content = $this->getContentFile($this->getStubPath().''.DIRECTORY_SEPARATOR.'pullCreate.stub', [
                     'className' => $dbtable,
                     'informations' => $informations
                 ]);
 
-                $contentResult = files()->put($makeDirectory.''.DIRECTORY_SEPARATOR.''.$migrationName.'.php',$content);
+                $contentResult = files()->put($makeDirectory.''.DIRECTORY_SEPARATOR.''.$migrationName.'.php', $content);
             }
             
                 
-            if(isset($contentResult) && $contentResult!==false){
+            if (isset($contentResult) && $contentResult!==false) {
                 echo $dbtablekey.'- '.$migrationName.' ---> Ok';
             }
-            elseif($exist){
+            elseif ($exist) {
                 echo $dbtablekey.'- '.$migrationName.' ---> (Already Exist)';
             }
-            else{
+            else {
                 echo $dbtablekey.'- '.$migrationName.' ---> Fail';
             }
             
@@ -101,46 +101,46 @@ 
 
         $list = [];
 
-        foreach ($columns as $key=>$data){
+        foreach ($columns as $key=>$data) {
             
-            $data['Type'] = rtrim(str_replace('unsigned','',$data['Type']));
+            $data['Type'] = rtrim(str_replace('unsigned', '', $data['Type']));
 
             $field      = $data['Field'];
             $list[]     = '$wizard->name(\''.$field.'\')';
             $list[]     = '->'.$this->getColumnTransformers($data['Type']).'';
 
             //default block
-            if(!is_null($data['Default'])){
+            if (!is_null($data['Default'])) {
                 $default = $data['Default'];
-                $list[]     = '->default(\''.$default.'\')';
+                $list[] = '->default(\''.$default.'\')';
             }
 
-            $getIndex = $this->getIndexInformation($indexes,$data['Field']);
+            $getIndex = $this->getIndexInformation($indexes, $data['Field']);
 
             //unique block
-            if($getIndex['Non_unique']=='0' && $getIndex['Key_name']!=='PRIMARY'){
+            if ($getIndex['Non_unique']=='0' && $getIndex['Key_name']!=='PRIMARY') {
                 $indexName = $getIndex['Key_name'];
-                $list[]     = '->unique(\''.$indexName.'\')';
+                $list[] = '->unique(\''.$indexName.'\')';
             }
 
             //index block
-            if($getIndex['Non_unique']=='1' && $getIndex['Key_name']!=='PRIMARY'){
+            if ($getIndex['Non_unique']=='1' && $getIndex['Key_name']!=='PRIMARY') {
                 $columnName = $getIndex['Column_name'];
                 $indexName = $getIndex['Key_name'];
 
-                if(count($multipleIndexes[$indexName])==1){
+                if (count($multipleIndexes[$indexName])==1) {
                     $list[] = '->index(\''.$indexName.'\')';
                 }
             }
 
             //comment block
-            if(strlen($data['Comment'])>0){
+            if (strlen($data['Comment'])>0) {
                 $comment = $data['Comment'];
                 $list[] = '->comment(\''.$comment.'\')';
             }
 
             //auto increment block
-            if($data['Extra']=='auto_increment'){
+            if ($data['Extra']=='auto_increment') {
                 $list[] = '->auto_increment()';
             }
 
@@ -155,39 +155,39 @@ 
 
         //table indexes
         foreach ($multipleIndexes as $indexName=>$values) {
-            if(count($values)>1){
-                $values = '\''.implode('\',\'',$values).'\'';
+            if (count($values)>1) {
+                $values = '\''.implode('\',\'', $values).'\'';
                 $list[] = '    $wizard->table()->indexes(\''.$indexName.'\',['.$values.']);
                 ';
             }
         }
 
-        if(count($foreignKeys)){
+        if (count($foreignKeys)) {
 
             $constraintName = $foreignKeys['CONSTRAINT_NAME'];
             $key = $foreignKeys['COLUMN_NAME'];
             $referenceTable = $foreignKeys['REFERENCED_TABLE_NAME'];
             $referenceColumn = $foreignKeys['REFERENCED_COLUMN_NAME'];
 
-            if($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT'){
+            if ($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT') {
                 $list[] = '    $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\');
                 ';
             }
 
-            if($foreignKeys['UPDATE_RULE']!=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT'){
+            if ($foreignKeys['UPDATE_RULE']!=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT') {
                 $rule = $foreignKeys['UPDATE_RULE'];
                 $list[] = '    $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\')->onUpdate()->'.strtolower($rule).'();
                 ';
             }
 
-            if($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']!=='RESTRICT'){
+            if ($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']!=='RESTRICT') {
                 $rule = $foreignKeys['DELETE_RULE'];
                 $list[] = '    $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\')->onDelete()->'.strtolower($rule).'();
                 ';
             }
         }
 
-        return implode('',$list);
+        return implode('', $list);
     }
 
     /**
@@ -198,43 +198,43 @@ 
      */
     private function getColumnTransformers($column)
     {
-        if($column=='datetime'){
+        if ($column=='datetime') {
             return 'datetime()';
         }
-        elseif($column=='longtext'){
+        elseif ($column=='longtext') {
             return 'longtext()';
         }
-        elseif($column=='date'){
+        elseif ($column=='date') {
             return 'date()';
         }
-        elseif($column=='text'){
+        elseif ($column=='text') {
             return 'text()';
         }
-        elseif($column=='timestamp'){
+        elseif ($column=='timestamp') {
             return 'timestamp()';
         }
-        elseif($column=='mediumint'){
+        elseif ($column=='mediumint') {
             return 'mediumint()';
         }
-        elseif($column=='tinyint'){
+        elseif ($column=='tinyint') {
             return 'tinyint()';
         }
-        elseif($column=='float'){
+        elseif ($column=='float') {
             return 'float()';
         }
-        elseif($column=='mediumtext'){
+        elseif ($column=='mediumtext') {
             return 'mediumtext()';
         }
-        elseif($column=='mediumblob'){
+        elseif ($column=='mediumblob') {
             return 'mediumblob()';
         }
-        elseif($column=='blob'){
+        elseif ($column=='blob') {
             return 'blob()';
         }
-        elseif(preg_match('@enum.*\((.*?)\)@',$column,$enum)){
+        elseif (preg_match('@enum.*\((.*?)\)@', $column, $enum)) {
             return 'enum(['.$enum[1].'])';
         }
-        else{
+        else {
             return $column;
         }
     }
@@ -246,11 +246,11 @@ 
      * @param $field
      * @return void|mixed
      */
-    private function getIndexInformation($index,$field)
+    private function getIndexInformation($index, $field)
     {
         foreach ($index as $key=>$item) {
 
-            if($item['Column_name'] == $field){
+            if ($item['Column_name']==$field) {
                 return $index[$key];
             }
         }
@@ -269,7 +269,7 @@ 
     {
         $list = [];
         foreach ($index as $key=>$item) {
-            if($item['Non_unique']==1 && $item['Key_name']!=='PRIMARY'){
+            if ($item['Non_unique']==1 && $item['Key_name']!=='PRIMARY') {
                 $list[$item['Key_name']][] = $item['Column_name'];
             }
         }

Braces +15 added lines, -30 removed lines

@@ -42,8 +42,7 @@ 
             if(!file_exists($makeDirectory)){
                 files()->makeDirectory($makeDirectory,0755,true);
                 $exist=false;
-            }
-            else{
+            } else{
                 $exist=true;
             }
 
@@ -62,11 +61,9 @@ 
                 
             if(isset($contentResult) && $contentResult!==false){
                 echo $dbtablekey.'- '.$migrationName.' ---> Ok';
-            }
-            elseif($exist){
+            } elseif($exist){
                 echo $dbtablekey.'- '.$migrationName.' ---> (Already Exist)';
-            }
-            else{
+            } else{
                 echo $dbtablekey.'- '.$migrationName.' ---> Fail';
             }
             
@@ -200,41 +197,29 @@ 
     {
         if($column=='datetime'){
             return 'datetime()';
-        }
-        elseif($column=='longtext'){
+        } elseif($column=='longtext'){
             return 'longtext()';
-        }
-        elseif($column=='date'){
+        } elseif($column=='date'){
             return 'date()';
-        }
-        elseif($column=='text'){
+        } elseif($column=='text'){
             return 'text()';
-        }
-        elseif($column=='timestamp'){
+        } elseif($column=='timestamp'){
             return 'timestamp()';
-        }
-        elseif($column=='mediumint'){
+        } elseif($column=='mediumint'){
             return 'mediumint()';
-        }
-        elseif($column=='tinyint'){
+        } elseif($column=='tinyint'){
             return 'tinyint()';
-        }
-        elseif($column=='float'){
+        } elseif($column=='float'){
             return 'float()';
-        }
-        elseif($column=='mediumtext'){
+        } elseif($column=='mediumtext'){
             return 'mediumtext()';
-        }
-        elseif($column=='mediumblob'){
+        } elseif($column=='mediumblob'){
             return 'mediumblob()';
-        }
-        elseif($column=='blob'){
+        } elseif($column=='blob'){
             return 'blob()';
-        }
-        elseif(preg_match('@enum.*\((.*?)\)@',$column,$enum)){
+        } elseif(preg_match('@enum.*\((.*?)\)@',$column,$enum)){
             return 'enum(['.$enum[1].'])';
-        }
-        else{
+        } else{
             return $column;
         }
     }

src/resta/Database/Migration/Src/GrammarStructure/Mysql/QuerySyntaxHelper.php

Spacing +28 added lines, -28 removed lines

@@ -10,16 +10,16 @@ 
      * @param $name
      * @return string
      */
-    protected function getNullableValue($nullable,$name)
+    protected function getNullableValue($nullable, $name)
     {
-        $nullableValue='';
+        $nullableValue = '';
 
-        if(isset($nullable[$name])){
-            if($nullable[$name]===false){
-                $nullableValue='NOT NULL';
+        if (isset($nullable[$name])) {
+            if ($nullable[$name]===false) {
+                $nullableValue = 'NOT NULL';
             }
-            else{
-                $nullableValue='NULL';
+            else {
+                $nullableValue = 'NULL';
             }
         }
 
@@ -59,21 +59,21 @@ 
      */
     protected function getValueWithIsset($name)
     {
-        $nameKey = array_search($name,$this->data['names']);
+        $nameKey = array_search($name, $this->data['names']);
         
         $list   = [];
-        $list[] = $this->getNullableValue($this->data['nullable'],$name);
+        $list[] = $this->getNullableValue($this->data['nullable'], $name);
         $list[] = (isset($this->data['autoIncrement'][$name])) ? 'AUTO_INCREMENT' : '';
         $list[] = (isset($this->data['primaryKey'][$name])) ? 'PRIMARY KEY' : '';
         
-        if($this->data['types'][$nameKey]=='timestamp' && !isset($this->data['default'][$nameKey])){
+        if ($this->data['types'][$nameKey]=='timestamp' && !isset($this->data['default'][$nameKey])) {
             $this->data['default'][$name] = 'CURRENT_TIMESTAMP';
         }
         
-        if($this->data['types'][$nameKey]!=='timestamp'){
+        if ($this->data['types'][$nameKey]!=='timestamp') {
             $list[] = (isset($this->data['default'][$name])) ? ' DEFAULT "'.$this->data['default'][$name].'"' : '';
         }
-        else{
+        else {
             $list[] = (isset($this->data['default'][$name])) ? ' DEFAULT '.$this->data['default'][$name].'' : '';
         }
         
@@ -90,8 +90,8 @@ 
     protected function getUniqueValueList($name)
     {
         //get unique
-        if(isset($this->data['unique'][$name])){
-            $this->data['uniqueValueList'][]      = 'UNIQUE INDEX '.$this->data['unique'][$name]['value'].' ('.$name.' ASC)';
+        if (isset($this->data['unique'][$name])) {
+            $this->data['uniqueValueList'][] = 'UNIQUE INDEX '.$this->data['unique'][$name]['value'].' ('.$name.' ASC)';
         }
     }
 
@@ -101,8 +101,8 @@ 
     protected function getIndexValueList($name)
     {
         //get index
-        if(isset($this->data['index'][$name])){
-            $this->data['indexValueList'][]  = 'INDEX '.$this->data['index'][$name]['value'].' ('.$name.')';
+        if (isset($this->data['index'][$name])) {
+            $this->data['indexValueList'][] = 'INDEX '.$this->data['index'][$name]['value'].' ('.$name.')';
         }
     }
 
@@ -123,19 +123,19 @@ 
      */
     protected function getCreateDefaultList()
     {
-        $list               = [];
+        $list = [];
 
         foreach ($this->data['names'] as $key=>$name)
         {
             list(
-                $nullableValue,$autoIncrementValue,
-                $primaryKeyValue,$defaultValue,$commentValue
+                $nullableValue, $autoIncrementValue,
+                $primaryKeyValue, $defaultValue, $commentValue
                 ) = $this->getValueWithIsset($name);
 
             //set index values
             $this->setIndex($name);
 
-            $list[]=''.$name.' '.$this->data['types'][$key].' '.$nullableValue.' '.$defaultValue.' '.$primaryKeyValue.' '.$autoIncrementValue.' '.$commentValue.'';
+            $list[] = ''.$name.' '.$this->data['types'][$key].' '.$nullableValue.' '.$defaultValue.' '.$primaryKeyValue.' '.$autoIncrementValue.' '.$commentValue.'';
         }
 
         return $list;
@@ -146,18 +146,18 @@ 
      */
     protected function getKeyList()
     {
-        $keyList            = [];
+        $keyList = [];
 
         //multiple indexes
-        if(isset($this->data['index']['indexes'])){
+        if (isset($this->data['index']['indexes'])) {
 
-            foreach ($this->data['index']['indexes'] as $index_key=>$index_value){
+            foreach ($this->data['index']['indexes'] as $index_key=>$index_value) {
 
                 $indexesCommentValue = (isset($index_value['comment'])) ? 'COMMENT "'.$index_value['comment'].'"' : '';
 
                 $keyType    = (isset($index_value['type'])) ? ucfirst($index_value['type']) : 'KEY';
 
-                $keyList[]  = "".$keyType." ".$index_value['name']." (".implode(",",$index_value['value']).") ".$indexesCommentValue;
+                $keyList[]  = "".$keyType." ".$index_value['name']." (".implode(",", $index_value['value']).") ".$indexesCommentValue;
             }
         }
 
@@ -172,13 +172,13 @@ 
     {
         $list = [];
 
-        foreach ($reference as $constraint=>$values){
+        foreach ($reference as $constraint=>$values) {
 
-            $list[]=',CONSTRAINT '.$constraint.' FOREIGN KEY ('.$values['key'].') 
+            $list[] = ',CONSTRAINT '.$constraint.' FOREIGN KEY ('.$values['key'].') 
             REFERENCES '.$values['references']['table'].'('.$values['references']['field'].') '.$this->getOnProcess($values);
         }
 
-        return implode (" ",$list);
+        return implode(" ", $list);
     }
 
     /**
@@ -186,7 +186,7 @@ 
      */
     private function getOnProcess($referenceValue)
     {
-        if(isset($referenceValue['on']) && isset($referenceValue['onOption'])){
+        if (isset($referenceValue['on']) && isset($referenceValue['onOption'])) {
             return ''.$referenceValue['on'].' '.strtoupper($referenceValue['onOption']).'';
         }