@@ -11,7 +11,6 @@ |
||
| 11 | 11 | use SqlParser\Parser; |
| 12 | 12 | use SqlParser\Statement; |
| 13 | 13 | use SqlParser\Token; |
| 14 | -use SqlParser\Context; |
|
| 15 | 14 | use SqlParser\TokensList; |
| 16 | 15 | use SqlParser\Components\ArrayObj; |
| 17 | 16 | use SqlParser\Components\DataType; |
@@ -277,80 +277,80 @@ |
||
| 277 | 277 | $fields = ''; |
| 278 | 278 | if (!empty($this->fields)) { |
| 279 | 279 | if (is_array($this->fields)) { |
| 280 | - $fields = CreateDefinition::build($this->fields) . ' '; |
|
| 280 | + $fields = CreateDefinition::build($this->fields).' '; |
|
| 281 | 281 | } elseif ($this->fields instanceof ArrayObj) { |
| 282 | 282 | $fields = ArrayObj::build($this->fields); |
| 283 | 283 | } |
| 284 | 284 | } |
| 285 | 285 | if ($this->options->has('DATABASE')) { |
| 286 | 286 | return 'CREATE ' |
| 287 | - . OptionsArray::build($this->options) . ' ' |
|
| 288 | - . Expression::build($this->name) . ' ' |
|
| 287 | + . OptionsArray::build($this->options).' ' |
|
| 288 | + . Expression::build($this->name).' ' |
|
| 289 | 289 | . OptionsArray::build($this->entityOptions); |
| 290 | 290 | } elseif ($this->options->has('TABLE') && !is_null($this->select)) { |
| 291 | 291 | return 'CREATE ' |
| 292 | - . OptionsArray::build($this->options) . ' ' |
|
| 293 | - . Expression::build($this->name) . ' ' |
|
| 292 | + . OptionsArray::build($this->options).' ' |
|
| 293 | + . Expression::build($this->name).' ' |
|
| 294 | 294 | . $this->select->build(); |
| 295 | 295 | } elseif ($this->options->has('TABLE') && !is_null($this->like)) { |
| 296 | 296 | return 'CREATE ' |
| 297 | - . OptionsArray::build($this->options) . ' ' |
|
| 298 | - . Expression::build($this->name) . ' LIKE ' |
|
| 297 | + . OptionsArray::build($this->options).' ' |
|
| 298 | + . Expression::build($this->name).' LIKE ' |
|
| 299 | 299 | . Expression::build($this->like); |
| 300 | 300 | } elseif ($this->options->has('TABLE')) { |
| 301 | 301 | $partition = ''; |
| 302 | 302 | |
| 303 | 303 | if (!empty($this->partitionBy)) { |
| 304 | - $partition .= "\nPARTITION BY " . $this->partitionBy; |
|
| 304 | + $partition .= "\nPARTITION BY ".$this->partitionBy; |
|
| 305 | 305 | } |
| 306 | 306 | if (!empty($this->partitionsNum)) { |
| 307 | - $partition .= "\nPARTITIONS " . $this->partitionsNum; |
|
| 307 | + $partition .= "\nPARTITIONS ".$this->partitionsNum; |
|
| 308 | 308 | } |
| 309 | 309 | if (!empty($this->subpartitionBy)) { |
| 310 | - $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy; |
|
| 310 | + $partition .= "\nSUBPARTITION BY ".$this->subpartitionBy; |
|
| 311 | 311 | } |
| 312 | 312 | if (!empty($this->subpartitionsNum)) { |
| 313 | - $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum; |
|
| 313 | + $partition .= "\nSUBPARTITIONS ".$this->subpartitionsNum; |
|
| 314 | 314 | } |
| 315 | 315 | if (!empty($this->partitions)) { |
| 316 | - $partition .= "\n" . PartitionDefinition::build($this->partitions); |
|
| 316 | + $partition .= "\n".PartitionDefinition::build($this->partitions); |
|
| 317 | 317 | } |
| 318 | 318 | |
| 319 | 319 | return 'CREATE ' |
| 320 | - . OptionsArray::build($this->options) . ' ' |
|
| 321 | - . Expression::build($this->name) . ' ' |
|
| 320 | + . OptionsArray::build($this->options).' ' |
|
| 321 | + . Expression::build($this->name).' ' |
|
| 322 | 322 | . $fields |
| 323 | 323 | . OptionsArray::build($this->entityOptions) |
| 324 | 324 | . $partition; |
| 325 | 325 | } elseif ($this->options->has('VIEW')) { |
| 326 | 326 | return 'CREATE ' |
| 327 | - . OptionsArray::build($this->options) . ' ' |
|
| 328 | - . Expression::build($this->name) . ' ' |
|
| 329 | - . $fields . ' AS ' . TokensList::build($this->body) . ' ' |
|
| 327 | + . OptionsArray::build($this->options).' ' |
|
| 328 | + . Expression::build($this->name).' ' |
|
| 329 | + . $fields.' AS '.TokensList::build($this->body).' ' |
|
| 330 | 330 | . OptionsArray::build($this->entityOptions); |
| 331 | 331 | } elseif ($this->options->has('TRIGGER')) { |
| 332 | 332 | return 'CREATE ' |
| 333 | - . OptionsArray::build($this->options) . ' ' |
|
| 334 | - . Expression::build($this->name) . ' ' |
|
| 335 | - . OptionsArray::build($this->entityOptions) . ' ' |
|
| 336 | - . 'ON ' . Expression::build($this->table) . ' ' |
|
| 337 | - . 'FOR EACH ROW ' . TokensList::build($this->body); |
|
| 333 | + . OptionsArray::build($this->options).' ' |
|
| 334 | + . Expression::build($this->name).' ' |
|
| 335 | + . OptionsArray::build($this->entityOptions).' ' |
|
| 336 | + . 'ON '.Expression::build($this->table).' ' |
|
| 337 | + . 'FOR EACH ROW '.TokensList::build($this->body); |
|
| 338 | 338 | } elseif (($this->options->has('PROCEDURE')) |
| 339 | 339 | || ($this->options->has('FUNCTION')) |
| 340 | 340 | ) { |
| 341 | 341 | $tmp = ''; |
| 342 | 342 | if ($this->options->has('FUNCTION')) { |
| 343 | - $tmp = 'RETURNS ' . DataType::build($this->return); |
|
| 343 | + $tmp = 'RETURNS '.DataType::build($this->return); |
|
| 344 | 344 | } |
| 345 | 345 | return 'CREATE ' |
| 346 | - . OptionsArray::build($this->options) . ' ' |
|
| 347 | - . Expression::build($this->name) . ' ' |
|
| 348 | - . ParameterDefinition::build($this->parameters) . ' ' |
|
| 349 | - . $tmp . ' ' . TokensList::build($this->body); |
|
| 346 | + . OptionsArray::build($this->options).' ' |
|
| 347 | + . Expression::build($this->name).' ' |
|
| 348 | + . ParameterDefinition::build($this->parameters).' ' |
|
| 349 | + . $tmp.' '.TokensList::build($this->body); |
|
| 350 | 350 | } |
| 351 | 351 | return 'CREATE ' |
| 352 | - . OptionsArray::build($this->options) . ' ' |
|
| 353 | - . Expression::build($this->name) . ' ' |
|
| 352 | + . OptionsArray::build($this->options).' ' |
|
| 353 | + . Expression::build($this->name).' ' |
|
| 354 | 354 | . TokensList::build($this->body); |
| 355 | 355 | } |
| 356 | 356 | |