"""Read-only editor upgrade audit preserving every prior raw human event."""
from contextlib import closing
import hashlib
import json
from pathlib import Path
import sqlite3
import sys

PROJECT=Path(__file__).resolve().parents[1];sys.path.insert(0,str(PROJECT));sys.path.insert(0,str(PROJECT/'scripts'))
from pallet.cluster_targets import digest
from pallet.mask_quality_recovery import fingerprint,POSE,GALLERY
from pallet.mask_quota_saved_extension import file_inventory
from pallet.pose_review_geometry import canonical
from pallet.mask_class_keypoint_review import EXTENSION,editable_editor_js
from audit_mask_class_keypoint_reviews import current


def read(path):return json.loads(Path(path).read_text())
def require(value,message):
    if not value:raise ValueError(message)
def db_rows(path):
    with closing(sqlite3.connect(path.resolve().as_uri()+'?mode=ro',uri=True)) as db:
        db.execute('PRAGMA query_only=ON');db.execute('BEGIN')
        return list(db.execute('SELECT id,target_key,revision,payload FROM events ORDER BY id')),dict(db.execute('SELECT target_key,payload FROM reviews')),dict(db.execute('SELECT key,value FROM metadata'))


def preservation():
    before=read(EXTENSION/'private/before.json');root=PROJECT/'outputs/pallet_mask_model_requests_v3'
    require(file_inventory(root)==before['frozen_v3_inventory'],'Frozen initial337 proposals/masks/exports/seals changed')
    require(file_inventory(PROJECT/'configs')==before['configuration_inventory'],'Global/old configurations changed')
    stores=dict(pose=POSE,gallery=GALLERY,isolated=PROJECT/'outputs/pallet_mask_nonconforming_reviews_v1/mask_reviews.sqlite3',
        model_v1=PROJECT/'outputs/pallet_mask_model_reviews_v1/mask_reviews.sqlite3')
    for name,path in stores.items():require(fingerprint(path)==before['source_fingerprints'][name],'Protected human source changed: '+name)
    baseline=EXTENSION/'private/model_reviews_before.sqlite3';snapshot=read(EXTENSION/'private/history_baseline.json')
    require(fingerprint(baseline)==snapshot['snapshot_fingerprint'],'Initial genuine history snapshot changed')
    old_events,old_current,old_meta=db_rows(baseline);events,current_rows,metadata=db_rows(PROJECT/'outputs/pallet_mask_model_reviews_v3/mask_reviews.sqlite3')
    require(events[:len(old_events)]==old_events and metadata==old_meta,'A real historical event/metadata row was changed or removed')
    appended={r[1] for r in events[len(old_events):]}
    for key,raw in old_current.items():
        require(key in current_rows and (key in appended or current_rows[key]==raw),'Prior current human polygon changed without a new append-only event')
    audit=current()
    return dict(initial_real_targets=len(old_current),initial_real_events=len(old_events),current_real_targets=len(current_rows),
        current_real_events=len(events),concurrent_new_real_events=len(events)-len(old_events),
        historical_raw_UTF8_event_prefix_sha256=hashlib.sha256(canonical(old_events)).hexdigest(),
        all_previous_human_history_and_machine_initials_preserved=True,read_only_live_provenance_audit_state=audit['state'])


def main():
    target=EXTENSION/'verification.json';require(not target.exists(),'Do not overwrite a completed editor-upgrade verification')
    manifest=read(EXTENSION/'editor_extension_manifest.json')
    for name,expected in manifest['assets'].items():require(digest(EXTENSION/name)==expected,'Editor public asset changed')
    require((EXTENSION/'editor.js').read_text()==editable_editor_js(),'Deployed JS is not the tested edge-insertion implementation')
    ui=read(EXTENSION/'ui_acceptance/ui_acceptance.json')
    require(ui['state']=='passed_actual_headless_Chromium_isolated_fullflow_not_real_Safari' and ui['production_annotation_writes']==0
        and len(ui['viewports'])==2 and all(v['human_added_point_save_and_reload'] and v['add_delete_vertex']
            and v['initial_machine_proposals_still_exact_class_K'] and v['explicit_point_exports_checked'] for v in ui['viewports']),
        'Real add-point/save/export/reload browser evidence missing')
    kept=preservation()
    result=dict(state='passed_editor_add_point_extension_initial_K_unchanged_and_real_history_preserved',
        policy=manifest['policy'],editor_extension_manifest_sha256=digest(EXTENSION/'editor_extension_manifest.json'),
        initial_worklist_manifest_sha256=manifest['initial_worklist_manifest_sha256'],class_standard_sha256=manifest['class_standard_sha256'],
        ui_acceptance_sha256=digest(EXTENSION/'ui_acceptance/ui_acceptance.json'),
        previous_local_draft_binding_and_auth_namespace_unchanged=True,
        human_save_actual_count_trace_required=True,no_automatic_GT_or_training_promotion=True,
        production_annotation_writes_by_agent=0,history=kept,real_Safari_tested=False,code_sha256=digest(__file__))
    with target.open('xb') as f:f.write(canonical(result)+b'\n')
    print(json.dumps(dict(state=result['state'],history=kept,production_annotation_writes=0)),flush=True)


if __name__=='__main__':main()
