Examples of org.apache.cayenne.access.DataContext.performQuery()

Class org.apache.cayenne.access.DataContext

Examples of org.apache.cayenne.access.DataContext.performQuery()

org.apache.cayenne.access.DataContext.performQuery()
Performs a single selecting query. Various query setting control the behavior of this method and the results returned:
- Query caching policy defines whether the results are retrieved from cache or fetched from the database. Note that queries that use caching must have a name that is used as a caching key.
- Query refreshing policy controls whether to refresh existing data objects and ignore any cached values.
- Query data rows policy defines whether the result should be returned as DataObjects or DataRows.
Since 1.2 takes any Query parameter, not just GenericSelectQuery
@return A list of DataObjects or a DataRows, depending on the value returned by{@link QueryMetadata#isFetchingDataRows()}.

        
        SQLTemplate template = new SQLTemplate(Artist.class, "SELECT ARTIST_ID FROM ARTIST");
        template.setStatementFetchSize(10);
        
        assertEquals(10, template.getMetaData(dataContext.getEntityResolver()).getStatementFetchSize());
        dataContext.performQuery(template);
        
        EJBQLQuery ejbql = new EJBQLQuery("select a from Artist a");
        ejbql.setStatementFetchSize(10);
        
        assertEquals(10, ejbql.getMetaData(dataContext.getEntityResolver()).getStatementFetchSize());

View Full Code Here

        
        EJBQLQuery ejbql = new EJBQLQuery("select a from Artist a");
        ejbql.setStatementFetchSize(10);
        
        assertEquals(10, ejbql.getMetaData(dataContext.getEntityResolver()).getStatementFetchSize());
        dataContext.performQuery(ejbql);
        
        ObjectId id = new ObjectId("Artist", Artist.ARTIST_ID_PK_COLUMN, 1);
        RelationshipQuery relationshipQuery = new RelationshipQuery(id, Artist.PAINTING_ARRAY_PROPERTY, true);
        relationshipQuery.setStatementFetchSize(10);

View Full Code Here

        ObjectId id = new ObjectId("Artist", Artist.ARTIST_ID_PK_COLUMN, 1);
        RelationshipQuery relationshipQuery = new RelationshipQuery(id, Artist.PAINTING_ARRAY_PROPERTY, true);
        relationshipQuery.setStatementFetchSize(10);
        
        assertEquals(10, relationshipQuery.getMetaData(dataContext.getEntityResolver()).getStatementFetchSize());
        dataContext.performQuery(relationshipQuery);
    }
}

View Full Code Here

        assertEquals(0, a1.getGroupArray().size());


        SelectQuery q = new SelectQuery(ArtGroup.class, ExpressionFactory.matchExp(
                "name",
                "g1"));
        List results = context.performQuery(q);
        assertEquals(1, results.size());


        assertFalse(context.hasChanges());
        ArtGroup group = (ArtGroup) results.get(0);
        a1.addToGroupArray(group);

View Full Code Here

        Artist a1 = Cayenne.objectForPK(context, Artist.class, 33001);


        SelectQuery q = new SelectQuery(ArtGroup.class, ExpressionFactory.matchExp(
                "name",
                "g1"));
        List results = context.performQuery(q);
        assertEquals(1, results.size());


        ArtGroup group = (ArtGroup) results.get(0);
        a1.addToGroupArray(group);

View Full Code Here

        Artist a1 = Cayenne.objectForPK(context, Artist.class, 33001);


        SelectQuery q = new SelectQuery(ArtGroup.class, ExpressionFactory.matchExp(
                "name",
                "g1"));
        List results = context.performQuery(q);
        assertEquals(1, results.size());


        ArtGroup group = (ArtGroup) results.get(0);
        a1.addToGroupArray(group);
        group.removeFromArtistArray(a1);

View Full Code Here

        DataContext context = createDataContext();


        Artist a1 = Cayenne.objectForPK(context, Artist.class, 33001);


        SelectQuery q = new SelectQuery(ArtGroup.class);
        List results = context.performQuery(q);
        assertEquals(2, results.size());


        ArtGroup g1 = (ArtGroup) results.get(0);
        ArtGroup g2 = (ArtGroup) results.get(1);
        a1.addToGroupArray(g1);

View Full Code Here

                "INSERT INTO GENERIC2 (GENERIC1_ID, ID, NAME) VALUES (1, 1, 'CCCCC')"));


        Expression qual = ExpressionFactory.matchExp("name", "AAAA");
        SelectQuery q = new SelectQuery("Generic1", qual);


        List result = context.performQuery(q);
        assertEquals(1, result.size());
    }


    public void testUpdateRelated() {
        DataContext context = createDataContext();

View Full Code Here


        SelectQuery distinct = new SelectQuery(ClobMaster.class);
        distinct.setDistinct(true);
        distinct.addOrdering(ClobMaster.NAME_PROPERTY, true);


        List noDistinctResult = context.performQuery(noDistinct);
        List distinctResult = context.performQuery(distinct);


        assertEquals(3, noDistinctResult.size());
        assertEquals(noDistinctResult, distinctResult);
    }

View Full Code Here

        SelectQuery distinct = new SelectQuery(ClobMaster.class);
        distinct.setDistinct(true);
        distinct.addOrdering(ClobMaster.NAME_PROPERTY, true);


        List noDistinctResult = context.performQuery(noDistinct);
        List distinctResult = context.performQuery(distinct);


        assertEquals(3, noDistinctResult.size());
        assertEquals(noDistinctResult, distinctResult);
    }

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.