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.

                Criteria.ISNULL);
        Criterion criterion2 = new Criterion(
                BintBcharTypePeer.BCHAR_VALUE,
                Boolean.FALSE,
                Criteria.EQUAL);
        criteria.where(criterion1.or(criterion2));
        List<BintBcharType> selectedList
                = BintBcharTypePeer.doSelect(criteria);
        assertTrue("Should have read 1 dataset complex Criteria "
                + "but read " + selectedList.size(),
                selectedList.size() == 1);

View Full Code Here

     */
    public void testRead() throws Exception
    {
        // prepare
        Criteria criteria = new Criteria();
        criteria.where(QualifiedNamePeer.ID, qualifiedName1.getId());
        criteria.and(QualifiedNamePeer.PAYLOAD, qualifiedName1.getPayload());


        // execute
        List<QualifiedName> qualifiedNames
                = QualifiedNamePeer.doSelect(criteria);

View Full Code Here

        // execute
        qualifiedName2.save();


        // verify
        Criteria criteria = new Criteria();
        criteria.where(QualifiedNamePeer.ID, qualifiedName2.getId());
        List<QualifiedName> qualifiedNames
                = QualifiedNamePeer.doSelect(criteria);
        assertEquals(1, qualifiedNames.size());
        assertEquals(qualifiedName2.getId(), qualifiedNames.get(0).getId());
        assertEquals(

View Full Code Here

                "schema.fully_qualified_table",
                fullyQualifiedDatatabaseMap);
        ColumnMap columnMap = new ColumnMap("column", tableMap);
        basePeerImpl.setTableMap(tableMap);
        Criteria criteria = new Criteria();
        criteria.where(columnMap, 42);


        // execute
        int deleteCount = basePeerImpl.doDelete(criteria, connection);


        // verify mock

View Full Code Here

        dateTimeTimestamp.setTimestampValue(new Date());
        dateTimeTimestamp.save();


        // execute select
        Criteria criteria = new Criteria();
        criteria.where(DateTimeTimestampTypePeer.DATE_VALUE,
                new GregorianCalendar(2010, 1, 23).getTime());
        List<DateTimeTimestampType> result
            = DateTimeTimestampTypePeer.doSelect(criteria);


        // verify

View Full Code Here

        dateTimeTimestamp.setTimestampValue(new Date());
        dateTimeTimestamp.save();


        // execute select
        Criteria criteria = new Criteria();
        criteria.where(DateTimeTimestampTypePeer.TIME_VALUE, new Date(1234000));
        List<DateTimeTimestampType> result
            = DateTimeTimestampTypePeer.doSelect(criteria);


        // verify
        assertEquals(1, result.size());

View Full Code Here

        dateTimeTimestamp.setTimestampValue(new Date());
        dateTimeTimestamp.save();


        // execute select
        Criteria criteria = new Criteria();
        criteria.where(
                DateTimeTimestampTypePeer.TIME_VALUE,
                new java.sql.Time(1234000));
        List<DateTimeTimestampType> result
            = DateTimeTimestampTypePeer.doSelect(criteria);

View Full Code Here

                new GregorianCalendar(2010, 1, 23).getTime());
        dateTimeTimestamp.save();


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


        // verify

View Full Code Here


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


        // verify
        assertEquals(0, result.size());

View Full Code Here


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

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.