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

Examples of com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseStatementList()

61
62
63
64
65
66
67
68
69
70
71
   
    public void test_1() throws Exception {
        String sql = "select    memberId ,   offerIds    from cnres.function_select_get_seller_hot_offer_list('\\'gzyyd168\\'')    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
85
86
87
88
89
90
91
92
93
94
95
   
    public void test_2() throws Exception {
        String sql = "            select    offerId ,   offerIds    from cnres.function_select_get_self_rel_offer_by_behavior      ('    350740   ')       as a(offerId numeric,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
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = "DELETE FROM tasks WHERE status = 'DONE' RETURNING *;";

        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
15
16
17
18
19
20
21
22
23
24
25
public class PGExportParameterVisitorTest extends TestCase {
    public void test_pg() throws Exception {
        String sql = "select fname, count(*) from t where fid = 1 group by fname order by 1";

        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);

        List<Object> parameters = new ArrayList<Object>();
        PGExportParameterVisitor visitor = new PGExportParameterVisitor(parameters);
        stmt.accept(visitor);
       
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = "DELETE FROM films WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');";

        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
41
42
43
44
45
46
47
48
49
50
51
                     "    , \"cateRule.id\" text, \"cateRule.name\" text, \"cateRule.assembleType\" text" + //
                     "    , \"cateRule.algmIds\" text, \"cateRule.algmRatio\" text, \"cateRule.algmMaxRatio\" text" + //
                     "    , \"appObject.id\" text,\"appObject.name\" text, \"appObject.beanId\" 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
33
34
35
36
37
38
39
40
41
42
43
                     "    name text," + //
                     "    price numeric DEFAULT 9.99" + //
                     ");";

        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
    public void test_0() throws Exception {
        String sql = "DELETE FROM tasks WHERE CURRENT OF c_tasks;";

        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
    public void test_0() throws Exception {
        String sql = "select \"xxx\"::varchar as xx from xxx;";

        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
30
31
32
33
34
35
36
37
38
39
40
        String sql = "select fromUserId, toMemberId, rank, tag " + //
                     "from cnres.function_get_re_cni_myali_acion_fct0(?) " + //
                     "as (fromUserId character varying(128), toMemberId character varying(128), rank numeric, tag character varying(128))";

        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
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.