ehiaborsuccess/OutreachAI

1import sqlite32import time3 4try:5    print("Testing DB connection...")6    conn = sqlite3.connect('outreach.db', timeout=5)7    cursor = conn.cursor()8    cursor.execute('SELECT count(*) FROM recruiters')9    print(f"Read success: {cursor.fetchone()[0]} records")10    11    # Try a non-destructive write (update notes of a non-existent ID)12    print("Testing DB write (update)...")13    cursor.execute("UPDATE recruiters SET notes = notes WHERE id = -999")14    conn.commit()15    print("Write success (transaction committed)")16    conn.close()17except Exception as e:18    print(f"DB Error: {e}")19