cascade delete so that unreferenced keys get deleted

diff --git a/sfa/storage/model.py b/sfa/storage/model.py
index 6da032b..fcbb1ff 100644 (file)
--- a/sfa/storage/model.py
+++ b/sfa/storage/model.py
@@ -220,7 +220,8 @@ class RegUser (RegRecord):
     email               = Column ('email', String)
     # can't use name 'keys' here because when loading from xml we're getting
     # a 'keys' tag, and assigning a list of strings in a reference column like this crashes
-    reg_keys            = relationship ('RegKey', backref='reg_user')
+    reg_keys            = relationship ('RegKey', backref='reg_user',
+                                        cascade="all, delete, delete-orphan")
     
     # so we can use RegUser (email=.., hrn=..) and the like
     def __init__ (self, **kwds):