#!/usr/bin/env python3
import paramiko

HOST = "135.125.102.180"
USER = "ubuntu"
PASS = "BotPascal2026!"

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect(HOST, username=USER, password=PASS)

print("📊 Checking current queue status...")
stdin, stdout, stderr = ssh.exec_command("wc -l /var/www/html/repondeur_mail_grok/data/queue.csv")
queue_count = stdout.read().decode().strip()
print(f"Queue: {queue_count}")

print("\n📧 Checking unread emails count from last scan...")
stdin2, stdout2, stderr2 = ssh.exec_command("grep 'nouveaux mails' /var/www/html/repondeur_mail_grok/data/logs/scan.log | tail -3")
unread = stdout2.read().decode()
print(unread if unread else "No unread count found")

print("\n📝 Last scan summary...")
stdin3, stdout3, stderr3 = ssh.exec_command("tail -20 /var/www/html/repondeur_mail_grok/data/logs/scan.log | grep -E '(nouveaux mails|Mail ajouté|Marked UID|SUCCESS|DONE)'")
summary = stdout3.read().decode()
print(summary if summary else "No recent activity")

ssh.close()