@@ -53,47 +53,47 @@ discard block |
||
| 53 | 53 | * @var string |
| 54 | 54 | */ |
| 55 | 55 | const TEMPLATE = |
| 56 | - '<?php' . "\n" . |
|
| 57 | - '' . "\n" . |
|
| 58 | - '/**' . "\n" . |
|
| 59 | - ' * Context for %1$s.' . "\n" . |
|
| 60 | - ' *' . "\n" . |
|
| 61 | - ' * This file was auto-generated.' . "\n" . |
|
| 62 | - ' *' . "\n" . |
|
| 63 | - ' * @package SqlParser' . "\n" . |
|
| 64 | - ' * @subpackage Contexts' . "\n" . |
|
| 65 | - ' * @link %3$s' . "\n" . |
|
| 66 | - ' */' . "\n" . |
|
| 67 | - 'namespace SqlParser\\Contexts;' . "\n" . |
|
| 68 | - '' . "\n" . |
|
| 69 | - 'use SqlParser\\Context;' . "\n" . |
|
| 70 | - '' . "\n" . |
|
| 71 | - '/**' . "\n" . |
|
| 72 | - ' * Context for %1$s.' . "\n" . |
|
| 73 | - ' *' . "\n" . |
|
| 74 | - ' * @category Contexts' . "\n" . |
|
| 75 | - ' * @package SqlParser' . "\n" . |
|
| 76 | - ' * @subpackage Contexts' . "\n" . |
|
| 77 | - ' * @author Dan Ungureanu <[email protected]>' . "\n" . |
|
| 78 | - ' * @license http://opensource.org/licenses/GPL-2.0 GNU Public License' . "\n" . |
|
| 79 | - ' */' . "\n" . |
|
| 80 | - 'class %2$s extends Context' . "\n" . |
|
| 81 | - '{' . "\n" . |
|
| 82 | - '' . "\n" . |
|
| 83 | - ' /**' . "\n" . |
|
| 84 | - ' * List of keywords.' . "\n" . |
|
| 85 | - ' *' . "\n" . |
|
| 86 | - ' * The value associated to each keyword represents its flags.' . "\n" . |
|
| 87 | - ' *' . "\n" . |
|
| 88 | - ' * @see Token::FLAG_KEYWORD_*' . "\n" . |
|
| 89 | - ' *' . "\n" . |
|
| 90 | - ' * @var array' . "\n" . |
|
| 91 | - ' */' . "\n" . |
|
| 92 | - ' public static $KEYWORDS = array(' . "\n" . |
|
| 93 | - '' . "\n" . |
|
| 94 | - '%4$s' . |
|
| 95 | - ' );' . "\n" . |
|
| 96 | - '}' . "\n"; |
|
| 56 | + '<?php'."\n". |
|
| 57 | + ''."\n". |
|
| 58 | + '/**'."\n". |
|
| 59 | + ' * Context for %1$s.'."\n". |
|
| 60 | + ' *'."\n". |
|
| 61 | + ' * This file was auto-generated.'."\n". |
|
| 62 | + ' *'."\n". |
|
| 63 | + ' * @package SqlParser'."\n". |
|
| 64 | + ' * @subpackage Contexts'."\n". |
|
| 65 | + ' * @link %3$s'."\n". |
|
| 66 | + ' */'."\n". |
|
| 67 | + 'namespace SqlParser\\Contexts;'."\n". |
|
| 68 | + ''."\n". |
|
| 69 | + 'use SqlParser\\Context;'."\n". |
|
| 70 | + ''."\n". |
|
| 71 | + '/**'."\n". |
|
| 72 | + ' * Context for %1$s.'."\n". |
|
| 73 | + ' *'."\n". |
|
| 74 | + ' * @category Contexts'."\n". |
|
| 75 | + ' * @package SqlParser'."\n". |
|
| 76 | + ' * @subpackage Contexts'."\n". |
|
| 77 | + ' * @author Dan Ungureanu <[email protected]>'."\n". |
|
| 78 | + ' * @license http://opensource.org/licenses/GPL-2.0 GNU Public License'."\n". |
|
| 79 | + ' */'."\n". |
|
| 80 | + 'class %2$s extends Context'."\n". |
|
| 81 | + '{'."\n". |
|
| 82 | + ''."\n". |
|
| 83 | + ' /**'."\n". |
|
| 84 | + ' * List of keywords.'."\n". |
|
| 85 | + ' *'."\n". |
|
| 86 | + ' * The value associated to each keyword represents its flags.'."\n". |
|
| 87 | + ' *'."\n". |
|
| 88 | + ' * @see Token::FLAG_KEYWORD_*'."\n". |
|
| 89 | + ' *'."\n". |
|
| 90 | + ' * @var array'."\n". |
|
| 91 | + ' */'."\n". |
|
| 92 | + ' public static $KEYWORDS = array('."\n". |
|
| 93 | + ''."\n". |
|
| 94 | + '%4$s'. |
|
| 95 | + ' );'."\n". |
|
| 96 | + '}'."\n"; |
|
| 97 | 97 | |
| 98 | 98 | /** |
| 99 | 99 | * Sorts an array of words. |
@@ -198,7 +198,7 @@ discard block |
||
| 198 | 198 | if ($i == 0) { |
| 199 | 199 | $ret .= str_repeat(' ', $spaces); |
| 200 | 200 | } |
| 201 | - $ret .= "'" . $word . "' => " . $type . ', '; |
|
| 201 | + $ret .= "'".$word."' => ".$type.', '; |
|
| 202 | 202 | if (++$i == $count) { |
| 203 | 203 | $ret .= "\n"; |
| 204 | 204 | $i = 0; |
@@ -259,7 +259,7 @@ discard block |
||
| 259 | 259 | * |
| 260 | 260 | * @var string |
| 261 | 261 | */ |
| 262 | - $directory = dirname($input) . '/'; |
|
| 262 | + $directory = dirname($input).'/'; |
|
| 263 | 263 | |
| 264 | 264 | /** |
| 265 | 265 | * The name of the file that contains the context. |
@@ -280,7 +280,7 @@ discard block |
||
| 280 | 280 | * |
| 281 | 281 | * @var string |
| 282 | 282 | */ |
| 283 | - $class = 'Context' . $name; |
|
| 283 | + $class = 'Context'.$name; |
|
| 284 | 284 | |
| 285 | 285 | /** |
| 286 | 286 | * The formatted name of this context. |
@@ -288,13 +288,13 @@ discard block |
||
| 288 | 288 | * @var string |
| 289 | 289 | */ |
| 290 | 290 | $formattedName = str_replace( |
| 291 | - array('Context', 'MySql', '00', '0'), |
|
| 292 | - array('', 'MySQL ', '', '.'), |
|
| 291 | + array('Context', 'MySql', '00', '0'), |
|
| 292 | + array('', 'MySQL ', '', '.'), |
|
| 293 | 293 | $class |
| 294 | 294 | ); |
| 295 | 295 | |
| 296 | 296 | file_put_contents( |
| 297 | - $output . '/' . $class . '.php', |
|
| 297 | + $output.'/'.$class.'.php', |
|
| 298 | 298 | static::generate( |
| 299 | 299 | array( |
| 300 | 300 | 'name' => $formattedName, |
@@ -302,9 +302,9 @@ discard block |
||
| 302 | 302 | 'link' => static::$LINKS[$name], |
| 303 | 303 | 'keywords' => static::readWords( |
| 304 | 304 | array( |
| 305 | - $directory . '_common.txt', |
|
| 306 | - $directory . '_functions' . $file, |
|
| 307 | - $directory . $file |
|
| 305 | + $directory.'_common.txt', |
|
| 306 | + $directory.'_functions'.$file, |
|
| 307 | + $directory.$file |
|
| 308 | 308 | ) |
| 309 | 309 | ), |
| 310 | 310 | ) |
@@ -332,7 +332,7 @@ discard block |
||
| 332 | 332 | |
| 333 | 333 | // Building the context. |
| 334 | 334 | sprintf("Building context for %s...\n", $file); |
| 335 | - static::build($input . '/' . $file, $output); |
|
| 335 | + static::build($input.'/'.$file, $output); |
|
| 336 | 336 | } |
| 337 | 337 | } |
| 338 | 338 | } |
@@ -152,9 +152,9 @@ discard block |
||
| 152 | 152 | } |
| 153 | 153 | |
| 154 | 154 | // Appending the filename to directories. |
| 155 | - $inputFile = $input . '/' . $file; |
|
| 156 | - $outputFile = $output . '/' . $file; |
|
| 157 | - $debugFile = ($debug !== null) ? $debug . '/' . $file : null; |
|
| 155 | + $inputFile = $input.'/'.$file; |
|
| 156 | + $outputFile = $output.'/'.$file; |
|
| 157 | + $debugFile = ($debug !== null) ? $debug.'/'.$file : null; |
|
| 158 | 158 | |
| 159 | 159 | if (is_dir($inputFile)) { |
| 160 | 160 | // Creating required directories to maintain the structure. |
@@ -171,9 +171,9 @@ discard block |
||
| 171 | 171 | } elseif (substr($inputFile, -3) === '.in') { |
| 172 | 172 | // Generating file names by replacing `.in` with `.out` and |
| 173 | 173 | // `.debug`. |
| 174 | - $outputFile = substr($outputFile, 0, -3) . '.out'; |
|
| 174 | + $outputFile = substr($outputFile, 0, -3).'.out'; |
|
| 175 | 175 | if ($debug !== null) { |
| 176 | - $debugFile = substr($debugFile, 0, -3) . '.debug'; |
|
| 176 | + $debugFile = substr($debugFile, 0, -3).'.debug'; |
|
| 177 | 177 | } |
| 178 | 178 | |
| 179 | 179 | // Building the test. |
@@ -228,7 +228,7 @@ discard block |
||
| 228 | 228 | $ret->subquery = $token->value; |
| 229 | 229 | } elseif (($token->flags & Token::FLAG_KEYWORD_FUNCTION) |
| 230 | 230 | && (empty($options['parseField']) |
| 231 | - && ! $alias) |
|
| 231 | + && !$alias) |
|
| 232 | 232 | ) { |
| 233 | 233 | $isExpr = true; |
| 234 | 234 | } elseif (($token->flags & Token::FLAG_KEYWORD_RESERVED) |
@@ -255,7 +255,7 @@ discard block |
||
| 255 | 255 | continue; |
| 256 | 256 | } |
| 257 | 257 | $isExpr = true; |
| 258 | - } elseif ($brackets === 0 && count($ret->expr) > 0 && ! $alias) { |
|
| 258 | + } elseif ($brackets === 0 && count($ret->expr) > 0 && !$alias) { |
|
| 259 | 259 | /* End of expression */ |
| 260 | 260 | break; |
| 261 | 261 | } |
@@ -433,7 +433,7 @@ discard block |
||
| 433 | 433 | } |
| 434 | 434 | |
| 435 | 435 | if (!empty($component->alias)) { |
| 436 | - $ret .= ' AS ' . Context::escape($component->alias); |
|
| 436 | + $ret .= ' AS '.Context::escape($component->alias); |
|
| 437 | 437 | } |
| 438 | 438 | |
| 439 | 439 | return $ret; |
@@ -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 | |
@@ -223,7 +223,7 @@ discard block |
||
| 223 | 223 | // We have reached the end of ALTER operation and suddenly found |
| 224 | 224 | // a start to new statement, but have not find a delimiter between them |
| 225 | 225 | |
| 226 | - if (! ($token->value == 'SET' && $list->tokens[$list->idx - 1]->value == 'CHARACTER')) { |
|
| 226 | + if (!($token->value == 'SET' && $list->tokens[$list->idx - 1]->value == 'CHARACTER')) { |
|
| 227 | 227 | $parser->error( |
| 228 | 228 | __('A new statement was found, but no delimiter between it and the previous one.'), |
| 229 | 229 | $token |
@@ -255,9 +255,9 @@ discard block |
||
| 255 | 255 | */ |
| 256 | 256 | public static function build($component, array $options = array()) |
| 257 | 257 | { |
| 258 | - $ret = $component->options . ' '; |
|
| 258 | + $ret = $component->options.' '; |
|
| 259 | 259 | if ((isset($component->field)) && ($component->field !== '')) { |
| 260 | - $ret .= $component->field . ' '; |
|
| 260 | + $ret .= $component->field.' '; |
|
| 261 | 261 | } |
| 262 | 262 | $ret .= TokensList::build($component->unknown); |
| 263 | 263 | return $ret; |
@@ -139,10 +139,10 @@ |
||
| 139 | 139 | { |
| 140 | 140 | if ($component->dest instanceof Expression) { |
| 141 | 141 | $columns = !empty($component->columns) ? |
| 142 | - '(`' . implode('`, `', $component->columns) . '`)' : ''; |
|
| 143 | - return $component->dest . $columns; |
|
| 142 | + '(`'.implode('`, `', $component->columns).'`)' : ''; |
|
| 143 | + return $component->dest.$columns; |
|
| 144 | 144 | } else { |
| 145 | - return 'OUTFILE "' . $component->dest . '"'; |
|
| 145 | + return 'OUTFILE "'.$component->dest.'"'; |
|
| 146 | 146 | } |
| 147 | 147 | } |
| 148 | 148 | } |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | * @var array |
| 33 | 33 | */ |
| 34 | 34 | public static $CLAUSES = array( |
| 35 | - 'SET' => array('SET', 3), |
|
| 35 | + 'SET' => array('SET', 3), |
|
| 36 | 36 | ); |
| 37 | 37 | |
| 38 | 38 | /** |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | */ |
| 67 | 67 | public function build() |
| 68 | 68 | { |
| 69 | - return 'SET ' . OptionsArray::build($this->options) |
|
| 70 | - . ' ' . SetOperation::build($this->set); |
|
| 69 | + return 'SET '.OptionsArray::build($this->options) |
|
| 70 | + . ' '.SetOperation::build($this->set); |
|
| 71 | 71 | } |
| 72 | 72 | } |
@@ -115,19 +115,19 @@ |
||
| 115 | 115 | */ |
| 116 | 116 | public function build() |
| 117 | 117 | { |
| 118 | - $ret = 'INSERT ' . $this->options |
|
| 119 | - . ' INTO ' . $this->into; |
|
| 118 | + $ret = 'INSERT '.$this->options |
|
| 119 | + . ' INTO '.$this->into; |
|
| 120 | 120 | |
| 121 | 121 | if ($this->values != NULL && count($this->values) > 0) { |
| 122 | - $ret .= ' VALUES ' . Array2d::build($this->values); |
|
| 122 | + $ret .= ' VALUES '.Array2d::build($this->values); |
|
| 123 | 123 | } elseif ($this->set != NULL && count($this->set) > 0) { |
| 124 | - $ret .= ' SET ' . SetOperation::build($this->set); |
|
| 124 | + $ret .= ' SET '.SetOperation::build($this->set); |
|
| 125 | 125 | } elseif ($this->select != NULL && count($this->select) > 0) { |
| 126 | - $ret .= ' ' . $this->select->build(); |
|
| 126 | + $ret .= ' '.$this->select->build(); |
|
| 127 | 127 | } |
| 128 | 128 | |
| 129 | 129 | if ($this->onDuplicateSet != NULL && count($this->onDuplicateSet) > 0) { |
| 130 | - $ret .= ' ON DUPLICATE KEY UPDATE ' . SetOperation::build($this->onDuplicateSet); |
|
| 130 | + $ret .= ' ON DUPLICATE KEY UPDATE '.SetOperation::build($this->onDuplicateSet); |
|
| 131 | 131 | } |
| 132 | 132 | |
| 133 | 133 | return $ret; |
@@ -93,15 +93,15 @@ |
||
| 93 | 93 | */ |
| 94 | 94 | public function build() |
| 95 | 95 | { |
| 96 | - $ret = 'REPLACE ' . $this->options |
|
| 97 | - . ' INTO ' . $this->into; |
|
| 96 | + $ret = 'REPLACE '.$this->options |
|
| 97 | + . ' INTO '.$this->into; |
|
| 98 | 98 | |
| 99 | 99 | if ($this->values != NULL && count($this->values) > 0) { |
| 100 | - $ret .= ' VALUES ' . Array2d::build($this->values); |
|
| 100 | + $ret .= ' VALUES '.Array2d::build($this->values); |
|
| 101 | 101 | } elseif ($this->set != NULL && count($this->set) > 0) { |
| 102 | - $ret .= ' SET ' . SetOperation::build($this->set); |
|
| 102 | + $ret .= ' SET '.SetOperation::build($this->set); |
|
| 103 | 103 | } elseif ($this->select != NULL && count($this->select) > 0) { |
| 104 | - $ret .= ' ' . $this->select->build(); |
|
| 104 | + $ret .= ' '.$this->select->build(); |
|
| 105 | 105 | } |
| 106 | 106 | |
| 107 | 107 | return $ret; |