a
    h                     @   sl   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ddfedd	d
ZdS )    )	APIRouterQuery)JSONResponse)
open_mysqlget_mysql_credsget_pingconf_varsz/usersearch.   )
min_length)qc                 C   s`   t tD}|jdd}d}||| d f | }t|dW  d   S 1 sR0    Y  dS )zIReturn up to 5 users whose names start with the query (case-insensitive).T)
dictionaryz
            SELECT HandleID, Handle AS Name
            FROM Handles
            WHERE Handle LIKE %s
            ORDER BY Handle
            LIMIT 3
        %)contentN)r   mysql_credscursorexecutefetchallr   )r
   connr   sqlZusers r   -/wd/v2025.freedom4um.com/routes/usersearch.py
usersearch	   s    
r   N)fastapir   r   fastapi.responsesr   utils.pingdatar   r   r   routerPingConfr   getstrr   r   r   r   r   <module>   s   