db_print.py

Sample

The only smart program in the folder. By default, this does the same thing as db_print_simple.py. However, it also looks for command line arguments. Type help to see the options.

If you use table_name=? it will print a list of the tables in the .mdb.

filename=X lets you open a different .mdb.

Note

This sample uses the database \adodbapi\examples\test.mdb

""" db_print.py -- a simple demo for ADO database reads."""

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()