lifeeka / jsql

src/Client.php

Spacing +1 added lines, -1 removed lines

@@ -118,7 +118,7 @@
         //create tables
         foreach ($JsonExtractor->getTablesArray() as $TableName => $TableColumn) {
             $this->capsule::schema()->dropIfExists($TableName);
-            $this->capsule::schema()->create($TableName, function ($table) use ($TableColumn) {
+            $this->capsule::schema()->create($TableName, function($table) use ($TableColumn) {
                 foreach ($TableColumn as $column_item) {
                     switch ($column_item['type']) {
                         case 'int':

src/Extractor/JsonExtractor.php

Spacing +12 added lines, -12 removed lines

@@ -74,13 +74,13 @@ 
 
             if (is_array($value) && is_object($value[0])) {//check whether it's a array and it's firs element is a object
 
-                $table_data = $this->getTable($prefix . $table_name, $value); //get table sql
+                $table_data = $this->getTable($prefix.$table_name, $value); //get table sql
                 $this->table[$table_data['name']] = $table_data['column'];
 
-                $this->toMysqlTables($this->getHighestColumnArray($value), $prefix . $table_name . "_", $prefix . $table_name); //get it inside tables
+                $this->toMysqlTables($this->getHighestColumnArray($value), $prefix.$table_name."_", $prefix.$table_name); //get it inside tables
             } elseif (is_array($value) || is_object($value)) {//if it's a array and  firs element is not a object
 
-                $table_data = $this->getTable($prefix . $table_name, $value);
+                $table_data = $this->getTable($prefix.$table_name, $value);
                 $this->table[$table_data['name']] = $table_data['column'];
             }
         }
@@ -99,12 +99,12 @@ 
         }
         foreach ($data as $table_name => $value) {
             if ($this->snake_case_table) {
-                $table_name = $this->snakeCase($prefix . $table_name);
+                $table_name = $this->snakeCase($prefix.$table_name);
             }
             if (is_array($value) && !empty($value) && is_object($value[0])) {//if it's a array and  firs element is not a object
-                $this->toMysqlData($value, $table_name . '_');
+                $this->toMysqlData($value, $table_name.'_');
             } elseif (is_object($value) || is_array($value)) {
-                $this->toMysqlData($value, $table_name . '_');
+                $this->toMysqlData($value, $table_name.'_');
                 $this->getTableData($table_name, $value);
             }
         }
@@ -161,7 +161,7 @@ 
         if ($this->snake_case_column) {
             return [
                 'name' => $table,
-                'column' => array_map(function ($item) {
+                'column' => array_map(function($item) {
                     return [
                         'name' => $this->snakeCase($item['name']),
                         'type' => $item['type'],
@@ -339,13 +339,13 @@ 
                 } elseif (is_numeric($item)) {
                     $value[] = $item;
                 } else {
-                    $value[] = '"' . addcslashes($item, "W") . '"';
+                    $value[] = '"'.addcslashes($item, "W").'"';
                 }
             }
-            $String[] = '(' . implode(",", $value) . ')';
+            $String[] = '('.implode(",", $value).')';
         }
 
-        return "values" . implode(", ", $String);
+        return "values".implode(", ", $String);
     }
 
     /**
@@ -356,7 +356,7 @@ 
     {
         $String = [];
         foreach ($array as $column) {
-            $String[] = "`" . JsonExtractor::snakeCase($column['name']) . "`";
+            $String[] = "`".JsonExtractor::snakeCase($column['name'])."`";
         }
 
         return implode(",", $String);
@@ -376,7 +376,7 @@ 
         } elseif (empty($Data)) {
             return $empty_val;
         } else {
-            return (string)$Data;
+            return (string) $Data;
         }
     }
 }

Braces +7 added lines, -6 removed lines

@@ -194,12 +194,13 @@
             foreach ($data ?? [] as $Column => $Value) {
                 if (!is_array($Value) && !is_object($Value) && !empty($Column) && !is_numeric($Column)) {
 
-                    if (isset($ForeignKeys[JsonExtractor::snakeCase($table)]) && $ForeignKeys[JsonExtractor::snakeCase($table)]['name'] == JsonExtractor::snakeCase($Column))
-                        $Columns[] = ['name' => $Column, 'type' => 'foreign_key', 'ref' => $ForeignKeys[JsonExtractor::snakeCase($table)]['ref']];
-                    elseif ($Column == 'id')
-                        $Columns[] = ['name' => $Column, 'type' => 'primary_key'];
-                    else
-                        $Columns[] = ['name' => $Column, 'type' => gettype($this->getActualDataType($Value, ""))];
+                    if (isset($ForeignKeys[JsonExtractor::snakeCase($table)]) && $ForeignKeys[JsonExtractor::snakeCase($table)]['name'] == JsonExtractor::snakeCase($Column)) {
+                                            $Columns[] = ['name' => $Column, 'type' => 'foreign_key', 'ref' => $ForeignKeys[JsonExtractor::snakeCase($table)]['ref']];
+                    } elseif ($Column == 'id') {
+                                            $Columns[] = ['name' => $Column, 'type' => 'primary_key'];
+                    } else {
+                                            $Columns[] = ['name' => $Column, 'type' => gettype($this->getActualDataType($Value, ""))];
+                    }
                 }
             }
         } elseif (is_array($data)) {

src/Helpers/Json.php

Spacing +10 added lines, -10 removed lines

@@ -64,7 +64,7 @@ 
     public function validate($json)
     {
         if (is_array($json)) {
-            return (object)[
+            return (object) [
                 $this->main_table_name => $json
             ];
         }
@@ -82,14 +82,14 @@ 
     {
 
         if (!is_array($array))
-            $array = json_decode($array, true);//if this is not the first time decode the text
+            $array = json_decode($array, true); //if this is not the first time decode the text
 
-        $return_array = $array;//return array
+        $return_array = $array; //return array
 
         foreach ($array ?? [] as $key => $array_item) {
 
             if (!is_numeric($key) && $parent_table)//single array table, no column
-                $table_name = $parent_table . '_' . $key;
+                $table_name = $parent_table.'_'.$key;
             elseif ($parent_table)//multiple array items
                 $table_name = $parent_table;
             else {//first time loop
@@ -97,16 +97,16 @@ 
             }
 
             if (is_array($array_item)) {//if this is a array
-                $array_item = $this->addID($array_item, $table_name, $this->increment);//recursive the array
+                $array_item = $this->addID($array_item, $table_name, $this->increment); //recursive the array
                 if (empty($array_item['id']) && empty($array_item[0])) {//if this is a single array with no child
-                    $array_item = ['id' => $this->increment++] + $array_item;//add id
+                    $array_item = ['id' => $this->increment++] + $array_item; //add id
                 }
 
-                if(isset($array_item[0]) && !is_array($array_item[0]) && !is_object($array_item[0])){//reference table
+                if (isset($array_item[0]) && !is_array($array_item[0]) && !is_object($array_item[0])) {//reference table
 
 
-                    $array_item = (object)array_map(function ($item){
-                        return (object)[
+                    $array_item = (object) array_map(function($item) {
+                        return (object) [
                             'id' => $this->increment++,
                             'value'=>$item
                         ];
@@ -138,7 +138,7 @@ 
 
 
             if (!is_numeric($key) && $parent_table)//single array table, no column
-                $table_name = $parent_table . '_' . $key;
+                $table_name = $parent_table.'_'.$key;
             elseif ($parent_table)//multiple array items
                 $table_name = $parent_table;
             elseif (!is_numeric($key))  //first time loop

Braces +19 added lines, -11 removed lines

@@ -81,18 +81,22 @@ 
     private function addID($array, $parent_table = false, $last_increment = false)
     {
 
-        if (!is_array($array))
-            $array = json_decode($array, true);//if this is not the first time decode the text
+        if (!is_array($array)) {
+                    $array = json_decode($array, true);
+        }
+        //if this is not the first time decode the text
 
         $return_array = $array;//return array
 
         foreach ($array ?? [] as $key => $array_item) {
 
-            if (!is_numeric($key) && $parent_table)//single array table, no column
+            if (!is_numeric($key) && $parent_table) {
+             //single array table, no column
                 $table_name = $parent_table . '_' . $key;
-            elseif ($parent_table)//multiple array items
+            } elseif ($parent_table) {
+             //multiple array items
                 $table_name = $parent_table;
-            else {//first time loop
+            } else {//first time loop
                 $table_name = $this->main_table_name;
             }
 
@@ -129,21 +133,25 @@ 
      */
     private function addForeign($array, $parent_table = null, $parent_key = false)
     {
-        if (!is_array($array))
-            $array = json_decode($array, true);
+        if (!is_array($array)) {
+                    $array = json_decode($array, true);
+        }
 
         $return_array = $array;
         foreach ($array ?? [] as $key => $array_item) {
 
 
 
-            if (!is_numeric($key) && $parent_table)//single array table, no column
+            if (!is_numeric($key) && $parent_table) {
+             //single array table, no column
                 $table_name = $parent_table . '_' . $key;
-            elseif ($parent_table)//multiple array items
+            } elseif ($parent_table) {
+             //multiple array items
                 $table_name = $parent_table;
-            elseif (!is_numeric($key))  //first time loop
+            } elseif (!is_numeric($key)) {
+             //first time loop
                 $table_name = $key;
-            else {//first time loop
+            } else {//first time loop
                 $table_name = $this->main_table_name;
             }