Python-Projekte/db_schema.py

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)