def DSNTables(dsn, user = ""):
logger = OGRBase().logger
odbc = RealPyOdbc.odbc()
odbc.ConnectOdbc(dsn, user)
dsntables = odbc.GeTables()
output = "#" * 60 + "\n#" + " DSN Tables for DSN: \"%s\" \n" % (dsn) + "#" * 60 + "\n"
for table in sorted(dsntables):
output += " - %s\n" % (table[0])
logger.info(output)
def DSNList():
logger = OGRBase().logger
odbc = RealPyOdbc.odbc()
dsnlist = odbc.EnumerateDSN()
output = "#" * 60 + "\n#" + " DSN List \n" + "#" * 60 + "\n"
# Calculate max width of DSN names
maxwidth = max([len(k) for k,v in dsnlist])
spacing = maxwidth + 2
for dsn, driver in dsnlist:
# format output to have a nice looking 2 column layout
output += ("%-" + str(spacing) + "s (%s)\n") % (dsn, driver)
logger.info(output)