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

org.apache.torque.test.dbobject.NullableOIntegerFk
table with a nullable integer object foreign key which references a primary key column in the foreign table 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.

        Criteria criteria = new Criteria();
        criteria.and(NullableOIntegerFkPeer.NAME, "nullableOIntegerFk2");
        List<NullableOIntegerFk> fkList
                = NullableOIntegerFkPeer.doSelect(criteria);
        assertEquals(1, fkList.size());
        NullableOIntegerFk fkObject = fkList.get(0);
        assertEquals(
                testData.getNullableOIntegerFkList().get(0).getId(),
                fkObject.getId());


        OIntegerPk changedPkObject = fkObject.getOIntegerPk();
        changedPkObject.setName("oIntegerPk2modified");


        List<OIntegerPk> referencedPkList
                = NullableOIntegerFkPeer.fillOIntegerPks(
                        fkList);


        // returned list must contain unchanged new oIntegerPk2
        assertEquals(1, referencedPkList.size());
        assertEquals("oIntegerPk2", fkObject.getOIntegerPk().getName());
        assertNotSame(fkObject.getOIntegerPk(), changedPkObject);


        // fkObject must reference unchanged new oIntegerPk2
        assertEquals("oIntegerPk2", fkObject.getOIntegerPk().getName());
        assertNotSame(fkObject.getOIntegerPk(), changedPkObject);
    }

View Full Code Here

    public void testFillReferencedManyRecords() throws Exception
    {
        ForeignKeySchemaData.clearTablesInDatabase();
        for (int i = 1; i <= MANY; ++i)
        {
            NullableOIntegerFk fkObject = new NullableOIntegerFk();
            fkObject.setName("nullableOIntegerFk" + i);


            if (i % 10 != 0)
            {
                OIntegerPk pkObject = new OIntegerPk();
                pkObject.setName("oIntegerPk" + i);
                pkObject.setIntegerColumn(i);
                pkObject.save();
                fkObject.setOIntegerPk(pkObject);
                fkObject.save();


            }
            else
            {
                fkObject.save();
            }
        }


        Criteria criteria = new Criteria();
        criteria.addAscendingOrderByColumn(NullableOIntegerFkPeer.ID);
        List<NullableOIntegerFk> fkObjectList
            = NullableOIntegerFkPeer.doSelect(criteria);
        assertEquals(MANY, fkObjectList.size());


        int count = 0;
        for (NullableOIntegerFk fkObject : fkObjectList)
        {
            if (fkObject.getFk() != null && fkObject.getFk() == 0)
            {
                fail("fk Object with id " + fkObject.getId()
                        + " on position " + count + " has foreign key 0");
            }
            ++count;
        }
        // TODO assert that fkObjectList have not already loaded their pk object


        List<OIntegerPk> oIntegerPkList
                = NullableOIntegerFkPeer.fillOIntegerPks(fkObjectList);


        assertEquals(MANY - (MANY / 10), oIntegerPkList.size());


        int i = 1;
        for (NullableOIntegerFk fkObject : fkObjectList)
        {
            if (i % 10 != 0)
            {
                assertEquals(
                        "oIntegerPk" + i,
                        fkObject.getOIntegerPk().getName());
            }
            else
            {
                assertNull(fkObject.getOIntegerPk());
            }
            ++i;
        }
    }

View Full Code Here

        OIntegerPk pkObject = pkList.get(0);
        assertEquals(
                testData.getOIntegerPkList().get(1).getId(),
                pkList.get(0).getId());


        NullableOIntegerFk changedFkObject
                = pkObject.getNullableOIntegerFks().get(0);
        changedFkObject.setName("nullableOIntegerFk2Modified");


        List<NullableOIntegerFk> referencingFkList
                = OIntegerPkPeer.fillNullableOIntegerFks(pkList);


        // returned list must contain unchanged new nullableOIntegerFk2

