From 11228bd33c8b53585d983445af28425e98dcf3f4 Mon Sep 17 00:00:00 2001 From: Tony Mack Date: Mon, 28 Dec 2009 15:52:31 +0000 Subject: [PATCH] when removing a site make sure to remove all records at the site --- sfa/util/genitable.py | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/sfa/util/genitable.py b/sfa/util/genitable.py index 80a4ddab..bf436bcd 100644 --- a/sfa/util/genitable.py +++ b/sfa/util/genitable.py @@ -92,8 +92,16 @@ class GeniTable(list): self.cnx.query(index) def remove(self, record): - query_str = "DELETE FROM %s WHERE record_id = %s" % (self.tablename, record['record_id']) + query_str = "DELETE FROM %s WHERE record_id = %s" % \ + (self.tablename, record['record_id']) self.cnx.query(query_str) + + # if this is a site, remove all records where 'authority' == the + # site's hrn + if record['type'] == 'site': + sql = " DELETE FROM %s WHERE authority = %s" % \ + (self.tablename, record['hrn']) + self.cnx.query(sql) def insert(self, record): db_fields = self.db_fields(record) -- 2.43.0