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

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

217
218
219
220
221
222
223
224
225
226
227
    public void test_17() throws Exception {
        String sql = "SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT DATEDIFF('2010-11-30 23:59:59', '2010-12-31');", text);
    }
View Full Code Here
228
229
230
231
232
233
234
235
236
237
238
    public void test_18() throws Exception {
        String sql = "SELECT '2008-12-31 23:59:59' + INTERVAL 1 SECOND;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT '2008-12-31 23:59:59' + INTERVAL 1 SECOND;", text);
    }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
    public void test_19() throws Exception {
        String sql = "SELECT INTERVAL 1 DAY + '2008-12-31';";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT INTERVAL 1 DAY + '2008-12-31';", text);
    }
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
    public void test_20() throws Exception {
        String sql = "SELECT '2005-01-01' - INTERVAL 1 SECOND;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT '2005-01-01' - INTERVAL 1 SECOND;", text);
    }
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
    public void test_21() throws Exception {
        String sql = "SELECT DATE_ADD('2000-12-31 23:59:59',INTERVAL 1 SECOND);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT DATE_ADD('2000-12-31 23:59:59', INTERVAL 1 SECOND);", text);
    }
View Full Code Here
272
273
274
275
276
277
278
279
280
281
282
    public void test_22() throws Exception {
        String sql = "SELECT DATE_ADD('2009-01-01', INTERVAL 6/4 HOUR_MINUTE);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT DATE_ADD('2009-01-01', INTERVAL 6 / 4 HOUR_MINUTE);", text);
    }
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
    public void test_23() throws Exception {
        String sql = "SELECT DATE_ADD('2009-01-01', INTERVAL 6/4 MINUTE_SECOND);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT DATE_ADD('2009-01-01', INTERVAL 6 / 4 MINUTE_SECOND);", text);
    }
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
    public void test_24() throws Exception {
        String sql = "SELECT INTERVAL '-1 10' DAY_HOUR;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT INTERVAL '-1 10' DAY_HOUR;", text);
    }
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
    public void test_25() throws Exception {
        String sql = "SELECT INTERVAL '1 1:1:1' DAY_SECOND;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT INTERVAL '1 1:1:1' DAY_SECOND;", text);
    }
View Full Code Here
316
317
318
319
320
321
322
323
324
325
326
    public void test_26() throws Exception {
        String sql = "SELECT INTERVAL '-1 10' DAY_HOUR;";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT INTERVAL '-1 10' DAY_HOUR;", text);
    }
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.