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)