+
    4oj	                    &   ^ RI Ht ^ RIHt ^ RIt^ RIt]! ]4      P                  4       P                  ^,          t	]	R,          t
]P                  P                  ^ ]! ]
4      4       ^ RIHt ^ RIHtHt RtR R	 lt]R
8X  d   ]! ]! 4       4      hR# )    )annotations)PathNsrc)
read_jsonl)	INDEX_DIRNORMALIZED_DIRa  
CREATE TABLE IF NOT EXISTS conversations (
    conversation_id TEXT PRIMARY KEY,
    source TEXT NOT NULL,
    title TEXT NOT NULL,
    created_at TEXT,
    updated_at TEXT,
    raw_path TEXT,
    metadata_json TEXT
);
CREATE TABLE IF NOT EXISTS chunks (
    chunk_id TEXT PRIMARY KEY,
    conversation_id TEXT NOT NULL,
    source TEXT NOT NULL,
    title TEXT NOT NULL,
    message_start INTEGER NOT NULL,
    message_end INTEGER NOT NULL,
    text TEXT NOT NULL,
    created_at TEXT,
    updated_at TEXT,
    metadata_json TEXT
);
CREATE VIRTUAL TABLE IF NOT EXISTS chunks_fts USING fts5(chunk_id UNINDEXED, conversation_id UNINDEXED, source UNINDEXED, title, text, content='chunks', content_rowid='rowid');
c                   V ^8  d   QhRR/# )   returnint )formats   "scripts/build_index.py__annotate__r   (   s      c     c                 f   \         P                  ! R R R7       \         R,          p V P                  4       '       d   V P                  4        \        P
                  ! V 4      p VP                  \        4       \        \        R,          4       F  pVP                  RVP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R	4      VP                  R
4      \        VP                  R/ 4      4      34       K  	  \        \        R,          4       EF2  pVP                  RVP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R	4      \        VP                  R/ 4      4      3
4       VP                  RVP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      VP                  R4      34       EK5  	  VP                  4        VP                  4        \        RV  24       ^ #   TP                  4        i ; i)T)parentsexist_okz
archive.dbzconversations.jsonlzAINSERT OR REPLACE INTO conversations VALUES (?, ?, ?, ?, ?, ?, ?)conversation_idsourcetitle
created_at
updated_atraw_pathmetadatazchunks.jsonlzCINSERT OR REPLACE INTO chunks VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)chunk_idmessage_startmessage_endtextzINSERT OR REPLACE INTO chunks_fts(rowid, chunk_id, conversation_id, source, title, text) VALUES ((SELECT rowid FROM chunks WHERE chunk_id = ?), ?, ?, ?, ?, ?)zbuilt )r   mkdirexistsunlinksqlite3connectexecutescriptSCHEMAr   r   executegetstrcommitcloseprint)db_pathconnconversationchunks       r   mainr1   (   s#   OOD40,&G~~??7#D	6"&~8M'MNLLL\_k_o_o  qB  `C  EQ  EU  EU  V^  E_  am  aq  aq  ry  az  |H  |L  |L  MY  |Z  \h  \l  \l  my  \z  |H  |L  |L  MW  |X  Z]  ^j  ^n  ^n  oy  {}  ^~  Z  _@  A O ?@ELL^afajajkuavx}  yB  yB  CT  yU  W\  W`  W`  ai  Wj  lq  lu  lu  v}  l~  @E  @I  @I  JY  @Z  \a  \e  \e  fs  \t  v{  v  v  @F  vG  IN  IR  IR  S_  I`  bg  bk  bk  lx  by  {~  D  H  H  IS  UW  X  {Y  aZ  [LL  z  }B  }F  }F  GQ  }R  TY  T]  T]  ^h  Ti  kp  kt  kt  uF  kG  IN  IR  IR  S[  I\  ^c  ^g  ^g  ho  ^p  rw  r{  r{  |B  rC  |D  E A 	

	F7)
 	

s   #HJ J0__main__)
__future__r   pathlibr   r#   sys__file__resolver   ROOTSRCpathinsertr)   ai_archive.ior   ai_archive.pathsr   r   r&   r1   __name__
SystemExitr   r   r   <module>r@      s{    "   
H~''*
Ul 3s8  $ 6
4( z
TV
 r   