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
53
54
        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.assertTrue(visitor.getTables().containsKey(new TableStat.Name("tmp_films")));

        Assert.assertEquals(2, visitor.getColumns().size());

        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("tmp_films", "date_prod")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("tmp_films", "*")));
    }
View Full Code Here

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

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
        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(0, visitor.getColumns().size());
        Assert.assertEquals(2, visitor.getTables().size());
    }
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
53
54
        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("my_first_table")));
       
        Assert.assertTrue(visitor.getTables().get(new TableStat.Name("my_first_table")).getCreateCount() == 1);

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

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

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        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("employees_log")));
        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("employees")));
        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("accounts")));

        Assert.assertEquals(4, visitor.getColumns().size());

        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("employees", "sales_count")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("employees", "id")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("accounts", "sales_person")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("accounts", "name")));
    }
View Full Code Here

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

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

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
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("films")));
        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("producers")));
        System.out.println("coditions : " + visitor.getConditions());

        Assert.assertTrue(visitor.getColumns().size() == 3);
       
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "producer_id")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("producers", "id")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("producers", "name")));
    }
View Full Code Here

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

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
        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(20, visitor.getColumns().size());
        Assert.assertEquals(0, visitor.getTables().size());
    }
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

35
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.assertTrue(visitor.getTables().containsKey(new TableStat.Name("tasks")));

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

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

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
        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(1, visitor.getColumns().size());
        Assert.assertEquals(1, visitor.getTables().size());
    }
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.