From a4ea24002bae4e81a2b5a43959fdfe246d60cddb Mon Sep 17 00:00:00 2001
From: Mark Huang <mlhuang@cs.princeton.edu>
Date: Mon, 25 Sep 2006 15:29:03 +0000
Subject: [PATCH] - clean up person_site when deleting sites

---
 PLC/Sites.py | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/PLC/Sites.py b/PLC/Sites.py
index 04372c99..733c7c1e 100644
--- a/PLC/Sites.py
+++ b/PLC/Sites.py
@@ -204,6 +204,12 @@ class Site(Row):
         for node in nodes.values():
             node.delete(commit = False)
 
+        # Clean up miscellaneous join tables
+        for table in ['person_site']:
+            self.api.db.do("DELETE FROM %s" \
+                           " WHERE site_id = %d" % \
+                           (table, self['site_id']), self)
+
         # Mark as deleted
         self['deleted'] = True
         self.sync(commit)
-- 
2.45.2