| 123456789101112131415161718192021222324252627282930 |
- import pyodbc
- import json
- c = pyodbc.connect("DSN=Autoline_direkt64;UID=kcc;PWD=kcc123")
- crsr = c.cursor()
- # table_name = [x[2] for x in crsr.tables(tableType='TABLE')]
- # open("tables.txt", "w").write("\n".join(table_name))
- with open("tables.txt", "r") as rh:
- tables = rh.readlines()
- res = {}
- def convert_desc(x):
- x = list(map(str, x))
- # x[1] = str(x[1])
- return ", ".join(x)
- for t in tables:
- try:
- crsr.execute("SELECT * FROM " + t)
- res[t[:-1]] = [convert_desc(x) for x in crsr.description]
- crsr.cancel()
- except pyodbc.Error:
- res[t[:-1]] = []
- # print(res)
- json.dump(res, open("schema.json", "w"), indent=2)
|
