# -*- coding: utf-8 -*-
"""原创离线合成样例；不连接模型、不读取账户。输出位于脚本旁。
已有输入保留，修改输入后可以重跑。失败边界由 --negative 单独演示。
"""
from pathlib import Path
import sys, json, csv, math, io, hashlib, html, base64, re
sys.stdout.reconfigure(encoding='utf-8')
sys.stderr.reconfigure(encoding='utf-8')
BASE = Path(__file__).resolve().parent
NEG = '--negative' in sys.argv
def write(name, value):
    p=BASE/name; p.parent.mkdir(parents=True,exist_ok=True)
    if isinstance(value,bytes): p.write_bytes(value)
    else: p.write_text(value,encoding='utf-8',newline='')
def seed(name,value):
    if not (BASE/name).exists(): write(name,value)
def jwrite(name,value): write(name,json.dumps(value,ensure_ascii=False,indent=2))
def jseed(name,value):
    if not (BASE/name).exists(): jwrite(name,value)
def load(name): return json.loads((BASE/name).read_text(encoding='utf-8'))
def table(name,heads,rows):
    f=io.StringIO(newline='');w=csv.writer(f);w.writerow(heads);w.writerows(rows);write(name,f.getvalue())
def page(name,title,body):
    write(name,'<!doctype html><html lang="zh-CN"><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>'+html.escape(title)+'</title><style>body{max-width:1000px;margin:2rem auto;padding:0 1rem;font:17px/1.7 system-ui}table{border-collapse:collapse}td,th{border:1px solid #aaa;padding:.5rem}pre{white-space:pre-wrap;overflow-wrap:anywhere}img,svg{max-width:100%;height:auto}a{color:#125caa}</style><h1>'+html.escape(title)+'</h1>'+body+'</html>')
def emit(data): print(json.dumps(data,ensure_ascii=False))

import sqlite3
seed('fts-corpus.sql',"CREATE VIRTUAL TABLE docs USING fts5(doc_id UNINDEXED, body);\nINSERT INTO docs VALUES ('one','alpha OR beta');\nINSERT INTO docs VALUES ('two','alpha only');\nINSERT INTO docs VALUES ('three','beta alone');\n")
db=sqlite3.connect(':memory:');db.executescript((BASE/'fts-corpus.sql').read_text(encoding='utf-8'))
phrase='alpha OR beta';literal='"'+phrase.replace('"','""')+'"'
if NEG: db.execute('SELECT doc_id FROM docs WHERE docs MATCH ?',('"unclosed',)).fetchall()
out={}
for label,query in [('literal',literal),('wide','alpha OR beta'),('quote_literal','"'+('alpha "OR" beta').replace('"','""')+'"')]:
    out[label]=db.execute("SELECT doc_id, snippet(docs,1,'[',']','...',20) FROM docs WHERE docs MATCH ?",(query,)).fetchall()
jwrite('queries.json',out);emit(out)