launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

On Mon, May 2, 2011 at 1:32 PM, Robert Collins
<robertc@xxxxxxxxxxxxxxxxx> wrote:
> On Mon, May 2, 2011 at 6:24 PM, Stuart Bishop
> <stuart.bishop@xxxxxxxxxxxxx> wrote:
>> StructuralSubscription is referenced by BugSubscriptionFilter.
>> BugSubscriptionFilter is referenced by BugNotificationFilter and 4 subtables.
>> BugNotificationFilter is referenced by BugNotification
>> BugNotification is referenced by Bug and Message
>>
>> Far too much fallout with all that cascading delete.
>>
>> I think we need to pull this patch until we can make the cleanup more
>> intelligent.
>
> So when a SS goes,
>  - the filter should go
>  - the 4 subtables with filter details should go
>  - bugnotification contains pending not yet sent emails; they can go
>  - the message and bug that the notification is for Must Not go
>
> That seems doable with cascade delete ?

its easier - in my coffee lacking state, I reversed a relationship.
BugNotificationFilter is not referenced by BugNotification, so we just
need to cascade the BugSubscriptionFilter, the BugNotificationFilter
and the 4 subtables already cascade. Preparing a patch now.




-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/