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)
        
        # Clear send_queue.csv (keep only header)
        clear_cmd = f'echo "id,email,subject,date_received,tag_zimbra,grok_response,status,shop_id,client_id" | sudo tee {REMOTE_BASE}/data/send_queue.csv > /dev/null'
        
        print("🗑️ Vidage de la file d'envoi...")
        stdin, stdout, stderr = ssh.exec_command(clear_cmd)
        stdout.read()  # Wait for completion
        
        # Verify
        print("\n✅ Vérification...")
        stdin, stdout, stderr = ssh.exec_command(f"cat {REMOTE_BASE}/data/send_queue.csv")
        content = stdout.read().decode()
        
        lines = content.strip().split('\n')
        print(f"Contenu actuel de send_queue.csv ({len(lines)} ligne(s)):")
        print(content)
        
        if len(lines) == 1:
            print("\n✅ File d'envoi vidée avec succès!")
        else:
            print(f"\n⚠️ Il reste {len(lines)-1} message(s) dans la file")
        
        ssh.close()
        
    except Exception as e:
        print(f"❌ Error: {e}")

if __name__ == "__main__":
    main()