@@ -15,7 +15,7 @@ discard block |
||
| 15 | 15 | /** |
| 16 | 16 | * @var $type |
| 17 | 17 | */ |
| 18 | - public $type='migration'; |
|
| 18 | + public $type = 'migration'; |
|
| 19 | 19 | |
| 20 | 20 | /** |
| 21 | 21 | * @var array |
@@ -33,8 +33,8 @@ discard block |
||
| 33 | 33 | /** |
| 34 | 34 | * @var $commandRule |
| 35 | 35 | */ |
| 36 | - public $commandRule=['create'=>[ |
|
| 37 | - 'name','table' |
|
| 36 | + public $commandRule = ['create'=>[ |
|
| 37 | + 'name', 'table' |
|
| 38 | 38 | ], |
| 39 | 39 | 'push'=>[]]; |
| 40 | 40 | |
@@ -63,14 +63,14 @@ discard block |
||
| 63 | 63 | |
| 64 | 64 | foreach ($pushResult as $key=>$value) {
|
| 65 | 65 | |
| 66 | - if(isset($value['success'])){
|
|
| 66 | + if (isset($value['success'])) {
|
|
| 67 | 67 | |
| 68 | 68 | $list[] = true; |
| 69 | 69 | |
| 70 | - $pushResultFile = explode("/",$pushResult[$key]['file']);
|
|
| 70 | + $pushResultFile = explode("/", $pushResult[$key]['file']);
|
|
| 71 | 71 | $file = end($pushResultFile); |
| 72 | 72 | |
| 73 | - if($pushResult[$key]['success']===true){
|
|
| 73 | + if ($pushResult[$key]['success']===true) {
|
|
| 74 | 74 | |
| 75 | 75 | $this->table->addRow([ |
| 76 | 76 | $key, |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | 'No', |
| 83 | 83 | ]); |
| 84 | 84 | } |
| 85 | - else{
|
|
| 85 | + else {
|
|
| 86 | 86 | |
| 87 | 87 | $this->table->addRow([ |
| 88 | 88 | $key, |
@@ -98,12 +98,12 @@ discard block |
||
| 98 | 98 | } |
| 99 | 99 | } |
| 100 | 100 | |
| 101 | - if(count($list)){
|
|
| 102 | - $this->table->setHeaders(['id','table','file','type','status','message','seeder']); |
|
| 101 | + if (count($list)) {
|
|
| 102 | + $this->table->setHeaders(['id', 'table', 'file', 'type', 'status', 'message', 'seeder']); |
|
| 103 | 103 | |
| 104 | 104 | echo $this->table->getTable(); |
| 105 | 105 | } |
| 106 | - else{
|
|
| 106 | + else {
|
|
| 107 | 107 | echo $this->classical('No migration was found to apply');
|
| 108 | 108 | } |
| 109 | 109 | |
@@ -124,19 +124,19 @@ discard block |
||
| 124 | 124 | |
| 125 | 125 | $stubType = (!file_exists($tablePath)) ? 'create' : 'alter'; |
| 126 | 126 | |
| 127 | - if(!file_exists($path)){
|
|
| 127 | + if (!file_exists($path)) {
|
|
| 128 | 128 | |
| 129 | - $this->file->fs->mkdir($path,0777); |
|
| 130 | - $this->file->fs->chmod($path,0777,000,true); |
|
| 129 | + $this->file->fs->mkdir($path, 0777); |
|
| 130 | + $this->file->fs->chmod($path, 0777, 000, true); |
|
| 131 | 131 | } |
| 132 | 132 | |
| 133 | - $migrationCreate = $this->getSchema()->stub($this->argument['table'],$this->argument['name'],$stubType); |
|
| 133 | + $migrationCreate = $this->getSchema()->stub($this->argument['table'], $this->argument['name'], $stubType); |
|
| 134 | 134 | |
| 135 | 135 | echo $this->info('Migration Create Process :');
|
| 136 | 136 | |
| 137 | - $this->table->setHeaders(['id','method','table','style','name','type','status','message']); |
|
| 137 | + $this->table->setHeaders(['id', 'method', 'table', 'style', 'name', 'type', 'status', 'message']); |
|
| 138 | 138 | |
| 139 | - foreach ($migrationCreate['directory'] as $key=>$data){
|
|
| 139 | + foreach ($migrationCreate['directory'] as $key=>$data) {
|
|
| 140 | 140 | |
| 141 | 141 | $this->table->addRow([ |
| 142 | 142 | $key, |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | ]); |
| 152 | 152 | } |
| 153 | 153 | |
| 154 | - foreach ($migrationCreate['file'] as $key=>$data){
|
|
| 154 | + foreach ($migrationCreate['file'] as $key=>$data) {
|
|
| 155 | 155 | |
| 156 | 156 | $this->table->addRow([ |
| 157 | 157 | $key, |
@@ -81,8 +81,7 @@ discard block |
||
| 81 | 81 | 'Ok', |
| 82 | 82 | 'No', |
| 83 | 83 | ]); |
| 84 | - } |
|
| 85 | - else{
|
|
| 84 | + } else{
|
|
| 86 | 85 | |
| 87 | 86 | $this->table->addRow([ |
| 88 | 87 | $key, |
@@ -102,8 +101,7 @@ discard block |
||
| 102 | 101 | $this->table->setHeaders(['id','table','file','type','status','message','seeder']); |
| 103 | 102 | |
| 104 | 103 | echo $this->table->getTable(); |
| 105 | - } |
|
| 106 | - else{
|
|
| 104 | + } else{
|
|
| 107 | 105 | echo $this->classical('No migration was found to apply');
|
| 108 | 106 | } |
| 109 | 107 | |
@@ -14,7 +14,7 @@ discard block |
||
| 14 | 14 | */ |
| 15 | 15 | public function get() |
| 16 | 16 | { |
| 17 | - if(!isset($this->config['paths'][0])){ |
|
| 17 | + if (!isset($this->config['paths'][0])) { |
|
| 18 | 18 | exit(); |
| 19 | 19 | } |
| 20 | 20 | |
@@ -27,11 +27,11 @@ discard block |
||
| 27 | 27 | |
| 28 | 28 | $list = []; |
| 29 | 29 | |
| 30 | - foreach ($migrations as $table=>$item){ |
|
| 30 | + foreach ($migrations as $table=>$item) { |
|
| 31 | 31 | $list[] = strtolower($table); |
| 32 | 32 | } |
| 33 | 33 | |
| 34 | - if(isset($arguments['only'])){ |
|
| 34 | + if (isset($arguments['only'])) { |
|
| 35 | 35 | $dbtables = $this->getOnly($dbtables); |
| 36 | 36 | } |
| 37 | 37 | |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | echo 'Toplam : '.count($dbtables).' Table'; |
| 41 | 41 | echo PHP_EOL; |
| 42 | 42 | |
| 43 | - foreach ($dbtables as $dbtablekey=>$dbtable){ |
|
| 43 | + foreach ($dbtables as $dbtablekey=>$dbtable) { |
|
| 44 | 44 | |
| 45 | 45 | $dbtablekey = $dbtablekey+1; |
| 46 | 46 | |
@@ -49,40 +49,40 @@ discard block |
||
| 49 | 49 | $dbtable = ucfirst($dbtable); |
| 50 | 50 | $makeDirectory = $directory.''.DIRECTORY_SEPARATOR.''.$dbtable; |
| 51 | 51 | |
| 52 | - if(!file_exists($makeDirectory)){ |
|
| 53 | - files()->makeDirectory($makeDirectory,0755,true); |
|
| 54 | - $exist=false; |
|
| 52 | + if (!file_exists($makeDirectory)) { |
|
| 53 | + files()->makeDirectory($makeDirectory, 0755, true); |
|
| 54 | + $exist = false; |
|
| 55 | 55 | } |
| 56 | - else{ |
|
| 57 | - $exist=true; |
|
| 56 | + else { |
|
| 57 | + $exist = true; |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | $migrationName = time().'_'.$dbtable.''; |
| 61 | 61 | |
| 62 | - if($exist===false){ |
|
| 62 | + if ($exist===false) { |
|
| 63 | 63 | |
| 64 | - $content = $this->getContentFile($this->getStubPath().''.DIRECTORY_SEPARATOR.'pullCreate.stub',[ |
|
| 64 | + $content = $this->getContentFile($this->getStubPath().''.DIRECTORY_SEPARATOR.'pullCreate.stub', [ |
|
| 65 | 65 | 'className' => $dbtable, |
| 66 | 66 | 'informations' => $informations |
| 67 | 67 | ]); |
| 68 | 68 | |
| 69 | - $contentResult = files()->put($makeDirectory.''.DIRECTORY_SEPARATOR.''.$migrationName.'.php',$content); |
|
| 69 | + $contentResult = files()->put($makeDirectory.''.DIRECTORY_SEPARATOR.''.$migrationName.'.php', $content); |
|
| 70 | 70 | } |
| 71 | 71 | |
| 72 | - if(substr($dbtable,-1)=='s'){ |
|
| 73 | - app()->command('model create','model:'.strtolower(substr($dbtable,0,-1)).' table:'.$dbtable); |
|
| 72 | + if (substr($dbtable, -1)=='s') { |
|
| 73 | + app()->command('model create', 'model:'.strtolower(substr($dbtable, 0, -1)).' table:'.$dbtable); |
|
| 74 | 74 | } |
| 75 | - else{ |
|
| 76 | - app()->command('model create','model:'.strtolower($dbtable).' table:'.$dbtable); |
|
| 75 | + else { |
|
| 76 | + app()->command('model create', 'model:'.strtolower($dbtable).' table:'.$dbtable); |
|
| 77 | 77 | } |
| 78 | 78 | |
| 79 | - if(isset($contentResult) && $contentResult!==false){ |
|
| 79 | + if (isset($contentResult) && $contentResult!==false) { |
|
| 80 | 80 | echo $dbtablekey.'- '.$migrationName.' ---> Ok'; |
| 81 | 81 | } |
| 82 | - elseif($exist){ |
|
| 82 | + elseif ($exist) { |
|
| 83 | 83 | echo $dbtablekey.'- '.$migrationName.' ---> (Already Exist)'; |
| 84 | 84 | } |
| 85 | - else{ |
|
| 85 | + else { |
|
| 86 | 86 | echo $dbtablekey.'- '.$migrationName.' ---> Fail'; |
| 87 | 87 | } |
| 88 | 88 | |
@@ -110,46 +110,46 @@ discard block |
||
| 110 | 110 | |
| 111 | 111 | $list = []; |
| 112 | 112 | |
| 113 | - foreach ($columns as $key=>$data){ |
|
| 113 | + foreach ($columns as $key=>$data) { |
|
| 114 | 114 | |
| 115 | - $data['Type'] = rtrim(str_replace('unsigned','',$data['Type'])); |
|
| 115 | + $data['Type'] = rtrim(str_replace('unsigned', '', $data['Type'])); |
|
| 116 | 116 | |
| 117 | 117 | $field = $data['Field']; |
| 118 | 118 | $list[] = '$wizard->name(\''.$field.'\')'; |
| 119 | 119 | $list[] = '->'.$this->getColumnTransformers($data['Type']).''; |
| 120 | 120 | |
| 121 | 121 | //default block |
| 122 | - if(!is_null($data['Default'])){ |
|
| 122 | + if (!is_null($data['Default'])) { |
|
| 123 | 123 | $default = $data['Default']; |
| 124 | - $list[] = '->default(\''.$default.'\')'; |
|
| 124 | + $list[] = '->default(\''.$default.'\')'; |
|
| 125 | 125 | } |
| 126 | 126 | |
| 127 | - $getIndex = $this->getIndexInformation($indexes,$data['Field']); |
|
| 127 | + $getIndex = $this->getIndexInformation($indexes, $data['Field']); |
|
| 128 | 128 | |
| 129 | 129 | //unique block |
| 130 | - if($getIndex['Non_unique']=='0' && $getIndex['Key_name']!=='PRIMARY'){ |
|
| 130 | + if ($getIndex['Non_unique']=='0' && $getIndex['Key_name']!=='PRIMARY') { |
|
| 131 | 131 | $indexName = $getIndex['Key_name']; |
| 132 | - $list[] = '->unique(\''.$indexName.'\')'; |
|
| 132 | + $list[] = '->unique(\''.$indexName.'\')'; |
|
| 133 | 133 | } |
| 134 | 134 | |
| 135 | 135 | //index block |
| 136 | - if($getIndex['Non_unique']=='1' && $getIndex['Key_name']!=='PRIMARY'){ |
|
| 136 | + if ($getIndex['Non_unique']=='1' && $getIndex['Key_name']!=='PRIMARY') { |
|
| 137 | 137 | $columnName = $getIndex['Column_name']; |
| 138 | 138 | $indexName = $getIndex['Key_name']; |
| 139 | 139 | |
| 140 | - if(count($multipleIndexes[$indexName])==1){ |
|
| 140 | + if (count($multipleIndexes[$indexName])==1) { |
|
| 141 | 141 | $list[] = '->index(\''.$indexName.'\')'; |
| 142 | 142 | } |
| 143 | 143 | } |
| 144 | 144 | |
| 145 | 145 | //comment block |
| 146 | - if(strlen($data['Comment'])>0){ |
|
| 146 | + if (strlen($data['Comment'])>0) { |
|
| 147 | 147 | $comment = $data['Comment']; |
| 148 | 148 | $list[] = '->comment(\''.$comment.'\')'; |
| 149 | 149 | } |
| 150 | 150 | |
| 151 | 151 | //auto increment block |
| 152 | - if($data['Extra']=='auto_increment'){ |
|
| 152 | + if ($data['Extra']=='auto_increment') { |
|
| 153 | 153 | $list[] = '->auto_increment()'; |
| 154 | 154 | } |
| 155 | 155 | |
@@ -164,39 +164,39 @@ discard block |
||
| 164 | 164 | |
| 165 | 165 | //table indexes |
| 166 | 166 | foreach ($multipleIndexes as $indexName=>$values) { |
| 167 | - if(count($values)>1){ |
|
| 168 | - $values = '\''.implode('\',\'',$values).'\''; |
|
| 167 | + if (count($values)>1) { |
|
| 168 | + $values = '\''.implode('\',\'', $values).'\''; |
|
| 169 | 169 | $list[] = ' $wizard->table()->indexes(\''.$indexName.'\',['.$values.']); |
| 170 | 170 | '; |
| 171 | 171 | } |
| 172 | 172 | } |
| 173 | 173 | |
| 174 | - if(count($foreignKeys)){ |
|
| 174 | + if (count($foreignKeys)) { |
|
| 175 | 175 | |
| 176 | 176 | $constraintName = $foreignKeys['CONSTRAINT_NAME']; |
| 177 | 177 | $key = $foreignKeys['COLUMN_NAME']; |
| 178 | 178 | $referenceTable = $foreignKeys['REFERENCED_TABLE_NAME']; |
| 179 | 179 | $referenceColumn = $foreignKeys['REFERENCED_COLUMN_NAME']; |
| 180 | 180 | |
| 181 | - if($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT'){ |
|
| 181 | + if ($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT') { |
|
| 182 | 182 | $list[] = ' $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\'); |
| 183 | 183 | '; |
| 184 | 184 | } |
| 185 | 185 | |
| 186 | - if($foreignKeys['UPDATE_RULE']!=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT'){ |
|
| 186 | + if ($foreignKeys['UPDATE_RULE']!=='RESTRICT' && $foreignKeys['DELETE_RULE']=='RESTRICT') { |
|
| 187 | 187 | $rule = $foreignKeys['UPDATE_RULE']; |
| 188 | 188 | $list[] = ' $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\')->onUpdate()->'.strtolower($rule).'(); |
| 189 | 189 | '; |
| 190 | 190 | } |
| 191 | 191 | |
| 192 | - if($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']!=='RESTRICT'){ |
|
| 192 | + if ($foreignKeys['UPDATE_RULE']=='RESTRICT' && $foreignKeys['DELETE_RULE']!=='RESTRICT') { |
|
| 193 | 193 | $rule = $foreignKeys['DELETE_RULE']; |
| 194 | 194 | $list[] = ' $wizard->table()->foreign()->constraint(\''.$constraintName.'\')->key(\''.$key.'\')->references(\''.$referenceTable.'\',\''.$referenceColumn.'\')->onDelete()->'.strtolower($rule).'(); |
| 195 | 195 | '; |
| 196 | 196 | } |
| 197 | 197 | } |
| 198 | 198 | |
| 199 | - return implode('',$list); |
|
| 199 | + return implode('', $list); |
|
| 200 | 200 | } |
| 201 | 201 | |
| 202 | 202 | /** |
@@ -207,43 +207,43 @@ discard block |
||
| 207 | 207 | */ |
| 208 | 208 | private function getColumnTransformers($column) |
| 209 | 209 | { |
| 210 | - if($column=='datetime'){ |
|
| 210 | + if ($column=='datetime') { |
|
| 211 | 211 | return 'datetime()'; |
| 212 | 212 | } |
| 213 | - elseif($column=='longtext'){ |
|
| 213 | + elseif ($column=='longtext') { |
|
| 214 | 214 | return 'longtext()'; |
| 215 | 215 | } |
| 216 | - elseif($column=='date'){ |
|
| 216 | + elseif ($column=='date') { |
|
| 217 | 217 | return 'date()'; |
| 218 | 218 | } |
| 219 | - elseif($column=='text'){ |
|
| 219 | + elseif ($column=='text') { |
|
| 220 | 220 | return 'text()'; |
| 221 | 221 | } |
| 222 | - elseif($column=='timestamp'){ |
|
| 222 | + elseif ($column=='timestamp') { |
|
| 223 | 223 | return 'timestamp()'; |
| 224 | 224 | } |
| 225 | - elseif($column=='mediumint'){ |
|
| 225 | + elseif ($column=='mediumint') { |
|
| 226 | 226 | return 'mediumint()'; |
| 227 | 227 | } |
| 228 | - elseif($column=='tinyint'){ |
|
| 228 | + elseif ($column=='tinyint') { |
|
| 229 | 229 | return 'tinyint()'; |
| 230 | 230 | } |
| 231 | - elseif($column=='float'){ |
|
| 231 | + elseif ($column=='float') { |
|
| 232 | 232 | return 'float()'; |
| 233 | 233 | } |
| 234 | - elseif($column=='mediumtext'){ |
|
| 234 | + elseif ($column=='mediumtext') { |
|
| 235 | 235 | return 'mediumtext()'; |
| 236 | 236 | } |
| 237 | - elseif($column=='mediumblob'){ |
|
| 237 | + elseif ($column=='mediumblob') { |
|
| 238 | 238 | return 'mediumblob()'; |
| 239 | 239 | } |
| 240 | - elseif($column=='blob'){ |
|
| 240 | + elseif ($column=='blob') { |
|
| 241 | 241 | return 'blob()'; |
| 242 | 242 | } |
| 243 | - elseif(preg_match('@enum.*\((.*?)\)@',$column,$enum)){ |
|
| 243 | + elseif (preg_match('@enum.*\((.*?)\)@', $column, $enum)) { |
|
| 244 | 244 | return 'enum(['.$enum[1].'])'; |
| 245 | 245 | } |
| 246 | - else{ |
|
| 246 | + else { |
|
| 247 | 247 | return $column; |
| 248 | 248 | } |
| 249 | 249 | } |
@@ -255,11 +255,11 @@ discard block |
||
| 255 | 255 | * @param $field |
| 256 | 256 | * @return void|mixed |
| 257 | 257 | */ |
| 258 | - private function getIndexInformation($index,$field) |
|
| 258 | + private function getIndexInformation($index, $field) |
|
| 259 | 259 | { |
| 260 | 260 | foreach ($index as $key=>$item) { |
| 261 | 261 | |
| 262 | - if($item['Column_name'] == $field){ |
|
| 262 | + if ($item['Column_name']==$field) { |
|
| 263 | 263 | return $index[$key]; |
| 264 | 264 | } |
| 265 | 265 | } |
@@ -277,13 +277,13 @@ discard block |
||
| 277 | 277 | { |
| 278 | 278 | $arguments = $this->schema->getArguments(); |
| 279 | 279 | |
| 280 | - $only = explode(',',$arguments['only']); |
|
| 280 | + $only = explode(',', $arguments['only']); |
|
| 281 | 281 | |
| 282 | 282 | $list = []; |
| 283 | 283 | |
| 284 | - foreach($only as $table){ |
|
| 284 | + foreach ($only as $table) { |
|
| 285 | 285 | |
| 286 | - if(in_array($table,$tables) || in_array($table = strtolower($table),$tables)){ |
|
| 286 | + if (in_array($table, $tables) || in_array($table = strtolower($table), $tables)) { |
|
| 287 | 287 | $list[] = $table; |
| 288 | 288 | } |
| 289 | 289 | } |
@@ -302,7 +302,7 @@ discard block |
||
| 302 | 302 | { |
| 303 | 303 | $list = []; |
| 304 | 304 | foreach ($index as $key=>$item) { |
| 305 | - if($item['Non_unique']==1 && $item['Key_name']!=='PRIMARY'){ |
|
| 305 | + if ($item['Non_unique']==1 && $item['Key_name']!=='PRIMARY') { |
|
| 306 | 306 | $list[$item['Key_name']][] = $item['Column_name']; |
| 307 | 307 | } |
| 308 | 308 | } |
@@ -11,25 +11,25 @@ discard block |
||
| 11 | 11 | */ |
| 12 | 12 | public function processHandler() |
| 13 | 13 | { |
| 14 | - return $this->errorHandler(function(){ |
|
| 14 | + return $this->errorHandler(function() { |
|
| 15 | 15 | |
| 16 | 16 | $results = []; |
| 17 | 17 | |
| 18 | - foreach ($this->list as $table =>$datas){ |
|
| 18 | + foreach ($this->list as $table =>$datas) { |
|
| 19 | 19 | |
| 20 | - foreach ($datas as $data){ |
|
| 20 | + foreach ($datas as $data) { |
|
| 21 | 21 | |
| 22 | - $query = $this->queryBuilder($table,$data); |
|
| 22 | + $query = $this->queryBuilder($table, $data); |
|
| 23 | 23 | |
| 24 | 24 | $query = $query->handle(); |
| 25 | 25 | |
| 26 | - if($query===false){ |
|
| 26 | + if ($query===false) { |
|
| 27 | 27 | $results[] = []; |
| 28 | 28 | } |
| 29 | - else{ |
|
| 30 | - $status =($query['result']!==false) ? true : false; |
|
| 29 | + else { |
|
| 30 | + $status = ($query['result']!==false) ? true : false; |
|
| 31 | 31 | |
| 32 | - $results[]= [ |
|
| 32 | + $results[] = [ |
|
| 33 | 33 | 'success'=>$status, |
| 34 | 34 | 'file'=>$data->getFile(), |
| 35 | 35 | 'table'=>$table, |
@@ -57,7 +57,7 @@ discard block |
||
| 57 | 57 | { |
| 58 | 58 | foreach ($objects as $object) |
| 59 | 59 | { |
| 60 | - if(count($object->getError())){ |
|
| 60 | + if (count($object->getError())) { |
|
| 61 | 61 | return 'error : '.$object->getFile().' -> '.$object->getError()[0].''; |
| 62 | 62 | } |
| 63 | 63 | } |
@@ -25,8 +25,7 @@ |
||
| 25 | 25 | |
| 26 | 26 | if($query===false){ |
| 27 | 27 | $results[] = []; |
| 28 | - } |
|
| 29 | - else{ |
|
| 28 | + } else{ |
|
| 30 | 29 | $status =($query['result']!==false) ? true : false; |
| 31 | 30 | |
| 32 | 31 | $results[]= [ |
@@ -27,32 +27,32 @@ discard block |
||
| 27 | 27 | |
| 28 | 28 | $this->getDefaultSyntaxGroup(); |
| 29 | 29 | |
| 30 | - $this->syntax[]=')'; |
|
| 30 | + $this->syntax[] = ')'; |
|
| 31 | 31 | |
| 32 | 32 | //get table collation |
| 33 | - if(isset($this->data['tableCollation']['table'])){ |
|
| 34 | - $this->syntax[]=' DEFAULT CHARACTER SET '.$this->data['tableCollation']['table']; |
|
| 33 | + if (isset($this->data['tableCollation']['table'])) { |
|
| 34 | + $this->syntax[] = ' DEFAULT CHARACTER SET '.$this->data['tableCollation']['table']; |
|
| 35 | 35 | } |
| 36 | - else{ |
|
| 37 | - $this->syntax[]=' DEFAULT CHARACTER SET utf8'; |
|
| 36 | + else { |
|
| 37 | + $this->syntax[] = ' DEFAULT CHARACTER SET utf8'; |
|
| 38 | 38 | } |
| 39 | 39 | |
| 40 | 40 | //get engine |
| 41 | - if($this->data['engine']!==null) |
|
| 41 | + if ($this->data['engine']!==null) |
|
| 42 | 42 | { |
| 43 | - $this->syntax[]=' ENGINE='.$this->data['engine'].' '; |
|
| 43 | + $this->syntax[] = ' ENGINE='.$this->data['engine'].' '; |
|
| 44 | 44 | } |
| 45 | - else{ |
|
| 46 | - $this->syntax[]=' ENGINE=InnoDB '; |
|
| 45 | + else { |
|
| 46 | + $this->syntax[] = ' ENGINE=InnoDB '; |
|
| 47 | 47 | } |
| 48 | 48 | |
| 49 | - $syntax = implode("",$this->syntax); |
|
| 49 | + $syntax = implode("", $this->syntax); |
|
| 50 | 50 | |
| 51 | - if(in_array($this->table,$existTables)){ |
|
| 51 | + if (in_array($this->table, $existTables)) { |
|
| 52 | 52 | return false; |
| 53 | 53 | } |
| 54 | - else{ |
|
| 55 | - $query=$this->schema->getConnection()->setQueryBasic($syntax); |
|
| 54 | + else { |
|
| 55 | + $query = $this->schema->getConnection()->setQueryBasic($syntax); |
|
| 56 | 56 | |
| 57 | 57 | return [ |
| 58 | 58 | 'syntax'=>$syntax, |
@@ -70,25 +70,25 @@ discard block |
||
| 70 | 70 | private function getDefaultSyntaxGroup() |
| 71 | 71 | { |
| 72 | 72 | |
| 73 | - $this->syntax[]=implode(",",$this->getCreateDefaultList()); |
|
| 73 | + $this->syntax[] = implode(",", $this->getCreateDefaultList()); |
|
| 74 | 74 | |
| 75 | 75 | //get unique values |
| 76 | - if(isset($this->data['uniqueValueList']) && count($this->data['uniqueValueList'])){ |
|
| 77 | - $this->syntax[]=','.implode(',',$this->data['uniqueValueList']); |
|
| 76 | + if (isset($this->data['uniqueValueList']) && count($this->data['uniqueValueList'])) { |
|
| 77 | + $this->syntax[] = ','.implode(',', $this->data['uniqueValueList']); |
|
| 78 | 78 | } |
| 79 | 79 | |
| 80 | 80 | //get index values |
| 81 | - if(isset($this->data['indexValueList']) && count($this->data['indexValueList'])){ |
|
| 82 | - $this->syntax[]=','.implode(',',$this->data['indexValueList']); |
|
| 81 | + if (isset($this->data['indexValueList']) && count($this->data['indexValueList'])) { |
|
| 82 | + $this->syntax[] = ','.implode(',', $this->data['indexValueList']); |
|
| 83 | 83 | } |
| 84 | 84 | |
| 85 | 85 | //get index values for key |
| 86 | - if(count($this->getKeyList())){ |
|
| 87 | - $this->syntax[]=','.implode(',',$this->getKeyList()); |
|
| 86 | + if (count($this->getKeyList())) { |
|
| 87 | + $this->syntax[] = ','.implode(',', $this->getKeyList()); |
|
| 88 | 88 | } |
| 89 | 89 | |
| 90 | - if(count($this->data['references'])){ |
|
| 91 | - $this->syntax[]=$this->getReferenceSyntax($this->data['references']); |
|
| 90 | + if (count($this->data['references'])) { |
|
| 91 | + $this->syntax[] = $this->getReferenceSyntax($this->data['references']); |
|
| 92 | 92 | } |
| 93 | 93 | } |
| 94 | 94 | |
@@ -112,33 +112,33 @@ discard block |
||
| 112 | 112 | |
| 113 | 113 | private function change($alterType) |
| 114 | 114 | { |
| 115 | - if(isset($alterType['place'])){ |
|
| 115 | + if (isset($alterType['place'])) { |
|
| 116 | 116 | |
| 117 | - foreach ($alterType['place'] as $placeKey=>$placeValue){ |
|
| 118 | - $placeList=$placeKey .' '.$placeValue.''; |
|
| 117 | + foreach ($alterType['place'] as $placeKey=>$placeValue) { |
|
| 118 | + $placeList = $placeKey.' '.$placeValue.''; |
|
| 119 | 119 | } |
| 120 | 120 | |
| 121 | - $syntax = implode("",$this->syntax); |
|
| 121 | + $syntax = implode("", $this->syntax); |
|
| 122 | 122 | |
| 123 | 123 | $columns = $this->schema->getConnection()->showColumnsFrom($this->table); |
| 124 | 124 | |
| 125 | - foreach ($columns as $columnKey=>$columnData){ |
|
| 126 | - if($columnData['Field']==$placeValue){ |
|
| 125 | + foreach ($columns as $columnKey=>$columnData) { |
|
| 126 | + if ($columnData['Field']==$placeValue) { |
|
| 127 | 127 | $changeAbleField = $columns[$columnKey+1]['Field']; |
| 128 | 128 | } |
| 129 | 129 | } |
| 130 | 130 | |
| 131 | - $syntaxList = explode(' ',$syntax); |
|
| 131 | + $syntaxList = explode(' ', $syntax); |
|
| 132 | 132 | |
| 133 | - if(current($syntaxList)!==$changeAbleField){ |
|
| 134 | - $alterSytanx = 'ALTER TABLE '.$this->table.' change '.$changeAbleField.' '.current($syntaxList).' '.implode(' ',array_splice($syntaxList,1)).' '.$placeList; |
|
| 133 | + if (current($syntaxList)!==$changeAbleField) { |
|
| 134 | + $alterSytanx = 'ALTER TABLE '.$this->table.' change '.$changeAbleField.' '.current($syntaxList).' '.implode(' ', array_splice($syntaxList, 1)).' '.$placeList; |
|
| 135 | 135 | } |
| 136 | - else{ |
|
| 136 | + else { |
|
| 137 | 137 | $alterSytanx = 'ALTER TABLE '.$this->table.' modify '.$syntax.' '.$placeList; |
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | |
| 141 | - $query=$this->schema->getConnection()->setQueryBasic($alterSytanx); |
|
| 141 | + $query = $this->schema->getConnection()->setQueryBasic($alterSytanx); |
|
| 142 | 142 | |
| 143 | 143 | return [ |
| 144 | 144 | 'syntax'=>$syntax, |
@@ -151,17 +151,17 @@ discard block |
||
| 151 | 151 | |
| 152 | 152 | private function addColumn($alterType) |
| 153 | 153 | { |
| 154 | - if(isset($alterType['place'])){ |
|
| 154 | + if (isset($alterType['place'])) { |
|
| 155 | 155 | |
| 156 | - foreach ($alterType['place'] as $placeKey=>$placeValue){ |
|
| 157 | - $placeList=$placeKey .' '.$placeValue.''; |
|
| 156 | + foreach ($alterType['place'] as $placeKey=>$placeValue) { |
|
| 157 | + $placeList = $placeKey.' '.$placeValue.''; |
|
| 158 | 158 | } |
| 159 | 159 | |
| 160 | - $syntax = implode("",$this->syntax); |
|
| 160 | + $syntax = implode("", $this->syntax); |
|
| 161 | 161 | |
| 162 | 162 | $alterSytanx = 'ALTER TABLE '.$this->table.' ADD COLUMN '.$syntax.' '.$placeList; |
| 163 | 163 | |
| 164 | - $query=$this->schema->getConnection()->setQueryBasic($alterSytanx); |
|
| 164 | + $query = $this->schema->getConnection()->setQueryBasic($alterSytanx); |
|
| 165 | 165 | |
| 166 | 166 | return [ |
| 167 | 167 | 'syntax'=>$syntax, |
@@ -32,8 +32,7 @@ discard block |
||
| 32 | 32 | //get table collation |
| 33 | 33 | if(isset($this->data['tableCollation']['table'])){ |
| 34 | 34 | $this->syntax[]=' DEFAULT CHARACTER SET '.$this->data['tableCollation']['table']; |
| 35 | - } |
|
| 36 | - else{ |
|
| 35 | + } else{ |
|
| 37 | 36 | $this->syntax[]=' DEFAULT CHARACTER SET utf8'; |
| 38 | 37 | } |
| 39 | 38 | |
@@ -41,8 +40,7 @@ discard block |
||
| 41 | 40 | if($this->data['engine']!==null) |
| 42 | 41 | { |
| 43 | 42 | $this->syntax[]=' ENGINE='.$this->data['engine'].' '; |
| 44 | - } |
|
| 45 | - else{ |
|
| 43 | + } else{ |
|
| 46 | 44 | $this->syntax[]=' ENGINE=InnoDB '; |
| 47 | 45 | } |
| 48 | 46 | |
@@ -50,8 +48,7 @@ discard block |
||
| 50 | 48 | |
| 51 | 49 | if(in_array($this->table,$existTables)){ |
| 52 | 50 | return false; |
| 53 | - } |
|
| 54 | - else{ |
|
| 51 | + } else{ |
|
| 55 | 52 | $query=$this->schema->getConnection()->setQueryBasic($syntax); |
| 56 | 53 | |
| 57 | 54 | return [ |
@@ -132,8 +129,7 @@ discard block |
||
| 132 | 129 | |
| 133 | 130 | if(current($syntaxList)!==$changeAbleField){ |
| 134 | 131 | $alterSytanx = 'ALTER TABLE '.$this->table.' change '.$changeAbleField.' '.current($syntaxList).' '.implode(' ',array_splice($syntaxList,1)).' '.$placeList; |
| 135 | - } |
|
| 136 | - else{ |
|
| 132 | + } else{ |
|
| 137 | 133 | $alterSytanx = 'ALTER TABLE '.$this->table.' modify '.$syntax.' '.$placeList; |
| 138 | 134 | } |
| 139 | 135 | |