From: Андрей Костенко [mailto:[email protected]] Sent: Monday, May 18, 2009 11:38 AM To: DBIx::Class user and developer list Subject: Re: [Dbix-class] Increment MySQL field
It is bad. If my program have more than one thread: first thread: SELECT balance FROM somewhere ( returns 150 ) second thread (which works at the same time): SELECT balance FROM somewhere ( returns 150 ) first thread: UPDATE something SET balance=250; second thread: UPDATE something SET balance=250; So wrap it in a transaction? -Byron On Mon, May 18, 2009 at 10:28 PM, Byron Young <[email protected]> wrote: Ben Vinnerd wrote on 2009-05-15: > Hey, > > I have the following SQL to increment a field by 100: > > update account set balance = balance + 100 > > I can increment a field with DBIC, like so: > > $account->update({balance => \'balance + 100'}); > > Is there a better/cleaner way of doing this in DBIC? > > Cheers, > > Ben Ben, how about this? $account->update({balance => $account->balance + 100}); -Byron
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
