"""Read-only, fail-closed pose-source dependency checks for the mask gallery."""
from contextlib import closing
import hashlib
import json
from pathlib import Path
import sqlite3

from .pose_review_geometry import canonical


def current_pose_source(path,formal_sha256,template):
    path=Path(path).resolve();wal=Path(str(path)+'-wal');journal=Path(str(path)+'-journal')
    def persisted():
        return tuple((p.stat().st_ino,p.stat().st_size,p.stat().st_mtime_ns) if p.exists() else None
            for p in (path,wal,journal))
    before=persisted()
    if not path.is_file() or journal.exists() and journal.stat().st_size:return False
    if wal.exists() and not Path(str(path)+'-shm').exists():return False
    immutable=not wal.exists()
    try:
        with closing(sqlite3.connect(path.as_uri()+'?mode=ro'+('&immutable=1' if immutable else ''),uri=True,timeout=1)) as db:
            db.execute('PRAGMA query_only=ON');db.execute('BEGIN')
            binding=db.execute("SELECT value FROM metadata WHERE key='binding'").fetchone()
            if not binding or json.loads(binding[0])['formal_manifest_sha256']!=formal_sha256:return False
            row=db.execute('SELECT revision,payload FROM annotations WHERE target_key=?',(template['target_key'],)).fetchone()
            if not row or row[0]!=template['snapshot_revision']:return False
            value=json.loads(row[1])
            if value.get('state') in ('deleted','deferred'):return False
            sha=lambda v:hashlib.sha256(canonical(v)).hexdigest()
            if sha(value)!=template['current_payload_sha256']:return False
            provenance=template.get('pose_review',{})
            if provenance and (provenance['target_key']!=template['target_key'] or
                    provenance['revision']!=row[0] or provenance['payload_sha256']!=sha(value) or
                    provenance['polygon_sha256']!=sha(value['polygon'])):return False
            return before==persisted()
    except (OSError,sqlite3.Error,KeyError,TypeError,ValueError):return False
