#!/bin/bash
# Quick Apify status check — run anytime
# Usage: bash scripts/check_apify.sh

LAST_CYCLE=$(python3 -c "
import sqlite3
conn = sqlite3.connect('data/catalog.db')
r = conn.execute('SELECT id, started_at, groups_scanned, groups_failed, posts_fetched, leads_matched, leads_review, leads_no_match FROM cycle_log ORDER BY id DESC LIMIT 1').fetchone()
if r:
    status = '✓ WORKING' if r[4] > 0 else '✗ STILL 403'
    print(f'Cycle #{r[0]} ({r[1][:16]}): {status}  groups={r[2]}/{r[2]+r[3]} posts={r[4]} 67={r[5]} 68={r[6]} 69={r[7]}')
")
echo "$LAST_CYCLE"