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

Examples of com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser

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

    public void test_0() throws Exception {
        String sql = "TRUNCATE bigtable, fattable;";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
    }

    public void test_1() throws Exception {
        String sql = "TRUNCATE bigtable, fattable RESTART IDENTITY;";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
    }

    public void test_2() throws Exception {
        String sql = "TRUNCATE othertable CASCADE;";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class DropTableTest extends PGTest {

    public void test_0() throws Exception {
        String sql = "DROP TABLE films, distributors;";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class PGInsertTest0 extends PGTest {

    public void test_0() throws Exception {
        String sql = "INSERT INTO films VALUES ('UA502', 'Bananas', 105, '1971-07-13', 'Comedy', '82 minutes');";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
                     "    product_no integer," + //
                     "    name text," + //
                     "    price numeric" + //
                     ");";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
                     ", \"algLable.schemaName\", \"algLable.tableName\", \"algLable.fieldName\"" + //
                     " from cnres.function_select_algmodule_rule() " + //
                     " as a( id text,name text,beanId text, \"algLable.id\" text,\"algLable.name\" text" + //
                     ", \"algLable.schemaName\" text,\"algLable.tableName\" text, \"algLable.fieldName\" text)";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
    public void test_0() throws Exception {
        String sql = "SELECT res.restaurant_id, row_number() " + //
                     "over (order by ST_Distance(res.restaurant_point,GeomFromEWKT(?))*111.12 ) as row_id " + //
                     "FROM restaurant res where res.city_id = ? and res.is_delete =false and res.restaurant_id <1000000 limit 10";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
                     + "SELECT t_e_shopcatalog.* " //
                     + "FROM t_e_shopcatalog, r " //
                     + "WHERE t_e_shopcatalog.parentcatalogid = r.catalogid )"
                     + "SELECT * FROM r )rs WHERE 1=1";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
    }
   
    public void test_3() throws Exception {
        String sql = "            select    memberId ,   offerIds    from cnres.function_select_get_seller_hot_offer_list('\\'-1\\'')    as a(memberId character varying(20),offerIds character varying(4000))     ";
       
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);
       
        Assert.assertEquals(1, statementList.size());
       
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser

  • com.alibaba.druid.bvt.sql.postgresql.DropTableTest
  • com.alibaba.druid.bvt.sql.postgresql.PGCreateTableTest_0
  • com.alibaba.druid.bvt.sql.postgresql.PGCreateTableTest_1
  • com.alibaba.druid.bvt.sql.postgresql.PGCreateTableTest_2
  • com.alibaba.druid.bvt.sql.postgresql.PGCreateTableTest_3
  • com.alibaba.druid.bvt.sql.postgresql.PGCreateTableTest_4
  • com.alibaba.druid.bvt.sql.postgresql.PGDeleteTest
  • com.alibaba.druid.bvt.sql.postgresql.PGDeleteTest2
  • com.alibaba.druid.bvt.sql.postgresql.PGDeleteTest3
  • com.alibaba.druid.bvt.sql.postgresql.PGDeleteTest4
    • 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.