#!/usr/bin/env python3
"""Close Batch 395 after explicit five-lens review."""
from __future__ import annotations
import datetime as dt,json,sqlite3
from close_394 import TARGETS
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-395";NOW=dt.datetime.now(dt.timezone.utc).replace(microsecond=0).isoformat().replace("+00:00","Z");LOG="process_logs/batch-395-complementary-corrected-bird-set-e-nonsingular-past-perception-after-rule352-process.md";LENSES=("morphology","lexicon","syntax","fidelity","register")
NOTES="COMPLEMENTARY CORRECTED BIRD SET-E NON-SINGULAR PAST PERCEPTION AFTER RULE 352 (Rule 353). 50 accepted; exact complements; full grid complete; Patz/corrected boundaries retained; gap 162->172."
LESSONS=[("source","Corrected cards, zero-Patz bird profile and Patz pronouns remained exact.","Rule353 source."),("process","All candidates absent and opposites exactly Batch394.","Rule353 map."),("process","Full non-singular 100-cell grid complete.","Rule353 completion."),("process","Gap162->172 because lower-gap inverse is duplicate.","Rule353 balance."),("process","Superseded Rule350 heads remain excluded.","Rule353 reject.")]+[("lexicon",f"{h} remains {g}; {n}.",f"Rule353 {h}.") for h,g,n in TARGETS]+[("morphology","Targets remain bare O.","Rule353 O."),("morphology","Whole heads remain nonproductive.","Rule353 heads."),("morphology","Pronouns remain bare A with clusivity explicit.","Rule353 A."),("morphology","Locals and nyajin remain fixed.","Rule353 support."),("syntax","Rows1-10 Ngali...yinyay.","Rule353 band1."),("syntax","Rows11-20 Ngaliny...yaluy.","Rule353 band2."),("syntax","Rows21-30 Yubal...yinyay.","Rule353 band3."),("syntax","Rows31-40 Yurra...yaluy.","Rule353 band4."),("syntax","Rows41-50 Nganjin...yinyay.","Rule353 band5."),("fidelity","English preserves number/clusivity,label,location,past seeing only.","Rule353 fidelity."),("fidelity","No cultural/property/source/event content.","Rule353 exclusions."),("register","Neutral elicitation register.","Rule353 register."),("process","AST proves 50 literal calls.","Rule353 authorship."),("process","Exact readback/lint/dup/integrity gate close.","Rule353 gates."),("process","Five lenses store 250 decisions.","Rule353 review."),("process","35 lessons/18 logs persist.","Rule353 storage."),("process","Export/books/live refresh.","Rule353 publish."),("process","Artifacts remain mounted.","Rule353 mounted."),("handoff","Rule354 requires a fresh linter-clean lexical set.","Rule353 handoff."),("handoff","Do not reuse any completed set-E cell.","Rule353 no-reuse.")]
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)!=(19847,19797,134547):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-395: {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-395-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; complement/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,"Rule353 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)!=(19847,134747,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_395.py",artifact_path=LOG,created_at=NOW);db.commit();print(f"closed batch-395: {before}->{after}");return 0
if __name__=="__main__":raise SystemExit(main())
