Tup.Cobar4Net.Parser.Recognizer.Mysql.Syntax.MySqlDmlUpdateParser.Update C# (CSharp) Method

MySqlDmlUpdateParser Class Documentation Usage Examples Of Tup.Cobar4Net.Parser.Recognizer.Mysql.Syntax.MySqlDmlUpdateParser::Update Datei anzeigen Open project: tupunco/Tup.Cobar4Net

Update() public method

nothing has been pre-consumed 
 'UPDATE' 'LOW_PRIORITY'? 'IGNORE'? table_reference 'SET' colName ('='|':=') (expr|'DEFAULT') (',' colName ('='|':=') (expr|'DEFAULT')) ('WHERE' cond)? {singleTable}? => ('ORDER' 'BY' orderBy)?  ('LIMIT' Count)?
public Update ( ) : DmlUpdateStatement
return Tup.Cobar4Net.Parser.Ast.Stmt.Dml.DmlUpdateStatement 
        public virtual DmlUpdateStatement Update()
        {
            Match(MySqlToken.KwUpdate);
            var lowPriority = false;
            var ignore = false;
            if (lexer.Token() == MySqlToken.KwLowPriority)
            {
                lexer.NextToken();
                lowPriority = true;
            }
            if (lexer.Token() == MySqlToken.KwIgnore)
            {
                lexer.NextToken();
                ignore = true;
            }
            var tableRefs = TableRefs();
            Match(MySqlToken.KwSet);
            IList<Pair<Identifier, IExpression>> values;
            var col = Identifier();
            Match(MySqlToken.OpEquals, MySqlToken.OpAssign);
            var expr = exprParser.Expression();
            if (lexer.Token() == MySqlToken.PuncComma)
            {
                values = new List<Pair<Identifier, IExpression>>();
                values.Add(new Pair<Identifier, IExpression>(col, expr));
                for (; lexer.Token() == MySqlToken.PuncComma;)
                {
                    lexer.NextToken();
                    col = Identifier();
                    Match(MySqlToken.OpEquals, MySqlToken.OpAssign);
                    expr = exprParser.Expression();
                    values.Add(new Pair<Identifier, IExpression>(col, expr));
                }
            }
            else
            {
                values = new List<Pair<Identifier, IExpression>>(1);
                values.Add(new Pair<Identifier, IExpression>(col, expr));
            }
            IExpression where = null;
            if (lexer.Token() == MySqlToken.KwWhere)
            {
                lexer.NextToken();
                where = exprParser.Expression();
            }
            OrderBy orderBy = null;
            Limit limit = null;
            if (tableRefs.IsSingleTable)
            {
                orderBy = OrderBy();
                limit = Limit();
            }
            return new DmlUpdateStatement(lowPriority, ignore, tableRefs, values, where, orderBy, limit);
        }
    }

Usage Example

Beispiel #1
0
 public virtual void TestUpdate()
 {
     var sql = "upDate LOw_PRIORITY IGNORE test.t1 sEt t1.col1=?, col2=DefaulT";
     var lexer = new MySqlLexer(sql);
     var parser = new MySqlDmlUpdateParser(lexer, new MySqlExprParser(lexer));
     var update = parser.Update();
     var output = Output2MySql(update, sql);
     Assert.IsNotNull(update);
     Assert.AreEqual("UPDATE LOW_PRIORITY IGNORE test.t1 SET t1.col1 = ?, col2 = DEFAULT", output);
     sql = "upDate  IGNORE (t1) set col2=DefaulT order bY t1.col2 ";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlUpdateParser(lexer, new MySqlExprParser(lexer));
     update = parser.Update();
     output = Output2MySql(update, sql);
     Assert.AreEqual("UPDATE IGNORE t1 SET col2 = DEFAULT ORDER BY t1.col2", output);
     sql = "upDate   (test.t1) SET col2=DefaulT order bY t1.col2 limit ? offset 1";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlUpdateParser(lexer, new MySqlExprParser(lexer));
     update = parser.Update();
     output = Output2MySql(update, sql);
     Assert.AreEqual("UPDATE test.t1 SET col2 = DEFAULT ORDER BY t1.col2 LIMIT 1, ?", output);
     sql = "upDate LOW_PRIORITY  t1, test.t2 SET col2=DefaulT , col2='123''4'";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlUpdateParser(lexer, new MySqlExprParser(lexer));
     update = parser.Update();
     output = Output2MySql(update, sql);
     Assert.AreEqual("UPDATE LOW_PRIORITY t1, test.t2 SET col2 = DEFAULT, col2 = '123\\'4'", output);
     sql = "upDate LOW_PRIORITY  t1, test.t2 SET col2:=DefaulT , col2='123''4' where id='a'";
     lexer = new MySqlLexer(sql);
     parser = new MySqlDmlUpdateParser(lexer, new MySqlExprParser(lexer));
     update = parser.Update();
     output = Output2MySql(update, sql);
     Assert.AreEqual("UPDATE LOW_PRIORITY t1, test.t2 SET col2 = DEFAULT, col2 = '123\\'4' WHERE id = 'a'",
         output);
 }
All Usage Examples Of Tup.Cobar4Net.Parser.Recognizer.Mysql.Syntax.MySqlDmlUpdateParser::Update
MySqlDmlUpdateParser
MySqlDmlUpdateParser
Update