Checkpoint

svn path=/scripts/rpki/sql.py; revision=932

1 files changed, 12 insertions, 0 deletions

diff --git a/scripts/rpki/sql.py b/scripts/rpki/sql.py
index 9762f9ea..785caa38 100644
--- a/scripts/rpki/sql.py
+++ b/scripts/rpki/sql.py
@@ -77,3 +77,15 @@ class sql_persistant(object):
     for kids in self.sql_children.values():
       for kid in getattr(self, kids):
         kid.sql_store(db, cur)
+
+  def sql_delete(self, db, cur=None):
+    """Delete an object and its descendants from SQL.
+    """
+    if cur is None:
+      cur = db.cursor()
+    if self.sql_in_db:
+      cur.execute(self.sql_delete_cmd % self.sql_makedict())
+      self.sql_in_db = False
+    for kids in self.sql_children.values():
+      for kid in getattr(self, kids):
+        kid.sql_store(db, cur)