svn commit: r552274 - /cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java

[aa...@apache.org]

Author: aadamchik
Date: Sun Jul  1 03:42:58 2007
New Revision: 552274

URL: http://svn.apache.org/viewvc?view=rev&rev=552274
Log:
frontbase testing
(frontbase seems more strict with aggregate queries, so adding a special SQLTemplate syntax for FrontBase; also "C" seems to be a keyword on Frontbase, so I couldn't use it as a column alias) 

Modified:
    cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java

Modified: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java?view=diff&rev=552274&r1=552273&r2=552274
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java (original)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/java/org/apache/cayenne/DataObjectUtilsTest.java Sun Jul  1 03:42:58 2007
@@ -28,6 +28,7 @@
 import org.apache.art.CharPkTestEntity;
 import org.apache.art.CompoundPkTestEntity;
 import org.apache.cayenne.access.DataContext;
+import org.apache.cayenne.dba.frontbase.FrontBaseAdapter;
 import org.apache.cayenne.map.DataMap;
 import org.apache.cayenne.query.ObjectIdQuery;
 import org.apache.cayenne.query.SQLResultSetMapping;
@@ -49,14 +50,15 @@
         createTestData("testScalarObjectForQuery");
         DataContext context = createDataContext();
 
-        String sql = "SELECT count(1) AS C FROM ARTIST";
+        String sql = "SELECT count(1) AS X FROM ARTIST";
 
         DataMap map = getDomain().getMap("testmap");
         SQLTemplate query = new SQLTemplate(map, sql);
+        query.setTemplate(FrontBaseAdapter.class.getName(), "SELECT COUNT(ARTIST_ID) AS X FROM ARTIST");
         query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
 
         SQLResultSetMapping rsMap = new SQLResultSetMapping();
-        rsMap.addColumnResult("C");
+        rsMap.addColumnResult("X");
         query.setResultSetMapping(rsMap);
 
         Object object = DataObjectUtils.objectForQuery(context, query);