View Full Code Here

            pkObject.setIntegerColumn(i);
            pkObject.save();


            if (i % 10 != 0)
            {
                NullableOIntegerFk fkObjectA = new NullableOIntegerFk();
                fkObjectA.setName("nullableOIntegerFk" + i + "a");
                fkObjectA.setOIntegerPk(pkObject);
                fkObjectA.save();
                NullableOIntegerFk fkObjectB = new NullableOIntegerFk();
                fkObjectB.setName("nullableOIntegerFk" + i + "b");
                fkObjectB.setOIntegerPk(pkObject);
                fkObjectB.save();
            }
        }


        Criteria criteria = new Criteria();
        criteria.addAscendingOrderByColumn(OIntegerPkPeer.ID);

View Full Code Here

        ForeignKeySchemaData.clearTablesInDatabase();
        ForeignKeySchemaData testData
                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        NullableOIntegerFk toDelete
            = testData.getNullableOIntegerFkList().get(0);
        int preDeleteId = toDelete.getId();


        // check that four entries are in the NullableOIntegerFk table
        List<NullableOIntegerFk> nullableOIntegerFkList
                = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
        assertTrue(nullableOIntegerFkList.contains(toDelete));


        // call delete method and check result.
        int deleted = NullableOIntegerFkPeer.doDelete(toDelete);
        assertEquals(1, deleted);
        assertEquals(preDeleteId, toDelete.getId().intValue());


        // check that there are three entries remaining in the database
        // and the toDelete object was deleted
        nullableOIntegerFkList = getNullableOIntegerFkList();
        assertEquals(3, nullableOIntegerFkList.size());

View Full Code Here

        ForeignKeySchemaData.clearTablesInDatabase();
        ForeignKeySchemaData testData
                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        NullableOIntegerFk toDelete
            = testData.getNullableOIntegerFkList().get(0);
        toDelete.setId(toDelete.getId() - 1);
        int preDeleteId = toDelete.getId();


        // check that four entries are in the NullableOIntegerFk table
        List<NullableOIntegerFk> nullableOIntegerFkList
                = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
        assertFalse(nullableOIntegerFkList.contains(toDelete));


        // call delete method and check result.
        int deleted = NullableOIntegerFkPeer.doDelete(toDelete);
        assertEquals(0, deleted);
        assertEquals(preDeleteId, toDelete.getId().intValue());


        // check that all entries remain in the database
        nullableOIntegerFkList = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
    }

View Full Code Here

        ForeignKeySchemaData.clearTablesInDatabase();
        ForeignKeySchemaData testData
                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        NullableOIntegerFk toDelete
            = testData.getNullableOIntegerFkList().get(0);
        toDelete.setName("nullableOIntegerFk2Changed");
        int preDeleteId = toDelete.getId();


        // check that isDeleted() is false before deletion
        assertFalse(toDelete.isDeleted());


        // check that four entries are in the NullableOIntegerFk table
        List<NullableOIntegerFk> nullableOIntegerFkList
                = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
        assertTrue(nullableOIntegerFkList.contains(toDelete));


        // call delete method and check result.
        int deleted = NullableOIntegerFkPeer.doDelete(toDelete);
        assertEquals(1, deleted);
        assertEquals(preDeleteId, toDelete.getId().intValue());
        assertTrue(toDelete.isDeleted());


        // check that there are three entries remaining in the database
        // and the toDelete object was deleted
        nullableOIntegerFkList = getNullableOIntegerFkList();
        assertEquals(3, nullableOIntegerFkList.size());

