Thanks for the tips guys! I saw some listen/notify[1] stuff and it works pretty well on clients (postgresql).
[1] http://news.freshports.org/2006/08/01/python-postgresql-and-listen/ I think I will try to do the listen/notify outside of SQLObject and then fetch the objects using SQLObject. Should work. I was also happy to see support for SELECT FOR UPDATE. nice work! Darren On Mon, 2008-11-17 at 18:21 +0300, Oleg Broytmann wrote: > On Sun, Nov 16, 2008 at 08:08:11PM -0500, Darren Govoni wrote: > > I googled around a bit, but couldn't see if SQLObject (or any Python DB > > API) supports triggers. I want to call some python code when a > > particular database action has occurred > > Triggers, as far as I understand them, are SQL-only things, i.e. they > occur inside the backend and never call back to the application. Hence > Python DB API doesn't support triggers - there is nothing Python can do > about triggers. To declare a trigger the application just needs to issue > a CREATE TRIGGER query - and that's all about it at the Python side. > > Some additional thoughts. PostgreSQL supports asynchronous client > notification using LISTEN/NOTIFY statements, but these statements are > non-standard, and I don't know how well Python DB API drivers for Pg > support notifications. > You can write triggers in Python on the server-side using plpython > Postgres plugin, but this is server-side, and has nothing with DB API. > > Oleg. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
