a nh @sddlmZmZmZddlmZddlmZddlm Z ddl m Z ddl m Z mZmZeZeeZeZeddZeed d d Zed ee fed ddZdS)) APIRouterRequestDepends)RedirectResponse)Jinja2Templates)HTTP_302_FOUND)get_current_user) open_mysqlget_mysql_credsget_pingconf_vars templates) directory)qreturncCs |}ddd|DS)z Converts a search string into BOOLEAN MODE format where each word must appear. Example: "Tucker Impunity" => "+Tucker +Impunity"  css|]}|rd|VqdS)+N).0wordrr1/wd/v2025.freedom4um.com/routes/latestarticles.py z&build_boolean_query..)stripsplitjoin)rwordsrrrbuild_boolean_querys rz/latestarticles)requestc s|stdtdS|jdd}|jdd}|jdd}d }g}|rt|}|d krn|d 7}||q|d 7}||n|d 7}|d7}|r|d kr|d7}||d|dgn(|d7}||d|dd|dg|dkr|r|d7}n|d7}|d7}g}d} ztt ^} | j dd} | ||| }|D](} t | dtrD| dd| d<qDWdn1s0YW| r| n| r| 0td|||||||jdddS)Nz/signin)url status_coderscopeallorderdatez SELECT a.ArtNum, a.Title, a.PostDate, u.Name AS Username, a.ViewCnt, a.CommentCnt ZtitleszS, (MATCH(a.Title) AGAINST (%s IN BOOLEAN MODE)) * 2 AS relevancez^, (MATCH(a.Title, a.Article) AGAINST (%s IN BOOLEAN MODE) * 2) AS relevancez, 0 AS relevancezc FROM Articles a JOIN ID u ON a.HandleID = u.IDNum WHERE a.Deleted = 0 zE AND (MATCH(a.Title) AGAINST (%s IN BOOLEAN MODE) OR a.Title LIKE %s)%ze AND (MATCH(a.Title, a.Article) AGAINST (%s IN BOOLEAN MODE) OR a.Title LIKE %s OR a.Article LIKE %s)Z relevancez) ORDER BY relevance DESC, a.PostDate DESCz ORDER BY a.PostDate DESCz LIMIT 50T) dictionaryZTitlezutf-8zlatestarticles.htmlthemelight)ruserarticlesqueryr!r#r')rr query_paramsgetrrappendextendr mysql_credscursorexecutefetchall isinstancebytesdecodecloser TemplateResponsecookies) rr)rr!r#sqlparamsZ boolean_qr*r1connarticlerrrlatest_articlessn         8   r>N)fastapirrrfastapi.responsesrfastapi.templatingrZstarlette.statusr utils.authrutils.pingdatar r r PingConfr0routerr strrr-r>rrrrs