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

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

147
148
149
150
151
152
153
154
155
        new AliasedRelation(table("table1"), "t1"), table("t2"));
  }
 
  public void testGroupByClause() {
    Parser<GroupBy> parser = RelationParser.groupByClause(NUMBER, NUMBER);
    assertParser(parser, "group by 1, 2", new GroupBy(Arrays.asList(number(1), number(2)), null));
    assertParser(parser, "group by 1, 2 having 3",
        new GroupBy(Arrays.asList(number(1), number(2)), number(3)));
  }
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
            number(1), null, null));
    assertParser(parser, "select 1 as id from t group by 2, 3",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, new GroupBy(Arrays.asList(number(2), number(3)), null), null));
    assertParser(parser, "select 1 as id from t group by 2, 3 having 4",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, new GroupBy(Arrays.asList(number(2), number(3)), number(4)), null));
    assertParser(parser, "select 1 as id from t order by 2 asc, 3 desc",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, null, new OrderBy(Arrays.asList(
View Full Code Here
159
160
161
162
163
164
165
166
167
  }

  @Test
  public void testGroupByClause() {
    Parser<GroupBy> parser = RelationParser.groupByClause(NUMBER, NUMBER);
    assertParser(parser, "group by 1, 2", new GroupBy(Arrays.asList(number(1), number(2)), null));
    assertParser(parser, "group by 1, 2 having 3",
        new GroupBy(Arrays.asList(number(1), number(2)), number(3)));
  }
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
            number(1), null, null));
    assertParser(parser, "select 1 as id from t group by 2, 3",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, new GroupBy(Arrays.asList(number(2), number(3)), null), null));
    assertParser(parser, "select 1 as id from t group by 2, 3 having 4",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, new GroupBy(Arrays.asList(number(2), number(3)), number(4)), null));
    assertParser(parser, "select 1 as id from t order by 2 asc, 3 desc",
        new Select(false,
            Arrays.asList(new Projection(number(1), "id")),
            Arrays.asList(table("t")),
            null, null, new OrderBy(Arrays.asList(
View Full Code Here
TOP

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

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