How to start a transaction?

[Hussein B]

Hey,
I know the basics of interacting with databases in Python.
How to start a transaction in case I want to group a couple of insert
and update statements into a single operation?
Thanks.

 

[Diez B. Roggisch]

Hey,
I know the basics of interacting with databases in Python.
How to start a transaction in case I want to group a couple of insert
and update statements into a single operation?

Please read the python database API documentation:

http://www.python.org/dev/peps/pep-0249/

And make sure your database supports transactions.

Diez

 

[M.-A. Lemburg]

Hey,
I know the basics of interacting with databases in Python.
How to start a transaction in case I want to group a couple of insert
and update statements into a single operation?

If you use a Python DB-API compatible database module, then
transactions are enabled per default after you connect to the
database. connection.commit() and .rollback() then complete a
transaction and implicitly start a new one.

--
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source (#1, Jan 20 2009)________________________________________________________________________

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::


eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
http://www.egenix.com/company/contact/