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

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

20
21
22
23
24
25
26
27
28
29
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }
       
        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }
       
        return new SQLStatementParser(sql);
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
        return query;
    }

    public SQLDeleteStatement explainToDeleteSQLObject(MappingEngine engine, String sql) {
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLDeleteStatement stmt = parser.parseDeleteStatement();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
29
30
31
32
33
34
35
        super(config);
    }

    @Override
    public SQLStatementParser createParser(String sql) {
        return new SQLServerStatementParser(sql);
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
        return query;
    }

    public SQLDeleteStatement explainToDeleteSQLObject(MappingEngine engine, String sql) {
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLDeleteStatement stmt = parser.parseDeleteStatement();

        MappingVisitorUtils.setDataSource(engine, stmt);

        return stmt;
    }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }
       
        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }
View Full Code Here
43
44
45
46
47
48
49
        super(config, JdbcConstants.SQL_SERVER);
    }

    @Override
    public SQLStatementParser createParser(String sql) {
        return new SQLServerStatementParser(sql);
    }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSQLStatementParser(sql);
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerStatementParser(sql);
        }

        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
        String sql = "SELECT name + ‘-’ + master.sys.fn_varbintohexstr(password_hash) from master.sys.sql_logins";

        String expect = "SELECT name + ‘ - ’ + master.sys.fn_varbintohexstr(password_hash)\n" + //
                        "FROM master.sys.sql_logins";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
public class SQLServerAlterTableTest_7 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL ;";
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
public class SQLServerAlterTableTest_5 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE project_measures DROP COLUMN diff_value_1, diff_value_2, diff_value_3";
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

  • com.alibaba.druid.bvt.sql.sqlserver.MSSQLServerExportParameterVisitorTest
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_0
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_1
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_10
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_11
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_2
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_3
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_4
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_5
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_6
    • 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.