a
    h                     @   sj   d dl mZmZ d dlmZ d dlmZmZmZ e Z	ee	Z
e ZeddZededdd	Zd
S )    )	APIRouterRequest)Jinja2Templates)
open_mysqlget_mysql_credsget_pingconf_vars	templates)	directoryz
/headlines)requestc                    s   g }d }zt t}|jdd}|d | }|D ]P}|d|d f | }|D ]$}t|d trX|d d|d< qX||d< q6W d    n1 s0    Y  W |r|  n|r|  0 t	
d	| |d
S )NT)
dictionaryz
                SELECT CatNum, CatName
                FROM Categories
                ORDER BY DisplayOrder ASC, CatName ASC
            z
                    SELECT a.ArtNum, a.Title
                    FROM Articles a
                    WHERE a.CatNum = %s AND a.Deleted = 0
                    ORDER BY a.PostDate DESC
                    LIMIT 10
                ZCatNumTitlezutf-8articleszheadlines.html)r
   
categories)r   mysql_credscursorexecutefetchall
isinstancebytesdecodecloser   TemplateResponse)r
   r   r   conncategoryr   article r   ,/wd/v2025.freedom4um.com/routes/headlines.pyheadlines_page   s4    

*

r   N)fastapir   r   fastapi.templatingr   utils.pingdatar   r   r   PingConfr   routerr   getr   r   r   r   r   <module>   s   
