import sqlite3

DB_PATH = 'D:/cnf/chatbot_canifa/preference/common/database/canifa_ai_dump.sqlite'
conn = sqlite3.connect(DB_PATH)
cursor = conn.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
tables = [row[0] for row in cursor.fetchall()]
print('Tables:', tables)
cursor.execute("PRAGMA table_info(sr__test_db__magento_product_dimension_with_text_embedding);")
columns = [row[1] for row in cursor.fetchall()]
print('Columns:', columns)
