
    	Sj                     z   d Z ddlmZ ddlZddlZddlZddlmZ  ee      j                         j                  d   Zedz  dz  Zej                  j                  d ee             ddlmZ dd	lmZ dd	lmZ dd
Zedk(  r9 eej4                        dk7  r ed       e eej4                  d                yy)zDSynthetic controlled-lab-review fixture; never uses production data.    )annotationsN)Path   scriptshealth)reconcile_documents)apply_schemac                   t        j                  |       }	 t        |       t        |       |j	                  d       |j	                  d       t        |j	                  d      j                         d         }d}d}|j	                  d||df       |j	                  d	|||f       |j	                  d
|||df       g d}|D ]R  \  }}}}	|j	                  d||||d| |	t        j                  |j                               j                         f       T |j                          t        |g |g       |j                          |j                          y # |j                          w xY w)NzGINSERT OR IGNORE INTO dokumente_status(status) VALUES ('eingearbeitet')aP  INSERT INTO dokumente
               (datei_name,dateipfad,daten_typ,kategorie,quelle,status,document_date,institution,review_status)
               VALUES('synthetic-lab.pdf','/synthetic/allowlisted/synthetic-lab.pdf','pdf','Labor','browser_fixture',
                      'eingearbeitet','2026-06-10','Synthetic Lab','nicht_geprueft')zSELECT last_insert_rowid()r   doc_eeeeeeeeeeeeeeeeeeeeeeeeu?   CRP: <4,2 mg/L
D-Dimer: 0,31 µg/L
Ferritin: nicht lesbar ng/mLa  INSERT INTO document_processing
               (document_id,intake_id,original_status,extraction_status,content_status,transfer_status,search_status,
                sha256,page_count,engine,engine_version,created_at,updated_at,original_reviewed_at)
               VALUES(?,?,'available','text_layer','partial','candidates_available','machine_searchable',
                      ?,1,'synthetic','1','2026-06-15T12:00:00+00:00','2026-06-15T12:00:00+00:00','2026-06-15T12:00:00+00:00')@eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeea  INSERT INTO document_text_versions
               (id,document_id,version,source_kind,original_text,normalized_text,engine,engine_version,created_at)
               VALUES('text_eeeeeeeeeeeeeeeeeeeeeeee',?,1,'text_layer',?,?, 'synthetic','1','2026-06-15T12:00:00+00:00')a  INSERT INTO document_pages
               (id,document_id,text_version,page_number,original_text,normalized_text,confidence,section_hash,repetition_status,reviewed_at)
               VALUES('page_eeeeeeeeeeeeeeeeeeeeeeee',?,1,1,?,?,0.94,?, 'first_documented','2026-06-15T12:00:00+00:00')@ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff))cand_e11111111111111111111111z	CRP: <4,2zmg/Lg\(\?)cand_e22222222222222222222222zD-Dimer: 0,31u   µg/Lg{Gz?)cand_e33333333333333333333333zFerritin: nicht lesbarzng/mLgRQ?ay  INSERT INTO document_candidates
                   (id,document_id,candidate_type,value_text,unit,page_number,section_number,context_text,engine,
                    confidence,status,source_text_version,candidate_fingerprint,created_at)
                   VALUES(?,?,'laboratory_value',?,?,1,1,?,'synthetic',?,'open',1,?,
                          '2026-06-15T12:00:00+00:00')u   Befunddatum 2026-06-10 · )document_ids)sqlite3connectapply_document_schemaapply_reconciliation_schemaexecuteintfetchonehashlibsha256encode	hexdigestcommitr   close)
database
connectiondocument_idintaketextrowscandidate_idvalueunit
confidences
             1tests/fixtures/dashboard_v5_sprint7c_e_fixture.pymainr*      s   *J3j)#J/deX	
 *,,-IJSSUVWXY/RB
 &(+	
 	| $%		
 	{ $h/		


 6: 	1L%z:
 {E4;UV[U\9]_ikrkyky  {G  {N  {N  {P  lQ  l[  l[  l]  ^	 	J+G
s   D1E E+__main__z2usage: dashboard_v5_sprint7c_e_fixture.py DATABASE   )r   r   returnNone)__doc__
__future__r   r   r   syspathlibr   __file__resolveparentsROOTHEALTHpathinsertstr$dashboard_v5.document_reconciliationr   dashboard_v5.sprint6i_a_schemar	   r   dashboard_v5.sprint6i_c_schemar   r*   __name__lenargv
SystemExit     r)   <module>rD      s    J "   
 H~''*			H	$ 3v;  D P V5p z
388}MNNchhqk	 rC   