Examples of MySqlSchemaStatVisitor

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
        SQLDropViewStatement stmt = (SQLDropViewStatement) 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());

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

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

    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
        SQLStatement statemen = statementList.get(0);
        print(statementList);

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

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        statemen.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());


//        Assert.assertTrue(visitor.getColumns().contains(new Column("mytable", "last_name")));
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
                     + "    )"; //

        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseCreateTable();

        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());

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

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

        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("CREATE TABLE tauth (" //
                            + "\n\tcid varchar(36) NOT NULL PRIMARY KEY, "//
                            + "\n\tcdesc varchar(200), "//
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
        SQLStatement stmt = 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());

        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("lc")));

        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("CREATE TABLE lc (" + //
                            "\n\ta INT NULL, " + //
                            "\n\tb INT NULL" + //
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
        SQLStatement stmt = 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());

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

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

        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("CREATE TABLE user (" + //
                            "\n\tid INT, " + //
                            "\n\tINDEX USING BTREE(id)" + //
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
        print(statementList);

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

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

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

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

        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("SELECT COUNT(*) AS a" + //
                            "\nFROM (SELECT nickname, mobile, comment, createdate" + //
                            "\n\tFROM ub_userdiscuss" + //
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
        String sql = "ALTER TABLE tbl_name IMPORT TABLESPACE;";
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        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());

        String output = SQLUtils.toMySqlString(stmt);
        Assert.assertEquals("ALTER TABLE tbl_name" + //
                            "\n\tIMPORT TABLESPACE", output);

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

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

59
60
61
62
63
64
65
66
67
68
69
        System.out.println("MySql\t" + millis + ", ygc " + ygc + ", ygct " + ygct + ", fgc " + fgc);
        return millis;
    }

    static void execMySql(List<SQLStatement> statementList) {
        MySqlASTVisitor visitor = new MySqlSchemaStatVisitor();

        for (SQLStatement statement : statementList) {
            statement.accept(visitor);
        }
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

38
39
40
41
42
43
44
45
46
47
48
    private void f() throws Exception {
        long start = System.currentTimeMillis();
        for (int i = 0; i < COUNT; ++i) {
          List<SQLStatement> statementList =  new SQLStatementParser(sql).parseStatementList();
           
            MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
            statementList.get(0).accept(visitor);
            // stmtList.toString();
        }
        long time = System.currentTimeMillis() - start;
        System.out.println(NumberFormat.getInstance().format(time));
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.mysql.visitor.MySqlSchemaStatVisitor

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
        SQLStatement statemen = statementList.get(0);
        print(statementList);

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

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        statemen.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());

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

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