[Zope] ZODB: Solutions similar to SQL triggers?

[Andreas Jung]

--On 12. September 2008 10:13:20 +0100 Phillip B Oldham 
<phillip.oldham at gmail.com> wrote:

> 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.

Sound as if you want to use the event system of Zope in some way...

-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20080912/2cc39407/attachment.bin