o <#d@szddlZddlmZmZmZmZddlmZmZddl m Z ddl m Z ddl TddlZeZeddefd d ZdS) N) APIRouterRequestBodystatus)DictList)jsonable_encoder) JSONResponse)*z/get_product_name/{filter}requestcsj|jj}|dkr|d}n|d|}g}|jdkr3|D]}||d|ddq"|SgS)N0zselect top 20 PAT.Name,PT.ProductId from ProductTranslation PT inner join ProductAdditionalTranslation PAT on PT.ProductAdditionalTransId = PAT.ProductAdditionalTransIdzselect top 20 PAT.Name,PT.ProductId from ProductTranslation PT inner join ProductAdditionalTranslation PAT on PT.ProductAdditionalTransId = PAT.ProductAdditionalTransId where name like '{}%'r)Z product_name product_id)appmssqlcursorexecuteformatrowcountappend)r filterrrowsZ product_datarowr7D:\Vignesh\Freelance\Astroved\api_v1\routes\products.pyget_product_name s     r)arrowfastapirrrrtypingrrfastapi.encodersrfastapi.responsesr lib.commonjsonroutergetrrrrrs