ehiaborsuccess/OutreachAI

1import sqlite32import time3import os4 5db_path = "outreach.db"6 7def get_count():8    conn = sqlite3.connect(db_path)9    cursor = conn.cursor()10    cursor.execute('SELECT count(*) FROM recruiters;')11    count = cursor.fetchone()[0]12    cursor.execute('SELECT count(*) FROM recruiters WHERE status = "Not Contacted";')13    new = cursor.fetchone()[0]14    conn.close()15    return count, new16 17print("Monitoring database for 5 minutes...")18initial, _ = get_count()19print(f"Initial Total: {initial}")20 21for i in range(10):22    time.sleep(30)23    total, new = get_count()24    if total > initial or new > 0:25        print(f"[{time.strftime('%H:%M:%S')}] New leads found! Total: {total}, New: {new}")26        break27    else:28        print(f"[{time.strftime('%H:%M:%S')}] Still searching... Total: {total}")29 30print("Monitoring session finished.")31