~OiP @ d dl mZmZmZ d dlmZ d dlmZ d dlm Z m
Z
m Z d dl m
Z
d dlmZ e Z e
e Z eddg Z ed
Z eed d
ge e d ee
fdefd ZdS ) ) APIRouterRequestDepends) HTMLResponse)Jinja2Templates)
open_mysqlget_mysql_credsget_pingconf_vars) nav_context)add_dual_routez /readarticle readarticle)prefixtags templates) directory GET)methodsresponse_classrequestc K | j d }d }g }d } t t 5 }| d }| d|f | | d|f | }|rdD ]H}t | | t r ||
d ||< I| d rQ|d }d d l } |
d
d | }|
d d | }||d< | d
|f | }|D ]Q}
dD ]L}|
| } t | t r|
d |
|< E| d |
|< MR d d d n # 1 swxY w Y |r| n # |r| w w xY wt d| ||d| S )NArtNumT)
dictionaryz
UPDATE Articles
SET ViewCnt = IFNULL(ViewCnt, 0) + 1
WHERE ArtNum = %s
a
SELECT a.ArtNum, a.Title, a.Source, a.URL AS URL_Source, a.PubDate, a.Author,
a.PostDate, a.ViewCnt, a.Article, c.CatName, h.Handle
FROM Articles a
JOIN Categories c ON a.CatNum = c.CatNum
JOIN Handles h ON a.HandleID = h.HandleID
WHERE a.ArtNum = %s AND a.Deleted = 0
)TitleSource
URL_SourceAuthorArticleCatNameViewCntHandlezutf-8r r z ^(\s*()?\s*
\s*)+r z (\s*\s*()?\s*
)+$ai
SELECT c.ComNum, c.ArtNum, h.Handle AS HandleStr,
c.ReplyToComNum, c.ReplyToHandleStr,
c.Comment, c.PostDate
FROM Comments c
JOIN Handles h ON c.HandleID = h.HandleID
WHERE c.ArtNum = %s and c.ComNum > 0
ORDER BY c.ComNum
) HandleStrReplyToHandleStrCommentzreadarticle.html)r articlecomments) query_paramsgetr mysql_credscursorexecutecommitfetchone
isinstancebytesdecodestripresubfetchallcloser TemplateResponse) r navart_numr% r& r* connkeycleanedr2 cvalues ./wd/v2025.freedom4um.com/routes/readarticle.py read_articler? s "&&x00GGH
F>
$
$ 9 $[[D[11F
NN
KKMMM
NN
oo''G
1q D DC!'++c"2"2E:: D'.s|':':7'C'C ;;y)) 1 %i 0 6 6 8 8G III ff%H"g V VG ff%H"g V VG)0GI&
NN
((H
$
$G $ $C EE#JJE!%// $!& g!6!6# !## $
$g9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $ 9 $x LLNNN LLNNNN % %
s/ H F G$ H $G((H +G(,H H N)fastapir r r fastapi.responsesr fastapi.templatingr utils.pingdatar r r
utils.navr utils.routesr PingConfr) routerr r( r? r> rJ sE / / / / / / / / / / * * * * * * . . . . . . I I I I I I I I I I ! ! ! ! ! ! ' ' ' ' ' ' oh'' .
? ? ? Ok 2 2 2 UGLIIIN-4W[-A-A N N N N N JIN N NrI