o h<@sDddlmZmZmZmZddlmZddlmZddl m Z ddl m Z m Z eddgdZd d Zejd ee d eefd efddZddlmZejd e ejdeefde d efddZejde d eefded efddZejde d eefdede d efddZejdejdeefded efddZdS)) APIRouter HTTPExceptionstatusDepends)Session) SessionLocal)Client)r ClientCreatez/clientsclients)prefixtagsccs(t}z |VW|dS|wN)rclosedbr)C:\MealPlanner\backend\routers\clients.pyget_db s r/)response_modelrcCs|tSr )queryrallrrrr list_clientssr)IntegrityError)r status_codeclientcCsVt|j|jd}||z ||||WSty*|tdddw)N)nameemailiuEmail già esistenterdetail) rrraddcommitrefreshrZrollbackr)rr db_clientrrr create_clients    r$z /{client_id} client_idcCs.|ttj|k}|stddd|SNizCliente non trovator)rrfilteridfirstr)r%rrrrr get_client"s r*cCsP|ttj|k}|stddd|j|_|j|_|| ||Sr&) rrr'r(r)rrrr!r")r%rrr#rrr update_client)s  r+)rcCs@|ttj|k}|stddd|||dSr&)rrr'r(r)rdeleter!)r%rr#rrr delete_client4s   r-N)fastapirrrrZsqlalchemy.ormrZdatabasermodelsrschemasZ ClientSchemar routerrgetlistrZsqlalchemy.excrpostHTTP_201_CREATEDr$intr*putr+r,HTTP_204_NO_CONTENTr-rrrrs$