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

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

73
74
75
76
77
78
79
80
81
82
83
84
    }

    public void test_4() throws Exception {
        String sql = "SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY)";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);", text);
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
    }

    public void test_5() throws Exception {
        String sql = "SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY)";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY);", text);
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
    }

    public void test_6() throws Exception {
        String sql = "SELECT ADDDATE('2008-01-02', 31)";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT ADDDATE('2008-01-02', 31);", text);
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
    }

    public void test_7() throws Exception {
        String sql = "SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');", text);
    }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
    }

    public void test_8() throws Exception {
        String sql = "SELECT ADDTIME('01:00:00.999999', '02:00:00.999998')";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');", text);
    }
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
    }

    public void test_9() throws Exception {
        String sql = "SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT CONVERT_TZ('2004-01-01 12:00:00', 'GMT', 'MET');", text);
    }
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
    }

    public void test_10() throws Exception {
        String sql = "SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT CONVERT_TZ('2004-01-01 12:00:00', '+00:00', '+10:00');", text);
    }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
    }

    public void test_11() throws Exception {
        String sql = "SELECT CURDATE();";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT CURDATE();", text);
    }
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
    }

    public void test_12() throws Exception {
        String sql = "SELECT CURDATE() + 0;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT CURDATE() + 0;", text);
    }
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
183
    }

    public void test_13() throws Exception {
        String sql = "SELECT CURTIME();";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT CURTIME();", text);
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser

  • com.alibaba.druid.bvt.sql.cobar.DALParserTest
  • com.alibaba.druid.bvt.sql.cobar.DMLDeleteParserTest
  • com.alibaba.druid.bvt.sql.mysql.MySqlCreateTableTest
  • com.alibaba.druid.mapping.spi.MySqlMappingProvider
  • com.alibaba.druid.mock.handler.MySqlMockExecuteHandlerImpl
  • com.alibaba.druid.sql.ast.expr.SQLCharExpr
  • com.alibaba.druid.sql.ast.expr.SQLIdentifierExpr
  • com.alibaba.druid.sql.ast.expr.SQLLiteralExpr
  • com.alibaba.druid.sql.ast.expr.SQLQueryExpr
  • com.alibaba.druid.sql.ast.expr.SQLVariantRefExpr
    • 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.