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)
    return o.read().decode().strip()

print("=== Uptime Kuma Pods ===")
print(run("kubectl get pods -n monitoring -o wide"))

print("\n=== Uptime Kuma Deployment & Volumes ===")
print(run("kubectl get deployment -n monitoring uptime-kuma-2-1756668961 -o yaml | grep -A 10 volumes"))

pod = run("kubectl get pod -n monitoring -l app.kubernetes.io/name=uptime-kuma-2-1756668961 -o jsonpath='{.items[0].metadata.name}'")
print(f"\n=== Current Pod: {pod} ===")

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

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

c.close()