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

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

16
17
18
19
20
21
22
23
24
25
26
        if (JdbcUtils.MYSQL.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }
       
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }
       
        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
        return stmt;
    }

    public SQLUpdateStatement explainToUpdateSQLObject(MappingEngine engine, String sql) {
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        SQLUpdateStatement stmt = parser.parseUpdateStatement();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
        return stmt;
    }

    public SQLInsertStatement explainToInsertSQLObject(MappingEngine engine, String sql) {
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        SQLInsertStatement stmt = (SQLInsertStatement) parser.parseInsert();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
        String sql = out.toString();
        return sql;
    }

    public static String formatPGSql(String sql) {
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();

        StringBuilder out = new StringBuilder();
        PGOutputVisitor visitor = new PGOutputVisitor(out);

        for (SQLStatement stmt : statementList) {
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
        return stmt;
    }

    public SQLUpdateStatement explainToUpdateSQLObject(MappingEngine engine, String sql) {
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        SQLUpdateStatement stmt = parser.parseUpdateStatement();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
80
        return stmt;
    }

    public SQLInsertStatement explainToInsertSQLObject(MappingEngine engine, String sql) {
        PGSQLStatementParser parser = new PGSQLStatementParser(sql);
        SQLInsertStatement stmt = (SQLInsertStatement) parser.parseInsert();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
        if (JdbcUtils.MYSQL.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }

        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }
View Full Code Here
37
38
39
40
41
42
43
        super(config, JdbcConstants.POSTGRESQL);
    }

    @Override
    public SQLStatementParser createParser(String sql) {
        return new PGSQLStatementParser(sql);
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
        if (JdbcUtils.MARIADB.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }

        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
                     ",SOURCE,INFO,RECOMMEND_FLAG,CREATE_TIME,CREATE_IP,CREATE_ACCENDANT_ID" + //
                     ",LAST_UPD_TIME,LAST_UPD_IP,LAST_UPD_ACCENDANT_ID,'http://cmp2.test.com/cmps' AS STR_BASE_URL" + //
                     ",'html' AS STR_SUFFIX FROM WEB_DATA_TITLE_LIST" + //
                     " WHERE WEB_ID=? AND MENU_ID=? AND MENU_TYPE_ID=? ORDER BY RECOMMEND_FLAG DESC ,LAST_UPD_TIME DESC  OFFSET ? LIMIT ?";

        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.