1$jhSSKrSSKrSSKrSSKrSSKrSSKrSSKrSSKrSSKJrJ r SSK J r SSK J r Jr SSKJrJr SSKJrJr SSKJrJr SSKJr \ "\5R75R8r\S - S - r\S - r1S kr S r!Sq"\RF"5r$Sr%Sr&Sr'Sr(SVSjr)Sr*SWSjr+Sr,Sr-Sr.Sr/Sr0Sr1Sr2SXSjr3Sr4Sr5S r6S!r7S"r8SVS#jr9S$r:S%r;S&rS*r?S+r@S,rAS-rBS.rCS/rDS0rES1rFSZS2jrGS3rHS4rIS[S5jrJS6rDS7rKS8rLS9rMS:rNS;rOS<rPS=rQS>rRS?rSS\S@jrTSArUS[SBjrV\!4SCjrWSDrXS]SEjrYSFrZSGr[SHr\"SISJ\5r]S^SKjr^S^SLjr_S^SMjrTS[SNjrV\`SO:Xag\a"\R5SP:a\c"\RSP5OSQrd\'"5 \)"S(SR9 \\"5 \e"SS\dST35 \ "SU\d4\]5R5 gg)_N)datetimetimezone)Path)ThreadingHTTPServerSimpleHTTPRequestHandler)urlparseparse_qs)Requesturlopen) HTTPErrorURLError) load_databaseDATABASEzGRAFO_D_DATABASE.sqlitezrender_excel_like.py>folders event_meta folder_metagraph_set_cardsFcV[R"S[R"55$)N%Y-%m-%dT%H:%M:%SZ)timestrftimegmtimegrafo_d_server.pynow_isors ==-t{{} ==rc[R"[SS9n[RUlUR S5 UR S5 UR S5 U$)NtimeoutzPRAGMA foreign_keys = ONzPRAGMA journal_mode = WALzPRAGMA busy_timeout = 5000)sqlite3connectDBRow row_factoryexecutecons r connect_dbr*!sI //"b )CkkCOKK*+KK+,KK,- Jrc[5nURS5 URS5 [U5 UR5 SSS5 g!,(df  g=f)zFIdempotent schema extension inside the same canonical SQLite database.z CREATE TABLE IF NOT EXISTS ui_state ( key TEXT PRIMARY KEY, value_json TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL ) aL CREATE TABLE IF NOT EXISTS api_ingest_log ( id INTEGER PRIMARY KEY, api_id TEXT NOT NULL, event_legacy_id TEXT NOT NULL, action TEXT NOT NULL, created_at TEXT NOT NULL, UNIQUE(api_id, event_legacy_id) ) N)r*r'repair_malformed_api_eventscommitr(s rensure_runtime_schemar.*sJ       $C( ) s >A A c*[5 [5$N)r.rrrrload_dbr1Cs ?rcnSnU(aU"5 g[R"USS9R5 g)Nc[R5(dg[ [R"[ R [[5/[[5SS9 SSS5 g!,(df  g=f)NF)cwdcheck) RENDERexists _render_lock subprocessrunsys executablestrROOTrrr_runrender_frontend.._runIs>}}   NNCNNCK8c$iu U\\s AA++ A9Ttargetdaemon) threadingThreadstart)blockr?s rrender_frontendrHHs+V   T288:rcUcg[U5R5nU(dg[U5nUS:aUS- nUS:dUS:ag[R "U[ RS9nURS5URS5URURUR4$![a gf=f) z^Return (iso_datetime, yyyy-mm-dd, year, month, day) for valid Unix epoch seconds/milliseconds.Nld( g@@iCm8lW i)tzrz%Y-%m-%d) r=stripfloat Exceptionr fromtimestamprutcryearmonthday)valuerawnumberdts repoch_to_utc_partsrWTs } e*   C s& Vj0   8<< 8B () J      s B00 B=<B=cUHBn[U[5(dMURU5S;dM1URU5s $ U$)N)N) isinstancedictget)mappingkeysdefaultkeys r first_presentrans? gt $ $S)9)K;;s# # Nrc[U[5(dgU/nSH<nURU5n[U[5(dM+URU5 M> SnSnUH;n[ XdS5n[ XeS5nUcM UcM%[ U5[ U54s $ URS5n [U [ [45(a+[U 5S:a[ U S5[ U S 54$g) zIExtract latitude/longitude from common API-center and ISS payload shapes.NN) iss_positionpositionlocation coordinatesgeo)latitudelat) longitudelonlnglongNrgr) rZr[r\appendrar=listtuplelen) item candidatesr`vallat_keyslon_keyssrcrjrlcoordss rextract_lat_lonr|us dD ! !JMhhsm c4   c "N #H2HC40C40 ?ss8SX% %  XXm $F&4-((S[A-=6!9~s6!9~-- rc"[USS5nU(a [U5$[U[5(aUR S5OSn[U[5(a%UR 5(aUR 5$Ub UbSUSU3$g)N)place location_namecitycountryregionrYrfzLow Earth Orbit / lat z, lon )rar=rZr[r\rK)rurjrlexplicitlocs r build_placers}T#Z\^_H8}",T4"8"8$((: dC#s yy{ 3?'uF3%88 rc[URS5=(d URS5=(d S5R5nSU;=(d [U[5=(a SU;$)NnameidrYISSrd)r=r\upperrZr[)api_rowruapi_names ris_iss_payloadrsR7;;v&A'++d*;ArBHHJH H  SD$!7!RNd 9999 AND ( UPPER(COALESCE(event_name, '')) LIKE '%ISS-LIVE-LOCATION%' OR UPPER(COALESCE(api_text, '')) LIKE '%ISS-LIVE-LOCATION%' OR UPPER(COALESCE(who, '')) = 'ISS-LIVE-LOCATION' ) N)r'r(s rr,r,s KK  rc [URS5=(db URS5=(dJ URS5=(d2 URS5=(d URS5=(d S5R5nSSKn[ U5nU(a7UupEpgnURS5=(d UUS'XPS'X`S'XpS 'XS 'XgU4$UR S U5n U (aw[ U RS 55nU RS 5b[ U RS 55OS nU RS5b[ U RS55OS nOURSU5V s/sHn [ U 5PM n n U (dIURS[URSS555V s/sHn [ U 5PM n n U SS n [U 5S :aU SOSn[U 5S :aU S OS n[U 5S:aU S OS nUbDX`S'XpS 'XS 'URS5(d"US:a USSUSSUS3O USUSSUS3US'XgU4$s sn fs sn f)Ndate date_text timestamprrPrYrrrQrRz+^(-?\d{1,6})(?:-(\d{1,2}))?(?:-(\d{1,2}))?$rproz-?\d+r04d-02d) r=r\rKrerWmatchintgroupfindallrt) eventrTrepoch iso_datetimerrPrQrRmxnums name_numss rparse_event_daterso eiiD599[#9DUYY{=SDW\W`W`agWhDlqluluv|l}DBD E K K MC s #E 491 c!IIj1A\j!f f ge C ?EA1771:#$771:#9AGGAJq!"!7c!''!*oQ " 8S 9: 91A 9:)+Hc%))FTVBW>X)YZ)YAQ)YIZRa=Dd)q.tAwdt9>QqTad1gQ f ge yy  CG!8tCj%Ac#Y?TXSYYZ[`adZeefgjknfoQpE&M  ;Zs I7I<c[U=(d 05nURSURS5=(d6 URS5=(d [[R "555 URSURS5=(d2 URS5=(d URS5=(d S5 URS URS 5=(d2 URS 5=(d URS 5=(d S 5 [ U5 URSURS5=(d S5 URSURS5=(d US5 [US5US'[US5US'[5US'URSUS5 U$)Nrevent_id legacy_idrtitlelabel event_nameUntitled eventrowgraphgraph_idrow_keyr_ start_colrFrpend_colend updated_at created_at) r[ setdefaultr\r=uuiduuid4rrr)payloadrs rnormalize_eventrsZ B E T599Z0_EIIk4J_cRVR\R\R^N_` VUYYw/t599W3EtS_I`tdtu UEIIg.l%))J2Gl599U^K_lclmU [%))G"4"9: Y % 0 FE+4FGU;/0E+5+,E)!)E, \5#67 Lrc*[U=(d S5R5=(d Sn[5nURSU45R 5nU(a[ US5$URSX#U45n[ UR 5$)N Uncategorized%SELECT id FROM folders WHERE name = ?rzNINSERT INTO folders(name, is_open, created_at, updated_at) VALUES (?, 1, ?, ?))r=rKrr'fetchoner lastrowid)r)r folder_nametsrcurs rget_or_create_folderrs}d-o.446I/K B ++= ~ N W W YC 3t9~ ++X " C s}} rch[U=(d S5R5=(d Sn[5nURSU45R 5nU(a[ US5$[ X5nURSU[U=(d U5XuU45n[ UR5$)Nr_'SELECT id FROM graphs WHERE row_key = ?rz INSERT INTO graphs(row_key, visible_name, folder_id, color, created_at, updated_at) VALUES (?, ?, ?, NULL, ?, ?) )r=rKrr'rrrr) r)r visible_namerr`rr folder_idrs rget_or_create_graphrs g" # ) ) + 8yC B ++?# H Q Q SC 3t9~$S6I ++  c,%#& r:  C s}} rcrURSU45R5n[US=(d S5$)NzGSELECT COALESCE(MAX(sort_index), 0) AS n FROM events WHERE graph_id = ?nr)r'rr)r)rrs rmax_sort_indexr s3 ++_bjal m v v xC s3x}1 rc0[URS5=(d2 URS5=(d URS5=(d S5n[XX!RS5=(d URS5=(d S5n[U5upEnURS5=(d URS 5nU(d4Ub1US S [ U=(d S 5S S [ U=(d S 5S 3n[ URS5=(d& URS5=(d [ X5S -5n[ URS5=(d URS5=(d U5n [ URS5=(d [ S X- S -55n [ URS5=(d U5n [5n 0S[URS5=(d- URS5=(d [R"55_SU_SU_S[URS5=(d URS5=(d S5_S [U=(d S5_SU_SU_SU_SU_SU _SU _S[URS5=(d URS5=(d S5_S [URS 5=(d2 URS!5=(d URS"5=(d S5_S#[URS#5=(dJ URS$5=(d2 URS%5=(d URS&5=(d S5_S'[URS'5=(d URS(5=(d S5_S)[URS*5=(d URS)5=(d S5_SU _S+U 0E$),Nrrrr_rfolderrrrrrrprrrFrrduration sort_indexrrrrrrrY date_year date_monthdate_dayr~PLACEwhoWHOactorbrief_descriptionbriefBRIEF description source_linkurlapi_textapir) r=r\rrrrmaxrrr) r)rrrrPrQrRrrrrrrs revent_to_sql_valuesrsv%))E"]eii &:]eii>P]T]^G"3))G:L:vPUPYPYZbPc:vgvwH'.D &!;UYY{%;I )Cj#ejq/#!6aCH1 c7JK EIIk*eeii.@eNSVDadeDefI%))I&G%))E*:GiHG599Z(KC73F3J,KLHUYY|,9 :J B S4REIIk,BRdjjlS H  7  c%))F+Zuyy/FZJZ[   Sb)   T   e  C  Y  7  H  UYYw'C599W+=CD  s599U#Suyy'7S599W;MSQST  S II) * yy! yy! yy'    * s599]3Muyy7GM2N+ , C %(GEIIj,AGRH- . j/ 0 b1 rc^^^ SSKnSSKJm [U=(d S5R 5nU(d [ S5eUR 5R 5nURSS5nURSSU5n0S S _S S _S S _S S _SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_0S S_S!S_S"S#_S$S#_S%S#_S&S'_S(S'_S)S'_S*S'_S+S,_S-S,_S.S,_S/S,_S0S1_S2S1_S3S1_S4S5_ES5S5S6S6S6S6S7.EnS8mS9m SCUUU 4S:jjnURS;U5nU(aU"URS 55$URSU5nU(a7U"URS5URS5URS 55$URS?U5nU(a>URS 5U;a)U"URS5XFRS 55$URS@U5nU(aNURS5U;a9U"URS5XFRS5URS 55$URSAU5nU(aNURS 5U;a9U"URS5XFRS 5URS55$[ SBU-5e)Dz Deterministic smart date parser for manual UI/API events. Accepted: - -600 - -600-01 - -600-01-01 - 1989 - 1989-01 - 1989-01-01 - 01/01/1989 - 1/1/1989 - 01-01-1989 - 1989/01/01 - June 1989 - 4 June 1989 - Junio 1989 - 4 Junio 1989 rN)rrYzdate is required, z\s+janrpjanuaryeneenerofebrofebruaryfebreromarrmarchmarzoapraprilabrabrilmaymayojunjunejuniojuljulyjulioaugaugustagoagostosep sept september septiembreoct octoberoctubrenov )november noviembredecdecemberdic diciembrecB[U5nUS:aUS$[U5$)Nrr)rr=ys r format_year%smart_parse_date..format_yeares$ FU!C.A.rcd[U5nUS-S:H=(a US-S:g=(d US-S:H$)Nrrd)rrs r is_leap_year&smart_parse_date..is_leap_yearis3 FA >SA!=SA>rc >[U5nUS:Xd US:dUS:a [S5eUc[U5USS4$[U5nUS:dUS:a [S5eUcT"U5SUS 3XS4$[U5nUS:a T"XU5 O9S T"U5(aS OS S S S S S S S S S S / nUS:d X#US- :a [S5eT"U5SUS SUS 3XU4$)Nrii?Bzyear out of rangerpr zmonth out of rangerrrzday out of range)r ValueErrorr=)rrd month_daysrrrs rr5smart_parse_date..checkms F 6Q[AJ01 1 9q61dD( ( F q5AF12 2 9!!n%Qqg.d: : F q5 qMLOObRRRQSUWY[]_acdJ1uq1u-- !344a.!1S'1S'2A!;;rz (-?\d{1,6})z(-?\d{1,6})[-/](\d{1,2})z%(-?\d{1,6})[-/](\d{1,2})[-/](\d{1,2})z%(\d{1,2})[-/](\d{1,2})[-/](-?\d{1,6})u"([a-záéíóúñ]+)\s+(-?\d{1,6})u.(\d{1,2})\s+([a-záéíóúñ]+)\s+(-?\d{1,6})u.([a-záéíóúñ]+)\s+(\d{1,2})\s+(-?\d{1,6})zunsupported date format: rc) rrrr=rKr!lowerreplacesub fullmatchr) rSrrTtxtmonthsr5rrrrs @@@rsmart_parse_dater+7s( ekr  "C +,, ))+   C ++c3 C &&c "C  q Q  %q *11  q a !*A  q 1 &q  q 1 $Q )0  q  !  q  !  %a  q ! %a  q A  %a *21  q ! )! .:1  r b #,R  r  "r"2 F/?<<2 ^S)AQWWQZ   0#6AQWWQZ,, =sCAQWWQZQWWQZ88 =sCAQWWQZQWWQZ88 :C@AQWWQZ6 !QWWQZ !344 FLAQWWQZ6 !QWWQZ !3QWWQZ@@ FLAQWWQZ6 !QWWQZ !3QWWQZ@@ 036 77rcF[5 [U=(d 05n[URS5=(dJ URS5=(d2 URS5=(d URS5=(d S5R 5nU(d [ S5e[URS5=(d2 URS5=(d URS 5=(d S5R 5nU(d [ S 5e[URS 5=(d URS 5=(d S5R 5n[ U5upVpx[URS 5=(d URS5=(d S5R 5n [URS5=(d URS5=(d S5R 5n [URS5=(dJ URS5=(d2 URS5=(d URS5=(d S5R 5n [URS5=(d URS5=(d S5R 5n [URS5=(d URS5=(d S5R 5n [5n[5nURS5 URSU45R5nU(a[US5nO [XUS5nURSU45R5n[US=(d S 5nUS!US!US!U3nURS"UUUUUUUUS S S U U U U U UUU45nUR5 S#S#S#5 S$WRUUUUUUS%.$!,(df  N#=f)&zu Insert one manually-created event into canonical SQLite using smart date parsing. This is used by POST /api/events. rrr graph_rowrYzrow_key/row/graph is requiredrrrzevent name is requiredrrr~rrrrrrrrrrsourcez manual-uiBEGIN IMMEDIATEz5SELECT id, visible_name FROM graphs WHERE row_key = ?rrzSSELECT COALESCE(MAX(sort_index), 0) + 1 AS next_sort FROM events WHERE graph_id = ? next_sortrp:a INSERT INTO events( legacy_id, graph_id, row_key, event_name, date_text, date_year, date_month, date_day, start_col, end_col, duration, place, who, brief_description, source_link, api_text, sort_index, created_at, updated_at ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) NT)okrrrrrrr)r.r[r=r\rKr!r+rr*r'rrrr-r)rdatarrraw_daterrrrr~rrrrrr)rrsort_rowrrrs rinsert_manual_event_sqlr6s   2 D   88E?  88G   88K      eg   899   88F   88G      eg  122488F#Btxx '<BCIIKH1A(1K.I* !++  K  (* $Q    !/GJ/ ! @  K   (*  G J  !2!DI e U N    s!E6Q9 R 9 R RRc[5 [U5n[5nURS5 [ X25nURSUS45R 5nU(a"U(dUR 5 [S5eU(aURSU5 SnO9URS5=(d [5US'URSU5 S nUR5 SSS5 WUS .$!,(df  N=f) Nr/z)SELECT id FROM events WHERE legacy_id = ?rzduplicate event ida? UPDATE events SET graph_id=:graph_id, row_key=:row_key, event_name=:event_name, date_text=:date_text, date_year=:date_year, date_month=:date_month, date_day=:date_day, start_col=:start_col, end_col=:end_col, duration=:duration, place=:place, who=:who, brief_description=:brief_description, source_link=:source_link, api_text=:api_text, sort_index=:sort_index, updated_at=:updated_at WHERE legacy_id=:legacy_id updatedra INSERT INTO events( legacy_id, graph_id, row_key, event_name, date_text, date_year, date_month, date_day, start_col, end_col, duration, place, who, brief_description, source_link, api_text, sort_index, created_at, updated_at ) VALUES( :legacy_id, :graph_id, :row_key, :event_name, :date_text, :date_year, :date_month, :date_day, :start_col, :end_col, :duration, :place, :who, :brief_description, :source_link, :api_text, :sort_index, :created_at, :updated_at ) inserted)actionr) r.rr*r'rrrollbackr!r\rr-)r allow_upsertnormr)valuesexistingrHs rinsert_event_sqlrNs 5 !D  %&$S/;; 7&:M9O (*  L LLN12 2  KK  F#'88L#9#FWYF< KK   F U Vt ,,W s CC<< D c[5 [5nURS5 URS[U5[U545R 5nU(dUR 5 SSS5 g0SUS=(d [US5_SUS_SUS_S US =(d S _S US _SUS_SUS_SUS_SUS_SUS_SUS_SUS_SUS_SUS_SUS_SUS_nUR U=(d 05 [U[U55nUSUS'URSU5 UR5 SSS5 U$!,(df  W$=f)Nr/z@SELECT * FROM events WHERE legacy_id = ? OR CAST(id AS TEXT) = ?rrrrrrrrrYrPrrQrrRrrrrr~rrrrrrdb_ida UPDATE events SET graph_id=:graph_id, row_key=:row_key, event_name=:event_name, date_text=:date_text, date_year=:date_year, date_month=:date_month, date_day=:date_day, start_col=:start_col, end_col=:end_col, duration=:duration, place=:place, who=:who, brief_description=:brief_description, source_link=:source_link, api_text=:api_text, sort_index=:sort_index, updated_at=:updated_at WHERE id=:db_id ) r.r*r'r=rrIupdaterrr-)rpatchr)rr=rLs rupdate_event_sqlrSs  %&kk N ]CM *  (*  LLN  #k"4c#d)n 3y>  C %  C $*  C $  S&   3z?  [)  s9~  J  S\  3u:  323  3}-  J #l+! $ u{#$S/'*BCd)w     Y Z N[ Z NsAEDELETE FROM events WHERE legacy_id = ? OR CAST(id AS TEXT) = ?r)r.r*r'r=r-rowcount)rr)rs rdelete_event_sqlrVs^  %&kk L ]CM *  ||a s AA55 Bc ^ U(dgUVs1sHn[U5iM nnURS5R5nUGHnUSn[R"US5nSnUS:Xa[ U[5(aSH^n [ URU 5[5(dM)XyVs/sHn[U5U;dMUPM n nXU :wdMXXU 'SnM` [ URS5[5(a<[USR55Hn [U 5U;dMUSU SnM US ;aV[ U[5(aA[UR55H$m [U 4S jU55(dMUT SnM& U(dGMjURS [R"USSS 9[5U45 GM gs snf![ a GMf=fs snf) Nz$SELECT key, value_json FROM ui_stater` value_jsonFr) deletedRows deleteRowsT graphFolder)rrrc3># UH7n[T5RUS-5=(d [T5U:Hv M9 g7f)r1N)r= startswith).0r"meta_keys r 6cleanup_ui_state_after_graph_delete..Es8`X_STs8}//C8NCMQ G G ID%j JJs<01E )  5$ 7 72eiilD11+08M8as1vW7L8HM8+#+a"& 3%))M2D99!%eM&:&?&?&A!BI9~0!-0;"&"C B BzRWY]G^G^ .`X_```h"G/ 7 KKREF SVW =-    Ns#G'G,7G>G>, G;:G;c z[5 SSKJn /nU=(d /HLnU"[U=(d S55R 5nU(dM4XB;dM;UR U5 MN /n/n[ 5n[5nURS5 UHnUS:XaUR USS.5 MURSU45R5n U (dUR US S.5 M]URS U S 45R5Sn U (aUR US U S .5 MURSU S 45 UR U5 M URS5R5n U (a[R"U S5n O0n [U [5(Ga[U5n U R!S/5V s/sHn [U 5U ;dMU PM sn U S'U R!S05n[U[5(a-[#UR%55H n X;dM X M XS'U R!S05n[U[5(a4[#UR'55HunnUU ;dMSUU'M XS'URS[R("U SSS9Xw45 UR+5 SSS5 [-SSSS9 SUUUS.$![a 0n GNif=fs sn f!,(df  N9=f![a N,>,@'AOGV,0? W-(B(4m$ KKEFO  ] `  !6aM   [   a d    sdDLL'8LL6L nnU(d SSSSS/S.$SnSnSnSn/n[ 5nUR S5 UGH:n UR SU 45R 5n U (dM.[U S5n UR SX45R5n U V s/sHn [U S5PM nn UH%nUR SU45nUUR- nM' UH%nUR S U45nUUR- nM' UR S X45nUUR- nUR S U 45nUUR- nUR(dGM)URU 5 GM= [X5 UR5 SSS5 U(a$[ 5nUR S 5 SSS5 SUUUUUS.$s snfs sn f!,(df  NL=f!,(df  N2=f) NTr)r2deleted_graphsdeleted_events deleted_apisdeleted_api_logsrlr/z0SELECT id, row_key FROM graphs WHERE row_key = ?rz>SELECT id FROM api_registry WHERE target_graph = ? OR name = ?+DELETE FROM api_ingest_log WHERE api_id = ?%DELETE FROM api_registry WHERE id = ?z4DELETE FROM events WHERE graph_id = ? OR row_key = ?zDELETE FROM graphs WHERE id = ?VACUUM) r.rZr=rKr*r'rrrerUrqrqr-)row_keysvacuumrrrrrphysically_deleted_rowsr)rrrapi_rowsrapi_idsapi_idrs rdelete_graphs_sqlrs_(C  :)1RK1CFLLNA HK  !   NNL   %&GKKB hj  5;'H{{P"hj  .66Xs1T7|XG6!kkAI!CLL0 ""kk;I , "++F#C cll *N++1 C cll *N|||'..w7[ ^ ,CI g j \S KK !(($,'  WLJ7' l\s="IIA5I I&B+I 1I  II  I I,cl[U=(d S5R5nU(dSn/nSnUR5HInUR5(aUR U5 SnM-U(aM6UR S5 SnMK SR U5RS5=(d S$)NrYz NEW GRAPHF_T NEW_GRAPH)r=rKrisalnumrqjoin)rrToutprev_uschs rslugify_graph_keyr s djb/   !C  CGiik ::<< JJrNG7 3 GGCL  s # 2{3rc [5 [U=(d 05n[URS5=(d URS5=(d S5R 5nU(d [ S5e[ 5n[5nURS5 URSX#U45 URSX245 URS5R5nU(a[R"US 5nO0n[U[5(d0nURS /5 URS 05 URS 05 URS /5 URS/5 SUS ;aUS RSS5 X&S ;aUS R!U5 SUS U'URS[R""USSS9X345 UR%5 SSS5 ['SSSS9 SUS.$![a 0nGNf=f!,(df  N2=f![a N5f=f)z Create a folder physically in SQLite. Canonical policy: - folders table is the source of truth. - ui_state is synchronized for UI open/visibility state. - no graph and no event is created. rrrYzfolder name is requiredr/z~ INSERT OR IGNORE INTO folders(name, is_open, created_at, updated_at) VALUES (?, 1, ?, ?) z UPDATE folders SET is_open = 1, updated_at = ? WHERE name = ? rxrXrr[ryrYrZrrT  INSERT INTO ui_state(key, value_json, created_at, updated_at) VALUES ('folders', ?, ?, ?) ON CONFLICT(key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at FrbNz create-folderr2r8)r2r)r.r[r=r\rKr!rr*r'rrfrgrMrZrinsertrqrir-r<)rr3rrr)rrs rcreate_folder_sqlr7s!  2 D txx;488H#5; < B B DD 233 B  %&  rN     J kk A (*    3|#45E%&&E B' + $ + r* % "2 2 )  # #A 7 Y' ' )  # #D )"f d  ZZET BB K  { ~  $G$ ''Q  9 B    sDAH!.HC.H!> H2 HH!HH!! H/2 H?>H?c\[5 [5n[5nURS5R 5nU(dSSS.sSSS5 $[ R "US5n[U[5(dSSS S .sSSS5 $URS /5n[U[5(dSSS S .sSSS5 $SnURS 5 UHn[U=(d S5R5nU(dM.URSU45R 5nURSX`U45 URSX45 UbM{US- nM UR5 SSS5 SWS.$![a SSSS .ssSSS5 $f=f!,(df  N2=f)z Convert folders present in ui_state into canonical rows in folders. This makes Save meaningful for folders that were created by older UI code before POST /api/folders existed. rxTr)r2syncedNrXFzinvalid ui_state folders json)r2rerrorzui_state folders is not objectrzui_state folders list missingr/rYrz INSERT OR IGNORE INTO folders(name, is_open, created_at, updated_at) VALUES (?, 1, ?, ?) z=UPDATE folders SET is_open = 1, updated_at = ? WHERE name = ?rp)r.rr*r'rrfrgrMrZr[r\rrr=rKr-)rr)rrrrrbefores rsync_ui_folders_to_sqlrs B kk A (* !,  XJJs<01E%&&17WX  ))Ir*'4((17VW% ( %&Dtzr?((*D[[7hj  KK2   KKO   ~! 14 c f& ))S X17VW W  X sB+FE>.F,FB FF>FFFF F+c [5 [U=(d 05n[URS5=(d URS5=(d S5R 5nU(d [ S5e[URS5=(d S5R 5=(d Sn[URS5=(d [ U55R 5n[5n[5nURS5 UnUnS n URS U45R5(a4US U 3nU S - n URS U45R5(aM4Un[XdX#5n URS 5R5n U (a[R"U S5n O0n U RS/5 U RS05 U RS05 U RS/5 U RS/5 X>+ % 99Y'99W%  eg  &!99\*  eg  &!99[)eg   '*Feii.@FBGMMOEeii&@%))E*:@bAGGIC # -.99W%99W%99]+ ! eg eii 6P%))E:JPbQWWYK*1 F$)< i*= (*~(j(3 (*~j) (*~1 {+I{+I -Jj)HAQRZA[>Iy*h KK %t %  : qLGe'h M P 33} C QSB B  C2!# $I"G#B!I s,T8S$<T8 B"T8TL%T8T(AT8$ T.T <T=T8 TT8T%!T8$T%%T8( T52T84T55T88 Uc[5 [5n[5 [5nUR S5R 5SnUR S5R 5SnUR S5R 5SnSnUR S5R 5SnSSS5 [5 WS:HUWWWS.$![ a SnN+f=f!,(df  N5=f) a> Explicit session save endpoint. Operational policy: - Does not create data. - Does not delete data. - Forces frontend render from canonical SQLite. - Verifies SQLite integrity. - Returns current object counts. Most operations already persist transactionally. This endpoint is the explicit user-facing Save barrier. PRAGMA integrity_checkrSELECT COUNT(*) FROM graphsSELECT COUNT(*) FROM events!SELECT COUNT(*) FROM api_registryNr2)r2sqlite_integrityrweventsapis)r.rrr*r'rrMrH)event_meta_syncr) integrityr event_count api_counts rsave_session_sqlrs35O KK 89BBDQG kk"?@IIKAN kk"?@IIKAN    $GHQQSTUVI 4%    I  s*A)C$"C C!C$ C!!C$$ C2c[5 [5nURS5 URS[545 UR 5 SSS5 g!,(df  g=f)Na\ CREATE TABLE IF NOT EXISTS persistence_audit( id INTEGER PRIMARY KEY CHECK(id = 1), revision INTEGER NOT NULL DEFAULT 0, dirty INTEGER NOT NULL DEFAULT 0, last_operation TEXT, last_status TEXT, last_error TEXT, sqlite_integrity TEXT, graph_count INTEGER DEFAULT 0, event_count INTEGER DEFAULT 0, folder_count INTEGER DEFAULT 0, api_count INTEGER DEFAULT 0, updated_at TEXT ) z INSERT OR IGNORE INTO persistence_audit( id, revision, dirty, last_operation, last_status, sqlite_integrity, updated_at ) VALUES (1, 0, 0, 'init', 'ok', 'unknown', ?) )r.r*r'rr-r(s rensure_persistence_audit_schemarsQ    $  YL  ; s =A A)cfURS5R5SnURS5R5SnURS5R5SnURS5R5SnXX44$![a SnN5f=f![a SnN$f=f)NrrrzSELECT COUNT(*) FROM foldersr)r'rrM)r)rr folder_countrs rpersistence_counts_sqlr@s++;<EEGJK++;<EEGJK{{#ABKKMaP KK CDMMOPQR  \ <<    s$"B)"B! BB! B0/B0c[5 [5nURS5R5Sn[ U5upgpUS:H=(a US:Hn [ 5n URSU(aSOSUU (aSOS[ U=(d S5UUUUU U 4 5 UR5 SSS5 W [U5UU (aSOS[ U=(d S5WWWWW W S. $!,(df  N@=f) Nrrr2a UPDATE persistence_audit SET revision = revision + 1, dirty = ?, last_operation = ?, last_status = ?, last_error = ?, sqlite_integrity = ?, graph_count = ?, event_count = ?, folder_count = ?, api_count = ?, updated_at = ? WHERE id = 1 rprrY) r2r9 operationr:rrrwrrrr) rr*r'rrrr=r-bool) rr9r:rr)rrrrrr2rs rr<r<Qs#% KK 89BBDQG  Y   EKR  ! : G Le$'U[b!%  K s BC++ C9cT[5 [5nURS5R5Sn[ U5up#pEURS5R5nU(a [ U5O0nUS:H=(a UR SS5S:H[UR SS55UR SS5UR SS 5UR SS 5UR S S 5UUUUUUR S S 5S . sSSS5 $!,(df  g=f) Nrrz,SELECT * FROM persistence_audit WHERE id = 1r2 last_statusr9revisionlast_operationrY last_errorr) r2r9rrrrrrwrrrr)rr*r'rrr[r\r)r)rrrrrrr3s rpersistence_status_sqlrs#% KK 89BBDQG */=")E)K(R(R(T$g,,,.!+.446I/ =J(* 0B  WG,)U&  $**U$G P  o rZq>sT 22E #ENE #<!- sD-K80B>L/=L ,C3L8L  L  LLLL L-c [U=(d 05nURS5(a[SURS5S.5 [5 [ SSSS9$![ an[ SSS [ U5S 9sS nA$S nAff=f) z Autosave barrier. It first persists UI state when present, then verifies SQLite and regenerates the HTML. It does not fabricate application data. ui_stater)r`rSautosaverr2r8rpr)r9r:rN)r[r\rrHr<rMr=)rrs rautosave_session_sqlrs7=b!G ;;z " " %  Z0'  ' !DII  ' c(    sAA B(B<BBc[05$)zC Manual Save button uses the same real autosave verification path. )rrrrrrs  ##rc[5 SSSSSSSSSSSSSSSS.n[5nURS5R5Vs/sHnUS PM nnU(d /sSSS5 $S R U5nURS US 35R5n/nUHn[ U5nUR 5HupURX5 M S U;a5URS 5=(d URS5=(d SUS '[URS55US'URU5 M URSS9 UsSSS5 $s snf!,(df  g=f)a Schema-tolerant API registry reader. It reads the actual api_registry columns present in SQLite and fills missing operational fields with safe defaults. This prevents /api/health from failing when older databases do not yet contain last_status, last_latency_ms, last_run_at, etc. NrunknownrYTGET)rlast_latency_ms last_run_at last_inserted last_updated last_skippedr:raw_jsonrrenabledmethod target_graphendpointrPRAGMA table_info(api_registry)r, zSELECT z FROM api_registryrrrrc[URS5=(d S5[URS5=(d S54$)NrrYr)r=r\)rs rlist_apis..[s-AEE&M$7R 8#aeeDk>OR:PQr)r`) r.r*r'rerr[r~rr\rrqsort) wanted_defaultsr)rcols select_colsrlrrur`r_s r list_apisr"szO$ [[!BCLLN N fIN   iio {{k]"4 5 (* A7D / 5 5 7 -!84!XXf-N*1ENT "488I#67DO JJt  QR;   s$"E) E$ E),C.E)$E)) E7c@[5 [U=(d 05n[URS5=(d% S[R "5R SS35n[URS5=(d U5nURSS5(aSOSn[URS 5=(d URS 5=(d S 5n[URS 5=(d S 5R5n[URS5=(d S 5n[URS5=(d S5n[URS5=(d S5n UU[U5UUUUU S.UEn [5n [5n U RS5 U RSX#XEXgX[R"U SSS9X4 5 U(a [XUS5 U R!5 SSS5 U $!,(df  U $=f)NrAPI_r rrTrprrrrYrrrinterval_seconds,r: registered)rrrrrrrr:r/a INSERT INTO api_registry(id, name, enabled, target_graph, method, endpoint, interval_seconds, status, raw_json, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET name=excluded.name, enabled=excluded.enabled, target_graph=excluded.target_graph, method=excluded.method, endpoint=excluded.endpoint, interval_seconds=excluded.interval_seconds, status=excluded.status, raw_json=excluded.raw_json, updated_at=excluded.updated_at Frbr)r.r[r=r\rrhexrrrrr*r'rfrirr-) rr3rrrrrrintervalr:rTrr)s r upsert_apir`s  2 D $AT$**,*:*:3B*?)@#A BF txx)6 *D88It,,a!Gtxx/J488G3DJKL (#,u - 3 3 5F488J'-2.H488./637H (#3| 4F=$$   C B  %&  7&H ZZ%4 @" J! &  < Q / 0 J1 0 Js "A"H Hc[5nURS5R5Vs/sHnUSPM snsSSS5 $s snf!,(df  g=f![a /s$f=f)Nrr)r*r'rerM)r)rs rapi_registry_columnsrsk \S%FGPPRRA& R\\  s= A"AA A A A AAA A.-A.cU(d0$[U[5(aU$[U[5(a0[R"U5n[U[5(aU$0$0$![ a 0s$f=fr0)rZr[r=rfrgrM)rSparseds rparse_json_objectrsp  % % ZZ&F'556 =2 = I I s,A($A(( A76A7c0n[U[R5(a [U5n[U[5(a<[ UR S55nUR U5 UR U5 URSUR S5=(d UR S5=(d S5 URSUR S55 URSS5 URSS 5 URSUR S 5=(d S 5 URS UR S 5=(d UR S5=(d S 5 URSUR S5=(d S5 URSS5 URSS 5 URSS 5 [UR S55US'U$)zw Normaliza una fila de api_registry mezclando columnas reales y raw_json. Esto permite soportar bases viejas y nuevas. rrrrrrTrrrrYrrrr:rrrNrr) rZr"r%r[rr\rQrr)rrurTs rnormalize_api_rowrs^ D#w{{##3i#t 34 C COOD$((6*Kdhhz.BKeLOOFDHHTN+OOIt$OOHe$OOJ 526OONDHHW$5$N%$NBOOOHdhh}5BCOO%t,OOM2&OOL"%488I./DO Krc [5 [U5n[5nU(dSSS.$[5n[ 5nUR S5 UR SX45R 5nU(dUR5 SSUS.sSSS5 $0nUR5HupxXr;dM XU'M S U;aX6S 'U(ahS RUR5V s/sHoS 3PM sn 5n [UR55US /-n UR S U S3U 5 SU;ad[SUR5;aUSOS5n U RU5 X  775>      eg rc[URS5=(d S5R5R5nUS;agU$)Nrr)rHEAD)r=r\rrK)rrs rsafe_api_methodr*s> "+e , 2 2 4 : : _]_`!#&#  D 779  "X!* &W  "X!* *W  h F }}--#X!+ 5W  !G/! +C0"3'  S *c4,,.8D@AGgc8Q7M3;;=MANK"- !( k'C'!)X)1%& $W  )c)!+X)3%&"2;- @W !+X)3%&"' } 5W %+T   >]+ .^,G}*n- 01  Kq+ *( ;t((*W4<=!'#vq"9">Q?]$\#X!+ $T-%8$9:W 9t((*W4<=$\#X!+ GC378W !t((*W4<=$\#X!+ CW !$   K sd?&J'%B8JJ'&.O J$ J'$J'' O 1AL O "A M33 O AOO  OOc U(dg[U5R5n[URS5=(d S5[URS5=(d S5[URS5=(d S5[URS5=(d S5[URS5=(d S51nX;$)NTrrYrrrr)r=rKr\)rrrvs rapi_matches_graphr5s  J   E CGGN # )r* CGGG  "# CGGEN b! CGGFO !r" CGGDM R J  rc[5 [5Vs/sHn[U5PM nnUVs/sHn[X5(dMUPM nnUVs/sHn[ U5PM nnU(dSnOP[ SU55(aSnO6[ SU55(aSnO[ SU55(aSnOSnSUU[ 5[U5US .$s snfs snfs snf) z[ Endpoint backend para el sensor real: GET /api/apis/status GET /api/apis/status?graph=ISS rc30# UH oSS:Hv M g7fr:r!Nrr^rs rr`!api_status_sql.. 81x[J &r!c30# UH oSS:Hv M g7fr:r'Nrr9s rr`r:r;r<r'c30# UH oSS:Hv M g7fr:rNrr9s rr`r: 7w!x[I %wr<r&Tr2rr: checked_atcountrr.rrr5r3rhrrtrrrselectedresultsoveralls rapi_status_sqlrJs ; C #    S ( t C s#   8 8 8 8 8 8 8 8 7w 7 7 7iW  5   sC!C& C&C+c[U5n[U5nU(d [S5e[U5nURS;a [S5e[ U[ U5[U5S9n[XAS9nURS5nSSS5 WRSS S 9n[R"U5$!,(df  N5=f![a S U0s$f=f) z2 Descarga JSON desde la API. Se usa por sync_api. zAPI endpoint is requiredrr"r#r iNutf-8r&)errorstext)rrr!rr+r rrr readdecoderfrgrM)rr!rrr0r1rTrNs rfetch_api_jsonrQs C C$H 344 h F }}--677 ',s# C  &#hh{# ' ::gi: 0Dzz$ ' & ~s5B6 C6 CCCc[U[5(aU$[U[5(a6SH-nURU5n[U[5(dM+Us $ U/$SU0/$)z= Convierte respuestas comunes de APIs en una lista de items. )rr~rHr3rrS)rZrrr[r\)rr`rws r payload_itemsrS sf'4  '4  DC++c"C#t$$ E y g  rc[U5n[U[5(dSU0n[UR S5=(dJ UR S5=(d2 UR S5=(d UR S5=(d S5n[UR S5=(d UR S5=(d S5n[ U5upV[ USS 5n[U5nU(aUuppn US U 3nU nO=[[ US US US -355n[U=(d [5SS5n[X5(a*U(a SUS3nOSU;aSUR S53n[XU5n[[ USS 55nU(d[R"USSS9n[[ US[R"[R"USSS9R!S55R#5SS55nUR S5=(d USU3UUUUUUU[[ USU55UU[%U5UUS.$![a [U5nNf=f)u3 Mapeo tolerante API → evento canónico GRAFO_D. rSrrrrAPIr)rrrrrrPrYz position )rrrrz event rpNrz ISS position rr)rrrsummaryrNmessageFTrb)rrrrrLr1)rrr.)rrrrrrrr~rrrrrr)rrZr[r=r\r|rarWrrrrfrirMhashlibsha1encode hexdigestr)rruindexrrrjrlraw_timerrrrPrQrRr event_dater~r source_ids revent_from_api_itemra s| C C dD ! !   777   775>  776?   L3776?I?c [5 [U5n[5Vs/sHn[U5PM nnSnUHCn[UR S55U:Xd [UR S55U:XdMAUn O U(dSUSS.$[ U[ S9nUSS ;a"SUUS S S UR S 5=(d S S .$[U[ S9n[U5nS nS nS n [U5Hup[XU S9n [U SS9n U R S5nUS:XaUS- nOUS:XaUS- nOU S- n [5nURS[UR S5=(d U5[U R S55[U=(d S5[545 UR5 SSS5 M [#UUUU S[5S9 [%5 SUUUUU S.$s snf!,(df  GM=f![ a GM)f=f![ a U S- n GM@f=f![ a N`f=f)u Sincronización tolerante de una API registrada. - Verifica conectividad real. - Si responde, intenta leer JSON. - Normaliza items a eventos. - Inserta o actualiza eventos en SQLite. NrrFz API not found)r2rrr r:)r&r'rrzAPI not reachable)r2rr:rGrFr{r)r]TrJrHrGrprFz INSERT OR IGNORE INTO api_ingest_log( api_id, event_legacy_id, action, created_at ) VALUES (?, ?, ?, ?) upsertr&)rrrr:r)r2rr:rGrFr{)r.r=rrr\r3API_SYNC_TIMEOUT_SECONDSrQrS enumeraterarNr*r'rr-rMr rH)rrrrr:rr~rGrFr{r]rurresultrHr)s rsync_apirhv su [F; C #   C y}}T" #v -Y]]65J1Kv1UC  $  $C1I JF h55ZZ(?,?  S*BCG ' "EHGG ' " '?E%e$?FZZ)F#A 9$1 1  \SKK  78 $0 2(3#I  JJL"\(J   "      u l"\     qLG     sgG7:AH!= HA:G<HH8< H H H HH!HH!!H54H58 IIcl[5n[R"5nUHnURS5(dMURS5nU(dM5[URS5=(d S5nURS5nSn[ U[[ 45(aU[ U5- U:nU(dM[ USXRS5=(d S S 9 [US5 M [R"S 5 GM![a Mf=f![a N6f=f) NTrrrrlast_run_epochrr: scheduled)rjr:r) rrr\rrZrLr rhrMsleep)rnowrrrlast_rundues rapi_poll_workerrp s  ;D))+Cwwy))77:.sww'9:AcB77#34he 55h/8;C3"3t9SQYIZIi^ij T+( 1 1 (%   s<B=D&%D&*D8D& D#D&"D##D&& D32D3cr[(agSq[R"[SS9nUR 5 g)NTrA)_api_worker_startedrDrErprF)ts rstart_api_worker_oncert s,=AGGIrcP^\rSrSrS SjrSrU4SjrSrSrSr Sr S r U=r $) Handleri c2[R"USSS9RS5nURU5 UR SS5 UR S[ [ U555 UR5 URRU5 g)NFro)rcindentrLz Content-Typezapplication/json; charset=utf-8Content-Length) rfrir[ send_response send_headerr=rt end_headerswfilewrite)selfobjr)r3s r _send_jsonHandler._send_json suzz#E!<CCGL 4  )JK )3s4y>:  rc[URRSS55nU(a>[R"UR R U5RS55$0$)Nry0rL)rr r\rfrgrfilerOrP)rrs r_payloadHandler._payload sL    !137 8ABtzz$**//!,33G<=JJrc >[UR5nURn[UR5nUS;a[ 5nUR U5 gUS:XaUR [ 55 gUS:XaISnURS5(aURSS/5Sn[US9nUR U5 g[5nUS:XaUR U5 gUS :Xa[5nUR U5 gUS :Xa"UR URS /55 gUS :Xa"UR URS /55 gUS:Xa"UR URS/55 gUS:XaURS /5Vs/sH%n[URS55S:wdM#UPM' nnUR S[[5[U5[[ 55UR5S.5 g[ T U]E5$s snf![a(nUR S[U5S.S5 SnAgSnAff=f)N)z/api/autosave/statusz/api/persistence/status /api/apisz/api/apis/statusrYrr)rz/api/db/api/session/save /api/eventsr /api/graphsrwz /api/alertsalertsz /api/healthr__AXIS__T)r2dbrrrFr)rpathr queryrrrr\rJr1rr=r$rtrrMsuperdo_GET) r parsed_urlrrrgrre graph_events __class__s rrHandler.do_GET s&dii( ))*9 JJ/1'{" ,))99W%%!IIgt4Q7E'e4'By #**)+'}$x 45}$x 45}$x 45}$!vvh3 3!155<(J63 b'!,/ ,(,(=(=(? !%$w~#   OO53q6:C @  sa!H/H/;AH/ !H/,!H/'H/6'H/'H/H/ "H*H* AH/*H// I!9II!c[5nURS5R5SsSSS5 $!,(df  g=f)Nrr)r*r'r)rr)s rrHandler.sqlite_integrity^ s. \S;;78AACAF\\s "7 Acl[UR5RnUR5nUS:Xa7SSKJn U"5nUR XDR S5(aSOS5 gUS:XaqSSKJn U"[5nUR S5(aUR S 5(a [S S 9 UR XDR S5(aSOS5 gUS :Xa'[U5n[5 UR U5 gUS :Xa+[U5n[5 UR SS 0UE5 gUS:Xa*[USS9n[5 UR SS 0UE5 gUS:Xa'[U5n[5 UR U5 gUS:Xa'[U5n[5 UR U5 gUS:Xa [U5nUR S US.5 gURS5(aGUR!S5(a1UR#S5Sn[%U5nUR U5 gUS:Xa[5 UR S S S.5 gUS;a-['S[)5;aUO05nUR U5 gUR SSS.S5 g![*a;nS [-U5;aS!OSn UR S[-U5S.U 5 SnAgSnAf[.a(nUR S[-U5S.S"5 SnAgSnAff=f)#Nz/api/import/graph-inbox/previewr)preview_graph_inboxr2r%rz/api/import/graph-inbox)import_graph_inboximportedTrGz /api/ui-staterz /api/ingestFrcz /api/foldersrrr2r /api/apis/z/sync/z /api/render)r2rendered)z/api/autosave/saverrunknown endpointr duplicateir)rrrrrrr\r$rHrr6rNrrrr]endswithrrhrlocalsr!r=rM) rrrrrgrrrrr)s rdo_POSTHandler.do_POSTb s "''M AmmoG88B,.zz$/?/?SI00A+B/::d## :(>(>#$/zz$/?/?SI&27;!'}$09!t 6v 67}$)'F!t 6v 67~%*73!'}$)'2!'{" )tC 89|,,w1G1GC,!&)'}$!t >?BB-fh9NgTVW' OO53EF L B%Q/3SD OO53q6:D A A A OO53q6:C @ @ AshA J>.A6J>%,J>0J>/J>3,J> ,J> %J>3AJ>$J>52J>(J>> L31K>> L3 L..L3cz[UR5RnUR5nURS5(a\UR SS5Sn[ X25nU(dUR SSS.S5 g[5 UR S US .5 gURS 5(a9UR SS5SnXRS '[U5nUR S US .5 gUR SSS.S5 g![a(nUR S[U5S.S5 SnAgSnAff=f)N /api/events/rrpFevent not foundrrTr;rrrrr) rrrr]rsplitrSrrHrrMr=)rrrrrrrrs rdo_PATCHHandler.do_PATCH s "'' AmmoG~..;;sA.r2(;OO5;L$MsS!te <=|,,S!,R0 &  )tC 89 OO53EF L A OO53q6:C @ @ As+A"DD#AD2D D:D55D:c[UR5RnURS5(aZURSS5Sn[ U5(dUR SSS.S5 g[ 5 UR S US .5 gURS 5(aIS S KJn U"URSS5S5n[U/5n[ 5 UR U5 gURS5(a<URSS5Sn[U/S S9n[ 5 UR U5 gURS5(aURSS5Sn[5nURS5 URSU45n URSU45n UR5 SSS5 [ 5 UR S UW RW RS.5 gUR SSS.S5 g!,(df  NY=f![a(n UR S[!U 5S.S5 Sn A gSn A ff=f)NrrrprFrrrT)r2rkz /api/folders/rrsz /api/graphs/)rrr/rr)r2rkrrrr)rrr]rrVrrHr|rtrrr*r'r-rUrMr=) rrrrtrrgrrr)cur_logsrrs r do_DELETEHandler.do_DELETE s "''6 A~..;;sA.r2'11OO5;L$MsS!t AB//0%dkk#q&9"&=> 1;-@!'~..++c1-b1*G9TB!'|,,S!,R0\SKK 12"{{E  H++? CJJL" !%$'LL(0(9(9 !  OO53EF L+"\. A OO53q6:C @ @ AsQAH#2H#AH#0AH#5H#7AH? returncodestderrstdoutrK RuntimeErrorrisdigit) rr!rrr/cmdprocr2errrrs r_v55b_probe_with_curlr9 s C C$H +,, h F }}--677!G     $ CL C >> I !  D4$$&0D89G !{{/dkk/R6683DN4??2C"DEE [[ B % % ' - - /E#(U1X-=-=-?-?#eAh-QK[&&3&" 1c1  :?{m7L  rc>[U5n[URS5=(d URS5=(d S5n[URS5=(d U5n[U5nUU[ URS55[URS5=(d2 URS5=(d URS5=(d S5U[ U5S S S S [ 5S S S . nURS5(dS US 'S US 'SUS'U$U(dS US 'S US 'SUS'U$/nS n[XS9nU(aURS5US'URS5US'URS5US'URS5(aSUS 'SUS 'S US'O[URS5=(d S5n SU s=::aS:a.O O+SUS 'SUS 'URS5=(d SU 3US'ORSUS 'SUS 'URS5=(d SU 3US'O'SUS 'SUS 'U(aSRU5OS US'[UUS USUSUS!US=(d SUS!US S"9 U$![aknURS[U5-5 [XS9nS nAGN![a,n URS[U 5-5 S n A S nAGNS n A ff=fS nAff=f![a U$f=f)#zv V55B robust real API connectivity check. Fixes false inactive state when urllib times out but curl succeeds locally. rrrrrrrrYrN) rrrrrrr:rrrrrrr:rrrrr zurllib: zcurl: rrrr2r&rrrr'r(r!z | z probe failedrr*)rr=r\rrrrrrMrqrrrr ) rr!rrrrrMproberexc2 status_codes rr3r3m s C C :#''&/:U ;F swwv(& )D$H *+CGGN3_swww7G_377SX>_]_`!#&#  D 779  "X!* &W  "X!* *W  F E0'= #ii 6]"YY|4\!IIk2[ 99T??%DN%-D! " DMeii 6;!]+ .^,G}*n- 01  K_ 0 j3s8+, 0)#?E 0 MM(SY. / / 0 0X   K sN J&.L L  L> K  LK>4L>LLL  LLc[5 [5Vs/sHn[U5PM nnUVs/sHn[X5(dMUPM nnUVs/sH n[ USS9PM nnU(dSnOP[ SU55(aSnO6[ SU55(aSnO[ SU55(aSnOS nS UU[ 5[U5US .$s snfs snfs snf) zL V55B endpoint backend: GET /api/apis/status GET /api/apis/status?graph=ISS rr rc30# UH oSS:Hv M g7fr8rr9s rr`r: r;r<r!c30# UH oSS:Hv M g7fr>rr9s rr`r: r;r<r'c30# UH oSS:Hv M g7fr@rr9s rr`r: rAr<r&TrBrErFs rrJrJ s  ; C #    S ( t C sB/   8 8 8 8 8 8 8 8 7w 7 7 7iW  5   sC C% C%C*__main__rpi="rz%GRAFO D API server: http://127.0.0.1:z1/outputs/timeline_excel_like.html?v=sqlite_serverz 127.0.0.1)F)rY)Nr)T)rrr2rYr0)r)r)r)grYrfr"r9r;rDrrrrpathlibr http.serverrrr|rr urllib.requestr r urllib.errorr r grafo_d_sqlite_adapterr__file__resolveparentr>r$r6ALLOWED_UI_KEYSrerrLockr8rr*r.r1rHrWrar|rrr,rrrrrrr+r6rDrNrSrVrqrrrrrrrrrrr<rrrrrrrrr rrrr3r5rJrQrSrarhrprtrvrrrrtargvrportprint serve_foreverrrrrsg   'E++,0 H~&& J22 & &M~~ >2 ;48 T (#L  " %Rk8\qlWt.-b/d  (XqhXv4.W(t=*@TvD4N&VD="4n 4Z3z 8$:|/h">9;x,tn")X!9@ $Yxnh8|A&|AH# L1h\~)\ z"388}q03sxx{ dD$ 1$7h ijd+W5CCE r