ref #7648 initial implementation of TaxonGraphService with tests and TaxonGraphObserver

[cdmlib.git] / cdmlib-persistence / src / main / java / eu / etaxonomy / cdm / persistence / dao / hibernate / taxon / TaxonDaoHibernateImpl.java

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImpl.java
index 0a8b104d741ce0f789873b5134b0c9ed47a11857..075d403ba4f0287d6b0b9e87c2b87e50540bc978 100755 (executable)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImpl.java
@@ -66,6 +66,7 @@ import eu.etaxonomy.cdm.model.view.AuditEvent;
 import eu.etaxonomy.cdm.persistence.dao.hibernate.common.IdentifiableDaoBase;
 import eu.etaxonomy.cdm.persistence.dao.name.ITaxonNameDao;
 import eu.etaxonomy.cdm.persistence.dao.taxon.ITaxonDao;
+import eu.etaxonomy.cdm.persistence.dto.TaxonGraphEdgeDTO;
 import eu.etaxonomy.cdm.persistence.dto.UuidAndTitleCache;
 import eu.etaxonomy.cdm.persistence.query.MatchMode;
 import eu.etaxonomy.cdm.persistence.query.NameSearchOrder;
@@ -1970,5 +1971,34 @@ public class TaxonDaoHibernateImpl
         return list;
     }
 
+    /**
+     * {@inheritDoc}
+     */
+    @Override
+    public List<TaxonGraphEdgeDTO> getTaxonGraphEdgeDTOs(UUID fromTaxonUuid, UUID toTaxonUuid, TaxonRelationshipType type,
+            boolean includeUnpublished) {
+
+        Session session = getSession();
+        String hql = "select new eu.etaxonomy.cdm.persistence.dto.TaxonGraphEdgeDTO(fromT.uuid, fromT.titleCache, toT.uuid, toT.titleCache, c.uuid, c.titleCache) "
+                + "FROM TaxonRelationship as tr "
+                + "JOIN tr.relatedTo as toT "
+                + "JOIN tr.relatedFrom as fromT "
+                + "JOIN tr.citation as c "
+                + "WHERE tr.type = :reltype AND toT.uuid = :toTaxonUuid AND fromT.uuid = :fromTaxonUuid";
+
+        if(!includeUnpublished){
+            hql += " AND toT.publish is true AND fromT.publish is true";
+        }
+
+        Query query = session.createQuery(hql);
+        query.setParameter("reltype", type);
+        query.setParameter("fromTaxonUuid", fromTaxonUuid);
+        query.setParameter("toTaxonUuid", toTaxonUuid);
+
+        List<TaxonGraphEdgeDTO> result = query.list();
+
+        return result;
+    }
+
 
 }