#!/usr/bin/env python3
import os, sys
import mysql.connector
from pathlib import Path

def load_php_db():
    cfg = Path("/var/www/wifi-otantik/config.php").read_text(errors="replace")
    kv = {}
    for line in cfg.splitlines():
        for key in ("db_host", "db_name", "db_user", "db_pass"):
            if f"${key}" in line and "=" in line:
                kv[key] = line.split("=", 1)[1].strip().strip(";").strip().strip("'").strip('"')
    return kv

kv = load_php_db()
cn = mysql.connector.connect(
    host=kv.get("db_host") or "localhost",
    user=kv["db_user"],
    password=kv["db_pass"],
    database=kv["db_name"],
)
cur = cn.cursor()
for t in sys.argv[1:]:
    print("====", t)
    cur.execute("SHOW COLUMNS FROM `%s`" % t.replace("`", ""))
    for r in cur.fetchall():
        print("\t".join("" if x is None else str(x) for x in r))
    print()
cur.close()
cn.close()