Examples of org.apache.ojb.broker.query.ReportQueryByCriteria

org.apache.ojb.broker.query.ReportQueryByCriteria
Query for Reports. Supports selection of a subset of attributes. @author Jakob Braeuchi @version $Id: ReportQueryByCriteria.java,v 1.10.2.2 2005/12/21 22:27:09 tomdz Exp $

   * test may fail if db does not support sub queries
   */
    public void testSubQuery3()
    {


        ReportQueryByCriteria subQuery;
        Criteria subCrit = new Criteria();
        Criteria crit = new Criteria();


        subCrit.addEqualToField("productGroupId", Criteria.PARENT_QUERY_PREFIX + "groupId");
        subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
        subQuery.setAttributes(new String[] { "count(productGroupId)" });


        crit.addLessThan("10", subQuery); // MORE than 10 articles, uses
                      // attribute as value !
        crit.addLessThan("groupId", new Integer(987654));
        Query q = QueryFactory.newQuery(ProductGroup.class, crit);

View Full Code Here

   * test may fail if db does not support sub queries
   */
    public void testSubQuery4()
    {


        ReportQueryByCriteria subQuery;
        Criteria subCrit = new Criteria();
        Criteria crit = new Criteria();


        subCrit.addEqualToField("productGroupId", Criteria.PARENT_QUERY_PREFIX + "groupId");
        subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
        subQuery.setAttributes(new String[] { "count(productGroupId)" });


        crit.addGreaterThan(subQuery, "10"); // MORE than 10 articles
        crit.addLessThan("groupId", new Integer(987654));
        Query q = QueryFactory.newQuery(ProductGroup.class, crit);

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

        Criteria crit = new Criteria();
        Collection results = new Vector();
        int types[] = new int[]{Types.DECIMAL, Types.VARCHAR, Types.BIGINT};


        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });
        q.setJdbcTypes(types);


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });


        q.setStartAtIndex(3);
        q.setEndAtIndex(5);
        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())
        {

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("articleName", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "articleId", "articleName", "price" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

    public void testReportQueryPathExpression()
    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("articleName", "C%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "productGroup.groupName","articleId", "articleName", "price" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addEqualTo("productGroup.groupName", "Liquors");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "articleId", "articleName", "price" });
        q.addOrderByAscending("price");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        assertNotNull(iter);
        while (iter.hasNext())
        {

View Full Code Here

    {


        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addEqualTo("productGroup.groupName", "Liquors");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
        q.setAttributes(new String[] { "articleId", "articleName", "price" });
        q.addOrderByAscending("productGroup.groupId");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        assertNotNull(iter);
        while (iter.hasNext())
        {

View Full Code Here

   */
    public void testReportQueryGroupByExtents2()
    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroup.class, crit);
        q.setAttributes(new String[] { "groupName", "sum(allArticlesInGroup.stock)", "sum(allArticlesInGroup.price)" });
        q.addGroupBy("groupName");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        
//        SELECT A0.KategorieName,sum(A1.Lagerbestand),sum(A1.Einzelpreis)
//        FROM Kategorien A0

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.ojb.broker.query.ReportQueryByCriteria

org.apache.jetspeed.components.portletpreferences.PortletPreferencesServiceImpl

org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager

org.apache.ojb.broker.PersistenceBrokerTest

org.apache.ojb.broker.QueryTest

org.apache.ojb.broker.util.BrokerHelper

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.