consolidator

1
import traceback
2
import sys
3
from MdbHelper import MdbHelper
4
import pyodbc
5

6
path = "D:\\work\\Укрупнение\\current\\pyExcelCons3\\msa\\КПК_все.mdb"
7

8
if __name__=="__main__":
9
    try:
10
        drivers = [i for i in pyodbc.drivers() if i.startswith('Microsoft Access Driver')]
11
        print(drivers)
12
        print("is 64 bit:",sys.maxsize > 2**32)
13

14
        mdb = MdbHelper(path)
15
        print(mdb.connection_str)
16
        mdb.connect()
17
        info = mdb.db_info()
18
        print(f"info: {info}")
19
        df = mdb.get_table_df("Справочник МТР1")
20
        print(df)
21
        mdb.close_connection()
22
    except Exception as exp:
23
       print(traceback.format_exc())