Examples of GroupByItem

org.apache.metamodel.query.GroupByItem
Represents a GROUP BY item. GroupByItems always use a select item (that may or not be a part of the query already) for grouping. @see GroupByClause
org.apache.solr.request.compare.GroupbyItem

Examples of org.apache.metamodel.query.GroupByItem


    public static DataSet getDistinct(DataSet dataSet) {
        SelectItem[] selectItems = dataSet.getSelectItems();
        GroupByItem[] groupByItems = new GroupByItem[selectItems.length];
        for (int i = 0; i < groupByItems.length; i++) {
            groupByItems[i] = new GroupByItem(selectItems[i]);
        }
        return getGrouped(Arrays.asList(selectItems), dataSet, groupByItems);
    }

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column projectIdColumn = table2.getColumnByName(COLUMN_ROLE_PROJECT_ID);
        q.select(new SelectItem(FunctionType.SUM, projectIdColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        q.orderBy(roleColumn);
        assertEquals("SELECT SUM(r.project_id) FROM MetaModelSchema.role r GROUP BY r.name ORDER BY r.name ASC",
                q.toString());


        DataContext dc = getDataContext();

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

    public void testSimpleGroupBy() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        q.select(new SelectItem(roleColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        assertEquals("SELECT r.name FROM MetaModelSchema.role r GROUP BY r.name", q.toString());


        DataContext dc = getDataContext();
        DataSet data = dc.executeQuery(q);
        assertEquals(1, data.getSelectItems().length);

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

        StringBuilder sb = new StringBuilder();
        if (groupByClause.getItemCount() > 0) {
            sb.append(AbstractQueryClause.PREFIX_GROUP_BY);
            List<GroupByItem> items = groupByClause.getItems();
            for (int i = 0; i < items.size(); i++) {
                GroupByItem item = items.get(i);
                if (i != 0) {
                    sb.append(AbstractQueryClause.DELIM_COMMA);
                }
                sb.append(rewriteGroupByItem(query, item));
            }

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

        StringBuilder sb = new StringBuilder();
        if (groupByClause.getItemCount() > 0) {
            sb.append(AbstractQueryClause.PREFIX_GROUP_BY);
            List<GroupByItem> items = groupByClause.getItems();
            for (int i = 0; i < items.size(); i++) {
                GroupByItem item = items.get(i);
                if (i != 0) {
                    sb.append(AbstractQueryClause.DELIM_COMMA);
                }
                sb.append(rewriteGroupByItem(query, item));
            }

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem


    public static DataSet getDistinct(DataSet dataSet) {
        SelectItem[] selectItems = dataSet.getSelectItems();
        GroupByItem[] groupByItems = new GroupByItem[selectItems.length];
        for (int i = 0; i < groupByItems.length; i++) {
            groupByItems[i] = new GroupByItem(selectItems[i]);
        }
        return getGrouped(Arrays.asList(selectItems), dataSet, groupByItems);
    }

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column projectIdColumn = table2.getColumnByName(COLUMN_ROLE_PROJECT_ID);
        q.select(new SelectItem(FunctionType.SUM, projectIdColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        q.orderBy(roleColumn);
        assertEquals("SELECT SUM(r.project_id) FROM MetaModelSchema.role r GROUP BY r.name ORDER BY r.name ASC",
                q.toString());


        DataContext dc = getDataContext();

View Full Code Here

Examples of org.apache.metamodel.query.GroupByItem

    public void testSimpleGroupBy() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        q.select(new SelectItem(roleColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        assertEquals("SELECT r.name FROM MetaModelSchema.role r GROUP BY r.name", q.toString());


        DataContext dc = getDataContext();
        DataSet data = dc.executeQuery(q);
        assertEquals(1, data.getSelectItems().length);

View Full Code Here

Examples of org.apache.solr.request.compare.GroupbyItem

       
       NamedList fieldCounts = new NamedList();
        GroupbyItem[] counts = dff.getPairSorted(limit_offset);
        if(dff.recordcount!=null)
        {
          GroupbyItem recordcount=dff.recordcount;
          fieldCounts.add("count", recordcount.toNamedList());
        }
      ArrayList<Object> list=new ArrayList<Object>();


        int end = limit_offset> counts.length ?counts.length:limit_offset;
        for (int i=offset; i<end; i++) {

View Full Code Here

Examples of org.apache.solr.request.compare.GroupbyItem

  
      int saverecords=dff.offset + dff.limit;
      GroupbyItem[] counts = dff.getPairSorted(saverecords);
      if(dff.recordcount!=null)
      {
          GroupbyItem recordcount=dff.recordcount;
        fieldCounts.add("count", recordcount.toNamedList());
      }
  
      int end = dff.limit < 0 ? counts.length : Math.min(dff.offset + dff.limit, counts.length);
    ArrayList<Object> list=new ArrayList<Object>();


      for (int i=dff.offset; i<end; i++) {
        GroupbyItem item=counts[i];
        list.add(item.toNamedList());
      }
      fieldCounts.add("list", list);
      rb.rsp.add("mdrill_data", fieldCounts);
    }

View Full Code Here

TOP

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.