<?php /** * `RENAME TABLE` keyword parser. */ namespace SqlParser\Components; use SqlParser\Component; use SqlParser\Parser; use SqlParser\Token; use SqlParser\TokensList; /** * `RENAME TABLE` keyword parser. * * @category Keywords * * @license https://www.gnu.org/licenses/gpl-2.0.txt GPL-2.0+ */ class RenameOperation extends Component { /** * The old table name. * * @var Expression */ public $old; /** * The new table name. * * @var Expression */ public $new; /** * @param Parser $parser the parser that serves as context * @param TokensList $list the list of tokens that are being parsed * @param array $options parameters for parsing * * @return RenameOperation[] */ public static function parse(Parser $parser, TokensList $list, array $options = array()) { $ret = array(); $expr = new self(); /** * The state of the parser. * * Below are the states of the parser. * * 0 ---------------------[ old name ]--------------------> 1 * * 1 ------------------------[ TO ]-----------------------> 2 * * 2 ---------------------[ old name ]--------------------> 3 * * 3 ------------------------[ , ]------------------------> 0 * 3 -----------------------[ else ]----------------------> (END) * * @var int */ $state = 0; for (; $list->idx < $list->count; ++$list->idx) { /** * Token parsed at this moment. * * @var Token */ $token = $list->tokens[$list->idx]; // End of statement. if ($token->type === Token::TYPE_DELIMITER) { break; } // Skipping whitespaces and comments. if (($token->type === Token::TYPE_WHITESPACE) || ($token->type === Token::TYPE_COMMENT)) { continue; } if ($state === 0) { $expr->old = Expression::parse( $parser, $list, array( 'breakOnAlias' => true, 'parseField' => 'table', ) ); if (empty($expr->old)) { $parser->error( __('The old name of the table was expected.'), $token ); } $state = 1; } elseif ($state === 1) { if (($token->type === Token::TYPE_KEYWORD) && ($token->value === 'TO')) { $state = 2; } else { $parser->error( __('Keyword "TO" was expected.'), $token ); break; } } elseif ($state === 2) { $expr->new = Expression::parse( $parser, $list, array( 'breakOnAlias' => true, 'parseField' => 'table', ) ); if (empty($expr->new)) { $parser->error( __('The new name of the table was expected.'), $token ); } $state = 3; } elseif ($state === 3) { if (($token->type === Token::TYPE_OPERATOR) && ($token->value === ',')) { $ret[] = $expr; $expr = new self(); $state = 0; } else { break; } } } if ($state !== 3) { $parser->error( __('A rename operation was expected.'), $list->tokens[$list->idx - 1] ); } // Last iteration was not saved. if (!empty($expr->old)) { $ret[] = $expr; } --$list->idx; return $ret; } /** * @param RenameOperation $component the component to be built * @param array $options parameters for building * * @return string */ public static function build($component, array $options = array()) { if (is_array($component)) { return implode(', ', $component); } else { return $component->old . ' TO ' . $component->new; } } }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
AlterOperation.php | File | 7.01 KB | 0644 |
|
Array2d.php | File | 3.5 KB | 0644 |
|
ArrayObj.php | File | 5 KB | 0644 |
|
CaseExpression.php | File | 7.27 KB | 0644 |
|
Condition.php | File | 5.85 KB | 0644 |
|
CreateDefinition.php | File | 10.25 KB | 0644 |
|
DataType.php | File | 4.44 KB | 0644 |
|
Expression.php | File | 14.67 KB | 0644 |
|
ExpressionArray.php | File | 3.42 KB | 0644 |
|
FunctionCall.php | File | 2.95 KB | 0644 |
|
IntoKeyword.php | File | 7.1 KB | 0644 |
|
JoinKeyword.php | File | 5.73 KB | 0644 |
|
Key.php | File | 5.33 KB | 0644 |
|
Limit.php | File | 3.04 KB | 0644 |
|
OptionsArray.php | File | 11.98 KB | 0644 |
|
OrderKeyword.php | File | 3.53 KB | 0644 |
|
ParameterDefinition.php | File | 4.24 KB | 0644 |
|
PartitionDefinition.php | File | 6.38 KB | 0644 |
|
Reference.php | File | 3.75 KB | 0644 |
|
RenameOperation.php | File | 4.57 KB | 0644 |
|
SetOperation.php | File | 3.43 KB | 0644 |
|
UnionKeyword.php | File | 754 B | 0644 |
|