[DB-SIG] When must transactions begin?

2010-09-20 Thread Randall Nortman
PEP 249 says that transactions end on commit() or rollback(), but it doesn't explicitly state when transactions should begin, and there is no begin() method. I think the implication is that transactions begin on the first execute(), but that's not explicitly stated. At least one driver, pysqlite2

Re: [DB-SIG] When must transactions begin?

2010-09-20 Thread M.-A. Lemburg
Randall Nortman wrote: > PEP 249 says that transactions end on commit() or rollback(), but it > doesn't explicitly state when transactions should begin, and there is > no begin() method. Transactions start implicitly after you connect and after you call .commit() or .rollback(). They are not st

Re: [DB-SIG] When must transactions begin?

2010-09-20 Thread Andy Dustman
On Mon, Sep 20, 2010 at 12:49 PM, M.-A. Lemburg wrote: > > > Randall Nortman wrote: >> PEP 249 says that transactions end on commit() or rollback(), but it >> doesn't explicitly state when transactions should begin, and there is >> no begin() method. > > Transactions start implicitly after you con

Re: [DB-SIG] When must transactions begin?

2010-09-20 Thread M.-A. Lemburg
Andy Dustman wrote: > On Mon, Sep 20, 2010 at 12:49 PM, M.-A. Lemburg wrote: >> >> >> Randall Nortman wrote: >>> PEP 249 says that transactions end on commit() or rollback(), but it >>> doesn't explicitly state when transactions should begin, and there is >>> no begin() method. >> >> Transactions