Introduce list results 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 65fb02de27308c5065c142b2da8ce06cf9aaa405..0e44b74d5229ee2c189810a4fb7771d84dd13d35 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
@@ -1,9 +1,11 @@
 package org.argeo.slc.hibernate.test.tree;\r
 \r
 import java.sql.SQLException;\r
+import java.util.List;\r
 import java.util.SortedSet;\r
 import java.util.TreeSet;\r
 \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
 import org.argeo.slc.dao.test.tree.TreeTestResultCollectionDao;\r
@@ -29,6 +31,7 @@ public class TreeTestResultCollectionDaoHibernate extends HibernateDaoSupport
                getHibernateTemplate().update(ttrCollection);\r
        }\r
 \r
+       @SuppressWarnings("unchecked")\r
        public SortedSet<TreeTestResultCollection> listCollections() {\r
                return new TreeSet<TreeTestResultCollection>(getHibernateTemplate()\r
                                .find("from TreeTestResultCollection"));\r
@@ -64,4 +67,21 @@ public class TreeTestResultCollectionDaoHibernate extends HibernateDaoSupport
                });\r
        }\r
 \r
+       @SuppressWarnings("unchecked")\r
+       public List<ResultAttributes> listResultAttributes(String collectionId) {\r
+               List<ResultAttributes> list;\r
+               if (collectionId == null)\r
+                       list = getHibernateTemplate().find(\r
+                                       "select new org.argeo.slc.core.test.tree.ResultAttributes(ttr)"\r
+                                                       + " from TreeTestResult ttr");\r
+               else\r
+                       list = getHibernateTemplate()\r
+                                       .find(\r
+                                                       "select new org.argeo.slc.core.test.tree.ResultAttributes(ttr) "\r
+                                                                       + " from TreeTestResult ttr, TreeTestResultCollection ttrc "\r
+                                                                       + " where ttr in elements(ttrc.results) and ttrc.id=?",\r
+                                                       collectionId);\r
+\r
+               return list;\r
+       }\r
 }\r