
    [jm                    .   d dl mZ d dlZd dlZd dlZd dlZd dlmZ  ee          	                                j
        d         Zedz  dz  Zej                            d  ee                     d dlZd dlmZ ddZddZedk    r e             dS dS )    )annotationsN)Path   scriptshealth)apply_schemakindstratdurationintdatadictkeyreturnc                    ddl m }m} |                    |           ||          z   }dddd|||                    d          | |d	|g d d d
S )Nr   )datetime	timedelta)minutes   capture_entryeventr   )timespec)
event_kindduration_minutes)versionactioncapture_typerequest_versionidempotency_keyoccurred_atended_atr   attachmentscorrects_entry_idwithdraws_entry_id)r   r   fromisoformat	isoformat)r	   r   r   r   r   r   r   ends           1tests/fixtures/dashboard_v5_sprint7c_a_fixture.pycapturer*      s    ,,,,,,,,

 
 
$
$yy'B'B'B
BC!MM9M55#JJTJ!"      Nonec                 F   t          t          j        d                                                   } t	          j        |           5 }t          |           d |                    d          D             dd dddddd	fd
ddddi fdddddi fdddddi fdddddi fdddddddddd d!fg}t          |d          D ]\  }\  }}}}}}	|||||d"d#d$t          |          z   t          j        |	          d%	fd&D             }
|                    d'd(                    |
           d)d(                    d* |
D                        d+t          fd,|
D                                  |                                 d d d            n# 1 swxY w Y   | t          _        | j        d-z  t          _        | j        d.z  t          _        t          j        t+          d/d0d1d2d3d4dd5d6d7d8                     t          j        t+          d9d:d;d<d3d<d=d>d?d@                     d S )ANr   c                    h | ]
}|d          S )r    ).0rows     r)   	<setcomp>zmain.<locals>.<setcomp>)   s    cccc3q6cccr+   z'PRAGMA table_info(apple_health_records)blood_pressuremmHgz2026-06-14T08:00:00+02:00x   P   )systolic	diastolicweight_body_massg     Q@kgrespiratory_rateg      ,@z	count/minz2026-06-14T08:05:00+02:00blood_oxygen_saturationg     X@%apple_exercise_timeg      9@minz2026-06-14T09:00:00+02:00sleep_analysisg      @hrz2026-06-14T00:00:00+02:00z2026-06-14T07:00:00+02:00g      @g      ?g      ?g      ?)
totalSleepcoredeepremawakezHealth Auto Exportzsynthetic-7c-a.json7ca)	metricvalueunit
start_dateend_datesource_name	file_name	file_hashraw_jsonc                    g | ]}|v |	S r/   r/   )r0   namecolumnss     r)   
<listcomp>zmain.<locals>.<listcomp>8   s    DDDDGOOOOOr+   z!INSERT INTO apple_health_records(,z	) VALUES(c              3     K   | ]}d V  dS )?Nr/   )r0   _s     r)   	<genexpr>zmain.<locals>.<genexpr>:   s$      YpYpbcZ]YpYpYpYpYpYpr+   )c              3  (   K   | ]}|         V  d S )Nr/   )r0   rR   payloads     r)   rY   zmain.<locals>.<genexpr>;   s'      99gdm999999r+   zcapture-quarantinezcapture-mediasaunaz2026-06-15T10:00   SaunazSynthetischer Testeintragr   zkurze Kaltphasei  )titlenoteroundstemperature_ccoolinghydration_ml 77777777777777777777777777777777trainingz2026-06-15T12:00<   Gehen   g      @)r`   ra   activity_typeactive_kcaldistance_km 88888888888888888888888888888888)r   sysargvresolvesqlite3connectr   execute	enumerater
   jsondumpsjointuplecommitworkerDASHBOARD_DBparentCAPTURE_QUARANTINECAPTURE_MEDIAapply_capture_actionr*   )database
connectionvaluesindexrH   rI   rJ   startr(   rawselectedrS   r\   s              @@r)   mainr   %   sJ   CHQK  ((**H		"	" jZ   ccZ%7%78a%b%bccctV-HJetw  GI  hJ  hJ  Kt-HJegij{4OQlnpq&c3NPkmop"D%1LNikmnsD*EGbsv  AD  NQ  Z]  hk  el  el  m
 >Gvq=Q=Q 
	 
	9E9FE4S 5$ead3BW"SZZ/TZ__ G
 EDDDDDDHsCHHX4F4FssQTQYQYYpYpgoYpYpYpQpQpsss999999999    	-              0 #F (2F FF#?_<F
1CR"=(93J J ! !    
4F"=PW3M M ! !     s   D7FFF__main__)r	   r
   r   r
   r   r   r   r   r   r
   r   r   )r   r,   )
__future__r   rv   osrr   ro   pathlibr   __file__rq   parentsROOTHEALTHpathinsertr
   health_dashboard_action_workerr{   dashboard_v5.sprint6h_b_schemar   r*   r   __name__r/   r+   r)   <module>r      s   " " " " " "  				  



      tH~~'*			H	$ 33v;;    / / / / 7 7 7 7 7 7   &$ $ $ $N zDFFFFF r+   