Changeset 30 for trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java

Timestamp:

Apr 9, 2011, 12:44:03 PM (14 years ago)

Author:

fmguler

Message:

Fixes #3 - Criteria object is mostly implemented. An override of Ven.list() having criteria parameter is added. Old codebase only had string based criteria. In this commit, I am also adding typed criteria as a new feauture. With this new criteria system, user can create criteria object like;

new Criteria().eq(attr,value).like(attr,value).and().gt(attr, value).or().orderAsc(attr).orderDesc(attr).limit(limit, offset);

The orderings and the limit/offset values are not taken into account in the Ven (these are trivial, I will do them later).

Not thouroughly tested, because complex scenarios are only possible when applying to a real problem in a real application (which I am planning to do next).

File:

• trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java (modified) (4 diffs)

trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java

@@ -18 +18 @@
 package com.fmguler.ven.sample;
 
+import com.fmguler.ven.Criteria;
 import com.fmguler.ven.LiquibaseUtil;
 import com.fmguler.ven.Ven;
@@ -43 +44 @@
         //list the objects
         testList();
+        //list the objects by some criteria string
+        testListByCriteriaString();
+        //list the objects by some typed criteria
+        testListByCriteriaObject();
         //delete an object
         testDelete();
@@ -112 +117 @@
         joins.add("SomeDomainObject.anotherDomainObject");
         List objList = ven.list(SomeDomainObject.class, joins);
-        
+
         Iterator it = objList.iterator();
         while (it.hasNext()) {
@@ -121 +126 @@
 
     /**
-     * Test list the collection of objects by some criteria
+     * Test list the collection of objects by some criteria (string)
      */
-    public static void testListByCriteria() {
+    public static void testListByCriteriaString() {
         Ven ven = getVen();
-        //List objList = ven.list(SomeDomainObject.class/*, criteria */);
-        //System.out.println(objList);
+
+        //these objects will be included
+        Set joins = new HashSet();
+        joins.add("SomeDomainObject.anotherDomainObjects");
+        joins.add("SomeDomainObject.anotherDomainObject");
+
+        //the results will be filtered according to this criteria
+        Criteria criteria = new Criteria() //criteria object
+                //.param("and SomeDomainObject.name like :p1").param("p1", "s%")
+                .add("and SomeDomainObject.anotherDomainObjects.name like :p2").param("p2", "a%");
+
+
+        //list with includes and criteria
+        List objList = ven.list(SomeDomainObject.class, joins, criteria);
+
+        //print the results
+        Iterator it = objList.iterator();
+        while (it.hasNext()) {
+            SomeDomainObject someDomainObject = (SomeDomainObject)it.next();
+            System.out.println(someDomainObject);
+        }
+    }
+
+    /**
+     * Test list the collection of objects by some criteria (object)
+     */
+    public static void testListByCriteriaObject() {
+        Ven ven = getVen();
+
+        //these objects will be included
+        Set joins = new HashSet();
+        joins.add("SomeDomainObject.anotherDomainObjects");
+        joins.add("SomeDomainObject.anotherDomainObject");
+
+        //the results will be filtered according to this criteria
+        Criteria criteria = new Criteria() //criteria object
+                .like("SomeDomainObject.anotherDomainObjects.name", "a%") //attribute like value
+                .eq("SomeDomainObject.name", "sdo1") //attribute equals value
+                .and(); //connects previous criteria with and
+
+        //list with includes and criteria
+        List objList = ven.list(SomeDomainObject.class, joins, criteria);
+
+        //print the results
+        Iterator it = objList.iterator();
+        while (it.hasNext()) {
+            SomeDomainObject someDomainObject = (SomeDomainObject)it.next();
+            System.out.println(someDomainObject);
+        }
     }