import paramiko
import os

HOST = "135.125.102.180"
USER = "ubuntu"
PASS = "BotPascal2026!"
REMOTE_BASE = "/var/www/html/repondeur_mail_grok"
LOCAL_FILE = "scripts/debug_api_orders.php"

def main():
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(HOST, username=USER, password=PASS)
        sftp = ssh.open_sftp()
        
        local_path = f"/home/dan/Documents🤮/🔴2026🔴/🔴----ROBOT-WHATSAPP-MARCHE-GroK----🔴/✍️ REPONDEUR_MAIL_GROK/{LOCAL_FILE}"
        remote_tmp = "/tmp/debug_api_orders.php"
        remote_dest = f"{REMOTE_BASE}/{LOCAL_FILE}"
        
        print(f"📤 Uploading {LOCAL_FILE}...")
        sftp.put(local_path, remote_tmp)
        
        cmd = f"echo '{PASS}' | sudo -S mv {remote_tmp} {remote_dest}"
        ssh.exec_command(cmd)
        
        print("🚀 Executing debug API orders...")
        stdin, stdout, stderr = ssh.exec_command(f"php {remote_dest}")
        print(stdout.read().decode())
        err = stderr.read().decode()
        if err:
             print(f"STDERR: {err}")
             
        ssh.close()
    except Exception as e:
        print(f"❌ Error: {e}")

if __name__ == "__main__":
    main()