Package org.codehaus.jparsec.examples.sql.ast

Examples of org.codehaus.jparsec.examples.sql.ast.AliasedRelation

39
40
41
42
43
44
45
46
47
    assertParser(TABLE, "a.b", table("a", "b"));
  }
 
  public void testAliasable() {
    Parser<Relation> parser = RelationParser.aliasable(TABLE);
    assertParser(parser, "table t", new AliasedRelation(table("table"), "t"));
    assertParser(parser, "table as t", new AliasedRelation(table("table"), "t"));
    assertParser(parser, "table", table("table"));
  }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
 
  public void testJoin() {
    Parser<Relation> parser = RelationParser.join(TABLE, NUMBER);
    assertParser(parser, "a", table("a"));
    assertParser(parser, "a cross join table2 as b",
        new CrossJoinRelation(table("a"), new AliasedRelation(table("table2"), "b")));
    assertParser(parser, "a inner join b on 1",
        new JoinRelation(table("a"), JoinType.INNER, table("b"), number(1)));
    assertParser(parser, "a inner join b on 1 left join c on 2 cross join d",
        new CrossJoinRelation(
            new JoinRelation(
View Full Code Here
140
141
142
143
144
145
146
147
148
  }
 
  public void testFromClause() {
    Parser<List<Relation>> parser = RelationParser.fromClause(TABLE);
    assertListParser(parser, "from a", table("a"));
    assertListParser(parser, "from a x", new AliasedRelation(table("a"), "x"));
    assertListParser(parser, "from table1 t1, t2",
        new AliasedRelation(table("table1"), "t1"), table("t2"));
  }
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
            Arrays.asList(table("t")),
            null, null, null));
    assertParser(parser, "select 1 from (select * from table) t",
        new Select(false,
            Arrays.asList(new Projection(number(1), null)),
            Arrays.<Relation>asList(new AliasedRelation(
                new Select(false,
                    Arrays.asList(new Projection(ExpressionParserTest.wildcard(), null)),
                    Arrays.asList(table("table")),
                    null, null, null),
                "t")),
View Full Code Here
39
40
41
42
43
44
45
46
47
  }

  @Test
  public void testAliasable() {
    Parser<Relation> parser = RelationParser.aliasable(TABLE);
    assertParser(parser, "table t", new AliasedRelation(table("table"), "t"));
    assertParser(parser, "table as t", new AliasedRelation(table("table"), "t"));
    assertParser(parser, "table", table("table"));
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
  @Test
  public void testJoin() {
    Parser<Relation> parser = RelationParser.join(TABLE, NUMBER);
    assertParser(parser, "a", table("a"));
    assertParser(parser, "a cross join table2 as b",
        new CrossJoinRelation(table("a"), new AliasedRelation(table("table2"), "b")));
    assertParser(parser, "a inner join b on 1",
        new JoinRelation(table("a"), JoinType.INNER, table("b"), number(1)));
    assertParser(parser, "a inner join b on 1 left join c on 2 cross join d",
        new CrossJoinRelation(
            new JoinRelation(
View Full Code Here
151
152
153
154
155
156
157
158
159
  @Test
  public void testFromClause() {
    Parser<List<Relation>> parser = RelationParser.fromClause(TABLE);
    assertListParser(parser, "from a", table("a"));
    assertListParser(parser, "from a x", new AliasedRelation(table("a"), "x"));
    assertListParser(parser, "from table1 t1, t2",
        new AliasedRelation(table("table1"), "t1"), table("t2"));
  }
View Full Code Here
227
228
229
230
231
232
233
234
235
236
237
            Arrays.asList(table("t")),
            null, null, null));
    assertParser(parser, "select 1 from (select * from table) t",
        new Select(false,
            Arrays.asList(new Projection(number(1), null)),
            Arrays.<Relation>asList(new AliasedRelation(
                new Select(false,
                    Arrays.asList(new Projection(ExpressionParserTest.wildcard(), null)),
                    Arrays.asList(table("table")),
                    null, null, null),
                "t")),
View Full Code Here
TOP

Related Classes of org.codehaus.jparsec.examples.sql.ast.AliasedRelation

  • org.codehaus.jparsec.examples.sql.parser.RelationParserTest
    • 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.