상속: MySqlDmlInsertReplaceParser
 public virtual void TestReplace()
 {
     var sql = "ReplaCe LOW_PRIORITY intO test.t1 seT t1.id1:=?, id2='123'";
     var lexer = new MySqlLexer(sql);
     var parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     var replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     Assert.IsNotNull(replace);
     var output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO test.t1 (t1.id1, id2) VALUES (?, '123')", output);
     sql = "ReplaCe   test.t1 seT t1.id1:=? ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE INTO test.t1 (t1.id1) VALUES (?)", output);
     sql = "ReplaCe t1 value (123,?) ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE INTO t1 VALUES (123, ?)", output);
     sql = "ReplaCe LOW_PRIORITY t1 valueS (12e-2), (?)";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 VALUES (0.12), (?)", output);
     sql = "ReplaCe LOW_PRIORITY t1 select id from t1";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 SELECT id FROM t1",
         output);
     sql = "ReplaCe delayed t1 select id from t1";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE DELAYED INTO t1 SELECT id FROM t1", output);
     sql = "ReplaCe LOW_PRIORITY t1 (select id from t1) ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 SELECT id FROM t1",
         output);
     sql = "ReplaCe LOW_PRIORITY t1 (t1.col1) valueS (123),('12''34')";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (t1.col1) VALUES (123), ('12\\'34')", output);
     sql = "ReplaCe LOW_PRIORITY t1 (col1, t1.col2) VALUE (123,'123\\'4') ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1, t1.col2) VALUES (123, '123\\'4')", output);
     sql = "REPLACE LOW_PRIORITY t1 (col1, t1.col2) select id from t3 ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1, t1.col2) SELECT id FROM t3", output);
     sql = "replace LOW_PRIORITY  intO t1 (col1) ( select id from t3) ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
     replace = parser.Replace();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(replace, sql);
     Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1) SELECT id FROM t3", output);
 }
예제 #2
0
        public virtual void TestReplace()
        {
            var sql     = "ReplaCe LOW_PRIORITY intO test.t1 seT t1.id1:=?, id2='123'";
            var lexer   = new MySqlLexer(sql);
            var parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            var replace = parser.Replace();

            parser.Match(MySqlToken.Eof);
            Assert.IsNotNull(replace);
            var output = Output2MySql(replace, sql);

            Assert.AreEqual("REPLACE LOW_PRIORITY INTO test.t1 (t1.id1, id2) VALUES (?, '123')", output);
            sql     = "ReplaCe   test.t1 seT t1.id1:=? ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE INTO test.t1 (t1.id1) VALUES (?)", output);
            sql     = "ReplaCe t1 value (123,?) ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE INTO t1 VALUES (123, ?)", output);
            sql     = "ReplaCe LOW_PRIORITY t1 valueS (12e-2), (?)";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 VALUES (0.12), (?)", output);
            sql     = "ReplaCe LOW_PRIORITY t1 select id from t1";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 SELECT id FROM t1",
                            output);
            sql     = "ReplaCe delayed t1 select id from t1";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE DELAYED INTO t1 SELECT id FROM t1", output);
            sql     = "ReplaCe LOW_PRIORITY t1 (select id from t1) ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 SELECT id FROM t1",
                            output);
            sql     = "ReplaCe LOW_PRIORITY t1 (t1.col1) valueS (123),('12''34')";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (t1.col1) VALUES (123), ('12\\'34')", output);
            sql     = "ReplaCe LOW_PRIORITY t1 (col1, t1.col2) VALUE (123,'123\\'4') ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1, t1.col2) VALUES (123, '123\\'4')", output);
            sql     = "REPLACE LOW_PRIORITY t1 (col1, t1.col2) select id from t3 ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1, t1.col2) SELECT id FROM t3", output);
            sql     = "replace LOW_PRIORITY  intO t1 (col1) ( select id from t3) ";
            lexer   = new MySqlLexer(sql);
            parser  = new MySqlDmlReplaceParser(lexer, new MySqlExprParser(lexer));
            replace = parser.Replace();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(replace, sql);
            Assert.AreEqual("REPLACE LOW_PRIORITY INTO t1 (col1) SELECT id FROM t3", output);
        }
예제 #3
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);
            }
        }