示例#1
0
 /// <exception cref="System.Exception" />
 public override void Route(SchemaConfig schema, int loop, string sql)
 {
     for (var i = 0; i < loop; ++i)
     {
         var lexer   = new MySqlLexer(sql);
         var select  = new MySqlDmlSelectParser(lexer, new MySqlExprParser(lexer)).Select();
         var visitor = new PartitionKeyVisitor(schema.Tables);
         select.Accept(visitor);
     }
 }
示例#2
0
        /// <exception cref="System.SqlSyntaxErrorException" />
        public static ISqlStatement Parse(string sql, MySqlLexer lexer, string charset)
        {
            try
            {
                ISqlStatement stmt       = null;
                var           isEof      = true;
                var           exprParser = new MySqlExprParser(lexer, charset);
                switch (lexer.Token())
                {
                case MySqlToken.KwDesc:
                case MySqlToken.KwDescribe:
                {
                    stmt = new MySqlDalParser(lexer, exprParser).Desc();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwSelect:
                case MySqlToken.PuncLeftParen:
                {
                    stmt = new MySqlDmlSelectParser(lexer, exprParser).SelectUnion();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwDelete:
                {
                    stmt = new MySqlDmlDeleteParser(lexer, exprParser).Delete();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwInsert:
                {
                    stmt = new MySqlDmlInsertParser(lexer, exprParser).Insert();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwReplace:
                {
                    stmt = new MySqlDmlReplaceParser(lexer, exprParser).Replace();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwUpdate:
                {
                    stmt = new MySqlDmlUpdateParser(lexer, exprParser).Update();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwCall:
                {
                    stmt = new MySqlDmlCallParser(lexer, exprParser).Call();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwSet:
                {
                    stmt = new MySqlDalParser(lexer, exprParser).Set();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwShow:
                {
                    stmt = new MySqlDalParser(lexer, exprParser).Show();
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwAlter:
                case MySqlToken.KwCreate:
                case MySqlToken.KwDrop:
                case MySqlToken.KwRename:
                {
                    stmt  = new MySqlDdlParser(lexer, exprParser).DdlStmt();
                    isEof = IsEOFedDdl(stmt);
                    goto stmtSwitch_break;
                }

                case MySqlToken.KwRelease:
                {
                    stmt = new MySqlMtsParser(lexer).Release();
                    goto stmtSwitch_break;
                }

                case MySqlToken.Identifier:
                {
                    var si = SpecialIdentifier.None;
                    if ((si = SpecialIdentifiers[lexer.GetStringValueUppercase()]) != SpecialIdentifier.None)
                    {
                        switch (si)
                        {
                        case SpecialIdentifier.Truncate:
                        {
                            stmt = new MySqlDdlParser(lexer, exprParser).Truncate();
                            goto stmtSwitch_break;
                        }

                        case SpecialIdentifier.Savepoint:
                        {
                            stmt = new MySqlMtsParser(lexer).Savepoint();
                            goto stmtSwitch_break;
                        }

                        case SpecialIdentifier.Rollback:
                        {
                            stmt = new MySqlMtsParser(lexer).Rollback();
                            goto stmtSwitch_break;
                        }
                        }
                    }
                    goto default;
                }

                default:
                {
                    throw new SqlSyntaxErrorException("sql is not a supported statement");
                }
                }
stmtSwitch_break:
                ;
                if (isEof)
                {
                    while (lexer.Token() == MySqlToken.PuncSemicolon)
                    {
                        lexer.NextToken();
                    }
                    if (lexer.Token() != MySqlToken.Eof)
                    {
                        throw new SqlSyntaxErrorException("Sql syntax error!");
                    }
                }
                return(stmt);
            }
            catch (Exception e)
            {
                throw new SqlSyntaxErrorException(BuildErrorMsg(e, lexer, sql), e);
            }
        }