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/17 08:58:54 UTC
svn commit: r548012 -
/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
Author: aadamchik
Date: Sat Jun 16 23:58:52 2007
New Revision: 548012
URL: http://svn.apache.org/viewvc?view=rev&rev=548012
Log:
CAY-805: SQLTemplate improvement: new #bindObjectEqual #bindObjectNotEqual directives
Modified:
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
Modified: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java?view=diff&rev=548012&r1=548011&r2=548012
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java (original)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java Sat Jun 16 23:58:52 2007
@@ -177,6 +177,27 @@
assertEquals(33002, DataObjectUtils.intPKForObject(p));
}
+ public void testBindObjectEqualFullNonArray() throws Exception {
+ createTestData("prepare");
+
+ ObjectContext context = createDataContext();
+
+ Artist a = (Artist) DataObjectUtils.objectForPK(context, Artist.class, 33002);
+
+ String template = "SELECT * FROM PAINTING t0"
+ + " WHERE #bindObjectEqual($a 't0.ARTIST_ID' 'ARTIST_ID' ) ORDER BY PAINTING_ID";
+ SQLTemplate query = new SQLTemplate(Painting.class, template);
+ query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
+ query.setParameters(Collections.singletonMap("a", a));
+
+ List objects = context.performQuery(query);
+ assertEquals(1, objects.size());
+
+ Painting p = (Painting) objects.get(0);
+ assertEquals(33002, DataObjectUtils.intPKForObject(p));
+ }
+
+
public void testBindObjectEqualNull() throws Exception {
createTestData("prepare");