@@ -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 |