
    j                        d dl Z d dlZd dlZg dZg dZg ZeD ]  Z e j                  dez   dz   d      Z e	d ej                  d	      D              Zej                  eej                  j                  e       eej                  d
      j!                               ej                  d      j#                         d     ee      eD  cg c]	  } | ev s|  c} ej                  d      j#                         d    ej                  d      j#                         d    d       ej%                            e ej(                  ed             yc c} w )    N)zD/opt/struktur/reports/backfill-backups-20260717T181315Z/knowledge.dbzN/opt/struktur/reports/obsidian-transcript-backup-20260717T193928Z/knowledge.dbzO/opt/struktur/reports/aa043-p34/20260827T223847Z/knowledge.db.pre-migration.bak)6   A   D   G   N   P   Z   a   d   f   u   w                        i  i%  i+  i,  i-  i3  i7  i?  zfile:z?mode=roT)uric              #   &   K   | ]	  }|d      yw)r   N ).0rs     (/opt/struktur/AA-043-P34-R1-snapshots.py	<genexpr>r      s     	;1!A$	;s   zselect id from videoszpragma foreign_key_checkzpragma integrity_checkzselect count(*) from chaptersz select count(*) from video_links)pathsizefk_count	integrityvideosmissing_ids_presentchaptersvideo_linksF)ensure_ascii)sqlite3jsonospathsidsoutpconnectcsetexecutevidsappendr   getsizelenfetchallfetchonecloseprintdumps)is   0r   <module>r;      s     ri	 A7??719Z'D1		;		"9:	;;ARWW__Q/3qyyIc?d?m?m?o;p}~  ~G  ~G  H`  ~a  ~j  ~j  ~l  mn  ~o  y|  }A  yB  eh  Yv  `a  lm  qu  lu  Z[  Yv  BC  BK  BK  Lk  Bl  Bu  Bu  Bw  xy  Bz  IJ  IR  IR  Su  Iv  I  I  IA  BC  ID  E  F	
 jdjj%( ) Yvs   	EE