Examples of PGSchemaStatVisitor

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

57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
        SQLStatement statemen = statementList.get(0);
        print(statementList);

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

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

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

        System.out.println();
        System.out.println();
    }
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
        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_recent")));
        Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("films")));
       
        Assert.assertTrue(visitor.getColumns().contains(new Column("films", "*")));
        Assert.assertTrue(visitor.getColumns().contains(new Column("films", "date_prod")));
  }
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());
        System.out.println("coditions : " + visitor.getConditions());

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

        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

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(0, 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
        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());
        Assert.assertEquals(0, visitor.getTables().size());
    }
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(2, visitor.getColumns().size());
        Assert.assertEquals(1, visitor.getTables().size());
    }
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

35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
        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("producers")));

        //Assert.assertTrue(visitor.getFields().size() == 0);
    }
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

37
38
39
40
41
42
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());

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

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

        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "kind")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "code")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "date_prod")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "title")));
        Assert.assertTrue(visitor.getColumns().contains(new TableStat.Column("films", "did")));
    }
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.