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)
        
        # Execute sender.php on the VPS
        print("🚀 Démarrage de l'envoi du message en attente...")
        cmd = f"cd {REMOTE_BASE} && php scripts/sender.php"
        stdin, stdout, stderr = ssh.exec_command(cmd)
        
        output = stdout.read().decode()
        error = stderr.read().decode()
        
        if output:
            print("\n📤 OUTPUT:")
            print(output)
        
        if error:
            print("\n⚠️ ERRORS/WARNINGS:")
            print(error)
        
        # Check logs
        print("\n📋 Vérification des logs...")
        stdin, stdout, stderr = ssh.exec_command(f"tail -n 20 {REMOTE_BASE}/data/logs/sender.log")
        logs = stdout.read().decode()
        if logs:
            print("Derniers logs:")
            print(logs)
        
        # Check archives to confirm sending
        print("\n✅ Vérification des archives...")
        stdin, stdout, stderr = ssh.exec_command(f"tail -n 5 {REMOTE_BASE}/data/archives.csv")
        archives = stdout.read().decode()
        if archives:
            print("Derniers messages envoyés:")
            print(archives)
        
        ssh.close()
        print("\n✅ Traitement terminé.")
        
    except Exception as e:
        print(f"❌ Error: {e}")

if __name__ == "__main__":
    main()