From: Dave Rolsky <autarch@ur...> - 2005-03-15 12:10:39
On Mon, 14 Mar 2005, Bertrand wrote:
> What is the proper Alzabo method to something such as:
> delete * from table WHERE DATE_SUB(CURDATE(),INTERVAL 21 DAY) <= date_col;
Unfortunately, there's no support in Alzabo for delete or update across a
table, which is lame. This has been on the todo list for a long time, but
it's made much more difficult by the referential integrity features Alzabo
supports. I've been thinking of dropping the latter now that MySQL's
InnoDB is quite stable. The only hitch is that for some dumb reason it
doesn't implement ON DELETE SET DEFAULT.
Anyway, you can always just run straight SQL by getting the DBI handle via
If you're using Alzabo::Runtime::UniqueRowCache, you should probably call
Alzabo::Runtime::UniqueRowCache->clear_table($table_object) after updating
or deleting from a given table.
Your guide to all that's veg. My book blog
Get latest updates about Open Source Projects, Conferences and News.