Examples of SQLServerSchemaStatVisitor

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
        List<SQLStatement> stmtList = parser.parseStatementList();
        SQLStatement stmt = stmtList.get(0);

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

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

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        Assert.assertEquals(0, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);

        Assert.assertEquals("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED", text);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
        List<SQLStatement> stmtList = parser.parseStatementList();
        SQLStatement stmt = stmtList.get(0);

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

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

        Assert.assertEquals(0, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);

        Assert.assertEquals("SET FMTONLY ON", text);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
        List<SQLStatement> stmtList = parser.parseStatementList();
        SQLStatement stmt = stmtList.get(0);

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

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

        Assert.assertEquals(0, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);

        Assert.assertEquals("SET STATISTICS XML OFF", text);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
        List<SQLStatement> stmtList = parser.parseStatementList();
        SQLStatement stmt = stmtList.get(0);

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

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

        Assert.assertEquals(0, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);

        Assert.assertEquals("SET @state = N'Oregon'", text);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLCreateTableStatement stmt = (SQLCreateTableStatement) statementList.get(0);

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

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

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(12, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("projects")));

        Assert.assertTrue(visitor.getColumns().contains(new Column("projects", "id")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("projects", "name")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("projects", "enabled")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("projects", "scope")));
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
                            + "\n\tPROFILE_PAGE_URI VARCHAR(767),"//
                            + "\n\tPROFILE_PICTURE_URI VARCHAR(767),"//
                            + "\n\tUSERNAME VARCHAR(255)"//
                            + "\n)", output);

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

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(5, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("dbo.AO_563AEE_ACTOR_ENTITY")));

        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.AO_563AEE_ACTOR_ENTITY", "FULL_NAME")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.AO_563AEE_ACTOR_ENTITY", "ID")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.AO_563AEE_ACTOR_ENTITY", "USERNAME")));
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLCreateViewStatement stmt = (SQLCreateViewStatement) statementList.get(0);

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

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

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(4, visitor.getColumns().size());
        Assert.assertEquals(2, visitor.getConditions().size());

        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("Products")));

        Assert.assertTrue(visitor.getColumns().contains(new Column("Products", "ProductID")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("Products", "ProductName")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("Products", "Discontinued")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("Products", "No")));
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

43
44
45
46
47
48
49
50
51
52
53
        Assert.assertEquals(1, insertStmt.getValuesList().size());
        Assert.assertEquals(5, insertStmt.getValues().getValues().size());
        Assert.assertEquals(5, insertStmt.getColumns().size());
        Assert.assertEquals(1, statementList.size());

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

        String formatSql = "INSERT INTO [dbo].[SurveyAnswer]"//
                           + "\n\t([CustomerId], [QuestionId], [OptionId], [CreateTime], [LastUpdateTime])"//
                           + "\nVALUES" //
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
        String sql = "alter table st_jklsxxb enable constraint FK_ST_xxx_REFERENCE_ST_xxx";
        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());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("ALTER TABLE st_jklsxxb" + //
                            "\n\tENABLE CONSTRAINT FK_ST_xxx_REFERENCE_ST_xxx", output);

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
        Assert.assertEquals("CREATE NONCLUSTERED INDEX IX_SalesPerson_SalesQuota_SalesYTD" //
                            + " ON Sales.SalesPerson (SalesQuota, SalesYTD)", //
                            SQLUtils.toSQLString(stmt, JdbcConstants.ORACLE));

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

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());
        System.out.println("coditions : " + visitor.getConditions());
        System.out.println("orderBy : " + visitor.getOrderByColumns());

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(2, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("Sales.SalesPerson")));

        Assert.assertTrue(visitor.getColumns().contains(new Column("Sales.SalesPerson", "SalesQuota")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("Sales.SalesPerson", "SalesYTD")));
    }
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.