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

Examples of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseStatementList()

29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = "GRANT SELECT (col1), INSERT (col1,col2) ON mydb.mytbl TO 'someuser'@'somehost';";

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    public void test_0() throws Exception {
        String sql = "INSERT INTO tbl_name (col1,col2) VALUES(15,col1*2);";

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLInsertStatement insertStmt = (SQLInsertStatement) stmt;

        Assert.assertEquals(2, insertStmt.getValues().getValues().size());
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = "INSERT INTO t VALUES (1,AES_ENCRYPT('text','password'))";

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

        String text = output(stmtList);

        Assert.assertEquals("INSERT INTO t\nVALUES (1, AES_ENCRYPT('text', 'password'));", text);
    }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    public void test_1() throws Exception {
        String sql = "SELECT LENGTH(COMPRESS(REPEAT('a',1000)))";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT LENGTH(COMPRESS(REPEAT('a', 1000)));", text);
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    public void test_2() throws Exception {
        String sql = "SELECT LENGTH(COMPRESS(REPEAT('a',16)))";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT LENGTH(COMPRESS(REPEAT('a', 16)));", text);
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    public void test_3() throws Exception {
        String sql = "SELECT MD5('testing')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT MD5('testing');", text);
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    public void test_4() throws Exception {
        String sql = "SELECT SHA1('abc')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT SHA1('abc');", text);
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    public void test_5() throws Exception {
        String sql = "SELECT SHA2('abc')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT SHA2('abc');", text);
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
    public void test_6() throws Exception {
        String sql = "SELECT PASSWORD('badpwd')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT PASSWORD('badpwd');", text);
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = "GRANT SHOW VIEW ON mydb.* TO 'someuser'@'somehost';";

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.