[web2py:11450] Re: Transactions and other questions

2008-11-08 Thread Jiff
Arf, I didn't think about this nice nested writng ! BTW this is cool to have stright answers by the creator (and DON'T call me Igor :) JY On 8 nov, 14:12, mdipierro <[EMAIL PROTECTED]> wrote: > yes you can: > > def index(): > try: > db.mytable.insert(myfield='myvalue') >

[web2py:11448] Re: Transactions and other questions

2008-11-08 Thread Jiff
On 8 nov, 07:25, mdipierro <[EMAIL PROTECTED]> wrote: > For example you can have a controller like > > def index(): > db.mytable.insert(myfield='myvalue') > db.commit() > db.mytable.insert(myfield='myothervalue') > db.commit() > return dict() Yeah, that's what I thought

[web2py:11415] Re: Transactions and other questions

2008-11-07 Thread Jiff
On 7 nov, 18:33, mdipierro <[EMAIL PROTECTED]> wrote: > you can do db.commit() to commit before the autocommit Well, the PB it that I don't know exactly when the autocommit takes place!? My concern is about a DB failure while making the many2many "copy": it *must* be complete, and as Murphy's la

[web2py:11378] Transactions and other questions

2008-11-07 Thread Jiff
Used C, but stopped pgming for years... web2pY 1.47 Debian sid very low connection, so please, if poss. cc me also (got a better one at my friend's home) == Hi folks, Is there a manner to temporarily stop the autocommit in order to begin/ commit transactions by my

[web2py:11377] Transaction and shutdown questions

2008-11-07 Thread Jiff
Made lot of C, but stopped pgming for years... web2pY 1.47 Debian sid very low connection, so please, if poss. cc me also (got a better one at my friend's home) == Hi folks, Is there a manner to temporarily stop the autocommit in order to begin/ commit transaction