import sys, os
sys.path.append('E:/genesis-system/data/genesis-memory')
try:
    from elestio_config import PostgresConfig
    import psycopg2
    params = PostgresConfig.get_connection_params()
    print('Connecting to:', params.get('host','?'), params.get('dbname','?'))
    conn = psycopg2.connect(**params)
    cur = conn.cursor()
    cur.execute("SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name")
    tables = [r[0] for r in cur.fetchall()]
    print('TABLES:', tables)
    if 'tradie_leads' in tables:
        cur.execute("SELECT COUNT(*) FROM tradie_leads")
        print('tradie_leads rows:', cur.fetchone()[0])
    conn.close()
    print('DB_OK')
except Exception as e:
    print('DB_ERROR:', type(e).__name__, str(e))