Changeset 30 for trunk/fmgVen/src/com/fmguler

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).

Location:

trunk/fmgVen/src/com/fmguler/ven

Files:

• Criteria.java (added)
• Ven.java (modified) (1 diff)

trunk/fmgVen/src/com/fmguler/ven/Ven.java

@@ -97 +97 @@
 
     /**
+     * List the objects of the specified objectClass type, filtering according to some criteria.
+     * <p>
+     * By default none of the associations will be retrieved.
+     * To include the object associations (retrieve the object graph) joins should be specified, e.g.
+     * <code>SomeObject.anotherObject</code>
+     * 
+     * @param objectClass the class of the objects to be retrieved
+     * @param joins the set of object graphs to be included with objects
+     * @param criteria to filter and order the result according to some criteria
+     * @return the list of objects including the specified associations filtered according to the specified criteria
+     */
+    public List list(Class objectClass, Set joins, Criteria criteria) {
+        String query = generator.generateSelectQuery(objectClass, joins);
+        query += " where 1=1 " + criteria.criteriaStringToSQL() + " and " + criteria.criteriaToSQL();
+
+        if (debug) System.out.println("Ven - SQL: " + query);
+
+        List result = mapper.list(query, criteria.getParameters(), objectClass);
+        return result;
+    }
+
+    /**
      * Save the object. If it has a non null (or non zero) "id" property it will be updated.
      * It will be inserted otherwise.