package main

import (
	"database/sql"
	"encoding/json"
	"fmt"
	"os"

	_ "github.com/jackc/pgx/v5/stdlib"
)

const dsn = "postgres://artex:agI8ahDs28HJn1nUbq11pPS3@127.0.0.1:5432/artex?sslmode=disable"

func main() {
	doInsert := len(os.Args) > 1 && os.Args[1] == "insert"
	db, err := sql.Open("pgx", dsn)
	if err != nil {
		panic(err)
	}
	defer db.Close()

	var kind, state, origin string
	var priority int
	var payload []byte
	var expID int64
	err = db.QueryRow(`SELECT exploration_id, kind, state, origin, priority, payload FROM exploration_nodes WHERE id=$1`, 166).
		Scan(&expID, &kind, &state, &origin, &priority, &payload)
	if err != nil {
		panic(fmt.Sprintf("intent 166 lookup: %v", err))
	}
	fmt.Printf("INTENT 166: expID=%d kind=%s state=%s origin=%s priority=%d\n", expID, kind, state, origin, priority)
	fmt.Printf("  payload=%s\n", string(payload))

	// mirror origin/priority from an existing fact (165)
	var fOrigin, fState string
	var fPrio int
	_ = db.QueryRow(`SELECT origin, state, priority FROM exploration_nodes WHERE id=165`).Scan(&fOrigin, &fState, &fPrio)
	fmt.Printf("FACT 165: origin=%s state=%s priority=%d\n", fOrigin, fState, fPrio)

	// existing yields edges for reference
	rows, err := db.Query(`SELECT src_id, rel, dst_id FROM exploration_edges WHERE dst_id=165 OR src_id=166 LIMIT 10`)
	if err == nil {
		for rows.Next() {
			var s, r string
			var d int64
			rows.Scan(&s, &r, &d)
			fmt.Printf("EDGE: %s --%s--> %d\n", s, r, d)
		}
		rows.Close()
	}

	if !doInsert {
		fmt.Println("(introspection only)")
		return
	}

	factPayload := map[string]any{
		"summary":    "运营方 Authentik SSO(112.199.81.2:37443)隐藏本地用户名+密码登录链弱口令爆破已全量穷尽：48 用户名 × 149 口令 = 7152 次尝试全部完成(5956s, ~1.2 attempts/s)，0 命中、未取得 SSO 会话；唯一异常是一次 502 泄露后端经 unix socket /dev/shm/authentik-core.sock 连接 authentik-core。",
		"detail":     "接续 #148/#165。复用 fact#165 证实的限速特性(每流实例 4 次失败即 ak-stage-access-denied，按 authentik_session cookie 轮换即可无限重置、非按 IP)，实现每流 GET→POST uid_field→连续 4 次 POST password 的会话轮换爆破；命中判定=响应出现 302/Location 或非 ak-stage-password/identification 的组件。用户名 48 个(akadmin/phitdc/phit/admin/administrator/root/itadmin/… 及 @hqstech.com/@reachvpn.com 邮箱变体)，口令 149 个(phit*/PHITDC*/PHIDC*/PAM360*/xiao9*/fansky*/msjshy*/hqstech*/reachvpn*/itportal*/authentik* 企业组合 + 常见弱口令/默认口令)。执行并发 3-4、实测 ~1.2 attempts/s，跑满 7152/7152：7151 次 ak-stage-password 'Invalid password'，1 次 502，未触发账号锁定(印证按 cookie 限速、无全局/按IP锁定)。残余判断：Authentik 对存在/不存在用户统一返回 'Invalid password'(不可枚举)，故无法确认这些用户名中哪些真实存在本地口令；不排除 (a) 本地登录链下无任何用户设置可用口令(全部走 hqstech OAuth)，或 (b) 命中口令不在 149 词库内。副产物线索：502 错误页泄露后端经 unix socket /dev/shm/authentik-core.sock 连接 authentik-core；限速按 cookie 而非 IP 意味着若未来拿到任意有效用户名可无限速爆破。",
		"evidence":   "brute_progress.log 末行 '[progress] chunks=1824/1824 attempts=7152/7152 int=1 err=0 thr=0 rate=1.20/s elapsed=5956s'; brute_stdout.log '[DONE attempts=7152/7152 int=1 err=0 thr=0 elapsed=5956s]'; brute_results.txt 7151 条 'fail' + interesting.txt 1 条 502",
		"confidence": "observed",
	}
	raw, _ := json.Marshal(factPayload)

	tx, err := db.Begin()
	if err != nil {
		panic(err)
	}
	defer tx.Rollback()
	useOrigin := fOrigin
	if useOrigin == "" {
		useOrigin = origin
	}
	var newID int64
	if err := tx.QueryRow(`INSERT INTO exploration_nodes(exploration_id, kind, payload, priority, state, origin) VALUES ($1,'fact',$2,5,'confirmed',$3) RETURNING id`,
		expID, string(raw), useOrigin).Scan(&newID); err != nil {
		panic(fmt.Sprintf("insert fact: %v", err))
	}
	fmt.Printf("INSERTED fact id=%d origin=%s\n", newID, useOrigin)
	for _, a := range []int64{667, 668} {
		if _, err := tx.Exec(`INSERT INTO exploration_anchors(node_id, asset_id) VALUES ($1,$2) ON CONFLICT DO NOTHING`, newID, a); err != nil {
			panic(fmt.Sprintf("anchor %d: %v", a, err))
		}
	}
	if _, err := tx.Exec(`INSERT INTO exploration_edges(exploration_id, src_id, rel, dst_id) VALUES ($1,166,'yields',$2) ON CONFLICT (exploration_id, src_id, rel, dst_id) DO NOTHING`, expID, newID); err != nil {
		panic(fmt.Sprintf("link: %v", err))
	}
	if err := tx.Commit(); err != nil {
		panic(err)
	}
	fmt.Printf("LINKED 166 --yields--> %d ; anchors 667,668\n", newID)
}
