
    ei                         d dl 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          d             ZdS )    )	APIRouter)JSONResponse)
open_mysqlget_mysql_credsget_pingconf_varsz/categoriesc                      t          t                    5 } |                     d          }|                    d           |                                }d d d            n# 1 swxY w Y   t          |          S )NT)
dictionaryz
            SELECT CatNum, CatName
            FROM Categories
            WHERE CatName IS NOT NULL AND CatName != ''
            ORDER BY DisplayOrder ASC, CatName ASC
        )content)r   mysql_credscursorexecutefetchallr   )connr   catss      0/wd/v2025.libertysflame.com/routes/categories.py
categoriesr   
   s    	K	 	  !D--  	 	 	   ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! %%%%s   A A!!A%(A%N)fastapir   fastapi.responsesr   utils.pingdatar   r   r   routerPingConfr   getr        r   <module>r      s          * * * * * * I I I I I I I I I I	oh''M
& 
& 
& 
& 
&r   