Package org.apache.ojb.broker.query

Examples of org.apache.ojb.broker.query.QueryByCriteria.addOrderByDescending()

805
806
807
808
809
810
811
812
813
814
815
        cldArticle.setProxyClass(null);

        Criteria crit = new Criteria();
        crit.addLessOrEqualThan("groupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(ProductGroupWithArray.class, crit);
        q.addOrderByDescending("groupId");
        q.addPrefetchedRelationship("allArticlesInGroup");

        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
View Full Code Here
872
873
874
875
876
877
878
879
880
881
882
        broker.getDescriptorRepository().setClassDescriptor(cldArticle);

        Criteria crit = new Criteria();
        crit.addLessOrEqualThan("groupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit);
        q.addOrderByDescending("groupId");
        q.addPrefetchedRelationship("allArticlesInGroup");

        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
View Full Code Here
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
        Criteria crit = new Criteria();
        crit.addNotNull("productGroupId");
        crit.addLessOrEqualThan("productGroupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(Article.class, crit);
        q.addOrderByDescending("productGroupId");
        q.addPrefetchedRelationship("productGroup");

        Collection results = broker.getCollectionByQuery(q);
        Set pgs = new HashSet();
        Iterator iter = results.iterator();
View Full Code Here
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
        crit = new Criteria();
        crit.addNotNull("productGroupId");
        crit.addLessOrEqualThan("productGroupId", new Integer(5));
        q = QueryFactory.newQuery(Article.class, crit);
        q.addOrderByDescending("productGroupId");

        results = broker.getCollectionByQuery(q);
        Set pgs2 = new HashSet();
        iter = results.iterator();
        while (iter.hasNext())
View Full Code Here
968
969
970
971
972
973
974
975
976
977
978
        // 1. ensure there are 0 items matching the query
        String name = "SortingTestArticle";
        Criteria criteria = new Criteria();
        criteria.addEqualTo("articleName", name);
        QueryByCriteria query = QueryFactory.newQuery(Article.class, criteria);
        query.addOrderByDescending("articleId");
        Collection col = broker.getCollectionByQuery(query);
        Iterator iter = col.iterator();
        broker.beginTransaction();
        while (iter.hasNext())
        {
View Full Code Here
913
914
915
916
917
918
919
920
921
922
923
    {
        String name = "testSorting_" + System.currentTimeMillis();
        Criteria criteria = new Criteria();
        criteria.addEqualTo("articleName", name);
        QueryByCriteria query = QueryFactory.newQuery(Article.class, criteria);
        query.addOrderByDescending("articleId");
        Collection col = broker.getCollectionByQuery(query);
        assertEquals("size of collection should be zero", 0, col.size());

        //2. insert 3 matching items
        broker.beginTransaction();
View Full Code Here
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
        cldArticle.setProxyClass(null);

        Criteria crit = new Criteria();
        crit.addLessOrEqualThan("groupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(ProductGroupWithArray.class, crit);
        q.addOrderByDescending("groupId");
        q.addPrefetchedRelationship("allArticlesInGroup");

        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
View Full Code Here
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
        cds.addOrderBy("articleId", true);
        
        Criteria crit = new Criteria();
        crit.addLessOrEqualThan("groupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit);
        q.addOrderByDescending("groupId");
        q.addPrefetchedRelationship("allArticlesInGroup");

        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() == 5);
View Full Code Here
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
        broker.getDescriptorRepository().setClassDescriptor(cldArticle);

        Criteria crit = new Criteria();
        crit.addLessOrEqualThan("groupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit);
        q.addOrderByDescending("groupId");
        q.addPrefetchedRelationship("allArticlesInGroup");

        Collection results = broker.getCollectionByQuery(q);
        assertNotNull(results);
        assertTrue(results.size() > 0);
View Full Code Here
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
        Criteria crit = new Criteria();
        crit.addNotNull("productGroupId");
        crit.addLessOrEqualThan("productGroupId", new Integer(5));
        QueryByCriteria q = QueryFactory.newQuery(Article.class, crit);
        q.addOrderByDescending("productGroupId");
        q.addPrefetchedRelationship("productGroup");

        Collection results = broker.getCollectionByQuery(q);
        Set pgs = new HashSet();
        Iterator iter = results.iterator();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.