Package org.apache.metamodel.query

Examples of org.apache.metamodel.query.SelectItem

706
707
708
709
710
711
712
713
714
715
716
717
718
719
        Table orderlinesTable = schema.getTableByName("orderlines");
        Column commonProdIdColumn = orderlinesTable.getColumnByName("prod_id");
        Column quantityColumn = orderlinesTable.getColumnByName("quantity");

        q.from(orderlinesTable);
        q.where(new FilterItem(new SelectItem(prodIdColumn), OperatorType.EQUALS_TO, new SelectItem(commonProdIdColumn)));
        q.groupBy(titleColumn);
        q.getSelectClause().removeItem(q.getSelectClause().getSelectItem(productPriceColumn));
        SelectItem quantitySum = new SelectItem(FunctionType.SUM, quantityColumn).setAlias("orderAmount");
        q.select(quantitySum);
        q.having(new FilterItem(quantitySum, OperatorType.GREATER_THAN, 25));
        q.orderBy(new OrderByItem(q.getSelectClause().getItem(0)));

        assertEquals("SELECT \"products\".\"title\" AS product-title, SUM(\"orderlines\".\"quantity\") AS orderAmount "
View Full Code Here
830
831
832
833
834
835
836
837
838
839
840
841
        Column priceColumn = productsTable.getColumnByName("price");
        Column cityColumn = customerTable.getColumnByName("city");
        Column ageColumn = customerTable.getColumnByName("age");
        q.select(titleColumn, priceColumn, cityColumn);

        q.where(new FilterItem(new SelectItem(priceColumn), OperatorType.GREATER_THAN, 27));
        q.where(new FilterItem(new SelectItem(ageColumn), OperatorType.GREATER_THAN, 55));

        assertEquals(
                "SELECT p.\"title\", p.\"price\", c.\"city\" FROM public.\"products\" p, public.\"customers\" c WHERE p.\"price\" > 27 AND c.\"age\" > 55",
                q.toString());
View Full Code Here
34
35
36
37
38
39
40
41
42
    private final Query _query;
    private final List<FilterItem> _orFilters;
    private FilterItem _parentOrFilter;

    public WhereBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) {
        super(new SelectItem(column), queryBuilder);
        _query = query;
        _orFilters = new ArrayList<FilterItem>();
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
        _orFilters = new ArrayList<FilterItem>();
    }

    public WhereBuilderImpl(Column column, Query query, FilterItem parentOrFilter, List<FilterItem> orFilters,
            GroupedQueryBuilder queryBuilder) {
        super(new SelectItem(column), queryBuilder);
        _query = query;
        _parentOrFilter = parentOrFilter;
        _orFilters = orFilters;
    }
View Full Code Here
35
36
37
38
39
40
41
42
43
  private final List<FilterItem> _orFilters;
  private FilterItem _parentOrFilter;

  public HavingBuilderImpl(FunctionType function, Column column, Query query,
      GroupedQueryBuilder queryBuilder) {
    super(new SelectItem(function, column), queryBuilder);
    _query = query;
    _orFilters = new ArrayList<FilterItem>();
  }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
  }

  public HavingBuilderImpl(FunctionType function, Column column, Query query,
      FilterItem parentOrFilter, List<FilterItem> orFilters,
      GroupedQueryBuilder queryBuilder) {
    super(new SelectItem(function, column), queryBuilder);
    _query = query;
    _orFilters = orFilters;
    _parentOrFilter = parentOrFilter;
  }
View Full Code Here
31
32
33
34
35
36
37
38
  private OrderByItem orderByitem;

  public SatisfiedOrderByBuilderImpl(Column column, Query query,
      GroupedQueryBuilder queryBuilder) {
    super(queryBuilder);
    orderByitem = new OrderByItem(new SelectItem(column));
    query.orderBy(orderByitem);
  }
View Full Code Here
38
39
40
41
42
43
44
45
  }

  public SatisfiedOrderByBuilderImpl(FunctionType function, Column column,
      Query query, GroupedQueryBuilder queryBuilder) {
    super(queryBuilder);
    orderByitem = new OrderByItem(new SelectItem(function, column));
    query.orderBy(orderByitem);
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    assertTrue(con1 != con2);
    dc = new JdbcDataContext(con2);
    Column col2 = dc.getDefaultSchema().getTableByName("EMPLOYEES").getColumnByName("EMPLOYEENUMBER");

    assertEquals(col1, col2);
    assertTrue(new SelectItem(col1).equals(new SelectItem(col2)));
    assertTrue(new SelectItem(col1).setAlias("foo").equalsIgnoreAlias(new SelectItem(col2).setAlias("bar")));

    con2.close();

    assertEquals(col1, col2);
    assertTrue(new SelectItem(col1).equals(new SelectItem(col2)));
    assertTrue(new SelectItem(col1).setAlias("foo").equalsIgnoreAlias(new SelectItem(col2).setAlias("bar")));

    try {
      col2.isIndexed();
      fail("Exception expected");
    } catch (MetaModelException e) {
View Full Code Here
79
80
81
82
83
84
85
    @Override
    public B isEquals(Column column) {
        if (column == null) {
            throw new IllegalArgumentException("column cannot be null");
        }
        return applyFilter(new FilterItem(_selectItem, OperatorType.EQUALS_TO, new SelectItem(column)));
    }
View Full Code Here
TOP

Related Classes of org.apache.metamodel.query.SelectItem

  • org.apache.metamodel.convert.ConvertedDataSetInterceptor
  • org.apache.metamodel.csv.CsvBigFileMemoryTest
  • org.apache.metamodel.csv.CsvDataContextTest
  • org.apache.metamodel.data.AbstractRow
  • org.apache.metamodel.data.RowPublisherDataSetTest
  • org.apache.metamodel.data.RowTest
  • org.apache.metamodel.data.SimpleDataSetHeader
  • org.apache.metamodel.delete.AbstractRowDeletionBuilder
  • org.apache.metamodel.delete.DeleteFrom
  • org.apache.metamodel.dialects.AbstractQueryRewriterTest
    • 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.