Examples of MySqlStatementParser

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

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

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

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

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

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

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

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

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

94
95
96
97
98
99
100
101
102
103
104
105
    }

    public void test_6() throws Exception {
        String sql = "SELECT '~' REGEXP '[[.tilde.]]'";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT '~' REGEXP '[[.tilde.]]';", text);
    }
View Full Code Here

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

33
34
35
36
37
38
39
40
41
42
43
44
                     + "pname VARCHAR(60), " //
                     + "DESCRIPTION TEXT, " //
                     + "ICONURL VARCHAR(255), " //
                     + "CONSTRAINT PK_issuestatus PRIMARY KEY (ID))"; //

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseCreateTable();

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here

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

28
29
30
31
32
33
34
35
36
37
38
39
public class FullTextSearchesWithQueryExpansionTest extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' IN NATURAL LANGUAGE MODE)";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT *\nFROM articles\nWHERE MATCH (title, body) AGAINST ('database' IN NATURAL LANGUAGE MODE);",
                            text);
View Full Code Here

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

25
26
27
28
29
30
31
32
33
34
35
36
    public void test_0() throws Exception {
        String sql = "Describe sdb_goods free_postage";
        Exception error = null;

        try {
            MySqlStatementParser parser = new MySqlStatementParser(sql);
            parser.parseStatementList();
        } catch (Exception e) {
            error = e;
        }

        Assert.assertNotNull(error);
View Full Code Here

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

37
38
39
40
41
42
43
44
45
46
47
48
                                 + "`ebay_name` varchar(50)  NOT NULL COMMENT 'eBay唯一名',"//
                                 + "`create_time` datetime NOT NULL COMMENT '授权时间',"//
                                 + "`invalid_time` datetime NOT NULL COMMENT '授权失效时间'," + "PRIMARY KEY USING BTREE (`auth_id`)"//
                                 + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='INS_EBAY_AUTH';";

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseCreateTable();

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here

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

79
80
81
82
83
84
85
86
87
88
89
90
                                 + "`ebay_name` varchar(50)  NOT NULL COMMENT 'eBay唯一名',"//
                                 + "`create_time` datetime NOT NULL COMMENT '授权时间',"//
                                 + "`invalid_time` datetime NOT NULL COMMENT '授权失效时间'," + "PRIMARY KEY USING BTREE (`auth_id`), INDEX `ind_usr_id` USING BTREE(`usr_id`)"//
                                 + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='INS_EBAY_AUTH';";

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseCreateTable();

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
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.