From: Thierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Date: Mon, 6 Feb 2012 11:00:19 +0000 (+0100)
Subject: cascade delete so that unreferenced keys get deleted
X-Git-Tag: sfa-2.1-2~7
X-Git-Url: http://git.onelab.eu/?p=sfa.git;a=commitdiff_plain;h=efb0c26f0afec8a3e3b7abc5560c6defb1bd5355

cascade delete so that unreferenced keys get deleted
---

diff --git a/sfa/storage/model.py b/sfa/storage/model.py
index 6da032b9..fcbb1ff1 100644
--- 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):