Creating a connection
According to PEP 249, the connection to a database should be established using a
connect() constructor, which returns a
Connection object. The arguments for this constructor are database dependent. Refer to the database specific topics for the relevant arguments.
import MyDBAPI con = MyDBAPI.connect(*database_dependent_args)
This connection object has four methods:
Closes the connection instantly. Note that the connection is automatically closed if the
Connection.__del___ method is called. Any pending transactions will implicitely be rolled back.
Commits any pending transaction the to database.
Rolls back to the start of any pending transaction. In other words: this cancels any non-committed transaction to the database.
cur = con.cursor()
Cursor object. This is used to do transactions on the database.