a h @sddlmZmZmZddlmZddlmZddlm Z m Z m Z ddl m Z ddlmZddlmZddlmZed d gd Zdd lmZeejjjZeeed dZddZedeefedddZedededeefeeedddZe deefe!edddZ"edeefeddd Z#edededeefeeed!d"d#Z$e d$eefe!edd%d&Z%ejd'e d(ed)d*d+Z&ejd,e d(eefeed-d.d/Z'ejd0e d(eefeed-d1d2Z(dS)3) APIRouterDepends HTTPException)Session) SessionLocal) InstrumentKPIKPIValue) HTMLResponse)Jinja2Templates)Request)Formz/adminZAdmin)prefixtags)Path templates) directoryccs(t}z|VW|n |0dSN)rclosedbr4/var/www/html/stock_analysis/app/api/admin_routes.pyget_dbsrz /instrumentsrcCs|tSr)queryrallrrrrlist_instrumentssr.N)symbolnamercCsD|tj|dr"tdddt||d}||||S)N)rzInstrument already existsdetail)rr)rr filter_byfirstraddcommit)rrritemrrrcreate_instruments    r'z/instruments/{id})idrcCs:|t|}|s tddd|||ddiSNiz Not foundr deletedT)rrgetrdeleter%r(rr&rrrdelete_instrument%s   r.z/kpiscCs|tSr)rrrrrrr list_kpis/sr/)coderrcCsLtd|tj|dr*tdddt||d}||||S)NzIN Create KPIs)r0rzKPI already existsr )r0r)printrrr"r#rr$r%)r0rrr&rrr create_kpi3s   r2z /kpis/{id}cCs:|t|}|s tddd|||ddiSr))rrr+rr,r%r-rrr delete_kpi=s   r3/)response_classrequestcCstdd|iS)Nz admin.htmlr7)rZTemplateResponser6rrradmin_dashboardFsr8z/admin/instruments)r7rcCs4|t}ddd|D}td|ddS)Nc Ss.g|]&}d|jd|jpdd|jdqS)C
 (r9zC)
)rrr().0irrr Msz)list_instruments_html..z

content)rrrjoinr )r7r instrumentshtmlrrrlist_instruments_htmlJs  rEz /admin/kpiscCs4|t}ddd|D}td|ddS)Nr9c Ss.g|]&}d|jd|jpdd|jdqS)r:r;r9z<))r0rr()r<krrrr>Xsz"list_kpis_html..z
r?r@)rrrrBr )r7rkpisrDrrrlist_kpis_htmlUs  rH))fastapirrrsqlalchemy.ormrapp.db.databaser app.db.modelsrrr fastapi.responsesr Zfastapi.templatingr r r routerpathlibr__file__resolveparentZBASE_DIRstrrrr+rpostr'r,intr.r/r2r3r8rErHrrrrs<       ( (