You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by aa...@apache.org on 2007/06/22 10:11:36 UTC
svn commit: r549749 -
/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java
Author: aadamchik
Date: Fri Jun 22 01:11:35 2007
New Revision: 549749
URL: http://svn.apache.org/viewvc?view=rev&rev=549749
Log:
CAY-452 EJB QL Cayenne Query
1. NOT BETWEEN test
Modified:
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java
Modified: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java?view=diff&rev=549749&r1=549748&r2=549749
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java (original)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextEJBQLQueryTest.java Fri Jun 22 01:11:35 2007
@@ -154,6 +154,20 @@
assertEquals(new BigDecimal(3000d), p.getEstimatedPrice());
}
+ public void testSelectFromWhereNotBetween() throws Exception {
+ createTestData("prepare");
+
+ String ejbql = "select P from Painting P WHERE p.estimatedPrice NOT BETWEEN 2000 AND 3500";
+ EJBQLQuery query = new EJBQLQuery(ejbql);
+
+ List ps = createDataContext().performQuery(query);
+ assertEquals(1, ps.size());
+
+ Painting p = (Painting) ps.get(0);
+ assertEquals("P2", p.getPaintingTitle());
+ assertEquals(new BigDecimal(5000d), p.getEstimatedPrice());
+ }
+
public void testSelectFromWhereGreater() throws Exception {
createTestData("prepare");