View Full Code Here

        ForeignKeySchemaData.clearTablesInDatabase();
        ForeignKeySchemaData testData
                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        NullableOIntegerFk toDelete
            = testData.getNullableOIntegerFkList().get(0);
        int preDeleteId = toDelete.getId();


        // check that four entries are in the NullableOIntegerFk table
        List<NullableOIntegerFk> nullableOIntegerFkList
                = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
        assertTrue(nullableOIntegerFkList.contains(toDelete));


        // calculate and check primary key
        ObjectKey primaryKey = toDelete.getPrimaryKey();
        assertTrue(primaryKey instanceof NumberKey);
        assertEquals(new BigDecimal(preDeleteId), primaryKey.getValue());


        // call delete method and check result.
        int deleted = NullableOIntegerFkPeer.doDelete(primaryKey);
        assertEquals(1, deleted);
        assertEquals(preDeleteId, toDelete.getId().intValue());


        // check that there are three entries remaining in the database
        // and the toDelete object was deleted
        nullableOIntegerFkList = getNullableOIntegerFkList();
        assertEquals(3, nullableOIntegerFkList.size());

View Full Code Here

        ForeignKeySchemaData.clearTablesInDatabase();
        ForeignKeySchemaData testData
                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        NullableOIntegerFk toDelete
            = testData.getNullableOIntegerFkList().get(0);
        toDelete.setId(toDelete.getId() - 1);
        int preDeleteId = toDelete.getId();


        // check that four entries are in the NullableOIntegerFk table
        List<NullableOIntegerFk> nullableOIntegerFkList
                = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
        assertFalse(nullableOIntegerFkList.contains(toDelete));


        // calculate and check primary key
        ObjectKey primaryKey = toDelete.getPrimaryKey();
        assertTrue(primaryKey instanceof NumberKey);
        assertEquals(new BigDecimal(preDeleteId), primaryKey.getValue());


        // call delete method and check result.
        int deleted = NullableOIntegerFkPeer.doDelete(primaryKey);
        assertEquals(0, deleted);
        assertEquals(preDeleteId, toDelete.getId().intValue());


        // check that all entries remain in the database
        nullableOIntegerFkList = getNullableOIntegerFkList();
        assertEquals(4, nullableOIntegerFkList.size());
    }

View Full Code Here

    }


    private static void fillNullableOIntegerFks(ForeignKeySchemaData result)
            throws TorqueException
    {
        NullableOIntegerFk nullableOIntegerFk2
                = new NullableOIntegerFk();
        nullableOIntegerFk2.setName(
                "nullableOIntegerFk2");
        result.getOIntegerPkList().get(1).addNullableOIntegerFk(
                nullableOIntegerFk2);
        result.getNullableOIntegerFkList().add(
                nullableOIntegerFk2);


        NullableOIntegerFk nullableOIntegerFk3a
                = new NullableOIntegerFk();
        nullableOIntegerFk3a.setName(
                "nullableOIntegerFk3a");
        result.getOIntegerPkList().get(2).addNullableOIntegerFk(
                nullableOIntegerFk3a);
        result.getNullableOIntegerFkList().add(
                nullableOIntegerFk3a);


        NullableOIntegerFk nullableOIntegerFk3b
                = new NullableOIntegerFk();
        nullableOIntegerFk3b.setName(
                "nullableOIntegerFk3b");
        result.getOIntegerPkList().get(2).addNullableOIntegerFk(
                nullableOIntegerFk3b);
        result.getNullableOIntegerFkList().add(
                nullableOIntegerFk3b);


        NullableOIntegerFk nullableOIntegerFk4
                = new NullableOIntegerFk();
        nullableOIntegerFk4.setName(
                "nullableOIntegerFk4");
        result.getNullableOIntegerFkList().add(
                nullableOIntegerFk4);
    }

View Full Code Here

0 1

TOP

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

org.apache.torque.ForeignKeySchemaData

org.apache.torque.generated.dataobject.ForeignKeyAdderTest

org.apache.torque.generated.dataobject.ForeignKeyGetterTest

org.apache.torque.generated.peer.DeleteTest

org.apache.torque.generated.peer.FillerTest

org.apache.torque.generated.peer.JoinTest

org.apache.torque.generated.peer.SetAndSaveTest

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.