
    a;j
                     
   d dl Z d dlZd dlZd dlZd dlZd dlZdZdZdZ e j                  dez   dz   d      Z
e j                  e
_        e
j                  d	      j                         Z ej                    ej"                  eD  cg c]  } | d    | d
   | d   | d   f c} d      j%                               j'                         Zg ZdD ]  Zej.                  j1                  e      s  ej2                  e      D ]  \  ZZZeD cg c]	  }|dvs| c}edd eD ]  Zej=                  d      sej.                  j?                  ee      Z  e!e dd      jE                         jG                         Z$ e%e$d
      D ]S  \  Z&Z' ejP                  de'      s ejP                  de'      r.ejS                  e e&e'jU                         dd d       U     e+ ej"                  i dej                  jY                  ejZ                  j\                        j_                         ded ej                    e!ed      jE                               j'                         dej.                  ja                  e      de
j                  d      jc                         d    d e2e      d ed!e
j                  d"      jc                         d    d#e
j                  d$      jc                         d    d%e
j                  d&      jc                         d    d' e3e
j                  d(      j                               d) e3e
j                  d*      j                               d+ e3e
j                  d,      j                               d-e
j                  d.      jc                         d    d/e
j                  d0      jc                         d    d1 e3e
j                  d2      j                               d3 e3e
j                  d4      j                               ej.                  j1                  e      ej.                  j1                  e      r5 ej                    e!ed      jE                               j'                         ndej.                  j1                  e      ej.                  j1                  e      r e4 ejj                  e            dd5 ng edd6 d7d8d9             e
jm                          yc c} w c c}w #  Y xY w):    Nz+/opt/struktur/youtube-research/knowledge.dbzK/opt/struktur/reports/aa043-p34-r2/20260828T072700Z/AA-043-P34-R2-writer.pyz%/opt/struktur/knowledge-unit-pipelinezfile:z?mode=ro&immutable=1T)urizpragma foreign_key_check         )	sort_keys)z'/home/hermes/.hermes/profiles/hermesvpsz/home/hermes/.hermes)cachelogssessions__pycache__)z.yamlz.ymlz.jsonz.tomlzutf-8ignore)encodingerrorsz!(?i)(^|[\s_])model(_name)?\s*[:=]z#(?i)(api_key|token|secret|password)   )pathlinevalue
checked_atdb	db_sha256rbdb_size	integrityzpragma integrity_checkfk_countfk_fingerprintku_totalz$select count(*) from knowledge_unitslegacyz?select count(*) from knowledge_units where legacy_placeholder=1pilot_sourceszVselect count(distinct source_identity) from knowledge_units where legacy_placeholder=0reviewzGselect review_state,count(*) from knowledge_units group by review_stateevidencezKselect evidence_class,count(*) from knowledge_units group by evidence_classgoldzCselect gold_state,count(*) from knowledge_units group by gold_stateprovz.select count(*) from knowledge_unit_provenancereview_auditz0select count(*) from knowledge_unit_review_auditqueue_statuszSselect graphiti_status,count(*) from graphiti_import_queue group by graphiti_statusreleasezUselect graphiti_release,count(*) from graphiti_import_queue group by graphiti_release2   d   )writer_report_existswriter_report_sha256target_dir_existstarget_dir_entriesmodelsF)ensure_asciiindent)7sqlite3hashlibjsonosdatetimereDBWTARGETconnectcRowrow_factoryexecutefetchallvsha256dumpsencode	hexdigestfpr+   rootr   existswalkbasedsfsfendswithjoinpopenread
splitlineslines	enumerateilsearchappendstripprintnowtimezoneutc	isoformatgetsizefetchonelendictsortedlistdirclose)rds   00$/opt/struktur/AA-043-P35-baseline.py<module>rf      s   * * *0  5B!  Kr  DJ'//'"*33=W[[q}))&'002~w~~jdjjqrQslmSTUVSWXYZ[X\]^_`]abcdebfRgQs  C  GD  GK  GK  GM  8N  8X  8X  8ZB	N 
rD
th2774= rZT"RMq!#LLM"Q% rajj12ggll4AAwh7<<>IIKq! r!		6q9)"))LrstBuw}  xE  xE  NO  WX  ab  ah  ah  aj  ko  lo  ap  Fq  xrrrr
r jdjj  p,x0044X5F5F5J5JKUUW  pX\]_  p`klzlslzlz{  AC  DH  |I  |N  |N  |P  mQ  m[  m[  m]  p  ^g  hj  ho  ho  hw  hw  xz  h{  p  |G  HI  HQ  HQ  Rj  Hk  Ht  Ht  Hv  wx  Hy  p  zD  EH  IJ  EK  p  L\  ]_  p  `j  kl  kt  kt  u[  k\  ke  ke  kg  hi  kj  p  ks  tu  t}  t}  ~  t@  tI  tI  tK  LM  tN  p  O^  _`  _h  _h  iA	  _B	  _K	  _K	  _M	  N	O	  _P	  p  Q	Y	  Z	^	  _	`	  _	h	  _	h	  i	r
  _	s
  _	|
  _	|
  _	~
  Z	
  p  @J  KO  PQ  PY  PY  Zg  Ph  Pq  Pq  Ps  Kt  p  u{  |@  AB  AJ  AJ  KP  AQ  AZ  AZ  A\  |]  p  ^d  ef  en  en  o_  e`  ei  ei  ek  lm  en  p  o}  ~  ~G  ~G  Hz  ~{  ~D  ~D  ~F  GH  ~I  p  JX  Y]  ^_  ^g  ^g  h}  ^~  ^G  ^G  ^I  YJ  p  KT  UY  Z[  Zc  Zc  d{  Z|  ZE  ZE  ZG  UH  p  `b  `g  `g  `n  `n  op  `q  |~  |C  |C  |J  |J  KL  |M  IW  IP  IW  IW  X\  ]^  _c  Xd  Xi  Xi  Xk  Il  Iv  Iv  Ix  SW  ln  ls  ls  lz  lz  {A  lB  {}  {B  {B  {I  {I  JP  {Q  X^  _i  _a  _i  _i  jp  _q  Xr  sv  tv  Xw  WY  ci  jn  kn  co  p  ~C  KL  M  N  PQ  PW  PW  PY Rt
 	N
 Hs   S:	S?S?'TT		