You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tf...@apache.org on 2005/01/11 18:13:00 UTC
cvs commit: db-torque/src/rttest/org/apache/torque DataTest.java
tfischer 2005/01/11 09:13:00
Modified: src/rttest/org/apache/torque Tag: TORQUE_3_1_BRANCH
DataTest.java
Added: src/java/org/apache/torque/util Tag: TORQUE_3_1_BRANCH
CountHelper.java
Log:
Added a helper class which eases counting of datasets in a table.
The CountHelper class has been submitted by Martin Goulet, and I have introduced some changes which are approved by Martin.
See TRQS265 in scarab for Martin's last version.
Also added a test case for the class.
Submitted by: (CountHelper.java) martin.goulet@sungard.com
Revision Changes Path
No revision
No revision
1.1.2.1 +141 -0 db-torque/src/java/org/apache/torque/util/Attic/CountHelper.java
No revision
No revision
1.8.2.8 +61 -2 db-torque/src/rttest/org/apache/torque/DataTest.java
Index: DataTest.java
===================================================================
RCS file: /home/cvs/db-torque/src/rttest/org/apache/torque/DataTest.java,v
retrieving revision 1.8.2.7
retrieving revision 1.8.2.8
diff -u -r1.8.2.7 -r1.8.2.8
--- DataTest.java 29 Dec 2004 20:45:01 -0000 1.8.2.7
+++ DataTest.java 11 Jan 2005 17:13:00 -0000 1.8.2.8
@@ -37,6 +37,7 @@
import org.apache.torque.test.MultiPkPeer;
import org.apache.torque.test.NullValueTable;
import org.apache.torque.util.BasePeer;
+import org.apache.torque.util.CountHelper;
import org.apache.torque.util.Criteria;
import com.workingdogs.village.Record;
@@ -901,8 +902,66 @@
+ " : " + e.getMessage());
}
}
+
-
+ /**
+ * Tests the CountHelper class
+ */
+ public void testCountHelper()
+ {
+ try
+ {
+ cleanBookstore();
+ Author author = new Author();
+ author.setName("Name");
+ author.save();
+
+ author = new Author();
+ author.setName("Name2");
+ author.save();
+
+ author = new Author();
+ author.setName("Name");
+ author.save();
+
+ Criteria criteria = new Criteria();
+ int count = new CountHelper().count(
+ criteria,
+ null,
+ AuthorPeer.AUTHOR_ID);
+
+ if (count != 3) {
+ fail("counted " + count + " datasets, should be 3 ");
+ }
+
+ criteria = new Criteria();
+ criteria.setDistinct();
+ count = new CountHelper().count(criteria, null, AuthorPeer.NAME);
+
+ if (count != 2) {
+ fail("counted " + count + " distinct datasets, should be 2 ");
+ }
+
+ criteria = new Criteria();
+ criteria.add(AuthorPeer.NAME, "Name2");
+ count = new CountHelper().count(criteria);
+
+ if (count != 1) {
+ fail("counted " + count + " datasets with name Name2,"
+ + " should be 1 ");
+ }
+
+ }
+ catch( Exception e)
+ {
+ e.printStackTrace();
+ fail("Exception caught : "
+ + e.getClass().getName()
+ + " : " + e.getMessage());
+ }
+ }
+
+
/**
* Strips the schema and table name from a fully qualified colum name
* This is useful for creating Query with aliases, as the constants
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org