On Fri, Sep 12, 2008 at 10:00 AM, Andreas Jung <lists@zopyx.com> wrote:
--On 12. September 2008 09:25:14 +0100 Phillip B Oldham <phillip.oldham@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@gmail.com +44 (0) 7525 01 09 01