ܒ$jk ddlZddlmZddlmZddlmZddlZdZdZ dZ dZ d Z d Z d Zd Zgd ZeZeeeredgZneeereZngZdZdZdZeedeDZiZeD]DZdeDZe deDZ!e"deDZ#e!e#rdndzee<Ee$eejZ%deDZ&ere$deDndZ'e$de&DdZ(e'e(kr<edeDZ)dZ*e)pe*gD]Z+e&,e%e+e(dze'dd eDZ-iZ.e-D]$Z/e.0e/d!e/d"%iZ1eeer,ed#id$ipiZ1e12D]\Z3Z4e3e.vre4re4e.e3<eZ5e52D] \Z3Z4e4pe3e.e3< eed%e-Dee56zd&Z7e$d'eDdZ8e e8e zzd(zZ9e e:e7ezzd(zZ;gZ<e=e7D]R\Z>Z?ee>e:ezZ@eee.e?ZAe<,d)e@d*e?d+eAd,SgZBe-D]Z/e7Ce/d!Z>ee>e:ezZ@e/d-p@e/d.p+e/d/pe/d0pd1ZDe/d2pe/d3pd1ZEeB,id4ee/d4d5e/d5d1d!eFe/d!d6eFe/d6pe/d!d"ee/d"d7ee/d7pe/d"d8e/d9d:e/d;d9e/d9d;e/d;dd>ee/d>pe/d=d?e/d?pe/d@pd1dAe/dApe/dBpd1dCe/dCpe/dDpd1dEee/dEpe/dFee/dEpe/dFee/dGpe/dHee/dGpe/dHeeDeeDeeDeeDee/dIee/dIpe/dJeeEeeEdK dLe&DZGdMe7DZHd1IgdNe9dOe;dPe9dQe;dRe dSe8e zdTedUedVd1Ie<dWejJeGdXYdZejJeBdXYd[ejJeHdXYd\e9d]e;d^e d_ed`e dae dbe dce dde dee dfe dgedhe die dje dkZedlKdmneLe dodpq5ZMeMNedddn #1swxYwYeOdre dsZPee ZQeQRdpqZSdteSvr=eSTduePdvzZSeQUeSdpqeOdwe n eOdxe dyZVee ZQeQRdpqZSdzeSvr=eSTdueVdvzZSeQUeSdpqeOd{e n eOd|e d}ZWee ZQeQRdpqZSd~eSvr=eSTdueWdvzZSeQUeSdpqeOde n eOde ddlmZXeXdZYeYZrgeYRdpqZ[de[vrMdZ\dZ]e[Tde\dzZ[e[Tdue]dvzZ[eYUe[dpqddlmZ^e^dZ_e_ZrWe_RdpqZ`de`vr=dZae`TdueadvzZ`e_Ue`dpqeOdddlmZbebdZcecZrecRdpqZddedvrdZeedTdeedzZddedvrdZfedTddefzdzdZddedvrdZgedTduegdvzZdecUeddpqeOdddlmZhdZieiddlmZjdZkekddlmZldZmemddlmZnddloZpdZqeqddlmZrddloZsdZtetddlmZuddloZvdZwewddlmZxddloZydZzezddlmZ{dZ|e|ddlmZ}ddloZ~dZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZeddlmZddloZdZedS)N)Path)escape) load_database DATABASE/GRAFO_D_DATABASE.sqlite outputs/timeline_excel_like.htmlx.i&8) z#1d7afcz#43a047z#f4511ez#8e24aaz#e53935z#00a6a6z#5145cdz#d29600z#d81b8az#795548eventscL|dSt|S)N)strstrip)vs render_excel_like.pycleanrs yr q66<<>>c ttt|dd}d|cxkodkncS#t$rYdSwxYw)N~riPLi'F)intfloatrreplace Exception)rxs r is_year_valuer$sv eAhh&&sB//00 1 1""""d""""" uusA A AAc&td}i}|s|Stjt |}tj|_ |d}|D]]}t |dpd }t |dp| }|r|p|||<^ | n#| wxYw|S)z Load graph rows directly from SQLite graphs. A graph with zero events must still be visible as a graph/container. It must not fabricate a timeline component. rz4SELECT row_key, visible_name FROM graphs ORDER BY idrow_keyr visible_name) rexistssqlite3connectrRow row_factoryexecutefetchallrclose)db_pathlabelsconrowsrowrr s r'load_sqlite_graph_labels_for_empty_rowsr.,s 566G F >>   /#g,, ' 'CkCO {{ B  (**  : :C#i..B//5577Gs>2=g>>DDFFL :"."9'w  :  Ms BC88Dc#&K|] }|dV dSr-N.0es r r5Ls&++q!E(++++++rc@g|]}|dtk|dSr-namerr2s r r;Ps% 7 7 7!5QAfIrc#8K|]}t|dVdS)N)rr3rs rr5r5Qs/<s rr5r5Rs>QQq588##C,,0BBQQQQQQri)keyc^g|]*}|dtkt|d(|+Sr7)axis_rowrr2s rr;r;WsB x8 ai 8 8rc#BK|]}|ddVdSend_colrNgetr2s rr5r5^s088AAEE)Q''888888rc#BK|]}|ddVdSrErGr2s rr5r5_s0==AAEE)Q''======r)defaultch|]}|ddtk!t|dddd^t|ddddS)rFrdaterN)rH max_axis_colrisdigitr2s r rPbs 55A   - -#aeeFB6G6G2H2H!2L2T2T2V2V - AEE&"  rr" - - -r2026r=)r-r8 start_colrFc4g|]}|dtk|S)r-)rCr2s rr;r;rs1 x8rr-r8ui_state graph_labelsc#&K|] }|dV dSr0r1r2s rr5r5s&''Q%''''''rcvtt||S)N)r row_labelsrHlowerr9s rrZs(% q!,,--3355rc#&K|] }|dV dS)rFNr1r2s rr5r5s&,,q|,,,,,,ri z+ brief_descriptionbriefBRIEF descriptionrapi_textapiiddb_idr event_namestartrRendrFcolorrL date_textyear date_yearmonth date_monthdaydate_dayplacePLACEwhoWHO source_linksource) rprqrrr_r]r^r\rsrtrar`c g|]a}t|ddd|d|dt|d|dzdz dz tzzdbS)r8z.0rrRrFr=)r8rerfr)rrLEFT_PADCELL_Wr2s rr;r;s ai  ((r22;| !K.1Y<71rzs< FFE*Q- ru GRAFO D - Línea Temporal Inteligente
GRAFO D — Línea Temporal Inteligente
TIMELINE
outputsT)exist_okwutf-8encodinguVisualización generada:u)
Technical Card
LIVE API SENSOR
NO GRAPH SELECTED
Open a graph event to inspect API runtime state.
grafoD_eventMeta_v1 zTechnical Card inyectada en:z&Technical Card ya estaba inyectada en:u#
Graph Technical Card
grafoD_folderMeta_v1z'Safe folder technical card injected in:z(Folder technical card already exists in:a grafoD_search_hard_fix_v1zSearch hard fix injected in:z"Search hard fix already exists in:grafoD_graph_set_cards_v1a u9  GRAFO_D_GENERIC_API_SENSOR_V1a z#Generic API status sensor injected. GRAFO_D_LIVE_API_SENSOR_STYLE_V3a zid="liveApiSensor"ag
LIVE API SENSOR
NO GRAPH SELECTED
Open a graph event to inspect API runtime state.
z z z GRAFO_D_LIVE_API_SENSOR_V3u zLive API sensor V3 injected.c td}|sdS|d}d}||vrdSd}d|vr|d|dz}n|dz|z}||ddS) NrrrV47_MANUAL_ELEMENT_CONTEXT_MENUu' rr )_V47Pathr! read_textr write_text html_pathhtmltoken injections r'_v47_inject_manual_element_context_menurS s;<??d{Y& 00000rc td}|sdS|d}d}||vrdSd}d|vr|d|dz}n|d|zz }||ddS) Nrrr&V47B_FORCE_MANUAL_ELEMENT_GRAPH_RENDERa+ rrr) _V47BPathr!rrrrs r&_v47b_inject_force_manual_graph_renderr s<==I          0 0D 4E }}JIXD||Iy;'>?? y   00000rc td}|sdS|d}d}||vrdSd}d|vr|d|dz}n|dz|z}||ddS) NrrrV49_SAVE_BUTTON_REPLACES_CLEARa  rrr) _V49SavePathr!rrrrs r&_v49_inject_save_button_replaces_clearrs?@@I          0 0D ,E }}vIpD||Iy;'>??d{Y& 00000rctd}|sdS|d}tjdd|tj}d}tjd||tj}tjd ||d tj }d }||vr||ddSd }d|vr|d|dzn|dz|z}||ddS)Nrrrz0]*id="V49[A-J][^"]*"[^>]*>.*?rflagszzN\s*(Save|Limpiar|Clear)\s*z6]*>.*?r=countr(V49K_SINGLE_STABLE_TOP_RIGHT_SAVE_SENSORuL rrr) _V49KPathr!r_v49k_resubSIrr)rrbuttonrrs r0_v49k_inject_single_stable_top_right_save_sensorrsH<==I          0 0D <;  j    DTF <Y j    D <A j    D 7E }}TG444ZIx@ID?P?P4<< 9{#: ; ; ;VZ]aVadmVmD 00000rc2td}|sdS|d}tjdd|tj}tjdd|tj}||ddS)NrrrzB]*id="V48_PHYSICAL_DELETE_UI_OVERRIDE"[^>]*>.*?rrz?]*id="V50[^"]*(FOLDER|folder)[^"]*"[^>]*>.*?) _V51CleanPathr!r _v51_clean_rerrrrrs r._v51_clean_old_delete_folder_generated_scriptsrs@AAI          0 0D  M  o    D  J  o    D00000rctd}|sdS|d}tjdd|tj}||ddS)Nrrrz@]*id="V52_EVENT_CARD_CANONICAL_SAVE"[^>]*>.*?rr) _V52BPathr!r_v52b_rerrrrs r(_v52b_remove_broken_event_card_interceptr%s<==I          0 0D <K  j    D 00000rc>td}|sdS|d}tjdd|tj}d}d|vr|d|d z}n|d |zz }||ddS) NrrrzD]*id="V52C_MASTER_SAVE_FLUSH_OPEN_CARDS"[^>]*>.*?rrav rrr) _V52CPathr!r_v52c_rerrrrrrrs r)_v52c_inject_master_save_flush_open_cardsr@s<==I          0 0D <O  j    DoIbD||Iy;'>?? y   00000rc|td}|sdS|d}d}||vrdSd}d}d|vr|d|dzd }n|d z|z}d |vr|d |d zd }n|d |zz }||dt d dS)Nrrr-GRAFO_D_V55_FRONT_FIELDS_AND_API_SENSOR_FINALa~ uHE rrr=rrrz4V55 final front fields/API sensor override injected.) _V55FinalPathr!rrrprint)rrrcssjss r'_v55_inject_front_fields_and_api_sensorrs@AAI          0 0D ;E }}. C`^ B@D||Is['8!<<TzD D||IrK'7;; r  000 @AAAAArc"td}|sdS|d}tjdd|tjtjz}tjdd|tjtjz}d}tjd |tjr'tjd |d z|d tj }n||z }||dtd dS)NrrrL]*id=["\']V56_GRAPH_INBOX_IMPORT_BUTTON_STYLE["\'][^>]*>.*?rrH]*id=["\']V56_GRAPH_INBOX_IMPORT_BUTTON["\'][^>]*>.*?u rr=rz'V56 graph inbox import button injected.) _V56Pathr!r_v56_rerrrsearchrrrs r%_v56_inject_graph_inbox_import_buttonrs;<]*id=["\']V57_IMPORT_BUTTON_VISIBLE_HOTFIX["\'][^>]*>.*?rra rrr=rz-V57 import button visibility hotfix injected.) _V57Pathr!r_v57_rerrrrrrrrpatchs r _v57_force_import_button_visiblers;<>t|d" 000 9:::::rctd}|sdS|d}dD]1}tj|d|tjtjz}2d}tjd|tjr'tjd d |z|d tj }n|d z|z}||dtddS)Nrrr)rrrzG]*id=["\']V58_STATIC_IMPORT_BUTTON_STYLE["\'][^>]*>.*?J]*id=["\']V58_STATIC_IMPORT_BUTTON_SCRIPT["\'][^>]*>.*?z8]*id=["\']v58GraphInboxHost["\'][\s\S]*?\s*rru-
z ]*>z (]*>)z\1\nr=rrz&V58 static Import TXT button injected.) _V58Pathr!r_v58_rerrrrrrrrpatternrs r_v58_static_import_buttonrs;<]*id=["\']V59_IMPORT_BUTTON_NEXT_TO_SAVE["\'][^>]*>.*?rra rrr=rrz)V59 Import TXT button moved next to Save.) _V59Pathr!r_v59_rerrrrrrrs r_v59_import_button_next_to_savers;<]*id=["\']V60_IMPORT_BUTTON_SAVE_ALIGNED["\'][^>]*>.*?rra rrr=rrz+V60 Import TXT button aligned next to Save.) _V60Pathr!r_v60_rerrrrrrrs r_v60_import_button_save_alignedrs;<]*id=["\']V61_IMPORT_BUTTON_ATTACH_TO_SAVE["\'][^>]*>.*?rrR]*id=["\']V61_IMPORT_BUTTON_ATTACH_TO_SAVE_SCRIPT["\'][^>]*>.*?aL rrr=rrz'V61 Import TXT button attached to Save.) _V61Pathr!r_v61_rerrrrrrrs r!_v61_import_button_attach_to_savers;<]*id=["\']V62_IMPORT_BUTTON_FIXED_NEXT_TO_SAVE["\'][^>]*>.*?a3 rrr=rrz)V62 Import TXT button fixed next to Save.) _V62Pathr!r_v62_rerrrrrrrs r%_v62_import_button_fixed_next_to_saversL;<]*id=["\']V63_MULTILINK_SOURCE_FIELD_STYLE["\'][^>]*>.*?zL]*id=["\']V63_MULTILINK_SOURCE_FIELD_SCRIPT["\'][^>]*>.*?zI]*id=["\']V64_MULTILINK_SOURCE_FIELD_STYLE["\'][^>]*>.*?zL]*id=["\']V64_MULTILINK_SOURCE_FIELD_SCRIPT["\'][^>]*>.*?z<]*id=["\']v64SourceLinksPreview["\'][\s\S]*?\s*rrc dS)Nucr1)matchs rreplace_source_inputz>_v64_multilink_source_field_safe..replace_source_inputs K  rz0]*\bid=["\']techSourceLink["\'][^>]*>r=rzC(]*\bid=["\']techSourceLink["\'][^>]*>.*?)c2|ddzS)Nr=z'
group)ms rrZz2_v64_multilink_source_field_safe..s!''!**IIra rc:dz|dzSNrrrrrs rrZz2_v64_multilink_source_field_safe..%$,+rz1V64 multiline source links field injected safely.) _V64Pathr!r_v64_rerrrrr)rrrrrs @r _v64_multilink_source_field_safersU;<>>>>rctd}|sdS|d}dD]1}tj|d|tjtjz}2tjdd|d tjtjz }d tjd fd |d tj }||dtddS)Nrrr)rrzO]*id=["\']V65_IMPORT_BUTTON_DIRECT_ONCLICK_STYLE["\'][^>]*>.*?zR]*id=["\']V65_IMPORT_BUTTON_DIRECT_ONCLICK_SCRIPT["\'][^>]*>.*?rrz2]*)>zt