68 lines
2.2 KiB
Python
68 lines
2.2 KiB
Python
|
""" db_print.py -- a simple demo for ADO database reads."""
|
||
|
|
from __future__ import with_statement #needed for Python 2.5
|
||
|
|
|
||
|
|
import sys
|
||
|
|
import adodbapi.ado_consts as adc
|
||
|
|
|
||
|
|
cmd_args = ('filename', 'table_name')
|
||
|
|
if 'help' in sys.argv:
|
||
|
|
print(('possible settings keywords are:',cmd_args))
|
||
|
|
sys.exit()
|
||
|
|
|
||
|
|
kw_args = {} # pick up filename and proxy address from command line (optionally)
|
||
|
|
for arg in sys.argv:
|
||
|
|
s = arg.split("=")
|
||
|
|
if len(s) > 1:
|
||
|
|
if s[0] in cmd_args:
|
||
|
|
kw_args[s[0]] = s[1]
|
||
|
|
|
||
|
|
kw_args.setdefault('filename', "test.mdb") # assumes server is running from examples folder
|
||
|
|
kw_args.setdefault('table_name', 'Products') # the name of the demo table
|
||
|
|
|
||
|
|
# the server needs to select the provider based on his Python installation
|
||
|
|
provider_switch = ['provider', 'Microsoft.ACE.OLEDB.12.0', "Microsoft.Jet.OLEDB.4.0"]
|
||
|
|
|
||
|
|
# ------------------------ START HERE -------------------------------------
|
||
|
|
#create the connection
|
||
|
|
constr = "Provider=%(provider)s;Data Source=%(filename)s"
|
||
|
|
import adodbapi as db
|
||
|
|
con = db.connect(constr, kw_args, macro_is64bit=provider_switch)
|
||
|
|
|
||
|
|
if kw_args['table_name'] == '?':
|
||
|
|
print('The tables in your database are:')
|
||
|
|
for name in con.get_table_names():
|
||
|
|
print(name)
|
||
|
|
else:
|
||
|
|
#make a cursor on the connection
|
||
|
|
with con.cursor() as c:
|
||
|
|
|
||
|
|
#run an SQL statement on the cursor
|
||
|
|
sql = 'select * from %s' % kw_args['table_name']
|
||
|
|
print(('performing query="%s"' % sql))
|
||
|
|
c.execute(sql)
|
||
|
|
|
||
|
|
#check the results
|
||
|
|
print(('result rowcount shows as= %d. (Note: -1 means "not known")' \
|
||
|
|
% (c.rowcount,)))
|
||
|
|
print('')
|
||
|
|
print('result data description is:')
|
||
|
|
print(' NAME Type DispSize IntrnlSz Prec Scale Null?')
|
||
|
|
for d in c.description:
|
||
|
|
print((('%16s %-12s %8s %8d %4d %5d %s') % \
|
||
|
|
(d[0], adc.adTypeNames[d[1]], d[2], d[3], d[4],d[5], bool(d[6]))))
|
||
|
|
print('')
|
||
|
|
print('str() of first five records are...')
|
||
|
|
|
||
|
|
#get the results
|
||
|
|
db = c.fetchmany(5)
|
||
|
|
|
||
|
|
#print them
|
||
|
|
for rec in db:
|
||
|
|
print(rec)
|
||
|
|
|
||
|
|
print('')
|
||
|
|
print('repr() of next row is...')
|
||
|
|
print((repr(c.fetchone())))
|
||
|
|
print('')
|
||
|
|
con.close()
|