import paramiko

HOST = "135.125.102.180"
USER = "ubuntu"
PASS = "BotPascal2026!"
REMOTE_BASE = "/var/www/html/repondeur_mail_grok"

def main():
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(HOST, username=USER, password=PASS)
        
        # Check sender log
        print("📋 Logs du sender (dernières 30 lignes):")
        print("="*60)
        stdin, stdout, stderr = ssh.exec_command(f"tail -n 30 {REMOTE_BASE}/data/logs/sender.log 2>/dev/null || echo 'Fichier sender.log non trouvé'")
        print(stdout.read().decode())
        
        # Check app log from today
        print("\n📋 Logs de l'application (aujourd'hui):")
        print("="*60)
        today = "2026-01-26"
        stdin, stdout, stderr = ssh.exec_command(f"tail -n 30 {REMOTE_BASE}/data/logs/app_{today}.log 2>/dev/null || echo 'Fichier app log non trouvé'")
        print(stdout.read().decode())
        
        # Check if send_queue is now empty
        print("\n📝 État actuel de send_queue.csv:")
        print("="*60)
        stdin, stdout, stderr = ssh.exec_command(f"cat {REMOTE_BASE}/data/send_queue.csv")
        queue = stdout.read().decode()
        lines = queue.strip().split('\n')
        print(f"Nombre de lignes: {len(lines)}")
        print(queue)
        
        ssh.close()
        
    except Exception as e:
        print(f"❌ Error: {e}")

if __name__ == "__main__":
    main()