Examples of org.apache.cayenne.testdo.relationship.FlattenedTest1

Package org.apache.cayenne.testdo.relationship

Examples of org.apache.cayenne.testdo.relationship.FlattenedTest1

org.apache.cayenne.testdo.relationship.FlattenedTest1


        String ejbql = "SELECT f FROM FlattenedTest3 f, FlattenedTest1 ft "
                + "WHERE f MEMBER OF ft.ft3Array AND ft = :ft";


        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 2);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);


        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());

View Full Code Here

    public void testCollectionMemberOfThetaJoinLongRelationshipSequence() throws Exception {
        String ejbql = "SELECT f FROM FlattenedTest4 f, FlattenedTest1 ft "
                + "WHERE f MEMBER OF ft.ft4ArrayFor1 AND ft = :ft";


        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 1);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);


        List<?> objects = context.performQuery(query);
        assertEquals(1, objects.size());

View Full Code Here


    public void testCollectionInnerJoin() throws Exception {
        String ejbql = "SELECT ft FROM FlattenedTest1 ft INNER JOIN ft.ft3Array f WHERE ft = :ft";


        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 1);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);


        List<?> objects = context.performQuery(query);
        assertNotNull(objects);

View Full Code Here

    public void testCollectionAsInnerJoin() throws Exception {
        // this query is equivalent to the previous INNER JOIN example
        String ejbql = "SELECT OBJECT(ft) FROM FlattenedTest1 ft, IN(ft.ft3Array) f WHERE ft = :ft";


        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 1);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);
        
        List<?> objects = context.performQuery(query);
        assertNotNull(objects);

View Full Code Here


    public void testCollectionIdentificationVariable() throws Exception {
        String ejbql = "SELECT ft.ft3Array FROM FlattenedTest1 ft WHERE ft = :ft";


        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 2);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);


        List<?> objects = context.performQuery(query);
        assertNotNull(objects);

View Full Code Here

    public void testAssociationFieldSelect() throws Exception {
        
        String ejbql = "SELECT ft3.toFT1 FROM FlattenedTest3 ft3 WHERE ft3.toFT1 = :ft";
        
        ObjectContext context = createDataContext();
        FlattenedTest1 ft = DataObjectUtils.objectForPK(context, FlattenedTest1.class, 1);
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("ft", ft);


        List<?> objects = context.performQuery(query);
        assertEquals(1, objects.size());

View Full Code Here

        tComplexJoin.insert(2001, 2, 3, "B");
        tComplexJoin.insert(2002, 2, 3, "C");
    }


    public void testInsertJoinWithPK() throws Exception {
        FlattenedTest1 obj01 = context.newObject(FlattenedTest1.class);
        FlattenedTest3 obj11 = context.newObject(FlattenedTest3.class);
        FlattenedTest3 obj12 = context.newObject(FlattenedTest3.class);


        obj01.setName("t01");
        obj11.setName("t11");
        obj12.setName("t12");


        obj01.addToFt3OverComplex(obj11);
        obj01.addToFt3OverComplex(obj12);


        context.commitChanges();


        int pk = Cayenne.intPKForObject(obj01);


        context.invalidateObjects(obj01, obj11, obj12);


        FlattenedTest1 fresh01 = Cayenne.objectForPK(context1, FlattenedTest1.class, pk);


        assertEquals("t01", fresh01.getName());
        ValueHolder related = (ValueHolder) fresh01.getFt3OverComplex();
        assertTrue(related.isFault());


        assertEquals(2, ((List<?>) related).size());
    }

View Full Code Here

                FlattenedTest1.class,
                "SELECT * FROM COMPLEX_JOIN");
        joinSelect.setFetchingDataRows(true);
        assertEquals(3, context.performQuery(joinSelect).size());


        FlattenedTest1 ft1 = Cayenne.objectForPK(context, FlattenedTest1.class, 2);


        assertEquals("ft12", ft1.getName());
        List<FlattenedTest3> related = ft1.getFt3OverComplex();
        assertTrue(((ValueHolder) related).isFault());


        assertEquals(2, related.size());


        FlattenedTest3 ft3 = Cayenne.objectForPK(context, FlattenedTest3.class, 3);
        assertTrue(related.contains(ft3));


        ft1.removeFromFt3OverComplex(ft3);
        assertFalse(related.contains(ft3));
        context.commitChanges();


        // the thing here is that there are two join records between
        // FT1 and FT3 (emulating invalid data or extras in the join table that

View Full Code Here

        // are ignored in the object model).. all (2) joins must be deleted
        assertEquals(1, context.performQuery(joinSelect).size());
    }


    public void testQualifyOnToManyFlattened() throws Exception {
        FlattenedTest1 obj01 = context.newObject(FlattenedTest1.class);
        FlattenedTest2 obj02 = context.newObject(FlattenedTest2.class);
        FlattenedTest3 obj031 = context.newObject(FlattenedTest3.class);
        FlattenedTest3 obj032 = context.newObject(FlattenedTest3.class);


        FlattenedTest1 obj11 = context.newObject(FlattenedTest1.class);
        FlattenedTest2 obj12 = context.newObject(FlattenedTest2.class);
        FlattenedTest3 obj131 = context.newObject(FlattenedTest3.class);


        obj01.setName("t01");
        obj02.setName("t02");
        obj031.setName("t031");
        obj032.setName("t032");
        obj02.setToFT1(obj01);
        obj02.addToFt3Array(obj031);
        obj02.addToFt3Array(obj032);


        obj11.setName("t11");
        obj131.setName("t131");
        obj12.setName("t12");
        obj12.addToFt3Array(obj131);
        obj12.setToFT1(obj11);

View Full Code Here

        assertSame(obj11, objects2.get(0));
    }


    public void testToOneSeriesFlattenedRel() {


        FlattenedTest1 ft1 = (FlattenedTest1) context.newObject("FlattenedTest1");
        ft1.setName("FT1Name");
        FlattenedTest2 ft2 = (FlattenedTest2) context.newObject("FlattenedTest2");
        ft2.setName("FT2Name");
        FlattenedTest3 ft3 = (FlattenedTest3) context.newObject("FlattenedTest3");
        ft3.setName("FT3Name");


        ft2.setToFT1(ft1);
        ft2.addToFt3Array(ft3);
        context.commitChanges();


        context.invalidateObjects(ft1, ft2, ft3);


        SelectQuery q = new SelectQuery(FlattenedTest3.class);
        q.setQualifier(ExpressionFactory.matchExp("name", "FT3Name"));
        List<?> results = context1.performQuery(q);


        assertEquals(1, results.size());


        FlattenedTest3 fetchedFT3 = (FlattenedTest3) results.get(0);
        FlattenedTest1 fetchedFT1 = fetchedFT3.getToFT1();
        assertEquals("FT1Name", fetchedFT1.getName());
    }

View Full Code Here

0 1 2 3

TOP

Related Classes of org.apache.cayenne.testdo.relationship.FlattenedTest1

org.apache.cayenne.access.DataContextEJBQLFlattenedRelationshipsTest

org.apache.cayenne.FlattenedRelationshipsTest

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.