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

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

53
54
55
56
57
58
59
60
61
    assertParser(parser, "1 desc", new OrderBy.Item(number(1), false));
  }
 
  public void testOrderByClause() {
    Parser<OrderBy> parser = RelationParser.orderByClause(NUMBER);
    assertParser(parser, "order by 1, 2 desc, 3 asc", new OrderBy(Arrays.asList(
        new OrderBy.Item(number(1), true), new OrderBy.Item(number(2), false),
        new OrderBy.Item(number(3), true))));
  }
View Full Code Here
178
179
180
181
182
183
184
185
            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(
                new OrderBy.Item(number(2), true), new OrderBy.Item(number(3), false)))));
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
  }

  @Test
  public void testOrderByClause() {
    Parser<OrderBy> parser = RelationParser.orderByClause(NUMBER);
    assertParser(parser, "order by 1, 2 desc, 3 asc", new OrderBy(Arrays.asList(
        new OrderBy.Item(number(1), true), new OrderBy.Item(number(2), false),
        new OrderBy.Item(number(3), true))));
  }
View Full Code Here
191
192
193
194
195
196
197
198
            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(
                new OrderBy.Item(number(2), true), new OrderBy.Item(number(3), false)))));
  }
View Full Code Here
TOP

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

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