Package com.alibaba.druid.sql.parser

Examples of com.alibaba.druid.sql.parser.SQLStatementParser

50
51
52
53
54
55
56
57
58
59
60
61
    }

    public void test_2() throws Exception {
        String sql = "SELECT x'4D7953514C';";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 0x4D7953514C;", text);
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
    }

    public void test_3() throws Exception {
        String sql = "SELECT 0x65 USING utf8;";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 0x65 USING utf8;", text);
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
    }

    public void test_4() throws Exception {
        String sql = "SELECT 0x41, CAST(0x41 AS UNSIGNED)";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 0x41, CAST(0x41 AS UNSIGNED);", text);
    }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
    }

    public void test_5() throws Exception {
        String sql = "SELECT HEX('cat')";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT HEX('cat');", text);
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class RegularExpressionsTest extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT 'Monty!' REGEXP '.*'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'Monty!' REGEXP '.*';", text);
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
    }

    public void test_1() throws Exception {
        String sql = "SELECT 'new*\n*line' REGEXP 'new\\\\*.\\\\*line'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'new*\n*line' REGEXP 'new\\*.\\*line';", text);
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
    }

    public void test_2() throws Exception {
        String sql = "SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A';", text);
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
    }

    public void test_3() throws Exception {
        String sql = "SELECT 'a' REGEXP '^[a-d]'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'a' REGEXP '^[a-d]';", text);
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
    }

    public void test_4() throws Exception {
        String sql = "SELECT 'fo\nfo' REGEXP '^fo$'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'fo\nfo' REGEXP '^fo$';", text);
    }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
    }

    public void test_5() throws Exception {
        String sql = "SELECT 'fofo' REGEXP '^fo'";

        SQLStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'fofo' REGEXP '^fo';", text);
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.parser.SQLStatementParser

  • com.alibaba.druid.bvt.sql.mysql.ArithmeticOperatorsTest
  • com.alibaba.druid.bvt.sql.mysql.AssignmentOperatorsTest
  • com.alibaba.druid.bvt.sql.mysql.BitFunctionsTest
  • com.alibaba.druid.bvt.sql.mysql.BooleanValuesTest
  • com.alibaba.druid.bvt.sql.mysql.CALL_Test
  • com.alibaba.druid.bvt.sql.mysql.CastFunctionsAndOperatorsTest
  • com.alibaba.druid.bvt.sql.mysql.ComparisonFunctionsAndOperatorsTest
  • com.alibaba.druid.bvt.sql.mysql.ControlFlowFunctionsTest
  • com.alibaba.druid.bvt.sql.mysql.DateAndTimeFunctionsTest
  • com.alibaba.druid.bvt.sql.mysql.DateAndTimeValuesTest
    • 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.