import paramiko
import sys

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)
        
        target_id = "813078"
        cmd = f"grep '^{target_id},' /var/www/html/repondeur_mail_grok/data/queue.csv"
        stdin, stdout, stderr = ssh.exec_command(cmd)
        
        results = stdout.read().decode()
        print(f"--- MATCHING ROWS FOR ID {target_id} ---")
        print(results)
        
        ssh.close()
    except Exception as e:
        print(e)

if __name__ == "__main__":
    main()