Introduce listResults service with filtering on collectionId and attributes

[gpl/argeo-slc.git] / runtime / org.argeo.slc.support.hibernate / src / main / java / org / argeo / slc / hibernate / test / tree / TreeTestResultCollectionDaoHibernate.java

diff --git a/runtime/org.argeo.slc.support.hibernate/src/main/java/org/argeo/slc/hibernate/test/tree/TreeTestResultCollectionDaoHibernate.java b/runtime/org.argeo.slc.support.hibernate/src/main/java/org/argeo/slc/hibernate/test/tree/TreeTestResultCollectionDaoHibernate.java
index c1679b8231c5629d353ebdecee43920ad2efe92e..75470e247a00cc954a5a93bf2a9beec30eb3bd81 100644 (file)
--- a/runtime/org.argeo.slc.support.hibernate/src/main/java/org/argeo/slc/hibernate/test/tree/TreeTestResultCollectionDaoHibernate.java
+++ b/runtime/org.argeo.slc.support.hibernate/src/main/java/org/argeo/slc/hibernate/test/tree/TreeTestResultCollectionDaoHibernate.java
@@ -2,9 +2,11 @@ package org.argeo.slc.hibernate.test.tree;
 \r
 import java.sql.SQLException;\r
 import java.util.List;\r
+import java.util.Map;\r
 import java.util.SortedSet;\r
 import java.util.TreeSet;\r
 \r
+import org.argeo.slc.SlcException;\r
 import org.argeo.slc.core.test.tree.ResultAttributes;\r
 import org.argeo.slc.core.test.tree.TreeTestResult;\r
 import org.argeo.slc.core.test.tree.TreeTestResultCollection;\r
@@ -12,6 +14,7 @@ import org.argeo.slc.dao.test.tree.TreeTestResultCollectionDao;
 import org.hibernate.HibernateException;\r
 import org.hibernate.LockMode;\r
 import org.hibernate.Session;\r
+import org.hibernate.criterion.DetachedCriteria;\r
 import org.springframework.orm.hibernate3.HibernateCallback;\r
 import org.springframework.orm.hibernate3.support.HibernateDaoSupport;\r
 \r
@@ -89,4 +92,49 @@ public class TreeTestResultCollectionDaoHibernate extends HibernateDaoSupport
 \r
                return list;\r
        }\r
+\r
+       @SuppressWarnings("unchecked")\r
+       public List<TreeTestResult> listResults(String collectionId,\r
+                       Map<String, String> attributes) {\r
+               List<TreeTestResult> list;\r
+\r
+               if (collectionId == null) {\r
+                       if (attributes == null || attributes.size() == 0)\r
+                               list = getHibernateTemplate().find("from TreeTestResult");\r
+                       else if (attributes.size() == 1) {\r
+                               Map.Entry<String, String> entry = attributes.entrySet()\r
+                                               .iterator().next();\r
+                               Object[] args = { entry.getKey(), entry.getValue() };\r
+                               list = getHibernateTemplate().find(\r
+                                               "select ttr from TreeTestResult ttr"\r
+                                                               + " where attributes[?]=?", args);\r
+                       } else {\r
+                               throw new SlcException(\r
+                                               "Multiple attributes filter are currently not supported.");\r
+                       }\r
+               } else {\r
+                       if (attributes == null || attributes.size() == 0)\r
+                               list = getHibernateTemplate()\r
+                                               .find(\r
+                                                               "select ttr "\r
+                                                                               + " from TreeTestResult ttr, TreeTestResultCollection ttrc "\r
+                                                                               + " where ttr in elements(ttrc.results) and ttrc.id=?",\r
+                                                               collectionId);\r
+                       else if (attributes.size() == 1) {\r
+                               Map.Entry<String, String> entry = attributes.entrySet()\r
+                                               .iterator().next();\r
+                               Object[] args = { collectionId, entry.getKey(),\r
+                                               entry.getValue() };\r
+                               list = getHibernateTemplate()\r
+                                               .find(\r
+                                                               "select ttr from TreeTestResult ttr, TreeTestResultCollection ttrc "\r
+                                                                               + " where ttr in elements(ttrc.results) and ttrc.id=?"\r
+                                                                               + " and attributes[?]=?", args);\r
+                       } else {\r
+                               throw new SlcException(\r
+                                               "Multiple attributes filter are currently not supported.");\r
+                       }\r
+               }\r
+               return list;\r
+       }\r
 }\r