"""Derive a database-free request package while preserving private staging evidence."""
from pathlib import Path
import shutil
import sys

PROJECT=Path(__file__).resolve().parents[1];sys.path.insert(0,str(PROJECT))
from pallet.cluster_targets import digest
from pallet.mask_template_transfer import write_json
from pallet.mask_template_refined import read_jsonl


def main():
    source=PROJECT/'outputs/pallet_mask_remaining_requests_v1'
    root=PROJECT/'outputs/pallet_mask_remaining_requests_v2'
    if root.exists():raise ValueError('Preserve existing derived task package')
    if not (source/'manifest.json').exists():raise ValueError('Finish and seal staged tasks first')
    root.mkdir()
    for path in source.rglob('*'):
        relative=path.relative_to(source)
        if 'backups' in relative.parts or path.suffix in ('.db','.sqlite','.sqlite3') or path.name.endswith(('-wal','-shm','-journal')):
            continue
        if path.is_file():
            target=root/relative;target.parent.mkdir(parents=True,exist_ok=True);shutil.copyfile(path,target)
    if any(p.suffix in ('.db','.sqlite','.sqlite3') for p in root.rglob('*')):
        raise ValueError('Private database leaked into derived worklist')
    requests=read_jsonl(root/'requests.jsonl')
    write_json(root/'private_staging_provenance.json',dict(private_staging_directory=str(source.relative_to(PROJECT)),
        manifest_sha256=digest(source/'manifest.json'),copied_manifest_byte_identical=digest(root/'manifest.json')==digest(source/'manifest.json'),
        staging_pose_snapshot_sha256=digest(source/'reviews_snapshot.sqlite3'),
        staging_gallery_snapshot_sha256=digest(source/'gallery_reviews_snapshot.sqlite3'),
        source_audit_directory='outputs/pallet_mask_remaining_classes_v1',request_count=len(requests),
        private_databases_omitted=True,original_staging_not_deleted=True,production_database_writes=0))
    print(f'Prepared {len(requests)} database-free manual tasks for independent verification; private staging retained',flush=True)


if __name__=='__main__':main()
