SqlParser\Components\ExpressionArray::parse PHP Method

parse() public static method

public static parse ( Parser $parser, TokensList $list, array $options = [] ) : Expression[]
$parser SqlParser\Parser The parser that serves as context.
$list SqlParser\TokensList The list of tokens that are being parsed.
$options array Parameters for parsing.
return Expression[]
    public static function parse(Parser $parser, TokensList $list, array $options = array())
    {
        $ret = array();
        /**
         * The state of the parser.
         *
         * Below are the states of the parser.
         *
         *      0 ----------------------[ array ]---------------------> 1
         *
         *      1 ------------------------[ , ]------------------------> 0
         *      1 -----------------------[ else ]----------------------> (END)
         *
         * @var int $state
         */
        $state = 0;
        for (; $list->idx < $list->count; ++$list->idx) {
            /**
             * Token parsed at this moment.
             *
             * @var Token $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 ($token->type === Token::TYPE_KEYWORD && $token->flags & Token::FLAG_KEYWORD_RESERVED && ~$token->flags & Token::FLAG_KEYWORD_FUNCTION && $token->value !== 'DUAL' && $token->value !== 'NULL' && $token->value !== 'CASE') {
                // No keyword is expected.
                break;
            }
            if ($state === 0) {
                if ($token->type === Token::TYPE_KEYWORD && $token->value === 'CASE') {
                    $expr = CaseExpression::parse($parser, $list, $options);
                } else {
                    $expr = Expression::parse($parser, $list, $options);
                }
                if ($expr === null) {
                    break;
                }
                $ret[] = $expr;
                $state = 1;
            } elseif ($state === 1) {
                if ($token->value === ',') {
                    $state = 0;
                } else {
                    break;
                }
            }
        }
        if ($state === 0) {
            $parser->error(__('An expression was expected.'), $list->tokens[$list->idx]);
        }
        --$list->idx;
        return $ret;
    }

Usage Example

示例#1
0
 /**
  * @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 IntoKeyword
  */
 public static function parse(Parser $parser, TokensList $list, array $options = array())
 {
     $ret = new IntoKeyword();
     /**
      * The state of the parser.
      *
      * Below are the states of the parser.
      *
      *      0 -----------------------[ name ]----------------------> 1
      *      0 ---------------------[ OUTFILE ]---------------------> 2
      *
      *      1 ------------------------[ ( ]------------------------> (END)
      *
      *      2 ---------------------[ filename ]--------------------> 1
      *
      * @var int $state
      */
     $state = 0;
     for (; $list->idx < $list->count; ++$list->idx) {
         /**
          * Token parsed at this moment.
          *
          * @var Token $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 ($token->type === Token::TYPE_KEYWORD && $token->flags & Token::FLAG_KEYWORD_RESERVED) {
             if ($state === 0 && $token->value === 'OUTFILE') {
                 $ret->type = 'OUTFILE';
                 $state = 2;
                 continue;
             }
             // No other keyword is expected.
             break;
         }
         if ($state === 0) {
             if (isset($options['fromInsert']) && $options['fromInsert'] || isset($options['fromReplace']) && $options['fromReplace']) {
                 $ret->dest = Expression::parse($parser, $list, array('parseField' => 'table', 'breakOnAlias' => true));
             } else {
                 $ret->values = ExpressionArray::parse($parser, $list);
             }
             $state = 1;
         } elseif ($state === 1) {
             if ($token->type === Token::TYPE_OPERATOR && $token->value === '(') {
                 $ret->columns = ArrayObj::parse($parser, $list)->values;
                 ++$list->idx;
             }
             break;
         } elseif ($state === 2) {
             $ret->dest = $token->value;
             ++$list->idx;
             break;
         }
     }
     --$list->idx;
     return $ret;
 }
All Usage Examples Of SqlParser\Components\ExpressionArray::parse
ExpressionArray