Thread: [SQLObject] How to create update trigger with sqlobject?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Matthew W. <ma...@tp...> - 2006-11-16 01:28:03
|
I want to add a modified_date column to my table that updates automatically when a row is updated. How do I do this using sqlobject? Matt -- A better way of running series of SAS programs: http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles |
From: Oleg B. <ph...@ph...> - 2006-11-16 06:54:54
|
On Thu, Nov 16, 2006 at 01:27:39AM +0000, Matthew Wilson wrote: > I want to add a modified_date column to my table that updates > automatically when a row is updated. > > How do I do this using sqlobject? SQLObject cannot do that. Worse, if you do this via connection.query("CREATE TRIGGER...") you have to find a way to draw the updated value back to SQLObject's cache. You can set cacheValues=False but then every access to any column will be resulted in a separate SELECT. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: sophana <so...@zi...> - 2006-11-16 08:52:28
|
Oleg Broytmann a =E9crit : > On Thu, Nov 16, 2006 at 01:27:39AM +0000, Matthew Wilson wrote: > =20 >> I want to add a modified_date column to my table that updates >> automatically when a row is updated. >> >> How do I do this using sqlobject? >> =20 > > SQLObject cannot do that. Worse, if you do this via > connection.query("CREATE TRIGGER...") > you have to find a way to draw the updated value back to SQLObject's > cache. You can set cacheValues=3DFalse but then every access to any col= umn > will be resulted in a separate SELECT. > > Oleg. > =20 If your database is accessed only through sqlobject, it would be much simpler to implement some method that would be called at each update. This would simply set the modify date in the row. |
From: Jason C. <jc...@xe...> - 2006-11-17 22:33:31
Attachments:
signature.asc
|
On Thu, 16 Nov 2006 01:27:39 +0000 (UTC) Matthew Wilson <ma...@tp...> wrote: > I want to add a modified_date column to my table that updates > automatically when a row is updated. >=20 > How do I do this using sqlobject? >=20 > Matt >=20 I did something like this with 0.8dev. http://xentac.net/~jchu/blog/technology/sqlobject-event-fu.html Now that I think of it, it's not really being used, but we still have it. Jason |