Package org.apache.cayenne.exp

Examples of org.apache.cayenne.exp.Expression


    }

    public void testPrefetch_ToOneWithQualifierOverlappingPrefetchPath() throws Exception {
        createTwoArtistsAndTwoPaintingsDataSet();

        Expression exp = ExpressionFactory.matchExp("toArtist.artistName", "artist3");

        SelectQuery q = new SelectQuery(Painting.class, exp);
        q.addPrefetch(Painting.TO_ARTIST_PROPERTY);

        final List<Painting> results = context.performQuery(q);
View Full Code Here


    }

    public void testPrefetch9() throws Exception {
        createTwoArtistsAndTwoPaintingsDataSet();

        Expression artistExp = ExpressionFactory.matchExp("artistName", "artist3");
        SelectQuery artistQuery = new SelectQuery(Artist.class, artistExp);
        Artist artist1 = (Artist) context.performQuery(artistQuery).get(0);

        // find the painting not matching the artist (this is the case where such prefetch
        // at least makes sense)
        Expression exp = ExpressionFactory.noMatchExp("toArtist", artist1);

        SelectQuery q = new SelectQuery(Painting.class, exp);
        q.addPrefetch("toArtist");

        final List<Painting> results = context.performQuery(q);
View Full Code Here

    }

    public void testPrefetch_OneToOneWithQualifier() throws Exception {
        createArtistWithTwoPaintingsAndTwoInfosDataSet();

        Expression e = ExpressionFactory.likeExp("toArtist.artistName", "a%");
        SelectQuery q = new SelectQuery(Painting.class, e);
        q.addPrefetch(Painting.TO_PAINTING_INFO_PROPERTY);
        q.addOrdering(Painting.PAINTING_TITLE_PROPERTY, SortOrder.ASCENDING);

        final List<Painting> results = context.performQuery(q);
View Full Code Here

    }

    public void testPrefetchToMany_DateInQualifier() throws Exception {
        createTwoArtistsAndTwoPaintingsDataSet();

        Expression e = ExpressionFactory.matchExp("dateOfBirth", new Date());
        SelectQuery q = new SelectQuery(Artist.class, e);
        q.addPrefetch("paintingArray");

        // prefetch with query using date in qualifier used to fail on SQL Server
        // see CAY-119 for details
View Full Code Here

        deleteTestData();
        createTestData("testRefreshCollection");

        DataContext context = createDataContext();

        Expression qual = ExpressionFactory.matchExp(
                Painting.PAINTING_TITLE_PROPERTY,
                "P2");
        SelectQuery q = new SelectQuery(Painting.class, qual);
        q.addOrdering("db:PAINTING_ID", SortOrder.ASCENDING);
        q.setCacheStrategy(QueryCacheStrategy.LOCAL_CACHE);
View Full Code Here

        deleteTestData();
        createTestData("testRefreshCollection");

        DataContext context = createDataContext();

        Expression qual = ExpressionFactory.matchExp(
                Painting.PAINTING_TITLE_PROPERTY,
                "P2");
        SelectQuery q = new SelectQuery(Painting.class, qual);
        q.addOrdering("db:PAINTING_ID", SortOrder.ASCENDING);
        q.setCacheStrategy(QueryCacheStrategy.SHARED_CACHE);
View Full Code Here

        deleteTestData();
        createTestData("testRefreshCollection");

        DataContext context = createDataContext();

        Expression qual = ExpressionFactory.matchExp(
                Painting.PAINTING_TITLE_PROPERTY,
                "P2");
        SelectQuery q = new SelectQuery(Painting.class, qual);
        q.addOrdering("db:PAINTING_ID", SortOrder.ASCENDING);
        q.setCacheStrategy(QueryCacheStrategy.LOCAL_CACHE);
View Full Code Here

    public void testFetchLimit_DistinctResultIterator() throws Exception {
        if (accessStack.getAdapter(getNode()).supportsLobs()) {

            insertClobDb();

            Expression qual = Expression.fromString("clobValue.value = 100");
            SelectQuery select = new SelectQuery(ClobTestEntity.class, qual);
            select.setFetchLimit(25);
            List<DataRow> resultRows = context.performQuery(select);

            assertNotNull(resultRows);
View Full Code Here

        Validate.notNull(dataObjectClass, "Null dataObjectClass parameter");
        Validate.notNull(property, "Null property parameter");
        Validate.notNull(value, "Null value parameter");

        Expression qual = ExpressionFactory.matchExp(property, value);
        return performQuery(new SelectQuery(dataObjectClass, qual));
    }
View Full Code Here

        ctxt.commitChanges();

        // reset context
        ctxt = createDataContext();

        Expression qual = ExpressionFactory.matchExp("toCompoundPk", master);
        SelectQuery q = new SelectQuery(CompoundFkTestEntity.class, qual);
        List<?> objs = ctxt.performQuery(q);
        assertEquals(1, objs.size());

        detail = (CompoundFkTestEntity) objs.get(0);
View Full Code Here

TOP

Related Classes of org.apache.cayenne.exp.Expression

Copyright © 2018 www.massapicom. All rights reserved.
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.