Changeset 5063

Timestamp:

Aug 19, 2009, 1:31:03 PM (13 years ago)

Author:

Nicklas Nordborg

Message:

References #108: Logging the change history of an item

• Added special loggers for data files (FileSetMember?) and plate events

Location:

trunk/src/core

Files:

• common-queries.xml (modified) (1 diff)
• net/sf/basedb/core/data/FileSetMemberData.java (modified) (1 diff)
• net/sf/basedb/core/data/PlateEventData.java (modified) (1 diff)
• net/sf/basedb/core/log/db/DbLogManagerFactory.java (modified) (2 diffs)
• net/sf/basedb/core/log/db/FileSetMemberLogger.java (added)
• net/sf/basedb/core/log/db/PlateEventLogger.java (added)

trunk/src/core/common-queries.xml

@@ -3565 +3565 @@
     </description>
   </query>
+  <query id="DBLOG_GET_DATAFILETYPE_NAME" type="HQL">
+    <sql>
+      SELECT dft.name
+      FROM DataFileTypeData dft
+      WHERE dft.id = :dataFileTypeId
+    </sql>
+    <description>
+      An HQL query that loads the name of a data file type
+      given the ID.
+    </description>
+  </query>
+  <query id="DBLOG_GET_FILESET_ITEMTYPE" type="HQL">
+    <sql>
+      SELECT fs.itemType 
+      FROM FileSetData fs 
+      WHERE fs.id = :fileSetId
+    </sql>
+    <description>
+      An HQL query that loads the item type value a file set
+      set with a given ID belongs to.
+    </description>
+  </query>
+  <query id="DBLOG_GET_ITEMID_WITH_FILESET" type="HQL">
+    <sql>
+      SELECT i.id 
+      FROM {1} i 
+      WHERE i.fileSet = :fileSetId
+    </sql>
+    <description>
+      An HQL query that loads the ID of the item that
+      is associated with a given file set.
+    </description>
+  </query>
+  <query id="DBLOG_GET_PLATEEVENTTYPE_NAME" type="HQL">
+    <sql>
+      SELECT pet.name
+      FROM PlateEventTypeData pet
+      WHERE pet.id = :plateEventTypeId
+    </sql>
+    <description>
+      An HQL query that loads the name of a plate event type
+      given the ID.
+    </description>
+  </query>
 
 </predefined-queries>

trunk/src/core/net/sf/basedb/core/data/FileSetMemberData.java

@@ -36 +36 @@
 public class FileSetMemberData
   extends BasicData
+  implements LoggableData
 {
 

trunk/src/core/net/sf/basedb/core/data/PlateEventData.java

@@ -37 +37 @@
 public class PlateEventData
   extends BasicData
+  implements LoggableData
 {
 

trunk/src/core/net/sf/basedb/core/log/db/DbLogManagerFactory.java

@@ -29 +29 @@
 import net.sf.basedb.core.data.AnnotationData;
 import net.sf.basedb.core.data.BioMaterialEventData;
+import net.sf.basedb.core.data.FileSetMemberData;
 import net.sf.basedb.core.data.LoggableData;
+import net.sf.basedb.core.data.PlateEventData;
 import net.sf.basedb.core.log.EntityLogger;
 import net.sf.basedb.core.log.LogManager;
@@ -58 +60 @@
     setSpecialLogger(BioMaterialEventData.class, new BioMaterialEventLogger(detailedProperties));
     setSpecialLogger(AnnotationData.class, new AnnotationLogger());
+    setSpecialLogger(FileSetMemberData.class, new FileSetMemberLogger());
+    setSpecialLogger(PlateEventData.class, new PlateEventLogger(detailedProperties));
   }