"""Read-only class-count conflict inventory; never choose a majority as ontology."""
from collections import Counter,defaultdict
from contextlib import closing
import json
from pathlib import Path
import sqlite3
import sys

PROJECT=Path(__file__).resolve().parents[1];sys.path.insert(0,str(PROJECT))
from pallet.cluster_targets import digest
from pallet.pose_review_geometry import canonical
from pallet.mask_quality_recovery import fingerprint,POSE,GALLERY

ROOT=PROJECT/'outputs/pallet_mask_model_requests_v1';OUT=PROJECT/'outputs/pallet_mask_model_keypoint_alignment_v1'


def rows(path):return [json.loads(s) for s in path.read_text().splitlines() if s.strip()]


def main():
    destination=OUT/'class_count_audit.json'
    if destination.exists():raise ValueError('Preserve the original correction audit')
    source=PROJECT/'outputs/pallet_mask_continuation_sources_v16/private/source_catalog.jsonl'
    catalog=rows(source);training=rows(PROJECT/'outputs/pallet_mask_annotation_full_v1/private/training_records.jsonl')
    index={r['target_key']:r for r in training};inputs=json.loads((ROOT/'input_manifest.json').read_text())
    nc=PROJECT/'outputs/pallet_mask_nonconforming_reviews_v1/mask_reviews.sqlite3'
    with closing(sqlite3.connect(nc.resolve().as_uri()+'?mode=ro',uri=True)) as db:
        isolated=[json.loads(raw) for raw, in db.execute('SELECT payload FROM reviews')]
    observed=defaultdict(Counter)
    for r in catalog:observed[r['row']['final_class_id']][len(r['polygon'])]+=1
    for r in isolated:observed[index[r['target_key']]['class_id']][len(r['polygon'])]+=1
    proposals=rows(ROOT/'proposals.jsonl');drafts=defaultdict(Counter);mismatches=[]
    for p in proposals:
        drafts[p['class_id']][len(p['polygon'])]+=1
        if len(p['polygon']) not in observed[p['class_id']]:mismatches.append(p['target_key'])
    model_db=PROJECT/'outputs/pallet_mask_model_reviews_v1/mask_reviews.sqlite3'
    with closing(sqlite3.connect(model_db.resolve().as_uri()+'?mode=ro',uri=True)) as db:
        saved=db.execute('SELECT count(*) FROM reviews').fetchone()[0];events=db.execute('SELECT count(*) FROM events').fetchone()[0]
    current=dict(pose=fingerprint(POSE),gallery=fingerprint(GALLERY),isolated=fingerprint(nc))
    if current!=inputs['source_fingerprints']:raise ValueError('Source changed; refresh the correction inventory without modifying old snapshots')
    receipt=dict(state='dense_draft_delivery_withdrawn_pending_authoritative_class_keypoint_counts',
        request_count=588,all_existing_drafts_inconsistent_with_observed_class_counts=len(mismatches),mismatched_target_keys=mismatches,
        current_manual_reference_total=sum(sum(d.values()) for d in observed.values()),
        classes={c:dict(observed_human_vertex_counts=dict(sorted(observed[c].items())),machine_draft_vertex_counts=dict(sorted(drafts[c].items())),
            all_observed_counts_agree=len(observed[c])==1,authoritative_count_confirmed=False) for c in range(1,23)},
        ambiguous_class_ids=[c for c in range(1,23) if len(observed[c])>1],
        unique_observation_class_ids=[c for c in range(1,23) if len(observed[c])==1],
        user_authorized_class_count_map=None,majority_voting_used=False,automatic_resampling_or_keypoint_invention=False,
        requirement='Each new draft must use the user-confirmed class keypoint count and corresponding ordered physical corners; reject unknown or incompatible structure.',
        authoritative_22class_map_found_in_existing_config=False,current_review_targets=saved,current_review_events=events,
        saved_human_records_or_frozen_data_modified=False,source_fingerprints=current,
        preserved=dict(manifest_sha256=digest(ROOT/'manifest.json'),proposals_sha256=digest(ROOT/'proposals.jsonl'),
            raw_predictions_sha256=digest(ROOT/'private/predictions.jsonl'),human_source_catalog_sha256=digest(source),model_store_fingerprint=fingerprint(model_db)),
        new_model_trained=False,old_models_or_GT_modified=False,code_sha256=digest(__file__))
    OUT.mkdir(exist_ok=True)
    with destination.open('xb') as stream:stream.write(canonical(receipt)+b'\n')
    print(json.dumps(dict(state=receipt['state'],drafts_inconsistent=len(mismatches),ambiguous_classes=receipt['ambiguous_class_ids'],
        saved_human_records=saved,events=events,user_confirmation_needed=True)))


if __name__=='__main__':main()
