Examples of org.apache.torque.criteria.Criteria

org.apache.torque.criteria.Criteria
Encapsulates conditions to access rows in database tables. @author Frank Y. Kim @author John D. McNally @author Brett McLaughlin @author Eric Dobbs @author Henning P. Schmiedehausen @author Sam Joseph @author Martin Poeschl @author Thomas Fischer @author Scott Eade @author Thomas Vandahl @version $Id: Criteria.java 1449216 2013-02-22 21:16:37Z tfischer $

     * @throws Exception if a database error occurs.
     */
    public void testInsert() throws Exception
    {
        // prepare
        SaveMethodInPeerFkPeer.doDelete(new Criteria());
        SaveMethodInObjectFkPeer.doDelete(new Criteria());
        SaveMethodInPeerPeer.doDelete(new Criteria());


        SaveMethodInPeer toSave = new SaveMethodInPeer();
        toSave.setPayload("payload 1");


        // execute
        SaveMethodInPeerPeer.save(toSave);


        // verify
        assertNotNull(toSave.getId());
        assertEquals("payload 1", toSave.getPayload());


        Criteria criteria = new Criteria()
            .where(SaveMethodInPeerPeer.ID, toSave.getId())
            .and(SaveMethodInPeerPeer.PAYLOAD, "payload 1");
        List<SaveMethodInPeer> loadedList
                = SaveMethodInPeerPeer.doSelect(criteria);
        assertEquals(1, loadedList.size());

View Full Code Here

                resolvedColumn.getTableName());
        if (resolvedAlias != null)
        {
            if (resolvedAlias instanceof Criteria)
            {
                Criteria subquery = (Criteria) resolvedAlias;
                Query renderedSubquery = SqlBuilder.buildQuery(subquery);
                PreparedStatementPart result = new PreparedStatementPart();
                result.getSql().append("(")
                        .append(renderedSubquery.toString())
                        .append(") ")

View Full Code Here

     * @throws Exception if a database error occurs.
     */
    public void testPropagationDown() throws Exception
    {
        // prepare
        SaveMethodInPeerFkPeer.doDelete(new Criteria());
        SaveMethodInObjectFkPeer.doDelete(new Criteria());
        SaveMethodInPeerPeer.doDelete(new Criteria());


        SaveMethodInPeer toSave = new SaveMethodInPeer();
        toSave.setPayload("payload");
        SaveMethodInPeerFk child1 = new SaveMethodInPeerFk();
        toSave.addSaveMethodInPeerFk(child1);
        child1.setPayload("payload 1");
        SaveMethodInObjectFk child2 = new SaveMethodInObjectFk();
        toSave.addSaveMethodInObjectFk(child2);
        child2.setPayload("payload 2");


        // execute
        SaveMethodInPeerPeer.save(toSave);


        // verify
        assertNotNull(toSave.getId());
        assertEquals("payload", toSave.getPayload());
        assertNotNull(child1.getId());
        assertEquals("payload 1", child1.getPayload());
        assertNotNull(child2.getId());
        assertEquals("payload 2", child2.getPayload());


        Criteria criteria = new Criteria()
            .where(SaveMethodInPeerPeer.ID, toSave.getId())
            .and(SaveMethodInPeerPeer.PAYLOAD, "payload");
        List<SaveMethodInPeer> loadedList
                = SaveMethodInPeerPeer.doSelect(criteria);
        assertEquals(1, loadedList.size());
        assertEquals(
                1,
                new CountHelper().count(SaveMethodInPeerPeer.getTableMap()));


        criteria = new Criteria()
            .where(SaveMethodInPeerFkPeer.SAVE_METHOD_IN_PEER_ID, toSave.getId())
            .and(SaveMethodInPeerFkPeer.ID, child1.getId())
            .and(SaveMethodInPeerFkPeer.PAYLOAD, "payload 1");
        List<SaveMethodInPeerFk> child1List
                = SaveMethodInPeerFkPeer.doSelect(criteria);
        assertEquals(1, child1List.size());
        assertEquals(
                1,
                new CountHelper().count(SaveMethodInPeerFkPeer.getTableMap()));


        criteria = new Criteria()
            .where(SaveMethodInObjectFkPeer.SAVE_METHOD_IN_PEER_ID, toSave.getId())
            .and(SaveMethodInObjectFkPeer.ID, child2.getId())
            .and(SaveMethodInObjectFkPeer.PAYLOAD, "payload 2");
        List<SaveMethodInObjectFk> child2List
                = SaveMethodInObjectFkPeer.doSelect(criteria);

View Full Code Here

     * with an already-existing unique key is inserted.
     */
    public void testUpdateWithUniqueConstraintViolation() throws TorqueException
    {
        // prepare
        SingleNamedUniquePeer.doDelete(new Criteria());
        SingleNamedUnique unique = new SingleNamedUnique();
        unique.setValue(1);
        unique.save();


        SingleNamedUnique duplicateUnique = new SingleNamedUnique();

View Full Code Here

    /**
     * Checks the values in the database if a new object is saved.
     */
    public void testNewObjectDatabaseDefault() throws Exception
    {
        DatabaseDefaultValuesPeer.doDelete(new Criteria());
        DatabaseDefaultValues databaseDefaultValues
                = new DatabaseDefaultValues();


        databaseDefaultValues.save();


        // saved object should stay the same
        assertEquals(Integer.valueOf(2), databaseDefaultValues.getOInteger());
        assertEquals(4, databaseDefaultValues.getPInt());
        assertEquals("Default!", databaseDefaultValues.getVarcharField());
        assertEquals(null, databaseDefaultValues.getDateField());
        assertEquals(null, databaseDefaultValues.getTimeField());
        assertEquals(null, databaseDefaultValues.getTimestampField());
        // re-loading should give the database default values
        List<DatabaseDefaultValues> databaseDefaultValuesList
                = DatabaseDefaultValuesPeer.doSelect(new Criteria());
        assertEquals(1, databaseDefaultValuesList.size());
        DatabaseDefaultValues databaseDefaultValuesSaved
                = databaseDefaultValuesList.get(0);
        assertEquals(
                new Integer(2),

View Full Code Here

     * Tests that values are saved if they are not equal to the default value
     * on a new object.
     */
    public void testNewObjectChangedValue() throws Exception
    {
        DatabaseDefaultValuesPeer.doDelete(new Criteria());
        DatabaseDefaultValues databaseDefaultValues
                = new DatabaseDefaultValues();
        databaseDefaultValues.setOInteger(1);
        databaseDefaultValues.setPInt(3);
        databaseDefaultValues.setVarcharField("Changed!");
        databaseDefaultValues.setDateField(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("2000-01-02 00:00:00"));
        databaseDefaultValues.setTimeField(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("1970-01-01 11:21:31"));
        databaseDefaultValues.setTimestampField(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("2010-09-08 12:13:14"));


        databaseDefaultValues.save();


        // saved object should stay the same
        assertEquals(Integer.valueOf(1), databaseDefaultValues.getOInteger());
        assertEquals(3, databaseDefaultValues.getPInt());
        assertEquals("Changed!", databaseDefaultValues.getVarcharField());
        assertEquals(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("2000-01-02 00:00:00"),
                databaseDefaultValues.getDateField());
        assertEquals(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("1970-01-01 11:21:31"),
                databaseDefaultValues.getTimeField());
        assertEquals(
                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .parse("2010-09-08 12:13:14"),
                databaseDefaultValues.getTimestampField());
        List<DatabaseDefaultValues> defaultValuesList
                = DatabaseDefaultValuesPeer.doSelect(new Criteria());
        assertEquals(1, defaultValuesList.size());
        DatabaseDefaultValues databaseDefaultValuesSaved
                = defaultValuesList.get(0);
        assertEquals(
                new Integer(1),

View Full Code Here

    /**
     * Checks the second save also saves unchanged values.
     */
    public void testNotNewObjectSavesUnchangedValues() throws Exception
    {
        DatabaseDefaultValuesPeer.doDelete(new Criteria());
        DatabaseDefaultValues databaseDefaultValues
                = new DatabaseDefaultValues();
        databaseDefaultValues.save();
        // modify object in db so we can check that the unchanged values
        // are saved
        List<DatabaseDefaultValues> databaseDefaultValuesList
                = DatabaseDefaultValuesPeer.doSelect(new Criteria());
        assertEquals(1, databaseDefaultValuesList.size());
        DatabaseDefaultValues changedValuesInDatabase
                = databaseDefaultValuesList.get(0);
        changedValuesInDatabase.setOInteger(1);
        changedValuesInDatabase.setPInt(3);
        changedValuesInDatabase.setVarcharField("Changed!");
        changedValuesInDatabase.setDateField(
                new GregorianCalendar(1990, 2, 4).getTime());
        changedValuesInDatabase.setTimeField(new Date(2500L));
        changedValuesInDatabase.setTimestampField(
                new GregorianCalendar(1990, 2, 4).getTime());
        changedValuesInDatabase.save();
        databaseDefaultValues.setModified(true);


        // second save behaves differently because object is not new any more
        // unchanged values should also be saved
        databaseDefaultValues.save();


        // saved object should stay the same
        assertEquals(Integer.valueOf(2), databaseDefaultValues.getOInteger());
        assertEquals(4, databaseDefaultValues.getPInt());
        assertEquals("Default!", databaseDefaultValues.getVarcharField());
        assertEquals(null, databaseDefaultValues.getDateField());
        assertEquals(null, databaseDefaultValues.getTimeField());
        assertEquals(null, databaseDefaultValues.getTimestampField());
        // re-loading should give the unchanged values
        // (changes in the db were overwritten by the second save)
        databaseDefaultValuesList
                = DatabaseDefaultValuesPeer.doSelect(new Criteria());
        assertEquals(1, databaseDefaultValuesList.size());
        DatabaseDefaultValues databaseDefaultValuesSaved
                = databaseDefaultValuesList.get(0);
        assertEquals(
                new Integer(2),

View Full Code Here

    {
        if (!canUseCurrentDateAsDefaultForDate())
        {
            return;
        }
        CurrentDateTablePeer.doDelete(new Criteria());
        CurrentDateTable currentDate = new CurrentDateTable();


        Date currentDateBefore = doSelect("CURRENT_DATE", java.sql.Date.class);
        currentDate.save();
        Date currentDateAfter = doSelect("CURRENT_DATE", java.sql.Date.class);


        List<CurrentDateTable> dbStateList
                = CurrentDateTablePeer.doSelect(new Criteria());
        assertEquals(1, dbStateList.size());
        CurrentDateTable dbState = dbStateList.get(0);
        assertFalse(
                "currentDate should be >= currentDateBefore",
                dbState.getCurrentDateValue().before(currentDateBefore));

View Full Code Here

    {
        if (!canUseCurrentTimeAsDefaultForTime())
        {
            return;
        }
        CurrentTimeTablePeer.doDelete(new Criteria());
        CurrentTimeTable currentTime = new CurrentTimeTable();


        Date currentDateBefore = doSelect("CURRENT_TIME", Time.class);
        currentTime.save();
        Date currentDateAfter = doSelect("CURRENT_TIME", Time.class);


        List<CurrentTimeTable> dbStateList
                = CurrentTimeTablePeer.doSelect(new Criteria());
        assertEquals(1, dbStateList.size());
        CurrentTimeTable dbState = dbStateList.get(0);
        if (timezoneBuggyInCurrentTime())
        {
            return;

View Full Code Here

    {
        if (!canUseCurrentTimestampAsDefaultForTimestamp())
        {
            return;
        }
        CurrentTimestampTablePeer.doDelete(new Criteria());
        CurrentTimestampTable currentTimestamp = new CurrentTimestampTable();


        Date currentTimestampBefore = doSelect("CURRENT_TIMESTAMP", Timestamp.class);
        currentTimestamp.save();
        Date currentTimestampAfter = doSelect("CURRENT_TIMESTAMP", Timestamp.class);


        List<CurrentTimestampTable> dbStateList
                = CurrentTimestampTablePeer.doSelect(new Criteria());
        assertEquals(1, dbStateList.size());
        CurrentTimestampTable dbState = dbStateList.get(0);
        assertFalse(
                "currentDate should be >= currentDateBefore",
                dbState.getCurrentTimestampValue().before(

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.torque.criteria.Criteria

org.apache.commons.lang.builder.EqualsBuilder

org.apache.commons.lang.builder.HashCodeBuilder

org.apache.torque.BaseDatabaseTestCase

org.apache.torque.BeanTestConditional

org.apache.torque.DataTest

org.apache.torque.datatypes.BitTest

org.apache.torque.datatypes.BooleanIntCharTest

org.apache.torque.datatypes.ByteTypeTest

org.apache.torque.datatypes.ClobTest

org.apache.torque.DocsTest

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.