a
    c%h]                     @   sh   d dl mZmZ d dlmZ d dlmZmZmZ e Z	e Z
ee
Ze	dedfedddZd	S )
    )	APIRouterQuery)JSONResponse)
open_mysqlget_mysql_credsget_pingconf_varsz/threadparty.)artnumc                 C   s   t t}|jdd}|d| f | }|d| f | }i }|rZ|d ||d < |D ]}|d ||d < q^dd | D }t|d	W  d    S 1 s0    Y  d S )
NT)
dictionaryz
            SELECT a.HandleID, i.Name
            FROM Articles a
            JOIN ID i ON a.HandleID = i.IDNum
            WHERE a.ArtNum = %s
        z
            SELECT DISTINCT c.HandleID, i.Name
            FROM Comments c
            JOIN ID i ON c.HandleID = i.IDNum
            WHERE c.ArtNum = %s
        NameHandleIDc                 S   s   g | ]\}}||d qS ))r   r
    ).0kvr   r   ./wd/v2025.freedom4um.com/routes/threadparty.py
<listcomp>(       z thread_party.<locals>.<listcomp>)content)r   mysql_credscursorexecutefetchonefetchallitemsr   )r   connr   Zarticle_poster
commentersZuser_mapuresultr   r   r   thread_party
   s"    
r   N)fastapir   r   fastapi.responsesr   utils.pingdatar   r   r   routerPingConfr   getintr   r   r   r   r   <module>   s   