Package org.apache.torque.util

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

187
188
189
190
191
192
193
194
195
196
197
        Criteria.Criterion c = crit.getNewCriterion(BookPeer.TITLE,
                (Object) "Book 6 - Author 1", Criteria.GREATER_EQUAL);
        c.and(crit.getNewCriterion(BookPeer.TITLE,
                (Object) "Book 8 - Author 3", Criteria.LESS_EQUAL));
        crit.add(c);
        crit.addDescendingOrderByColumn(BookPeer.BOOK_ID);
        crit.setLimit(10);
        crit.setOffset(5);
        List books = BookPeer.doSelect(crit);
        assertTrue("List should have 10 books, not " + books.size(),
                books.size() == 10);
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
                     + ", should be \"Book 4\"");
        }

        // test simple descending order by
        criteria = new Criteria();
        criteria.addDescendingOrderByColumn(BookPeer.TITLE);
        bookList = BookPeer.doSelect(criteria);
        if (bookList.size() != 4)
        {
            fail("Descending Order By: "
                     + "incorrect numbers of books found : "
View Full Code Here
690
691
692
693
694
695
696
697
698
699
700
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
        criteria.addDescendingOrderByColumn(BookPeer.TITLE);
        // the retrieved columns are
        // author    book   b
        // author1  book1   book1
        // author2  book4   book2
        // author2  book3   book2
View Full Code Here
729
730
731
732
733
734
735
736
737
738
739
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(BookPeer.TITLE);
        criteria.addDescendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
        // the retrieved columns are
        // author    book   b
        // author1  book1   book1
        // author2  book2   book4
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
            Criteria.Criterion c = crit.getNewCriterion(BookPeer.TITLE,
                    (Object) "Book 6 - Author 1", Criteria.GREATER_EQUAL);
            c.and(crit.getNewCriterion(BookPeer.TITLE,
                    (Object) "Book 8 - Author 3", Criteria.LESS_EQUAL));
            crit.add(c);
            crit.addDescendingOrderByColumn(BookPeer.BOOK_ID);
            crit.setLimit(10);
            crit.setOffset(5);
            List books = BookPeer.doSelect(crit);
            assertTrue("List should have 10 books, not " + books.size(),
                       books.size() == 10);
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
        Criteria.Criterion c = crit.getNewCriterion(BookPeer.TITLE,
                (Object) "Book 6 - Author 1", Criteria.GREATER_EQUAL);
        c.and(crit.getNewCriterion(BookPeer.TITLE,
                (Object) "Book 8 - Author 3", Criteria.LESS_EQUAL));
        crit.add(c);
        crit.addDescendingOrderByColumn(BookPeer.BOOK_ID);
        crit.setLimit(10);
        crit.setOffset(5);
        List books = BookPeer.doSelect(crit);
        assertTrue("List should have 10 books, not " + books.size(),
                books.size() == 10);
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
                     + ", should be \"Book 4\"");
        }
       
        // test simple descending order by
        criteria = new Criteria();
        criteria.addDescendingOrderByColumn(BookPeer.TITLE);
        bookList = BookPeer.doSelect(criteria);
        if (bookList.size() != 4)
        {
            fail("Descending Order By: "
                     + "incorrect numbers of books found : "
View Full Code Here
690
691
692
693
694
695
696
697
698
699
700
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
        criteria.addDescendingOrderByColumn(BookPeer.TITLE);
        // the retrieved columns are
        // author    book   b
        // author1  book1   book1
        // author2  book4   book2
        // author2  book3   book2
View Full Code Here
729
730
731
732
733
734
735
736
737
738
739
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(BookPeer.TITLE);
        criteria.addDescendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
        // the retrieved columns are
        // author    book   b
        // author1  book1   book1
        // author2  book2   book4
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
            Criteria.Criterion c = crit.getNewCriterion(BookPeer.TITLE,
                    (Object) "Book 6 - Author 1", Criteria.GREATER_EQUAL);
            c.and(crit.getNewCriterion(BookPeer.TITLE,
                    (Object) "Book 8 - Author 3", Criteria.LESS_EQUAL));
            crit.add(c);
            crit.addDescendingOrderByColumn(BookPeer.BOOK_ID);
            crit.setLimit(10);
            crit.setOffset(5);
            List books = BookPeer.doSelect(crit);
            assertTrue("List should have 10 books, not " + books.size(),
                       books.size() == 10);
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.