import sqlite3
from datetime import datetime, timedelta

def check_fred_status():
    conn = sqlite3.connect('/Eden/DATA/sales.db')
    
    # FIXED QUERY: We explicitly ask for 'created_at' so the date math works
    query = "SELECT created_at FROM outreach_queue WHERE subject LIKE '%Bend-PVM%' ORDER BY id DESC LIMIT 1"
    
    try:
        row = conn.execute(query).fetchone()
        if not row:
            print("❌ No record found for Fred yet.")
            return

        sent_time = datetime.fromisoformat(row[0])
        elapsed = datetime.now() - sent_time
        
        print(f"✅ Last message to Fred sent: {row[0]}")
        print(f"⏳ Time elapsed: {elapsed}")
        
        if elapsed > timedelta(hours=48):
            print("🚨 ALERT: 48 hours passed. Pivot to 'Contract Upgradability' pitch!")
        else:
            print("💤 Still within the 48-hour wait window. Patience.")
            
    except Exception as e:
        print(f"Error: {e}")
    finally:
        conn.close()

if __name__ == "__main__":
    check_fred_status()