Re: Select for update

[prev] [thread] [next] [Date index for 2004/07/19]

Ian McDonald wrote:
> Hi, I'd like to make some of my units of work (collections of updates
> across multiple tables) atomic, and plan to do this by issuing "select
> ... for update" commands instead of simple selects.

Read <http://www.class-dbi.com/cgi-bin/wiki/index.cgi?AtomicUpdates>;
for the best practice in implementing atomic anything.

> Am I right to think I need to overload private methods or use add_sql
> for this?

You mean set_sql(), right? Anyway, that or add_constructor() as Jason Scott
Gessner suggested in the other response. And wrap it all inside of a
do_transaction() (see the above Wiki page).