Re: [gnome-db] trigger

[Vivien Malerba <vmalerba gmail com>]

On 2 June 2010 11:35, Andrea Zagli <azagli libero it> wrote:
> i would like to realize on my applications, based on libgda, something
> similar to trigger
>
> is there some function/signal to make it possible? for example 2 signals
> named "before-non-select-execution" and "after-non-select-execution" on
> GdaConnection

The GdaConnection object does not emit any signal before or after
having executed a statement, but this could easily be added, and now
is the correct timeframe for this as the next stable version is not
far away...
Please tell me exactly what you need and I'll see how to implement it.

>
> i don't want to use dbms triggers, because i want that my applications are
> really multi-dabatase

Beware of the impact on transactions with this approach: you'll
probably have to start a transaction for each statement you want to
execute to make sure the statements you execute in your "pseudo
trigger" is executed in a single atomic way...

Regards,

Vivien