Changeset 8295 for mauRepo/MolesManager/trunk/src/MolesManager/moles3epb.py

Timestamp:

02/05/12 11:54:02 (9 years ago)

Author:

mnagni

Message:

added a method on moles3epb to retrieve a CEDA_Observation author

File:

• mauRepo/MolesManager/trunk/src/MolesManager/moles3epb.py (modified) (2 diffs)

mauRepo/MolesManager/trunk/src/MolesManager/moles3epb.py

@@ -16 +16 @@
 from sqlalchemy.orm import mapper
 from MolesManager.ceda_guid import CedaGUID
+from ea_model.moles3_4.utilities.mo_responsiblepartyinfo import MO_ResponsiblePartyInfo
+from ea_model.moles3_4.utilities.mo_rolevalue import MO_RoleValue
 
 
@@ -110 +112 @@
         intSession = Moles3EPB._getSession(session)
         return intSession.query(CEDA_ObservationCollection, CEDA_Observation).filter(CEDA_ObservationCollection.id==obs_coll_id).filter(CEDA_Observation.id==obs_id).count() > 0
+
+    @classmethod
+    def observationAuthor(self, obs_id, session = None):
+        """
+            Lists the CEDA_Observation author.
+            @param obs_id: the CEDA_Observation id            
+            @return: True if the collection contains the given observation, False otherwise  
+        """
+        intSession = Moles3EPB._getSession(session)
+        ret = intSession.query(MO_ResponsiblePartyInfo).join(MO_Observation). \
+            filter(MO_ResponsiblePartyInfo.role == MO_RoleValue.cl_author). \
+            filter(MO_Observation.id == obs_id)
+        return ret
 
     @classmethod