List of addGroupByColumn() Examples

Examples of addGroupByColumn()

org.apache.torque.criteria.Criteria.addGroupByColumn()
Add a group by clause. @param groupBy The column to group by. @return A modified Criteria object.
org.apache.torque.util.Criteria.addGroupByColumn()
Add group by column name. @param groupBy The name of the column to group by. @return A modified Criteria object.

Examples of org.apache.torque.criteria.Criteria.addGroupByColumn()


    public void testGroupBy()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 FROM TABLE GROUP BY TABLE.COLUMN1",
                query.toString());
    }

View Full Code Here

Examples of org.apache.torque.criteria.Criteria.addGroupByColumn()

    }


    public void testHaving() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        criteria.addAsColumn("count", new ColumnImpl("count(*)"));
        criteria.addSelectColumn(stringColumnMap);
        criteria.addHaving(
                new Criterion("count", 10, Criteria.GREATER_EQUAL));
        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()


    public void testGroupBy()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 FROM TABLE GROUP BY TABLE.COLUMN1",
                query.toString());
    }

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

    }


    public void testHaving() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        criteria.addAsColumn("count", "count(*)");
        criteria.addSelectColumn(stringColumnMap);
        criteria.addHaving(
                criteria.getNewCriterion("count", 10, Criteria.GREATER_EQUAL));
        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

        setDistributorCriteria(data, criteria);
        setLocationCriteria(data, criteria);
        setProjectCriteria(data, criteria);
        setProductCriteria(data, criteria);
                
        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

        setLocationCriteria(data, criteria);
        setProjectCriteria(data, criteria);
        setProductCriteria(data, criteria);
                
        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);
        criteria.addGroupByColumn(DcontractItemPeer.COST_AMOUNT);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

        setProjectCriteria(data, criteria);
        setProductCriteria(data, criteria);
                
        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);
        criteria.addGroupByColumn(DcontractItemPeer.COST_AMOUNT);
        criteria.addGroupByColumn(CountryPeer.COUNTRY_NAME);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

        setProductCriteria(data, criteria);
                
        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);
        criteria.addGroupByColumn(DcontractItemPeer.COST_AMOUNT);
        criteria.addGroupByColumn(CountryPeer.COUNTRY_NAME);
        criteria.addGroupByColumn(ProductPeer.PRODUCT_CODE);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

                
        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);
        criteria.addGroupByColumn(DcontractItemPeer.COST_AMOUNT);
        criteria.addGroupByColumn(CountryPeer.COUNTRY_NAME);
        criteria.addGroupByColumn(ProductPeer.PRODUCT_CODE);
        criteria.addGroupByColumn(ProductPeer.PRODUCT_DISPLAY);

View Full Code Here

Examples of org.apache.torque.util.Criteria.addGroupByColumn()

        criteria.addGroupByColumn(LocationPeer.COUNTRY_ID);
        criteria.addGroupByColumn(DorderPeer.PRODUCT_ID);
        criteria.addGroupByColumn(DcontractItemPeer.DCONTRACT_ITEM_ID);
        criteria.addGroupByColumn(DcontractItemPeer.COST_TYPE_ID);
        criteria.addGroupByColumn(CostTypePeer.COST_TYPE_NAME);
        criteria.addGroupByColumn(DcontractItemPeer.COST_FUNCTION);
        criteria.addGroupByColumn(DcontractItemPeer.COST_AMOUNT);
        criteria.addGroupByColumn(CountryPeer.COUNTRY_NAME);
        criteria.addGroupByColumn(ProductPeer.PRODUCT_CODE);
        criteria.addGroupByColumn(ProductPeer.PRODUCT_DISPLAY);

View Full Code Here

0 1 2 3 4 5

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.