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

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

28
29
30
31
32
33
34
35
36
37
38
39
40
public class SQLServerAlterTableTest_4 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE extensions DROP COLUMN [category]";
        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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
public class SQLServerInsertTest5 extends TestCase {

    public void test_parseCompleteValues_false() throws Exception {
        String sql = "insert into t(a,b) values ('a1','b1'),('a2','b2'),('a3','b3'),('a4','b4');";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        parser.setParseCompleteValues(false);
        parser.setParseValuesSize(3);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLServerInsertStatement insertStmt = (SQLServerInsertStatement) stmt;

        Assert.assertEquals(3, insertStmt.getValuesList().size());
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
    }

    public void test_parseCompleteValues_true() throws Exception {
        String sql = "insert into t(a,b) values ('a1','b1'),('a2','b2'),('a3','b3'),('a4','b4');";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        parser.setParseCompleteValues(true);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLServerInsertStatement insertStmt = (SQLServerInsertStatement) stmt;

        Assert.assertEquals(4, insertStmt.getValuesList().size());
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
        String sql = "SELECT name, password_hash FROM master.sys.sql_logins";

        String expect = "SELECT name, 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
32
33
34
35
36
37
38
39
40
41
42
43
                + "\nSET VacationHours = VacationHours * 1.25, ModifiedDate = GETDATE()"
                + "\nOUTPUT inserted.BusinessEntityID, deleted.VacationHours, inserted.VacationHours, inserted.ModifiedDate"
                + "\n\tINTO @MyTableVar";
       

        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_8 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dbo.doc_exb DROP COLUMN column_b ;";
        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
38
39
40
41
42
43
44
45
46
47
48
49
                        "\n\tFROM Product" + //
                        "\n\t) ProductsWithRowNumbers" + //
                        "\nWHERE Row >= 6" + //
                        "\n\tAND Row <= 10";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
            "\n\t\tAND a.time_add >= ?" +
            "\n\t\tAND a.time_add <= ?" +
            "\n\t) a" +
            "\nWHERE a.ROW BETWEEN ? + 1 AND ? + ?";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
46
        String expect = "UPDATE dbo.Table2" + //
                        "\nSET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB" + //
                        "\nFROM dbo.Table2" + //
                        "\n\tINNER JOIN dbo.Table1 ON dbo.Table2.ColA = dbo.Table1.ColA";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
            "SET VacationHours = VacationHours * 1.25 ;";

        String expect = "UPDATE TOP (10) HumanResources.Employee" +
            "\nSET VacationHours = VacationHours * 1.25";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);

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.