Revize c0f38eab

re #9429 Implemented funcionality for web views at data saved in database. Views at "/logs_web/", "/pcs_web/", "/devices_web/", "/licenses_web/".

server/sql_app/api/usb_logs.py

@@ -3 +3 @@
 from sqlalchemy.orm import Session
 from ...sql_app import crud, models, schemas
 from ..database import SessionLocal, engine
+from fastapi import FastAPI, Request
+from fastapi.responses import HTMLResponse
+from fastapi.staticfiles import StaticFiles
+from fastapi.templating import Jinja2Templates
 
 models.Base.metadata.create_all(bind=engine)
+templates = Jinja2Templates(directory="../templates/usb-logs")
 
 usblogs = APIRouter()
 
@@ -18 +23 @@
         db.close()
 
 
[e-mail]("/logs_web/", response_class=HTMLResponse)
+async def read_logs(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
+    logs = crud.get_logs(db, skip=skip, limit=limit)
+    pcs = []
+    for log in logs:
+        if log.pc_id not in pcs:
+            pcs.append(log.pc_id)
+    return templates.TemplateResponse("logs.html", {"request": request, "logs": logs})
+
+
 @usblogs.post("/usb-logs/", response_model=schemas.USBLog)
 def create_device_logs(log: schemas.USBTempBase, db: Session = Depends(get_db)):
     dev = crud.find_device(db, log.device)