"""One fresh catalog over a byte-verified immutable V6 baseline."""
import hashlib,json,sqlite3
from common import encoded,need
import build_public_name_directory as helpers
class Catalog:
 def __init__(self,path,readonly=False):
  from common import db_ro
  from pathlib import Path
  self.db=db_ro(path) if readonly else sqlite3.connect(Path(path).resolve().as_uri()+'?mode=rwc',uri=True)
  if not readonly:self.db.executescript('PRAGMA journal_mode=DELETE;PRAGMA synchronous=FULL;PRAGMA cache_size=-32768;PRAGMA mmap_size=0;')
 def event(self,key,form,data,rank):
  self.db.execute('INSERT INTO names(key,name,base_json,priority) VALUES(?,?,NULL,?) ON CONFLICT(key) DO UPDATE SET name=excluded.name,priority=excluded.priority WHERE names.base_json IS NULL AND excluded.priority<names.priority',(key,form,rank))
  for literal in data.get('forms',[form]):self.db.execute('INSERT OR IGNORE INTO forms VALUES(?,?)',(key,literal))
  self.db.execute('INSERT OR IGNORE INTO roles VALUES(?,?)',(key,data['role']))
  self.db.execute('INSERT OR IGNORE INTO source_roles VALUES(?,?,?)',(key,data['source_id'],data['role']))
  self.db.execute('INSERT OR IGNORE INTO events(key,source_id,data,event_sha,unit_rank) VALUES(?,?,?,?,?)',
   (key,data['source_id'],encoded(data).decode().rstrip('\n'),hashlib.sha256(encoded({'key':key,'event':data})).hexdigest(),rank))
 def records(self):
  for key,name,retained in self.db.execute('SELECT key,name,base_json FROM names ORDER BY key'):
   row=json.loads(retained) if retained else {'key':key,'name':name,'source_id':None,'source_category':'public_source_attestations','evidence_status':'source_attested','corroborated_roles':[],'role_warnings':[],'language':None,'written_script':helpers.written_script(name),'primary_locators':[],'corroboration':[]}
   row['forms']=[r[0] for r in self.db.execute('SELECT form FROM forms WHERE key=? ORDER BY form',(key,))]
   row['roles']=[r[0] for r in self.db.execute('SELECT role FROM roles WHERE key=? ORDER BY role',(key,))]
   events=[json.loads(r[0]) for r in self.db.execute('SELECT data FROM events WHERE key=? ORDER BY unit_rank,seq',(key,))]
   if events:row['attestations']=events
   source_roles={}
   for source,role in self.db.execute('SELECT source_id,role FROM source_roles WHERE key=? ORDER BY source_id,role',(key,)):source_roles.setdefault(source,[]).append(role)
   row['source_role_difference']=len({tuple(v) for v in source_roles.values()})>1
   yield row
 def close(self):self.db.close()
