Revize 99c92c11

re #9429 Added class and funcionality for Teams table. Modified date parsing and storing. Modified View at /usb-logs/. Replaced "_" with "-" in all endpoints.

server/sql_app/api/usb_logs.py

@@ -1 +1 @@
 from typing import List
 from fastapi import Depends, FastAPI, HTTPException, APIRouter, Form
+from datetime import datetime
 from sqlalchemy.orm import Session
 from ...sql_app import crud, models, schemas
 from ..database import SessionLocal, engine
@@ -23 +24 @@
         db.close()
 
 
[e-mail]("/logs_web/", response_class=HTMLResponse)
[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)
+    dat = datetime.strptime(log.timestamp, '%Y-%m-%d %H:%M:%S.%f')
     if dev is None:
         dev = crud.create_device(db=db, device=log.device)
     pc = crud.find_pc(db, log.username, log.hostname)
     if pc is None:
         pc = crud.create_pc(db=db, user=log.username, host=log.hostname)
 
-    print(crud.create_device_logs(db=db, item=log, dev_id=dev.id, pc_id=pc.id))
+    print(crud.create_device_logs(db=db, item=log, dev_id=dev.id, pc_id=pc.id, date=dat))
 
 
 @usblogs.get("/logs/", response_model=List[schemas.USBLog])