Python DBI

Links

Oracle

• Oracle Wiki
• cx_Oracle download from Sourceforge
• http://www.oracle.com/technology/pub/articles/prez-python-queries.html

Exmples

#!/usr/bin/env python

import dbi

dbh = dbi.connect("DBI:mysql:database=mydatabase", "myysername",
                  RaiseError = 1,
                  PrintError = 0,
                  AutoCommit = 1,
                 )

try:
    dbh["AutoCommit"] = 0
except:
    print "Can't turn off AutoCommit"

sth = dbh.prepare("select * from foo limit 5")
sth.execute()

while 1:
        row = sth.fetchrow_tuple()
        if not row: break
        print row

dbh.disconnect()