[Zope] ZODB: Solutions similar to SQL triggers?

Phillip B Oldham phillip.oldham at gmail.com
Fri Sep 12 05:13:20 EDT 2008


On Fri, Sep 12, 2008 at 10:00 AM, Andreas Jung <lists at zopyx.com> wrote:
> --On 12. September 2008 09:25:14 +0100 Phillip B Oldham
> <phillip.oldham at gmail.com> wrote:
>> How would I replicate the benefits of SQL triggers in ZODB?
> No idea what your particular usecase is but the transaction module provides
> support for pre- and post-commit hooks beyond the standard DataManager
> functionality.

Essentially I'm looking to put listeners on certain items which
trigger updates on other items. For instance, in MySQL I would put a
trigger on a InnoDB table on insert, which would then insert the same
data into a number optimised-for-reads MyISAM tables. Another example
would be to cascade deletes through a schema in MySQL (as it doesn't
currently have this feature).

I'm simply wondering whether its possible to put a listener on a
persisted object so that it executes some logic once something
happens.

-- 
Phillip B Oldham
phillip.oldham at gmail.com
+44 (0) 7525 01 09 01


More information about the Zope mailing list