php-resta / resta-core

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

Spacing +30 added lines, -30 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,22 +59,22 @@ 
      */
     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(isset($this->data['types'][$nameKey])){
-            if($this->data['types'][$nameKey]=='timestamp' && !isset($this->data['default'][$nameKey])){
+        if (isset($this->data['types'][$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].'' : '';
             }
 
@@ -82,7 +82,7 @@ 
 
         }
         
-        if(count($list)===3){
+        if (count($list)===3) {
             $list[] = '';
             $list[] = '';
         }
@@ -99,8 +99,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)';
         }
     }
 
@@ -110,8 +110,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.')';
         }
     }
 
@@ -132,13 +132,13 @@ 
      */
     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
@@ -146,7 +146,7 @@ 
             
             $types = (isset($this->data['types'][$key])) ? $this->data['types'][$key] : '';
 
-            $list[]=''.$name.' '.$types.' '.$nullableValue.' '.$defaultValue.' '.$primaryKeyValue.' '.$autoIncrementValue.' '.$commentValue.'';
+            $list[] = ''.$name.' '.$types.' '.$nullableValue.' '.$defaultValue.' '.$primaryKeyValue.' '.$autoIncrementValue.' '.$commentValue.'';
         }
 
         return $list;
@@ -157,18 +157,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;
             }
         }
 
@@ -183,13 +183,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);
     }
 
     /**
@@ -197,7 +197,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']).'';
         }
 

Braces +2 added lines, -4 removed lines

@@ -17,8 +17,7 @@ 
         if(isset($nullable[$name])){
             if($nullable[$name]===false){
                 $nullableValue='NOT NULL';
-            }
-            else{
+            } else{
                 $nullableValue='NULL';
             }
         }
@@ -73,8 +72,7 @@ 
 
             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].'' : '';
             }