Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.EJBQLQuery

84
85
86
87
88
89
90
91
92
93
94
95
        }

        createTwoPaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.estimatedPrice = :x";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);
        query1.setParameter("x", null);

        // unlike SelectQuery or SQLTemplate, EJBQL nulls are handled just like SQL.

        // note that some databases (notably Sybase) actually allow = NULL comparison,
        // most do not; per JPA spec the result is undefined.. so we can't make any
View Full Code Here
104
105
106
107
108
109
110
111
112
113
        }

        createTwoPaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.toArtist.artistName = :x";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);
        query1.setParameter("x", null);

        context.performQuery(query1);
    }
View Full Code Here
118
119
120
121
122
123
124
125
126
127
        }

        createTwoPaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE :x = p.toArtist.artistName";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);
        query1.setParameter("x", null);

        context.performQuery(query1);
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
    public void testIsNull() throws Exception {

        createTwoPaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.estimatedPrice IS NULL";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results = context.performQuery(query1);
        assertEquals(1, results.size());
        assertEquals(33001, Cayenne.intPKForObject((Persistent) results.get(0)));
    }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
    public void testIsNotNull() throws Exception {

        createTwoPaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.estimatedPrice IS NOT NULL";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results = context.performQuery(query1);
        assertEquals(1, results.size());
        assertEquals(33002, Cayenne.intPKForObject((Persistent) results.get(0)));
    }
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
    public void testToOneIsNull() throws Exception {

        createTwoPaintingsAndOneArtist();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.toArtist IS NULL";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results = context.performQuery(query1);
        assertEquals(1, results.size());
        assertEquals(33001, Cayenne.intPKForObject((Persistent) results.get(0)));
    }
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
    public void testToOneIsNotNull() throws Exception {

        createTwoPaintingsAndOneArtist();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.toArtist IS NOT NULL";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results = context.performQuery(query1);
        assertEquals(1, results.size());
        assertEquals(33003, Cayenne.intPKForObject((Persistent) results.get(0)));
    }
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
316
317
    public void testEqualsNullAndNotNullParameter() {
        String ejbql = "select p from Painting p WHERE p.toArtist=:x OR p.toArtist.artistName=:b";
        EJBQLParser parser = EJBQLParserFactory.getParser();
        EJBQLCompiledExpression select = parser.compile(ejbql, getDomain()
                .getEntityResolver());
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("x", null);
        query.setParameter("b", "Y");

        EJBQLTranslationContext tr = new EJBQLTranslationContext(getDomain()
                .getEntityResolver(), query, select, new JdbcEJBQLTranslatorFactory());
        select.getExpression().visit(new EJBQLSelectTranslator(tr));
        String sql = tr.getQuery().getDefaultTemplate();
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        String ejbql = "SELECT DISTINCT p FROM Painting p"
                + " WHERE p.estimatedPrice = ALL ("
                + " SELECT MAX(p1.estimatedPrice) FROM Painting p1"
                + ")";

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

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
                + " WHERE EXISTS ("
                + " SELECT DISTINCT p1.paintingTitle FROM Painting p1"
                + " WHERE p1.toArtist = a"
                + ")";

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

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
TOP

Related Classes of org.apache.cayenne.query.EJBQLQuery

  • com.adaptrex.core.persistence.cayenne.CayenneStoreData
  • org.apache.cayenne.access.DataContextEJBQLArrayResultTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsTest
  • org.apache.cayenne.access.DataContextEJBQLDeleteTest
  • org.apache.cayenne.access.DataContextEJBQLFetchJoinTest
  • org.apache.cayenne.access.DataContextEJBQLFlattenedRelationshipsTest
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressions
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressionsTemp
  • org.apache.cayenne.access.DataContextEJBQLGroupByHavingTest
    • 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.