A Ӫk߭M̭uX v9+DaD#WO$*7 1549jvv§{<.[ZV~H"’76͇ڐs& كmC :pwva(oBWmL(Gsgu5Lf?PԜ{Z-Nˆ"lq6H5Ns?#J=ԎX$;B}3NzdqF?ʎ vAi>XyʯucvOIr5{sx \1v}3L܇!B(+JғReH+0;:dKەqz$IA"\gsQ8=>%j$?P>\,bvOƨS|peg)(ysrʅszZEvhyjF}x=F8i4*iyT]l3\WۘGW 8ʁ@o3@4e\Y_WƏ/QZ)[dȮ=ey 7tBO]i620?eYH \J|`0w1+8xA F3MKb^CQ+ Vm0 d DP$eO'镫,zL?h< YȘYzc4Xa uLEL@Fy>4^PEꗐtTa MEFYϓjNc1*ƫ^vv Ne䶠hޑfD5non.j| ')s7OQ*֐%GcrLRaU㼬˜bx=S@/s 0*'c'#{/ AhA ht;+QňE*Nɶ1 !R.iHZ54nmOY1r ݦ"j UKNۂ;EX!q)MEpCj-`WݪZa!B)fbRwh]e<;B AIA6c~ a108ǵMޙH(ޠT~F+x +U)f ihH8ۼ_ <6(+(:^$s h:4s7#rKax*+${-t2/Ne! Zb$<)5~X#[x@Vm4$I7ni ,q~a›%P0'ʶL &ħ h;n! 7:´dQ_,yYo9QJJ7ii4B]@63Ƭ E1XwxUI8~JUm'{r(;2r0ol(*iwb; z@b\63Ͳs(7XMv,Cp٩0,W<+i@&hN<.lK5 M rp|XTB `_ve72{k>yt賂/l69˝XbHEzf@g a,ucmƧTٶ: |'뿺VqB]sE6k~9@gaDsM~a8U: g-sxi>6t#ŐNnb#z#T\ #Z2Y SE׆6ozKa-WJ6Dx1թ]È3 T_dZ+2# 36`GNMi2}?\Rvvk2uQg ٰK hcp8|j > Q;Srjb I;ǒGWMՏ,•C)kk雰) 8iY?Nuh8OFCo SdW)ls0/"H se b40Z@5b[jH HnC~[(" %J߃NDFl0jʀU-̀}G D gQnm> =yݐX{=Ċ Ge#nI %J߃NDFlֲ0 =w9>SI8p(Pey ،gRJiy,'x<^0QYk1m!wz++6ߝ'I2%ruփiC>icIm15LlK낟5j#:V˪3#DuW(\Sɚ\@:FHF#<N,Ѷ^kYN]Ƶ0Oכ|AsfY`J{"d1`~c#)DLa&lE*!M3z&QKLÇS] \J)YpCE}#4j[S Dl2mƒ;FIԊ J6vso^ykt^ԁ+N@tm%4~QgA q4y|[M+]!m ;Wng/BQLbL@y. R֧Ri D }a}ϣ΍8Ftӎ 1 * * 1 --------------------[ CONSTRAINT ]------------------> 1 * 1 -----------------------[ key ]----------------------> 2 * 1 -------------[ constraint / column name ]-----------> 2 * * 2 --------------------[ data type ]-------------------> 3 * * 3 ---------------------[ options ]--------------------> 4 * * 4 --------------------[ REFERENCES ]------------------> 4 * * 5 ------------------------[ , ]-----------------------> 1 * 5 ------------------------[ ) ]-----------------------> 6 (-1) * * @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) { if (($token->type === Token::TYPE_OPERATOR) && ($token->value === '(')) { $state = 1; } else { $parser->error( __('An opening bracket was expected.'), $token ); break; } } elseif ($state === 1) { if (($token->type === Token::TYPE_KEYWORD) && ($token->value === 'CONSTRAINT')) { $expr->isConstraint = true; } elseif (($token->type === Token::TYPE_KEYWORD) && ($token->flags & Token::FLAG_KEYWORD_KEY)) { $expr->key = Key::parse($parser, $list); $state = 4; } elseif ($token->type === Token::TYPE_SYMBOL || $token->type === Token::TYPE_NONE) { $expr->name = $token->value; if (!$expr->isConstraint) { $state = 2; } } elseif ($token->type === Token::TYPE_KEYWORD) { if ($token->flags & Token::FLAG_KEYWORD_RESERVED) { // Reserved keywords can't be used // as field names without backquotes $parser->error( __('A symbol name was expected! ' . 'A reserved keyword can not be used ' . 'as a column name without backquotes.' ), $token ); return $ret; } else { // Non-reserved keywords are allowed without backquotes $expr->name = $token->value; $state = 2; } } else { $parser->error( __('A symbol name was expected!'), $token ); return $ret; } } elseif ($state === 2) { $expr->type = DataType::parse($parser, $list); $state = 3; } elseif ($state === 3) { $expr->options = OptionsArray::parse($parser, $list, static::$FIELD_OPTIONS); $state = 4; } elseif ($state === 4) { if (($token->type === Token::TYPE_KEYWORD) && ($token->value === 'REFERENCES')) { ++$list->idx; // Skipping keyword 'REFERENCES'. $expr->references = Reference::parse($parser, $list); } else { --$list->idx; } $state = 5; } elseif ($state === 5) { if ((!empty($expr->type)) || (!empty($expr->key))) { $ret[] = $expr; } $expr = new self(); if ($token->value === ',') { $state = 1; } elseif ($token->value === ')') { $state = 6; ++$list->idx; break; } else { $parser->error( __('A comma or a closing bracket was expected.'), $token ); $state = 0; break; } } } // Last iteration was not saved. if ((!empty($expr->type)) || (!empty($expr->key))) { $ret[] = $expr; } if (($state !== 0) && ($state !== 6)) { $parser->error( __('A closing bracket was expected.'), $list->tokens[$list->idx - 1] ); } --$list->idx; return $ret; } /** * @param CreateDefinition|CreateDefinition[] $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 "(\n " . implode(",\n ", $component) . "\n)"; } else { $tmp = ''; if ($component->isConstraint) { $tmp .= 'CONSTRAINT '; } if ((isset($component->name)) && ($component->name !== '')) { $tmp .= Context::escape($component->name) . ' '; } if (!empty($component->type)) { $tmp .= DataType::build( $component->type, array('lowercase' => true) ) . ' '; } if (!empty($component->key)) { $tmp .= $component->key . ' '; } if (!empty($component->references)) { $tmp .= 'REFERENCES ' . $component->references . ' '; } $tmp .= $component->options; return trim($tmp); } } }