annator-full-system / scripts /utils /check_schema.py
github-actions
Sync from ATOM master 2026-08-17T19:34:18Z
81e8bb6
Raw History Blame Contribute Delete
519 Bytes
import sqlite3
import os
# Assuming default dev DB
db_path = "backend/atom_dev.db"
if not os.path.exists(db_path):
# Try alternate location if widely used
db_path = "atom_dev.db"
print(f"Checking DB: {db_path}")
try:
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute("PRAGMA table_info(users)")
columns = cursor.fetchall()
print("Columns in 'users' table:")
for col in columns:
print(col)
conn.close()
except Exception as e:
print(f"Error: {e}")