{ r r a{
INSERT OR REPLACE INTO nutrition_daily_features
(datum, plan_adherence_score, histamine_score, saturated_fat_score, sugar_score, gluten_flag, pork_flag, nightshade_flag, alcohol_flag, fiber_proxy, protein_proxy, omega3_proxy, positive_hits, negative_hits, source, computed_at)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,CURRENT_TIMESTAMP)
r r r r r r r r r r r , r r dashboard_v31_keyword_heuristicz5SELECT * FROM nutrition_daily_features ORDER BY datum)
r listexecuter5 rH joinrG r r commit)r0 by_daydaytextssr s @r1 compute_nutrition_featuresr v s #.t#4F
YYa
b is1W:s#$++CHH4gaffh4g,ghi
YY K L is1W:s#$++CHH4gaffh4g,ghi lln ~
U CHHUO , 1W:q~q{AgJ( UVW]U^`abn`oqrs|q} @A BI @J LM NW LX Z[ \d Ze gk gp gp qr s} q~ g AE AJ AJ KL MW KX AY [| } ~~ HHJ QR SSr3 c * t || }|sy t | }|D cg c] }|| }}t | }|||t | |d |d |d t t | d t t
| d t t | d d
S c c}w )Nr )
labelsdataunitcountfirstlastlatestr r r )canonical_apple_dailyr canonical_apple_unitr roundr r r )r0 metricmodeseriesr dr r s r1 apple_seriesr s #64
0F
F^F % &!F1I &D & 'D dD3t9W]^_W`jpqsjt AE FH AI RW X\ ]a Xb de Rf ot ux y} u~ @A oB KP QT UY QZ \] K^ _ _ 's Bc t dz } | j sy t j | j d S # t
$ r Y y w xY w)Nzarztbericht_drive_link.jsonutf-8encoding)REPORTSr; jsonloads read_textr[ )rA s r1 load_doctor_report_metar sJ //A 88:zz!++w+788 s $A A
A
c t j dd t } t j rt t ng }|r t
| ng g i i i f\ }}}}}t } t |j d }t |j d } t |j d }
t |j d } t |j d } t | }
t D ci c] \ }}}|t ||| }}}}|j g d}t t }|
D ]H }|t |d d d
j! |d d |d
d|d xs d j# J | D ]6 }|t |d d d
j! d|d d|d xs d d 8 g }|D ] }g }|D ]T }|j% ||f }|st' |j( /|j! |t' |j( f V |sb|D cg c] \ }}| }}}|D cg c] \ }}| } }}|D cg c]! }||v s|dj+ || d d d# } }t- |j% | \ } } t/ j0 dd | } |j! d t3 j4 | d t3 j4 |j% |d d | d | d!t7 j8 | d"t7 j8 | d"t7 j8 | d"t7 j8 | d"t7 j8 | d"t7 j8 | d#$ d% g }!g }"t D ]^ \ }}#}|j% | }$|$s d&t/ j0 dd | z } |!j! d t3 j4 |# d't3 j4 |$d( d)|$d* d+|$d, d-|d.k( rd/nd0 d1| d2| d!t7 j8 |# d"t7 j8 |$d3 d"t7 j8 |$d4 d"t7 j8 |$d( d% |"j! d5t3 j4 |# d6|$d* d+|$d, d6|$d7 d6|$d8 dt3 j4 |$d( d6|$d9 d6|$d: d6|$d; d< a dj+ d= | j; D }%dj+ d> |D }&dj+ d? | D }'dj+ d@ |
dAd D }(dj+ dB | dAd D })dj+ dC | D xs dD}*|
D cg c] }|d }+}|
D cg c] }|dE },}|
D cg c] }|dF xs dG
}-}dj+ dH |
dAd D }.t= }/t dIz }0|0j r"dJt3 j4 t |0 dKndL}1d}2|/rw|/j% dM xs i }3|3j% dN xs4 |3j% dOi j% dN xs |3j% dP }4|4rdQt3 j4 |4 dR}2t? j@ jC dS }5t dTz }6dj+ g dU|5 dV|1 |2 dWtD dXtD dY|% dZdj+ |" d[dj+ |! xs d\ d]dj+ | xs d^ d_t7 j8 |+ d"t7 j8 |, d"t7 j8 |-d#$ d`|. da|* db|' dc|( |) dd|& de }7|6jG |7dfg t }|j dhdit |6 djf |jI |j tK |6 y c c}}}w # |j w xY wc c}}w c c}}w c c}w c c}w c c}w c c}w )kNT)parentsexist_okzSELECT id,datei_name,dateipfad,kategorie,status,review_status,upload_datum,drive_web_url,local_original_path,length(COALESCE(extrahierte_inhalte,'')) text_len FROM dokumente ORDER BY id DESC LIMIT 25zSELECT id,datei_name,dateipfad,kategorie,status,drive_web_url,local_original_path FROM dokumente WHERE upper(COALESCE(kategorie,'')) LIKE '%LABOR%' ORDER BY id DESC LIMIT 40z
SELECT date,category,parameter,value,notes,source FROM health_events
WHERE date IS NOT NULL AND date(date) IS NOT NULL AND upper(COALESCE(category,'')) NOT IN ('LABOR','PROFIL','BEFUNDE')
ORDER BY date
zkSELECT datum,kategori,symptom,schwergrad,notizen FROM symptome WHERE date(datum) IS NOT NULL ORDER BY datumzSELECT start_date,end_date,event_type,label,severity,location,notes FROM health_event_periods ORDER BY start_date DESC LIMIT 50) zC-Reaktives Protein (CRP)z Blutsenkungsreaktion miniiSED
Leukozyten Neutrophile Lymphozyten
Monozythen ThrombozytenFerritin
FibrinogenzD-Dimerz Faktor VIIIzCholesterin gesamtzLDL-CholesterinzHDL-Cholesterin Triglyceride Homocystein Kreatininz eGFR (Niere)zAlbumin/KreatininProteinBlut Erythrozytenz
ALAT (GPT)z
ASAT (GOT)GGTzVitamin D (25-OH)zVitamin B12 (Active)u FolsäurezHLA-B51dater categoryz: parameterr r? rW r z Symptom: symptomz (
schwergradzn/a)z; )r\ r z\W+rb z!
apple_z!Einheit: r z ; Zeitraum: r z bis r z; Aggregation: r Summe Durchschnittz pro Tag/Woche
JARVIS Health Dashboard v3.1
Generiert: u
Neu: Apple-Health-Jahresdaten sind integriert. PDF-Arztbericht kann über das Generator-Skript aktualisiert und über Google Drive geöffnet werden.
Arztbericht PDF
z6
Aktualisieren per: python3 z./scripts/generate_doctor_report.py && python3 zb/scripts/health_pipeline.py dashboard
Systemstatus
u
Apple Health Trends
| Metrik | Zeitraum | Records | letzter Wert | Ø | Min | Max |
|---|
z
u+ Keine Apple-Health-Daten verfügbar.
z=
Labortrends mit Referenzband & Health-Event-Markern
u$ Keine Labortrends verfügbar.
u
Ernährungsplan-Konsequenz
| Datum | Score | erkannte Risiken | positive Treffer |
|---|
u
Health Event Periods / Zeiträume
| Start | Ende | Typ | Label | Schweregrad | Notizen |
|---|
zj
Laborberichte / Original-PDFs
Klinische Events, Medikamente & Symptome
| Datum | Kategorie | Parameter/Symptom | Wert/Notiz |
|---|
z
Letzte Dokumente
| ID | Datei | Kategorie | Status | Review | Volltext-Zeichen |
|---|
z