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

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

57
58
59
60
61
62
63
64
65
66
67
68
69
70
    }

    public void test_1() throws Exception {
        String sql = "INSERT TOP(5)INTO dbo.EmployeeSales  OUTPUT inserted.EmployeeID, inserted.FirstName, inserted.LastName, inserted.YearlySales SELECT sp.BusinessEntityID, c.LastName, c.FirstName, sp.SalesYTD FROM Sales.SalesPerson AS sp INNER JOIN Person.Person AS c ON sp.BusinessEntityID = c.BusinessEntityID WHERE sp.SalesYTD > 250000.00 ORDER BY sp.SalesYTD DESC;";

        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(0, insertStmt.getValuesList().size());
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
                        "\n\tJOIN HumanResources.Employee e ON e.ContactID = c.ContactID" + //
                        "\n\tJOIN HumanResources.EmployeeAddress ea ON ea.EmployeeID = e.EmployeeID" + //
                        "\n\tJOIN Person.Address a ON a.AddressID = ea.AddressID" + //
                        "\n\tJOIN Person.StateProvince sp ON sp.StateProvinceID = a.StateProvinceID";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
        "\n\tAND (t.enabled = 1" +
        "\n\t\tOR '1' = ?" +
        "\n\t\tOR t.need_control = 0)" +
        "\nORDER BY t.sort_order";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
    public void test_isEmpty() throws Exception {
        String sql = "SELECT TOP ? * FROM T";

        String expect = "SELECT TOP ? *\nFROM T";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);

View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
                        + "\n\tINNER JOIN Person.Contact c ON s.SalesPersonID = c.ContactID"
                        + "\n\tINNER JOIN Person.Address a ON a.AddressID = c.ContactID" //
                        + "\nWHERE TerritoryID IS NOT NULL" //
                        + "\n\tAND SalesYTD <> 0";

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

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dependencies ADD PRIMARY KEY(id)";
        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
48
49
50
51
52
53
54
55
56
57
58
59
            "\n\t)" +
            "\nSELECT ManagerID, DirectReports" +
            "\nFROM DirReps" +
            "\nORDER BY ManagerID";

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

        String text = TestUtils.outputSqlServer(stmt);

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

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dbo.doc_exc ADD column_b VARCHAR(20) NULL "//
                     + "    CONSTRAINT exb_unique UNIQUE ;";
        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
29
30
31
32
33
34
35
36
37
38
39
40
        String sql = "SELECT Location.Distance (@p)" + " FROM Cities;";

        String expect = "SELECT Location.Distance(@p)" + //
                        "\nFROM Cities";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
    public void test_0() throws Exception {
        String sql = "CREATE NONCLUSTERED INDEX IX_SalesPerson_SalesQuota_SalesYTD" //
                     + "    ON Sales.SalesPerson (SalesQuota, SalesYTD);";

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

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

        Assert.assertEquals("CREATE NONCLUSTERED INDEX IX_SalesPerson_SalesQuota_SalesYTD" //
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.