Package com.alibaba.druid.sql.parser

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

171
172
173
174
175
176
177
178
179
180
181
182
    }

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

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT 1 XOR 1 XOR 1;", text);
    }
View Full Code Here
557
558
559
560
561
562
563
564
565
566
567
568
    }

    public void test_48() throws Exception {
        String sql = "SELECT TO_DAYS(950501);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT TO_DAYS(950501);", text);
    }
View Full Code Here
568
569
570
571
572
573
574
575
576
577
578
579
    }

    public void test_49() throws Exception {
        String sql = "SELECT TO_DAYS('0000-01-01');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT TO_DAYS('0000-01-01');", text);
    }
View Full Code Here
579
580
581
582
583
584
585
586
587
588
589
590
    }

    public void test_50() throws Exception {
        String sql = "SELECT UNIX_TIMESTAMP();";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT UNIX_TIMESTAMP();", text);
    }
View Full Code Here
590
591
592
593
594
595
596
597
598
599
600
601
    }

    public void test_51() throws Exception {
        String sql = "SELECT WEEK('2008-02-20');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT WEEK('2008-02-20');", text);
    }
View Full Code Here
601
602
603
604
605
606
607
608
609
610
611
612
    }

    public void test_52() throws Exception {
        String sql = "SELECT MID(YEARWEEK('2000-01-01'),5,2);";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT MID(YEARWEEK('2000-01-01'), 5, 2);", text);
    }
View Full Code Here
612
613
614
615
616
617
618
619
620
621
622
623
    }

    public void test_53() throws Exception {
        String sql = "SELECT YEARWEEK('1987-01-01');";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT YEARWEEK('1987-01-01');", text);
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class EncryptionAndCompressionFunctionsTest extends TestCase {

    public void test_0() throws Exception {
        String sql = "INSERT INTO t VALUES (1,AES_ENCRYPT('text','password'))";

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

        String text = output(stmtList);

        Assert.assertEquals("INSERT INTO t\nVALUES (1, AES_ENCRYPT('text', 'password'));", 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 LENGTH(COMPRESS(REPEAT('a',1000)))";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT LENGTH(COMPRESS(REPEAT('a', 1000)));", 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 LENGTH(COMPRESS(REPEAT('a',16)))";

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

        String text = output(stmtList);

        Assert.assertEquals("SELECT LENGTH(COMPRESS(REPEAT('a', 16)));", 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.