Examples of SQLServerStatementParser

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

33
34
35
36
37
38
39
40
41
42
43
44
public class SQLServerSelectTest_cross_apply extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT DeptID, DeptName, DeptMgrID, EmpID, EmpLastName, EmpSalary FROM Departments d CROSS APPLY dbo.GetReports(d.DeptMgrID)";

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

        SQLSelectStatement selectStmt = (SQLSelectStatement) stmt;

        SQLSelect select = selectStmt.getSelect();
View Full Code Here

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

29
30
31
32
33
34
35
36
37
38
39
40
        String sql = "SELECT TOP 50 PERCENT * FROM Persons"; //

        String expect = "SELECT TOP 50 PERCENT *\n" + //
                        "FROM Persons";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);

View Full Code Here

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

32
33
34
35
36
37
38
39
40
41
42
43
                        + "\n\t\t\t(co_id, sku_id, order_lock)"//
                        + "\n\t\tVALUES"//
                        + "\n\t\t(@0, @1, @2);"//
                        + "\n\tEND";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here

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

    public void test_alter_constraint() throws Exception {
        String sql = "alter table SSHE.dbo.TUSER drop constraint UK_084c17821a8f47e8b31fbb126b6";
        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

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

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dependencies ALTER COLUMN id bigint";
        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

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

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE extensions ADD [core] bit";
        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

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

33
34
35
36
37
38
39
40
41
42
43
44
public class SQLServerSelectTest_outer_apply extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT DeptID, DeptName, DeptMgrID, EmpID, EmpLastName, EmpSalary FROM Departments d OUTER APPLY dbo.GetReports(d.DeptMgrID)";

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

        SQLSelectStatement selectStmt = (SQLSelectStatement) stmt;

        SQLSelect select = selectStmt.getSelect();
View Full Code Here

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

31
32
33
34
35
36
37
38
39
40
41
42
        String expect = "INSERT INTO Cities" + //
                        "\n\t(Location)" + //
                        "\nVALUES" + //
                        "\n(CONVERT(Point, '12.3:46.2'))";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here

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

50
51
52
53
54
55
56
57
58
59
60
61
62
    }
   
   
    public void test_2() throws Exception {
        String sql = "EXEC @returnstatus = dbo.ufnGetSalesOrderStatusText @Status = 2";
        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

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

28
29
30
31
32
33
34
35
36
37
38
39
    public void test_isEmpty() throws Exception {
        String sql = "USE AdventureWorks2008R2;";

        String expect = "USE AdventureWorks2008R2";

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