import paramiko
import sys
import os

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

def main():
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(HOST, username=USER, password=PASS)
        
        # Append wordpress if not present
        cmd = """
        if ! grep -q "wordpress" /var/www/html/repondeur_mail_grok/data/spam.csv; then
            echo "wordpress,2026-01-26" | sudo tee -a /var/www/html/repondeur_mail_grok/data/spam.csv
            echo "Wordpress added."
        else
            echo "Wordpress already exists."
        fi
        """
        stdin, stdout, stderr = ssh.exec_command(cmd)
        print(stdout.read().decode())
        
        # Verify
        stdin, stdout, stderr = ssh.exec_command("cat /var/www/html/repondeur_mail_grok/data/spam.csv")
        print("--- CONTENT ---")
        print(stdout.read().decode())
        
        ssh.close()
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    main()