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

org.apache.ojb.broker.query.Query
represents Queries that can be used by the OJB PersistenceBroker to retrieve Objects from the underlying DB. Until now there are two implementations: 1. QueryByCriteria, represents SELECT * FROM ... WHERE ... queries 2. QueryByIdentity, uses Example objects or OIDs as templates for the db lookup there could additional implementations, e.g for user defined SQL For the Criteria API I reused code from the COBRA project, as you will see by their class comments. I removed all stuff that relies on knowlegde of the DataDictionary or MetaData layer. The Query and Criteria classes thus don't know how to build SQL statements, as in the COBRA original sources. I use the this classes as mere data-structures, that are processed by the OJB Accesslayer (SqlGenerator, JdbcAccess). This design will allow to reuse the org.apache.ojb.broker.query package in other projects without breaking any references. I hope this will be useful for someone. @author Thomas Mahler @version $Id: Query.java,v 1.17.2.3 2005/12/21 22:27:09 tomdz Exp $

   */
    private void runQueryRangeTest(int delta)
    {


        // How many records are there in the table?
        Query countQuery = QueryFactory.newQuery(ProductGroup.class, null, false);


        // Get the existing record count
        int recordCount = broker.getCollectionByQuery(countQuery).toArray().length;


        // Build a query that will get the range we're looking for.
        Query listQuery = QueryFactory.newQuery(ProductGroup.class, null, false);
        listQuery.setStartAtIndex(1);
        listQuery.setEndAtIndex(recordCount + delta);


        // Get the list.
        Object[] theObjects = broker.getCollectionByQuery(listQuery).toArray();


        // Verify the record count

View Full Code Here

    {
        PersistenceBroker broker = getBroker();
        Collection result;
        try
        {
            Query q = new QueryByCriteria(target, null);
            result = broker.getCollectionByQuery(q);
        }
        finally
        {
            if (broker != null) broker.close();

View Full Code Here

                    String name = cld.getFullTableName();
                    assertEquals(newTestObjectString, name);
                    assertTrue(MetadataManager.getInstance().isEnablePerThreadChanges());


                    // query a test object
                    Query query = new QueryByCriteria(Person.class, null, true);
                    broker.getCollectionByQuery(query);
                    // store target object
                    /*
                    store some complex objects to check if references to
                    metadata classes are cached

View Full Code Here

                        // this PB instance use unchanged global metadata repository
                        assertEquals(getTestObjectString(), name);
                        // System.out.println("Default: found "+name);


                        // query a test object
                        Query query = new QueryByCriteria(Person.class, null, true);
                        broker.getCollectionByQuery(query);
                        // store target object
                        Object obj = ClassHelper.newInstance(targetTestClass);
                        broker.beginTransaction();
                        broker.store(obj);

View Full Code Here


    protected int getDBObjectCountWithNewPB(Class target) throws Exception
    {
        PersistenceBroker broker = PersistenceBrokerFactory.defaultPersistenceBroker();
        Criteria c = new Criteria();
        Query q = new QueryByCriteria(target, c);
        int count = broker.getCount(q);
        broker.close();
        return count;
    }

View Full Code Here

    }


    protected int getDBObjectCount(PersistenceBroker broker, Class target) throws Exception
    {
        Criteria c = new Criteria();
        Query q = new QueryByCriteria(target, c);
        int count = broker.getCount(q);
        return count;
    }

View Full Code Here

       group.setId(new Integer(0));
        group.setName(name);


        // prepare test
        broker.beginTransaction();
        Query q = QueryFactory.newQuery(group);
        broker.deleteByQuery(q);
        broker.commitTransaction();
        broker.clearCache();


       QueryByCriteria query = new QueryByCriteria(group);
       ObjectRepository.Group newGroup = ( ObjectRepository.Group ) broker.getObjectByQuery(query);
        assertNull(newGroup);


        broker.beginTransaction();
        broker.store(group);
        broker.commitTransaction();


        ObjectRepository.Group groupTemp = new ObjectRepository.Group();
       groupTemp.setId(new Integer(0));
        Query queryNew = QueryFactory.newQuery(groupTemp);
       newGroup = ( ObjectRepository.Group ) broker.getObjectByQuery(queryNew);
        assertNotNull(newGroup);
        assertEquals(new Integer(0), newGroup.getId());


       newGroup = ( ObjectRepository.Group ) broker.getObjectByQuery(queryNew);

View Full Code Here

        crit3.setNegative(true);


        crit1.addAndCriteria(crit2);
        crit1.addAndCriteria(crit3);


        Query q = QueryFactory.newQuery(Person.class, crit1);
        Collection results = broker.getCollectionByQuery(q);


        // all persons except tom
        assertEquals(results.size(), 9);
    }

View Full Code Here

   */
    public void testEqualCriteria()
    {
        Criteria crit = new Criteria();
        crit.addEqualTo("firstname", "tom");
        Query q = QueryFactory.newQuery(Person.class, crit);


        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
    }

View Full Code Here

        subQuery.setAttributes(new String[] { "productGroupId" });
        subQuery.setDistinct(true);


        crit.addEqualTo("groupName", "test group " + stamp);
        crit.addNotIn("groupId", subQuery);
        Query q = QueryFactory.newQuery(ProductGroup.class, crit);


        results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        System.out.println("*** Found " + results.size() + " empty ProductGroups ***");
        assertEquals("Result of the query with sub-query does not match", loops, results.size());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.cocoon.portal.security.DBSecurityHandler

org.apache.jetspeed.components.persistence.store.ojb.otm.OTMStoreImpl

org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEntityAccess

org.apache.jetspeed.prefs.impl.PersistenceBrokerPreferencesProvider

org.apache.jetspeed.security.impl.PermissionManagerImpl

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

org.apache.jetspeed.security.spi.impl.SecurityAccessImpl

org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider

org.apache.jetspeed.sso.spi.impl.JetspeedPersistentSSOSiteManager

org.apache.ojb.broker.AbstractExtentClassTest

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.