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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.where()
"AND"s Criterion object with the conditions in this Criteria. Equivalent to #and(Criterion) but better to read if this is the first condition to be added to the Criteria. @param criterion A Criterion object. @return A modified Criteria object.


        // execute matching select
        Criteria criteria = new Criteria();
        calendar = new GregorianCalendar(2010, 1, 23);
        calendar.set(GregorianCalendar.MILLISECOND, 124);
        criteria.where(
                DateTimeTimestampTypePeer.TIMESTAMP_VALUE,
                calendar.getTime());
        List<DateTimeTimestampType> result
            = DateTimeTimestampTypePeer.doSelect(criteria);

View Full Code Here

        dateTimeTimestamp.save();


        // execute select
        Criteria criteria = new Criteria();
        Date toSelect = new GregorianCalendar(2010, 1, 23).getTime();
        criteria.where(
                DateTimeTimestampTypePeer.TIMESTAMP_VALUE,
                new java.sql.Timestamp(toSelect.getTime()));
        List<DateTimeTimestampType> result
            = DateTimeTimestampTypePeer.doSelect(criteria);

View Full Code Here

        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        List<String> authorIds = new ArrayList<String>();
        authorIds.add(author1.getName());
        authorIds.add(author2.getName());
        subquery.where(AuthorPeer.NAME, authorIds, Criteria.IN);
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery, Criteria.IN);
        criteria.addDescendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<?> result = AuthorPeer.doSelect(criteria);

View Full Code Here

        List<String> authorIds = new ArrayList<String>();
        authorIds.add(author1.getName());
        authorIds.add(author2.getName());
        subquery.where(AuthorPeer.NAME, authorIds, Criteria.IN);
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery, Criteria.IN);
        criteria.addDescendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<?> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 2 but got " + result.size(),
                result.size(),

View Full Code Here

            return;
        }


        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        subquery.where(author1.getName(), AuthorPeer.NAME);
        Criteria criteria = new Criteria();
        criteria.where(subquery, AuthorPeer.AUTHOR_ID);
        criteria.addDescendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<?> result = AuthorPeer.doSelect(criteria);

View Full Code Here


        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        subquery.where(author1.getName(), AuthorPeer.NAME);
        Criteria criteria = new Criteria();
        criteria.where(subquery, AuthorPeer.AUTHOR_ID);
        criteria.addDescendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<?> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 1 but got " + result.size(),
                1,

View Full Code Here

            return;
        }


        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        subquery.where(AuthorPeer.NAME, author1.getName());
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery);


        List<Author> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 1 but got " + result.size(),

View Full Code Here


        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        subquery.where(AuthorPeer.NAME, author1.getName());
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery);


        List<Author> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 1 but got " + result.size(),
                result.size(),
                1);

View Full Code Here

        Criteria subquery = new Criteria();
        subquery.addSelectColumn(AuthorPeer.AUTHOR_ID);
        List<String> nameList = new ArrayList<String>();
        nameList.add(author1.getName());
        nameList.add(author2.getName());
        subquery.where(AuthorPeer.NAME, nameList, Criteria.IN);
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery, Criteria.IN);
        criteria.addAscendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<Author> result = AuthorPeer.doSelect(criteria);

View Full Code Here

        List<String> nameList = new ArrayList<String>();
        nameList.add(author1.getName());
        nameList.add(author2.getName());
        subquery.where(AuthorPeer.NAME, nameList, Criteria.IN);
        Criteria criteria = new Criteria();
        criteria.where(AuthorPeer.AUTHOR_ID, subquery, Criteria.IN);
        criteria.addAscendingOrderByColumn(AuthorPeer.AUTHOR_ID);


        List<Author> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 2 but got " + result.size(),
                result.size(),

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.