C# (CSharp) Tup.Cobar4Net.Parser.Recognizer.Mysql.Syntax MySqlMtsParser.Savepoint示例

Savepoint() public method

first token SAVEPOINT is scanned but not yet consumed

public Savepoint ( ) : MTSSavepointStatement
return	Tup.Cobar4Net.Parser.Ast.Stmt.Mts.MTSSavepointStatement

示例#1

        public virtual void TestSavepint()
        {
            var sql       = "  savepoint 123e123e";
            var parser    = new MySqlMtsParser(new MySqlLexer(sql));
            var savepoint = parser.Savepoint();
            var output    = Output2MySql(savepoint, sql);

            Assert.AreEqual("SAVEPOINT 123e123e", output);
            Assert.AreEqual("123e123e", savepoint.Savepoint.IdText);
            sql       = "  savepoint SAVEPOINT";
            parser    = new MySqlMtsParser(new MySqlLexer(sql));
            savepoint = parser.Savepoint();
            output    = Output2MySql(savepoint, sql);
            Assert.AreEqual("SAVEPOINT SAVEPOINT", output);
            Assert.AreEqual("SAVEPOINT", savepoint.Savepoint.IdText);
            sql       = "  savepoInt `select`";
            parser    = new MySqlMtsParser(new MySqlLexer(sql));
            savepoint = parser.Savepoint();
            output    = Output2MySql(savepoint, sql);
            Assert.AreEqual("SAVEPOINT `select`", output);
            Assert.AreEqual("`select`", savepoint.Savepoint.IdText);
        }

示例#2

文件： MySQLMTSParserTest.cs 项目： tupunco/Tup.Cobar4Net

 public virtual void TestSavepint()
 {
     var sql = "  savepoint 123e123e";
     var parser = new MySqlMtsParser(new MySqlLexer(sql));
     var savepoint = parser.Savepoint();
     var output = Output2MySql(savepoint, sql);
     Assert.AreEqual("SAVEPOINT 123e123e", output);
     Assert.AreEqual("123e123e", savepoint.Savepoint.IdText);
     sql = "  savepoint SAVEPOINT";
     parser = new MySqlMtsParser(new MySqlLexer(sql));
     savepoint = parser.Savepoint();
     output = Output2MySql(savepoint, sql);
     Assert.AreEqual("SAVEPOINT SAVEPOINT", output);
     Assert.AreEqual("SAVEPOINT", savepoint.Savepoint.IdText);
     sql = "  savepoInt `select`";
     parser = new MySqlMtsParser(new MySqlLexer(sql));
     savepoint = parser.Savepoint();
     output = Output2MySql(savepoint, sql);
     Assert.AreEqual("SAVEPOINT `select`", output);
     Assert.AreEqual("`select`", savepoint.Savepoint.IdText);
 }