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

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
        String sql = "DROP INDEX async_measure_snapshots.async_m_s_snapshot_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());
        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("DROP INDEX async_measure_snapshots.async_m_s_snapshot_id", output);

        Assert.assertEquals(0, visitor.getTables().size());
        Assert.assertEquals(0, visitor.getColumns().size());
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
        String sql = "ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT 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());
        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 MyTable"//
                            + "\n\tALTER COLUMN NullCOl NVARCHAR(20) NOT NULL", output);

        Assert.assertEquals(1, visitor.getTables().size());
        Assert.assertEquals(1, visitor.getColumns().size());
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
                + "\n\tdirectory_type NVARCHAR(60),"//
                + "\n\tdirectory_position NUMERIC,"//
                + "\n\tCONSTRAINT PK_cwd_directory PRIMARY KEY (ID)"//
                + "\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(12, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getConditions().size());

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

        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.cwd_directory", "ID")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.cwd_directory", "directory_name")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("dbo.cwd_directory", "lower_directory_name")));
    }
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }

        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlSchemaStatVisitor();
        }
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

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

        if (JdbcUtils.DB2.equals(dbType)) {
            return new DB2SchemaStatVisitor();
        }
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

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

        if (JdbcUtils.DB2.equals(dbType)) {
            return new DB2SchemaStatVisitor();
        }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }
       
        if (JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }

        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlSchemaStatVisitor();
        }
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }

        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlSchemaStatVisitor();
        }
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
231
232
233
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

        if (JdbcUtils.SQL_SERVER.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }

        if (JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerSchemaStatVisitor();
        }

        return new SchemaStatVisitor();
    }
View Full Code Here
262
263
264
265
266
267
268
269
270
271
272
        if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            return new PGSchemaStatVisitor();
        }

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

        if (JdbcUtils.DB2.equals(dbType)) {
            return new DB2SchemaStatVisitor();
        }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.sqlserver.visitor.SQLServerSchemaStatVisitor

  • 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
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_7
    • 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.