backend/scripts/check_db.py

import sqlite3, json, os

DB = os.path.join(os.path.dirname(__file__), "..", "sahel.db")
conn = sqlite3.connect(DB)
cursor = conn.execute("SELECT name FROM sqlite_master WHERE type='table'")
tables = [row[0] for row in cursor.fetchall()]
print("Tables:", tables)

if "businesses" in tables:
    cursor = conn.execute("SELECT id, name, slug, social_media FROM businesses")
    rows = cursor.fetchall()
    print(f"Businesses: {len(rows)}")
    for row in rows:
        print(f"  {row[0]}: {row[1]} ({row[2]}) social_media={row[3]}")
conn.close()