C# (CSharp) Tup.Cobar4Net.Parser.Recognizer.Mysql.Syntax MySqlDmlCallParser.Call Examples

Call() public method

public Call ( ) : DmlCallStatement
return	Tup.Cobar4Net.Parser.Ast.Stmt.Dml.DmlCallStatement

Example #1

File: MySQLDMLCallParserTest.cs Project: tupunco/Tup.Cobar4Net

 public virtual void TestCall()
 {
     var sql = "call p(?,?) ";
     var lexer = new MySqlLexer(sql);
     var parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
     var calls = parser.Call();
     parser.Match(MySqlToken.Eof);
     var output = Output2MySql(calls, sql);
     Assert.AreEqual("CALL p(?, ?)", output);
     sql = "call p(@var1,'@var2',var3)";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
     calls = parser.Call();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(calls, sql);
     Assert.AreEqual("CALL p(@var1, '@var2', var3)", output);
     sql = "call p()";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
     calls = parser.Call();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(calls, sql);
     Assert.AreEqual("CALL p()", output);
     sql = "call p(?)";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
     calls = parser.Call();
     parser.Match(MySqlToken.Eof);
     output = Output2MySql(calls, sql);
     Assert.AreEqual("CALL p(?)", output);
 }

Example #2

        public virtual void TestCall()
        {
            var sql    = "call p(?,?) ";
            var lexer  = new MySqlLexer(sql);
            var parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
            var calls  = parser.Call();

            parser.Match(MySqlToken.Eof);
            var output = Output2MySql(calls, sql);

            Assert.AreEqual("CALL p(?, ?)", output);
            sql    = "call p(@var1,'@var2',var3)";
            lexer  = new MySqlLexer(sql);
            parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
            calls  = parser.Call();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(calls, sql);
            Assert.AreEqual("CALL p(@var1, '@var2', var3)", output);
            sql    = "call p()";
            lexer  = new MySqlLexer(sql);
            parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
            calls  = parser.Call();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(calls, sql);
            Assert.AreEqual("CALL p()", output);
            sql    = "call p(?)";
            lexer  = new MySqlLexer(sql);
            parser = new MySqlDmlCallParser(lexer, new MySqlExprParser(lexer));
            calls  = parser.Call();
            parser.Match(MySqlToken.Eof);
            output = Output2MySql(calls, sql);
            Assert.AreEqual("CALL p(?)", output);
        }