#!/usr/bin/env python3
import paramiko, json

c = paramiko.SSHClient()
c.set_missing_host_key_policy(paramiko.AutoAddPolicy())
c.connect("10.10.0.10", username="localadministrator", password="Bbt9115xty9176!", timeout=20, allow_agent=False, look_for_keys=False)

_, o, e = c.exec_command(
    "docker exec coolify-db psql -U coolify -d coolify -t -A -c "
    "\"SELECT logs FROM application_deployment_queues WHERE id=1120;\"",
    timeout=120,
)
o.channel.recv_exit_status()
raw = (o.read() + e.read()).decode(errors="replace")
# find build errors
for needle in ["Failed to compile", "Type error", "ERROR:", "error TS", "not assignable"]:
    idx = raw.rfind(needle)
    if idx >= 0:
        print(raw[idx:idx+2500])
        print("\n---\n")
c.close()