Python DBI

Links

• http://www.linuxforu.com/teach-me/database-programming-in-python/

DBI

• http://www.oreillynet.com/oracle/os_dir/library.csp

ODBC

• http://www.easysoft.com/developer/languages/python/pyodbc.html

Oracle

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

SAP DB

• http://www.sapdb.org/sapdbapi.html
• http://flabellum.org/7.4/sapdbapi.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()