@@ -118,7 +118,7 @@ |
||
118 | 118 | //create tables |
119 | 119 | foreach ($JsonExtractor->getTablesArray() as $TableName => $TableColumn) { |
120 | 120 | $this->capsule::schema()->dropIfExists($TableName); |
121 | - $this->capsule::schema()->create($TableName, function ($table) use ($TableColumn) { |
|
121 | + $this->capsule::schema()->create($TableName, function($table) use ($TableColumn) { |
|
122 | 122 | foreach ($TableColumn as $column_item) { |
123 | 123 | switch ($column_item['type']) { |
124 | 124 | case 'int': |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | public function validate($json) |
64 | 64 | { |
65 | 65 | if (is_array($json)) { |
66 | - return (object)[ |
|
66 | + return (object) [ |
|
67 | 67 | $this->main_table_name => $json |
68 | 68 | ]; |
69 | 69 | } |
@@ -83,11 +83,11 @@ discard block |
||
83 | 83 | $array = json_decode($array, true); |
84 | 84 | }//if this is not the first time decode the text |
85 | 85 | |
86 | - $return_array = $array;//return array |
|
86 | + $return_array = $array; //return array |
|
87 | 87 | |
88 | 88 | foreach ($array ?? [] as $key => $array_item) { |
89 | 89 | if (!is_numeric($key) && $parent_table) {//single array table, no column |
90 | - $table_name = $parent_table . '_' . $key; |
|
90 | + $table_name = $parent_table.'_'.$key; |
|
91 | 91 | } elseif ($parent_table) {//multiple array items |
92 | 92 | $table_name = $parent_table; |
93 | 93 | } else {//first time loop |
@@ -95,16 +95,16 @@ discard block |
||
95 | 95 | } |
96 | 96 | |
97 | 97 | if (is_array($array_item)) {//if this is a array |
98 | - $array_item = $this->addID($array_item, $table_name, $this->increment);//recursive the array |
|
98 | + $array_item = $this->addID($array_item, $table_name, $this->increment); //recursive the array |
|
99 | 99 | if (empty($array_item['id']) && empty($array_item[0])) {//if this is a single array with no child |
100 | - $array_item = ['id' => $this->increment++] + $array_item;//add id |
|
100 | + $array_item = ['id' => $this->increment++] + $array_item; //add id |
|
101 | 101 | } |
102 | 102 | |
103 | 103 | if (isset($array_item[0]) && !is_array($array_item[0]) && !is_object($array_item[0])) {//reference table |
104 | 104 | |
105 | 105 | |
106 | - $array_item = (object)array_map(function ($item) { |
|
107 | - return (object)[ |
|
106 | + $array_item = (object) array_map(function($item) { |
|
107 | + return (object) [ |
|
108 | 108 | 'id' => $this->increment++, |
109 | 109 | 'value'=>$item |
110 | 110 | ]; |
@@ -133,7 +133,7 @@ discard block |
||
133 | 133 | $return_array = $array; |
134 | 134 | foreach ($array ?? [] as $key => $array_item) { |
135 | 135 | if (!is_numeric($key) && $parent_table) {//single array table, no column |
136 | - $table_name = $parent_table . '_' . $key; |
|
136 | + $table_name = $parent_table.'_'.$key; |
|
137 | 137 | } elseif ($parent_table) {//multiple array items |
138 | 138 | $table_name = $parent_table; |
139 | 139 | } elseif (!is_numeric($key)) { //first time loop |
@@ -73,13 +73,13 @@ discard block |
||
73 | 73 | |
74 | 74 | if (is_array($value) && is_object($value[0])) {//check whether it's a array and it's firs element is a object |
75 | 75 | |
76 | - $table_data = $this->getTable($prefix . $table_name, $value); //get table sql |
|
76 | + $table_data = $this->getTable($prefix.$table_name, $value); //get table sql |
|
77 | 77 | $this->table[$table_data['name']] = $table_data['column']; |
78 | 78 | |
79 | - $this->toMysqlTables($this->getHighestColumnArray($value), $prefix . $table_name . "_"); //get it inside tables |
|
79 | + $this->toMysqlTables($this->getHighestColumnArray($value), $prefix.$table_name."_"); //get it inside tables |
|
80 | 80 | } elseif (is_array($value) || is_object($value)) {//if it's a array and firs element is not a object |
81 | 81 | |
82 | - $table_data = $this->getTable($prefix . $table_name, $value); |
|
82 | + $table_data = $this->getTable($prefix.$table_name, $value); |
|
83 | 83 | $this->table[$table_data['name']] = $table_data['column']; |
84 | 84 | } |
85 | 85 | } |
@@ -97,12 +97,12 @@ discard block |
||
97 | 97 | } |
98 | 98 | foreach ($data as $table_name => $value) { |
99 | 99 | if ($this->snake_case_table) { |
100 | - $table_name = $this->snakeCase($prefix . $table_name); |
|
100 | + $table_name = $this->snakeCase($prefix.$table_name); |
|
101 | 101 | } |
102 | 102 | if (is_array($value) && !empty($value) && is_object($value[0])) {//if it's a array and firs element is not a object |
103 | - $this->toMysqlData($value, $table_name . '_'); |
|
103 | + $this->toMysqlData($value, $table_name.'_'); |
|
104 | 104 | } elseif (is_object($value) || is_array($value)) { |
105 | - $this->toMysqlData($value, $table_name . '_'); |
|
105 | + $this->toMysqlData($value, $table_name.'_'); |
|
106 | 106 | $this->getTableData($table_name, $value); |
107 | 107 | } |
108 | 108 | } |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | if ($this->snake_case_column) { |
159 | 159 | return [ |
160 | 160 | 'name' => $table, |
161 | - 'column' => array_map(function ($item) { |
|
161 | + 'column' => array_map(function($item) { |
|
162 | 162 | return [ |
163 | 163 | 'name' => $this->snakeCase($item['name']), |
164 | 164 | 'type' => $item['type'], |
@@ -336,13 +336,13 @@ discard block |
||
336 | 336 | } elseif (is_numeric($item)) { |
337 | 337 | $value[] = $item; |
338 | 338 | } else { |
339 | - $value[] = '"' . addcslashes($item, "W") . '"'; |
|
339 | + $value[] = '"'.addcslashes($item, "W").'"'; |
|
340 | 340 | } |
341 | 341 | } |
342 | - $String[] = '(' . implode(",", $value) . ')'; |
|
342 | + $String[] = '('.implode(",", $value).')'; |
|
343 | 343 | } |
344 | 344 | |
345 | - return "values" . implode(", ", $String); |
|
345 | + return "values".implode(", ", $String); |
|
346 | 346 | } |
347 | 347 | |
348 | 348 | /** |
@@ -353,7 +353,7 @@ discard block |
||
353 | 353 | { |
354 | 354 | $String = []; |
355 | 355 | foreach ($array as $column) { |
356 | - $String[] = "`" . JsonExtractor::snakeCase($column['name']) . "`"; |
|
356 | + $String[] = "`".JsonExtractor::snakeCase($column['name'])."`"; |
|
357 | 357 | } |
358 | 358 | |
359 | 359 | return implode(",", $String); |
@@ -373,7 +373,7 @@ discard block |
||
373 | 373 | } elseif (empty($Data)) { |
374 | 374 | return $empty_val; |
375 | 375 | } else { |
376 | - return (string)$Data; |
|
376 | + return (string) $Data; |
|
377 | 377 | } |
378 | 378 | } |
379 | 379 | } |