#!/usr/bin/env python3
import re, subprocess
t = open("/var/www/wifi-otantik/config.php").read()

def g(k):
    m = re.search(r"\$" + k + r"\s*=\s*['\"]([^'\"]+)", t)
    return m.group(1) if m else ""

sql = "SELECT id,name,slug,lan_host,ip_address FROM tbl_routers WHERE id IN (13,15)"
r = subprocess.run(
    ["mysql", "-h", g("db_host") or "localhost", "-u", g("db_user"), "-p" + g("db_pass"), g("db_name"), "-e", sql],
    capture_output=True, text=True,
)
print(r.stdout)
print(r.stderr.replace(g("db_pass"), "***") if r.returncode else "")
raise SystemExit(r.returncode)