#!/usr/bin/env python3
"""Close Batch 394 after explicit five-lens review."""
from __future__ import annotations
import datetime as dt,json,sqlite3
from process_ledger import ensure_schema,record_event
DB="/mnt/donto-data/donto-resources/research/translation-training/kuku-yalanji-runpod-2026-06-30/synthetic/claude-synthetic-v1-2026-07-02/synthetic.db";LABEL="batch-394";NOW=dt.datetime.now(dt.timezone.utc).replace(microsecond=0).isoformat().replace("+00:00","Z");LOG="process_logs/batch-394-corrected-bird-set-e-nonsingular-past-perception-after-rule351-process.md";LENSES=("morphology","lexicon","syntax","fidelity","register")
NOTES="CORRECTED BIRD SET-E NON-SINGULAR PAST PERCEPTION AFTER RULE 351 (Rule 352). 50 accepted; 100 cells empty; Patz clusivity and corrected head boundaries retained; gap 172->162."
TARGETS=[("dakwurr-dakwun","hammer bird","totem closed"),("kurkunbay","butcherbird","alternate/call closed"),("kurrujuwa","sentry bird","warning/totem closed"),("mirrku","kidney bird","anatomy/totem closed"),("baringkan","small bird","taxonomy closed"),("barinkan","scrub bird","color closed"),("bilu-warra","spoonbill","whole head"),("dukunjulu","golden whistler","song/color closed"),("jiwurrmal","pheasant cuckoo","alternate closed"),("kujuway","pigeon","color closed")]
LESSONS=[("source","Corrected cards and zero-Patz profile remained exact.","Rule352 source."),("source","Patz controls non-singular number and clusivity over dictionary defect.","Rule352 pronouns."),("source","Ngana remains grammatical but deferred at 1115 uses.","Rule352 ngana."),("process","All 100 non-singular cells were empty.","Rule352 matrix."),("process","Three-here/two-there changes gap 172->162.","Rule352 balance.")]+[("lexicon",f"{h} remains {g}; {n}.",f"Rule352 {h}.") for h,g,n in TARGETS]+[("morphology","Targets remain bare absolutive O.","Rule352 O."),("morphology","Lexical whole-head spelling remains nonproductive.","Rule352 heads."),("morphology","Selected pronouns remain bare nominative A.","Rule352 A."),("morphology","Yaluy/yinyay/nyajin remain fixed.","Rule352 support."),("syntax","Rows 1-10 use Ngali...yaluy.","Rule352 band1."),("syntax","Rows 11-20 use Ngaliny...yinyay.","Rule352 band2."),("syntax","Rows 21-30 use Yubal...yaluy.","Rule352 band3."),("syntax","Rows 31-40 use Yurra...yinyay.","Rule352 band4."),("syntax","Rows 41-50 use Nganjin...yaluy.","Rule352 band5."),("fidelity","English preserves number/clusivity, bird label, location and past seeing only.","Rule352 fidelity."),("fidelity","No cultural/property/source/event proposition enters.","Rule352 exclusions."),("register","Rows remain neutral elicitation clauses.","Rule352 register."),("process","AST proves 50 literal calls.","Rule352 authorship."),("process","Exact readback, lint, duplicates and integrity gate close.","Rule352 gates."),("process","Five lenses store 250 decisions.","Rule352 review."),("process","Thirty-five lessons and eighteen logs persist.","Rule352 storage."),("process","Export/books/render/live follow close.","Rule352 publish."),("handoff","Rule353 requires exact complement audit.","Rule352 handoff."),("handoff","Rejected Rule350 drafts remain excluded.","Rule352 reject." )]
LESSONS.append(("process","Source, review, export and live artifacts remain on mounted research storage.","Rule352 mounted."))
LEX=TARGETS+[("ngali","first dual exclusive nominative","Patz bare A"),("ngaliny","first dual inclusive nominative","Patz bare A"),("yubal","second dual nominative","bare A"),("yurra","second plural nominative","bare A"),("nganjin","first plural exclusive nominative","bare A"),("yaluy","here","Yalanji local"),("yinyay","there","Yalanji local"),("nyajin","see; see.PST","past surface")]
def main():
 if len(LESSONS)!=35 or len(LEX)!=18:raise SystemExit(f"inventory {len(LESSONS)}/{len(LEX)}")
 db=sqlite3.connect(DB);db.execute("PRAGMA foreign_keys=ON");db.execute("BEGIN");ensure_schema(db);r=db.execute("SELECT id FROM batches WHERE label=?",(LABEL,)).fetchone()
 if not r:raise SystemExit("not banked")
 bid=r[0];c=db.execute("SELECT COUNT(*),COUNT(*) FILTER(WHERE status='under_review') FROM sentences WHERE batch_id=?",(bid,)).fetchone();total=db.execute("SELECT COUNT(*) FROM sentences WHERE status!='rejected'").fetchone()[0];before,wb=db.execute("SELECT COUNT(*),SUM(LENGTH(kuku)-LENGTH(REPLACE(kuku,' ',''))+1) FROM sentences WHERE status IN('accepted','revised')").fetchone()
 if c!=(50,50) or (total,before,wb)!=(19797,19747,134347):raise SystemExit(f"pre {c}/{total}/{before}/{wb}")
 ids=[x[0] for x in db.execute("SELECT id FROM sentences WHERE batch_id=? ORDER BY seq",(bid,))];db.executemany("INSERT INTO reviews(sentence_id,round,lens,verdict,issues,suggested_fix,reviewer,created_at) VALUES(?,?,?,?,?,?,?,?)",[(sid,1,l,"pass",None,None,"codex-main-five-lens",NOW) for sid in ids for l in LENSES]);db.executemany("INSERT INTO lessons(batch_id,category,lesson,guide_change,created_at) VALUES(?,?,?,?,?)",[(bid,c,l,g,NOW) for c,l,g in LESSONS])
 for h,g,n in LEX:
  p="pronoun" if h in {"ngali","ngaliny","yubal","yurra","nganjin"} else "demonstrative" if h in {"yaluy","yinyay"} else "verb-tr" if h=="nyajin" else "noun";conj="l" if h=="nyajin" else None;s=json.dumps([{"sense":g,"definition":n,"status":"attested"}],ensure_ascii=False);a=json.dumps([{"source":LABEL,"ref":"five-lens close","quote":n}],ensure_ascii=False);note=f"batch-394: {n}"
  db.execute("""INSERT INTO lexemes(headword,phonemic,pos,conj_class,case_class,gloss,senses,attestation,allomorphy,morphology,collocations,usage_notes,antonyms_contrasts,corpus_freq,status,verified_at,notes) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(headword) DO UPDATE SET verified_at=excluded.verified_at,status=excluded.status,notes=CASE WHEN lexemes.notes IS NULL OR lexemes.notes='' THEN excluded.notes WHEN instr(lexemes.notes,?)>0 THEN lexemes.notes ELSE lexemes.notes||'; '||excluded.notes END""",(h,None,p,conj,"NA",g,s,a,None,None,None,n,None,0,"verified",NOW,note,LABEL));db.execute("INSERT INTO lexeme_log(headword,action,detail,created_at) VALUES(?,?,?,?)",(h,"batch-394-verify",n,NOW))
 for ph,et,d in [("lint","under-review-lint-green",f"Lint {total}/0; verified {before}."),("review","five-lens-pass","250/250 passed; clusivity/corrected heads retained."),("review","review-detail","No cultural/property/source/event drift."),("review","lesson-inventory","35 lessons."),("review","lexeme-source-log","18 logs.")]:record_event(db,batch_label=LABEL,phase=ph,event_type=et,actor="codex",detail=d,artifact_path=LOG,created_at=NOW)
 db.execute("UPDATE sentences SET status='accepted',updated_at=? WHERE batch_id=?",(NOW,bid));db.execute("UPDATE batches SET notes=?,cheatsheet_version=?,guide_version=? WHERE id=?",(NOTES,"Rule352 accepted","operator-guide-2026-07-10",bid));after,wa=db.execute("SELECT COUNT(*),SUM(LENGTH(kuku)-LENGTH(REPLACE(kuku,' ',''))+1) FROM sentences WHERE status IN('accepted','revised')").fetchone();rv=db.execute("SELECT COUNT(*) FROM reviews WHERE sentence_id IN(SELECT id FROM sentences WHERE batch_id=?)",(bid,)).fetchone()[0]
 if (after,wa,rv)!=(19797,134547,250):raise SystemExit(f"post {after}/{wa}/{rv}")
 record_event(db,batch_label=LABEL,phase="close",event_type="close-success",actor="codex",detail=f"accepted=50 reviews=250 lessons=35 logs=18 verified {before}->{after} words {wb}->{wa}.",command="python3 batch_scripts/close_394.py",artifact_path=LOG,created_at=NOW);db.commit();print(f"closed batch-394: {before}->{after}");return 0
if __name__=="__main__":raise SystemExit(main())
