Odbc.py
Revision as of 17:12, 19 July 2009 by PeterHarding (talk | contribs)
#!/usr/bin/env python import dbi, odbc # ODBC modules import time # standard time module dbc = odbc.odbc( # open a database connection 'sample/monty/spam' # 'datasource/user/password' ) crsr = dbc.cursor() # create a cursor crsr.execute( # execute some SQL """ SELECT country_id, name, insert_change_date FROM country ORDER BY name """ ) print 'Column descriptions:' # show column descriptions for col in crsr.description: print ' ', col result = crsr.fetchall() # fetch the results all at once print '\nFirst result row:\n ', result[0] # show first result row print '\nDate conversions:' # play with dbiDate object date = result[0][-1] fmt = ' %-25s%-20s' print fmt % ('standard string:', str(date)) print fmt % ('seconds since epoch:', float(date)) timeTuple = time.localtime(date) print fmt % ('time tuple:', timeTuple) print fmt % ('user defined:', time.strftime('%d %B %Y', timeTuple))