PeterHarding at 06:12, 19 July 2009

2009-07-19T06:12:20Z

← Older revision		Revision as of 17:12, 19 July 2009
Line 33:		Line 33:
	[[Category:Python]]		[[Category:Python]]
	[[Category:ODBC]]		[[Category:ODBC]]
			[[Category:Examples]]

PeterHarding: New page:

 #!/usr/bin/env python  import dbi, odbc     # ODBC modules import time          # standard time module  dbc = odbc.odbc(     # open a database connection     'sample/monty/spam'  # '...

2008-05-24T07:06:23Z

New page: <pre> #!/usr/bin/env python import dbi, odbc # ODBC modules import time # standard time module dbc = odbc.odbc( # open a database connection 'sample/monty/spam' # '...

New page

<pre>
#!/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))
</pre>

[[Category:Python]]
[[Category:ODBC]]

Odbc.py - Revision history

PeterHarding at 06:12, 19 July 2009

PeterHarding: New page:
#!/usr/bin/env python import dbi, odbc # ODBC modules import time # standard time module dbc = odbc.odbc( # open a database connection 'sample/monty/spam' # '...