o &Ph @sddlmZmZmZddlmZddlmZddlm Z m Z m Z ddl m Z ddlmZddlmZddlmZed d gd Zdd lmZeejjjZeeed dZddZedeefdefddZedededeefdededefddZe deefde!defddZ"edeefdefd d!Z#edededeefd"ededefd#d$Z$e d%eefde!defd&d'Z%ejd(e d)d*efd+d,Z&ejd-e d)eefd*edefd.d/Z'ejd0e d)eefd*edefd1d2Z(dS)3) APIRouterDepends HTTPException)Session) SessionLocal) InstrumentKPIKPIValue) HTMLResponse)Jinja2Templates)Request)Formz/adminAdmin)prefixtags)Path templates) directoryccs(t}z |VW|dS|wN)rclosedbr7/var/www/html/stock_analysis/be/app/api/admin_routes.pyget_dbs rz /instrumentsrcC|tSr)queryrallrrrrlist_instrumentsr.NsymbolnamecCsD|tj|drtdddt||d}||||S)N)r zInstrument already existsdetail)r r!)rr filter_byfirstraddcommit)r r!ritemrrrcreate_instruments    r*z/instruments/{id}idcC:|t|}|stddd|||ddiSNiz Not foundr#deletedT)rrgetrdeleter(r+rr)rrrdelete_instrument%   r2z/kpiscCrr)rrrrrrr list_kpis/rr4codecCsLtd|tj|drtdddt||d}||||S)NzIN Create KPIs)r5r"zKPI already existsr#)r5r!)printrrr%r&rr'r()r5r!rr)rrr create_kpi3s   r7z /kpis/{id}cCr,r-)rrr/rr0r(r1rrr delete_kpi=r3r8/)response_classrequestcCstdd|iS)Nz admin.htmlr;)rTemplateResponse)r;rrradmin_dashboardFsr=z/admin/instrumentscC4|t}ddd|D}td|ddS)Nc S.g|]}d|jd|jp dd|jdqS)C
 (r?zC)
)r r!r+).0irrr Mz)list_instruments_html..z

content)rrrjoinr )r;r instrumentshtmlrrrlist_instruments_htmlJ  rMz /admin/kpiscCr>)Nr?c Sr@)rArBr?z<))r5r!r+)rCkrrrrEXrFz"list_kpis_html..z
rGrH)rrrrJr )r;rkpisrLrrrlist_kpis_htmlUrNrQ))fastapirrrsqlalchemy.ormrapp.db.databaser app.db.modelsrrr fastapi.responsesr fastapi.templatingr r r routerpathlibr__file__resolveparentBASE_DIRstrrrr/rpostr*r0intr2r4r7r8r=rMrQrrrrs>       , ,