iY d Z ddlZddlZddlZddlmZmZ ddlmZ ee Z dde
dz de
fdZ de
de
fd Z d
e
de
fd Z
de
fd Zd
e
de
fd
Zy)z/
Helper functions for the Deep Analysis Agent.
N)datetimedate)
get_loggerbase_dirreturnc N | #t j j t } t j j | d }t |d 5 }|j
cddd S # 1 sw Y yxY w# t $ r"}t j d| Y d}~yd}~ww xY w)z|
Load the analytical schema markdown from file.
If base_dir is None, uses the directory containing this module.
Nzanalytical_schema.mdrz$Error loading analytical_schema.md: zCSTRICT SCHEMA: (Schema file not found. Fallback to default schema.))
ospathdirname__file__joinopenread Exceptionloggererror)r schema_pathfes D/var/www/html/userprofiledev.eatanceapp.com/deep_analysis/helpers.pyload_analytical_schemar s
77??8,Uggll8-CD
+s
#q668 $
#
# U ;A3?@TUs5 ,A9 A-# A9 -A62A9 6A9 9 B$B B$textc | syt j dd| }dj |j }|j S )z4Remove HTML tags from text and normalize whitespace. z<[^>]+> )resubr splitstrip)r ss r _strip_innerr" s:
z2t$A A 779 contentc 0 | r&t j d| t j s| S t j dd | t j t j z } t j dd | t j t j z } t j dd | t j t j z } t j d d
| t j t j z } t j d d | t j t j z } t j d
d| t j } t j dd| t j } | S )u
Convert simple HTML (h1–h3, ul/ol/li, p) to Markdown. No heavy dependencies.
Matches tags case-insensitively and allows attributes (e.g. ````).
z<\s*(h[1-3]|p|ul|ol|li)\b)flagsz]*>(.*?)c B dt | j d z dz S )Nz#
r" groupms r z#_html_to_markdown..4 s $ aggaj11F:r# z]*>(.*?)c B dt | j d z dz S )Nz## r( r) r* r, s r r. z#_html_to_markdown..: s %,qwwqz22V;r# z]*>(.*?)c B dt | j d z dz S )Nz### r( r) r* r, s r r. z#_html_to_markdown..@ s &<
33f]*>(.*?)
c < t | j d dz S )Nr( r) r* r, s r r. z#_html_to_markdown..G s ,qwwqz*V3r# z]*>(.*?)c B dt | j d z dz S )Nz- r(
r* r, s r r. z#_html_to_markdown..N s $ aggaj11D8r# z
]*>r3 z
]*>)r search
IGNORECASEr DOTALL)r$ s r _html_to_markdownr7 ( s(
"))$gR]] ff :ii"--' G ff ;ii"--' G ff <ii"--' G ff 3ii"--' G ff 8ii"--' G ff%tWBMMJGff%tWBMMJG Nr# c 8 d }t j | |d S )zGJSON-serialize query result for LLM consumption; handles datetime/date.c d t | t t f r| j S t | S N)
isinstancer r isoformatstr)objs r defaultz%serialize_sql_result..defaultZ s& cHd+ ,==? "3xr# )r? indent)jsondumps)resultr? s r serialize_sql_resultrE X s ::fga 88r# c | t | t sy| j } | syt d D ]O }| }| j dd j dd } | j dd j dd } | |k( sO n | j d d j dd } t d
D ]O }| }| j d d j d
d } | j dd j dd } | |k( sO n t d
D ] }| }| j dd j dd } | j dd j dd } | j dd j dd } | j dd j d d } | j d d j d d } | j d d! j d"d! } | j d#d$ j d%d$ } | j d&d' j d(d' } | |k( s n d)| v r| j d)d* } d)| v r| j d+d, } | j dd j dd j dd } | j d d j dd } t | } d-| v r| j d-d. } d-| v r| j S )/a
Fix LLM output so Markdown renders correctly: literal escape sequences
(e.g. \n, \", \#) are turned into real characters. Handles multiple levels
of escaping. Uses only str.replace (no regex) for speed.
Always returns a string (never None).
r z\\nr3 z\\r
z\nz\rz
z\\""z\\''z\"z\'z\\##z\#z\\__z\_z\\**z\*z\\--z\-z\\[[z\[z\\]]z\]z\\((z\(z\\))z\)z\\\z\t z
r) )r; r= r rangereplacer7 )r$ rM prevs r normalize_markdown_outputrY a s j# 6mmoG 1X//'4088$G//%.66udC d? oofd+33D$?G 1X//'3/77E//%-55eSA d? 1X//'3/77sC//'3/77sC//'3/77sC//'3/77sC//'3/77sC//'3/77sC//'3/77sC//'3/77sC d? G
//&$/ G
ooeT*G ooeT*225$?GGsSGoofd+33D$?G (G g
//(F3 g
==?r# r: )__doc__r
r rB r r core.logger_configr __name__r r= r r" r7 rE rY r# r r^ s
# ) H
US4Z
U3
U s s -s -s -`9C 9>s >s >r#