import re
import subprocess
import sys

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 ""


host = g("db_host") or "localhost"
user = g("db_user")
pw = g("db_pass")
name = g("db_name")
sql = sys.argv[1] if len(sys.argv) > 1 else "SELECT id,name,slug,owner_id,ip_address FROM tbl_routers"
r = subprocess.run(
    ["mysql", "-h", host, "-u", user, f"-p{pw}", name, "-N", "-e", sql],
    capture_output=True,
    text=True,
)
sys.stdout.write(r.stdout)
if r.returncode:
    sys.stderr.write(re.sub(re.escape(pw), "***", r.stderr))
sys.exit(r.returncode)