Package com.alibaba.druid.sql.ast.statement

Examples of com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement

113
114
115
116
117
118
119
        return createTable;
    }

    protected SQLCreateTableStatement newCreateStatement() {
        return new SQLCreateTableStatement(getDbType());
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        SQLASTVisitorAdapter adapter = new SQLASTVisitorAdapter();
        new SQLBinaryOpExpr().accept(adapter);
        new SQLInListExpr().accept(adapter);
        new SQLSelectQueryBlock().accept(adapter);
        new SQLDropTableStatement().accept(adapter);
        new SQLCreateTableStatement().accept(adapter);
        new SQLDeleteStatement().accept(adapter);
        new SQLCurrentOfCursorExpr ().accept(adapter);
        new SQLInsertStatement ().accept(adapter);
        new SQLUpdateStatement ().accept(adapter);
        new NotNullConstraint ().accept(adapter);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
    public void test_0() throws Exception {
        String sql = "CREATE TABLE #Test (C1 nvarchar(10), C2 nvarchar(50), C3 datetime);";

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

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

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("CREATE TABLE #Test (" //
                            + "\n\tC1 nvarchar(10),"//
                            + "\n\tC2 nvarchar(50),"//
                            + "\n\tC3 datetime"//
                            + "\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());
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
                     "PRIMARY KEY (`id`)" + //
                     ") ENGINE=InnoDB DEFAULT CHARSET=gbk;";

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

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

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        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());
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
                     + "CONSTRAINT pk_AO_E8B6CC_ISSUE_MAPPING_V2_ID PRIMARY KEY(ID)"//
                     + ")";

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

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

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("CREATE TABLE dbo.AO_E8B6CC_ISSUE_MAPPING_V2 (" //
                            + "\n\tAUTHOR VARCHAR(255),"//
                            + "\n\tBRANCH VARCHAR(255),"//
                            + "\n\t\"DATE\" DATETIME,"//
                            + "\n\tFILES_DATA NTEXT,"//
                            + "\n\tID INTEGER DEFAULT NULL IDENTITY (1, 1),"//
                            + "\n\tISSUE_ID VARCHAR(255),"//
                            + "\n\tMESSAGE NTEXT,"//
                            + "\n\tNODE VARCHAR(255),"//
                            + "\n\tPARENTS_DATA VARCHAR(255),"//
                            + "\n\tRAW_AUTHOR VARCHAR(255),"//
                            + "\n\tRAW_NODE VARCHAR(255),"//
                            + "\n\tREPOSITORY_ID INTEGER DEFAULT 0,"//
                            + "\n\tVERSION INTEGER,"//
                            + "\n\tCONSTRAINT pk_AO_E8B6CC_ISSUE_MAPPING_V2_ID 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());
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
                     + "optiontype NVARCHAR(60), disabled NVARCHAR(60), "//
                     + "CONSTRAINT PK_customfieldoption PRIMARY KEY (ID))";

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

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

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("CREATE TABLE dbo.customfieldoption (" //
                            + "\n\tID NUMERIC NOT NULL,"//
                            + "\n\tCUSTOMFIELD NUMERIC,"//
                            + "\n\tCUSTOMFIELDCONFIG NUMERIC,"//
                            + "\n\tPARENTOPTIONID NUMERIC,"//
                            + "\n\tSEQUENCE NUMERIC,"//
                            + "\n\tcustomvalue NVARCHAR(255),"//
                            + "\n\toptiontype NVARCHAR(60),"//
                            + "\n\tdisabled NVARCHAR(60),"//
                            + "\n\tCONSTRAINT PK_customfieldoption 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());
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
                     + "[copy_resource_id] int, "//
                     + "[long_name] NVARCHAR(256)) ";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        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());
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
                     + "    USERNAME VARCHAR(255),"//
                     + ")";

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

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

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("CREATE TABLE dbo.AO_563AEE_ACTOR_ENTITY (" //
                            + "\n\tFULL_NAME VARCHAR(255),"//
                            + "\n\tID INTEGER DEFAULT NULL IDENTITY (1, 1),"//
                            + "\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());
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
                + "directory_type NVARCHAR(60), directory_position NUMERIC, "//
                + "CONSTRAINT PK_cwd_directory PRIMARY KEY (ID))";

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

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

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
        Assert.assertEquals("CREATE TABLE dbo.cwd_directory (" //
                + "\n\tID NUMERIC NOT NULL,"//
                + "\n\tdirectory_name NVARCHAR(255),"//
                + "\n\tlower_directory_name NVARCHAR(255),"//
                + "\n\tcreated_date DATETIME,"//
                + "\n\tupdated_date DATETIME,"//
                + "\n\tactive int,"//
                + "\n\tdescription NVARCHAR(255),"//
                + "\n\timpl_class NVARCHAR(255),"//
                + "\n\tlower_impl_class NVARCHAR(255),"//
                + "\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());
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
                     "        primary key (ID)" + //
                     "    )";

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

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

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        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());
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement

  • com.alibaba.druid.bvt.sql.mysql.MySqlCreateTableTest10
  • com.alibaba.druid.bvt.sql.mysql.MySqlCreateTableTest11
  • com.alibaba.druid.bvt.sql.SQLASTVisitorAdapterTest
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_1
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_2
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_3
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_4
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_5
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerCreateTableTest_6
  • com.alibaba.druid.sql.parser.SQLCreateTableParser
    • 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.