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

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

876
877
878
879
880
881
882
883
884
885
886
   
    public void test_show_profile_1() throws Exception {
        String sql = "SHOW profile all,block io,context switches,cpu,ipc,memory, page faults,source,swaps for query 2 limit 1 offset 2";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        MySqlShowProfileStatement show = (MySqlShowProfileStatement) parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(show);
        Assert.assertEquals("SHOW PROFILE ALL, BLOCK IO, CONTEXT SWITCHES, CPU, IPC, MEMORY, PAGE FAULTS, SOURCE, SWAPS FOR QUERY 2 LIMIT 2, 1", output);
    }
   
    public void test_show_relayLogEvents() throws Exception {
View Full Code Here
885
886
887
888
889
890
891
892
893
894
895
   
    public void test_show_relayLogEvents() throws Exception {
        String sql = "SHOW RELAYLOG EVENTS";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        MySqlShowRelayLogEventsStatement show = (MySqlShowRelayLogEventsStatement) parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(show);
        Assert.assertEquals("SHOW RELAYLOG EVENTS", output);
    }
   
    public void test_show_relayLogEvents_1() throws Exception {
View Full Code Here
894
895
896
897
898
899
900
901
902
903
904
   
    public void test_show_relayLogEvents_1() throws Exception {
        String sql = "SHOW RELAYLOG EVENTS IN 'x' from 3 limit 5,6";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        MySqlShowRelayLogEventsStatement show = (MySqlShowRelayLogEventsStatement) parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(show);
        Assert.assertEquals("SHOW RELAYLOG EVENTS IN 'x' FROM 3 LIMIT 5, 6", output);
    }
   
    public void test_show_slaveHosts() throws Exception {
View Full Code Here
903
904
905
906
907
908
909
910
911
912
913
   
    public void test_show_slaveHosts() throws Exception {
        String sql = "SHOW SLAVE HOSTS";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        MySqlShowSlaveHostsStatement show = (MySqlShowSlaveHostsStatement) parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(show);
        Assert.assertEquals("SHOW SLAVE HOSTS", output);
    }
   
    public void test_show_slaveStatus() throws Exception {
View Full Code Here
912
913
914
915
916
917
918
919
920
921
922
   
    public void test_show_slaveStatus() throws Exception {
        String sql = "SHOW SLAVE Status";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        MySqlShowSlaveStatusStatement show = (MySqlShowSlaveStatusStatement) parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(show);
        Assert.assertEquals("SHOW SLAVE STATUS", output);
    }
   
    public void test_show_status() throws Exception {
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
    public void testDelete_0() throws Exception {
        String sql = "deLetE LOW_PRIORITY from id1.id , id using t1 a where col1 =? ";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("DELETE LOW_PRIORITY FROM id1.id, id USING (t1) AS a" + //
                            "\nWHERE col1 = ?", output);
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
    public void testDelete_1() throws Exception {
        String sql = "deLetE from id1.id  using t1";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("DELETE FROM id1.id" + //
                            "\nUSING t1", output);
    }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    public void testDelete_2() throws Exception {
        String sql = "delete from offer.*,wp_image.* using offer a,wp_image b where a.member_id=b.member_id and a.member_id='abc' ";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("DELETE FROM offer.*, wp_image.*" + //
                            " USING (offer) AS a, wp_image b\n" + //
                            "WHERE a.member_id = b.member_id\n" + //
                            "\tAND a.member_id = 'abc'", output);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
    public void testDelete_3() throws Exception {
        String sql = "deLetE from id1.id where col1='adf' limit 1,?";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("DELETE FROM id1.id\n" + //
                            "WHERE col1 = 'adf'\n" + //
                            "LIMIT 1, ?", output);
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    public void testDelete_4() throws Exception {
        String sql = "deLetE from id where col1='adf' ordEr by d liMit ? offset 2";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);
        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("DELETE FROM id\n" + //
                            "WHERE col1 = 'adf'\n" + //
                            "ORDER BY d\n" + //
                            "LIMIT 2, ?", output);
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.