Changeset 5403

Timestamp:

Sep 6, 2010, 12:44:50 PM (12 years ago)

Author:

Martin Svensson

Message:

Fixes #1507. Burp trying to empty trashcan.

Location:

trunk/src/core

Files:

• common-queries.xml (modified) (1 diff)
• net/sf/basedb/core/Group.java (modified) (2 diffs)

trunk/src/core/common-queries.xml

@@ -3860 +3860 @@
     </description>
   </query>
+  
+  <query id="SET_GROUP_TO_NULL_ON_DISK_USAGE" type="HQL">
+    <sql>
+      UPDATE DiskUsageData du
+        SET du.group = null
+        WHERE du.group = :group
+    </sql>
+    <description>
+      An HQL update-query that sets group to null on all 
+      diskusage that are associated with a given group.
+    </description>
+  </query>
 
 </predefined-queries>

trunk/src/core/net/sf/basedb/core/Group.java

@@ -24 +24 @@
 package net.sf.basedb.core;
 
+import net.sf.basedb.core.Transactional.Action;
 import net.sf.basedb.core.data.GroupData;
 import net.sf.basedb.core.hibernate.TypeWrapper;
@@ -248 +249 @@
     -------------------------------------------
   */
+  /**
+    Set group to null in disk usage 
+    where this group is referenced.
+  */
+  @Override
+  void onBeforeCommit(Action action)
+  {
+    super.onBeforeCommit(action);
+    
+    if (action == Transactional.Action.DELETE)
+    {
+      org.hibernate.Query query = HibernateUtil.getPredefinedQuery(
+          getDbControl().getHibernateSession(), "SET_GROUP_TO_NULL_ON_DISK_USAGE");
+      /*
+        UPDATE [DiskUsage]
+        SET [group] = null
+        WHERE [group] = :group
+      */
+      query.setInteger("group", getId());
+      HibernateUtil.executeUpdate(query);     
+    }
+  }
   /**
     Checks if: