import paramiko

c = paramiko.SSHClient()
c.set_missing_host_key_policy(paramiko.AutoAddPolicy())
c.connect('140.44.4.11', username='root', key_filename=r'C:\Users\Snarf\.ssh\id_ed25519_snarfnet', timeout=10)

def run(cmd):
    _, o, e = c.exec_command(cmd)
    out = o.read().decode().strip()
    err = e.read().decode().strip()
    return out + ("\nERR: " + err if err else "")

pod = "uptime-kuma-2-1756668961-7cbccffbbb-mbb64"
print(f"=== Querying Pod: {pod} ===")
print("Query MariaDB monitor count:")
print(run(f"kubectl exec -n monitoring {pod} -- mariadb -u root --socket=/app/data/run/mariadb.sock -e 'USE kuma; SELECT count(*) FROM monitor;'"))

print("Query all monitors:")
print(run(f"kubectl exec -n monitoring {pod} -- mariadb -u root --socket=/app/data/run/mariadb.sock -e 'USE kuma; SELECT id, name, type, active FROM monitor;'"))

print("\nFiles in /app/data:")
print(run(f"kubectl exec -n monitoring {pod} -- ls -la /app/data"))

c.close()