Package com.alibaba.druid.sql.parser

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

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
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
138
139
140
141
142
143
144
145
146
147
148
149
    }

    public void test_10() throws Exception {
        String sql = "SELECT STRCMP('text', 'text2')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT STRCMP('text', 'text2');", text);
    }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
    }

    public void test_11() throws Exception {
        String sql = "SET @s1 = _latin1 'x' COLLATE latin1_general_ci;";

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

        String text = output(stmtList);

        Assert.assertEquals("SET @s1 = _latin1 'x' COLLATE latin1_general_ci;", text);
    }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
    }

    public void test_12() throws Exception {
        String sql = "SET @s2 = _latin1 'X' COLLATE latin1_general_ci;";

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

        String text = output(stmtList);

        Assert.assertEquals("SET @s2 = _latin1 'X' COLLATE latin1_general_ci;", text);
    }
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
    }

    public void test_13() throws Exception {
        String sql = "SELECT STRCMP(@s1, @s2), STRCMP(@s3, @s4);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT STRCMP(@s1, @s2), STRCMP(@s3, @s4);", text);
    }
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
    }

    public void test_14() throws Exception {
        String sql = "SELECT STRCMP(@s1, @s3 COLLATE latin1_general_ci);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT STRCMP(@s1, @s3 COLLATE latin1_general_ci);", text);
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class LogicalOperatorsTest extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT 10 IS TRUE;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT 10 IS true;", 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 -10 IS TRUE;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT -10 IS true;", 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 'string' IS NOT NULL;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT 'string' IS NOT NULL;", 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.