Examples of org.apache.torque.test.dbobject.DatabaseDefaultValues

org.apache.torque.test.dbobject.DatabaseDefaultValues
The skeleton for this class was autogenerated by Torque on: [Wed Feb 27 08:39:08 CET 2013] You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.

    /**
     * Checks the java default values.
     */
    public void testJavaDefault() throws Exception
    {
        DatabaseDefaultValues databaseDefaultValues
                = new DatabaseDefaultValues();
        assertEquals(Integer.valueOf(2), databaseDefaultValues.getOInteger());
        assertEquals(4, databaseDefaultValues.getPInt());
        assertEquals("Default!", databaseDefaultValues.getVarcharField());
        // For date values, java fields are null if the default is read
        // from the database. This is because different databases
        // handle dates differently so it is difficult to predict
        // from java side what the database value will be.
        assertEquals(null, databaseDefaultValues.getDateField());
        assertEquals(null, databaseDefaultValues.getTimeField());
        assertEquals(null, databaseDefaultValues.getTimestampField());
    }

View Full Code Here

     * Checks that the buildColumnValues for an unchanged object
     * does not contain the values with database default.
     */
    public void testGetColumnValuesNewUnchangedObject() throws Exception
    {
        DatabaseDefaultValues databaseDefaultValues
                = new DatabaseDefaultValues();
        ColumnValues columnValues
                = DatabaseDefaultValuesPeer.buildColumnValues(
                        databaseDefaultValues);
        assertEquals(1, columnValues.size());
        assertEquals(

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),
                databaseDefaultValuesSaved.getOInteger());
        assertEquals(4, databaseDefaultValuesSaved.getPInt());
        assertEquals("Default!", databaseDefaultValuesSaved.getVarcharField());
        assertEquals(toString(doSelect(toDate("2010-09-08 00:00:00"),
                        java.sql.Date.class)),
                toString(databaseDefaultValuesSaved.getDateField()));
        assertEquals(toString(doSelect(toDate("1970-01-01 10:20:30"),
                        java.sql.Time.class)),
                toString(databaseDefaultValuesSaved.getTimeField()));
        assertEquals(toString(doSelect(toDate("2010-09-08 11:12:13"),
                        java.sql.Timestamp.class)),
                toString(databaseDefaultValuesSaved.getTimestampField()));
    }

View Full Code Here

     * 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),
                databaseDefaultValuesSaved.getOInteger());
        assertEquals(3, databaseDefaultValuesSaved.getPInt());
        assertEquals("Changed!", databaseDefaultValuesSaved.getVarcharField());
        assertEquals(toString(doSelect(toDate("2000-01-02 00:00:00"),
                    java.sql.Date.class)),
                toString(databaseDefaultValuesSaved.getDateField()));
        assertEquals(toString(doSelect(toDate("1970-01-01 11:21:31"),
                        java.sql.Time.class)),
                toString(databaseDefaultValuesSaved.getTimeField()));
        assertEquals(toString(doSelect(toDate("2010-09-08 12:13:14"),
                        java.sql.Timestamp.class)),
                toString(databaseDefaultValuesSaved.getTimestampField()));
    }

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),
                databaseDefaultValuesSaved.getOInteger());
        assertEquals(4, databaseDefaultValuesSaved.getPInt());
        assertEquals("Default!", databaseDefaultValuesSaved.getVarcharField());
        assertEquals(null, databaseDefaultValuesSaved.getDateField());
        assertEquals(null, databaseDefaultValuesSaved.getTimeField());
        assertEquals(null, databaseDefaultValuesSaved.getTimestampField());
    }

View Full Code Here

TOP

Related Classes of org.apache.torque.test.dbobject.DatabaseDefaultValues

org.apache.torque.generated.peer.DefaultValuesFromDatabaseTest

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.