Package com.alibaba.druid.sql.dialect.mysql.parser

Examples of com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser

38
39
40
41
42
43
44
45
46
    return SQLParserUtils.createSQLStatementParser(sql, dbType);
  }

  public static SQLExprParser createExprParser(String sql, String dbType) {
    if (WASP.equals(dbType) || JdbcUtils.HBASE.equals(dbType)) {
      return new MySqlExprParser(sql);
    }
    return SQLParserUtils.createExprParser(sql, dbType);
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
    public static SQLExpr toMySqlExpr(String sql) {
        MySqlLexer lexer = new MySqlLexer(sql);
        lexer.nextToken();

        MySqlExprParser parser = new MySqlExprParser(lexer);
        SQLExpr expr = parser.expr();

        if (lexer.token() != Token.EOF) {
            throw new ParserException("illegal sql expr : " + sql);
        }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        if (JdbcUtils.ORACLE.equals(dbType)) {
            return new OracleExprParser(sql);
        }

        if (JdbcUtils.MYSQL.equals(dbType)) {
            return new MySqlExprParser(sql);
        }

        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGExprParser(sql);
        }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        }

        if (JdbcUtils.MYSQL.equals(dbType) || //
            JdbcUtils.MARIADB.equals(dbType) || //
            JdbcUtils.H2.equals(dbType)) {
            return new MySqlExprParser(sql);
        }

        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGExprParser(sql);
        }
View Full Code Here
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    public void test_exits() throws Exception {
        String sql = "-a";
        String sql_c = "-(a+1 + +(b+1))";
        SQLUnaryExpr exprA, exprB, exprC;
        {
            MySqlExprParser parser = new MySqlExprParser(sql);
            exprA = (SQLUnaryExpr) parser.expr();
        }
        {
            MySqlExprParser parser = new MySqlExprParser(sql);
            exprB = (SQLUnaryExpr) parser.expr();
        }
        {
            MySqlExprParser parser = new MySqlExprParser(sql_c);
            exprC = (SQLUnaryExpr) parser.expr();
        }
        Assert.assertEquals(exprA, exprB);
        Assert.assertNotEquals(exprA, exprC);
        Assert.assertTrue(exprA.equals(exprA));
        Assert.assertFalse(exprA.equals(new Object()));
View Full Code Here
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    public void test_exits() throws Exception {
        String sql = "fstate in (select state from t_status)";
        String sql_c = "fstate_c in (select state from t_status)";
        SQLInSubQueryExpr exprA, exprB, exprC;
        {
            MySqlExprParser parser = new MySqlExprParser(sql);
            exprA = (SQLInSubQueryExpr) parser.expr();
        }
        {
            MySqlExprParser parser = new MySqlExprParser(sql);
            exprB = (SQLInSubQueryExpr) parser.expr();
        }
        {
            MySqlExprParser parser = new MySqlExprParser(sql_c);
            exprC = (SQLInSubQueryExpr) parser.expr();
        }
        Assert.assertEquals(exprA, exprB);
        Assert.assertNotEquals(exprA, exprC);
        Assert.assertTrue(exprA.equals(exprA));
        Assert.assertFalse(exprA.equals(new Object()));
View Full Code Here
28
29
30
31
32
33
34
35
* @author <a href="mailto:shuo.qius@alibaba-inc.com">QIU Shuo</a>
*/
public class LiteralHexadecimalTest extends TestCase {
    public void test_0() throws Exception {
        String sql = "x'E982B1E7A195275C73'";
        SQLHexExpr hex = (SQLHexExpr) new MySqlExprParser(sql).expr();
        Assert.assertEquals("邱硕'\\s", new String(hex.toBytes(), "utf-8"));
    }
View Full Code Here
34
35
36
37
38
39
40
41
        Assert.assertEquals("邱硕'\\s", new String(hex.toBytes(), "utf-8"));
    }

    public void test_1() throws Exception {
        String sql = "x'0D0A'";
        SQLHexExpr hex = (SQLHexExpr) new MySqlExprParser(sql).expr();
        Assert.assertEquals("\r\n", new String(hex.toBytes(), "utf-8"));
    }
View Full Code Here
40
41
42
43
44
45
46
47
        Assert.assertEquals("\r\n", new String(hex.toBytes(), "utf-8"));
    }
   
    public void test_2() throws Exception {
        String sql = "X'4D7953514C'";
        SQLHexExpr hex = (SQLHexExpr) new MySqlExprParser(sql).expr();
        Assert.assertEquals("MySQL", new String(hex.toBytes(), "utf-8"));
    }
View Full Code Here
46
47
48
49
50
51
52
53
        Assert.assertEquals("MySQL", new String(hex.toBytes(), "utf-8"));
    }
   
    public void test_3() throws Exception {
        String sql = "0x5061756c";
        SQLHexExpr hex = (SQLHexExpr) new MySqlExprParser(sql).expr();
        Assert.assertEquals("Paul", new String(hex.toBytes(), "utf-8"));
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser

  • com.alibaba.druid.bvt.sql.cobar.LiteralHexadecimalTest
  • com.alibaba.druid.bvt.sql.EqualTest_binary
  • com.alibaba.druid.bvt.sql.EqualTest_boolean
  • com.alibaba.druid.bvt.sql.EqualTest_extract_mysql
  • com.alibaba.druid.bvt.sql.EqualTest_inquery
  • com.alibaba.druid.bvt.sql.EqualTest_interval_mysql
  • com.alibaba.druid.bvt.sql.EqualTest_mysqlMatch
  • com.alibaba.druid.bvt.sql.EqualTest_unary_mysql
  • com.alibaba.druid.sql.ast.expr.SQLBinaryOpExpr
  • com.alibaba.druid.sql.ast.expr.SQLCharExpr
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.