Examples of PGSchemaStatVisitor

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

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

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

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

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

        Assert.assertEquals(0, visitor.getColumns().size());
       
//        Assert.assertTrue(visitor.getFields().contains(new TableStat.Column("films", "producer_id")));
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

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

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());

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

        Assert.assertTrue(visitor.getTables().get(new TableStat.Name("products")).getCreateCount() == 1);

        Assert.assertTrue(visitor.getColumns().size() == 3);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

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

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

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

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

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

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

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

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

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

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
        SQLStatement statemen = statementList.get(0);
        print(statementList);

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

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

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

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
        SQLStatement statemen = statementList.get(0);
        print(statementList);

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);
//
//        System.out.println("Tables : " + visitor.getTables());
//        System.out.println("fields : " + visitor.getColumns());
//        System.out.println("coditions : " + visitor.getConditions());


        Assert.assertEquals(2, visitor.getColumns().size());
       
        String mergedSql = ParameterizedOutputVisitorUtils.parameterize(sql, JdbcUtils.POSTGRESQL);
        System.out.println(mergedSql);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        SQLStatement statemen = statementList.get(0);
        print(statementList);
       
        Assert.assertEquals(1, statementList.size());
       
        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);
       
//        System.out.println("Tables : " + visitor.getTables());
//        System.out.println("fields : " + visitor.getColumns());
//        System.out.println("coditions : " + visitor.getConditions());
       
       
        Assert.assertEquals(2, visitor.getColumns().size());
       
        String mergedSql = ParameterizedOutputVisitorUtils.parameterize(sql, JdbcUtils.POSTGRESQL);
        System.out.println(mergedSql);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
        SQLStatement statemen = statementList.get(0);
        print(statementList);
       
        Assert.assertEquals(1, statementList.size());
       
        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);
       
//        System.out.println("Tables : " + visitor.getTables());
//        System.out.println("fields : " + visitor.getColumns());
//        System.out.println("coditions : " + visitor.getConditions());
       
       
        Assert.assertEquals(2, visitor.getColumns().size());
       
        String mergedSql = ParameterizedOutputVisitorUtils.parameterize(sql, JdbcUtils.POSTGRESQL);
        System.out.println(mergedSql);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
        SQLStatement statemen = statementList.get(0);
        print(statementList);
       
        Assert.assertEquals(1, statementList.size());
       
        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);
       
//        System.out.println("Tables : " + visitor.getTables());
//        System.out.println("fields : " + visitor.getColumns());
//        System.out.println("coditions : " + visitor.getConditions());
       
       
        Assert.assertEquals(2, visitor.getColumns().size());
       
        String mergedSql = ParameterizedOutputVisitorUtils.parameterize(sql, JdbcUtils.POSTGRESQL);
        System.out.println(mergedSql);
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.postgresql.visitor.PGSchemaStatVisitor

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

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

        PGSchemaStatVisitor visitor = new PGSchemaStatVisitor();
        statemen.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
        System.out.println("fields : " + visitor.getColumns());

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

        Assert.assertTrue(visitor.getTables().get(new TableStat.Name("products")).getCreateCount() == 1);

        Assert.assertTrue(visitor.getColumns().size() == 3);
    }
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.