1 |
b6f0e019
|
Matej Zeman
|
from typing import List
|
2 |
|
|
from fastapi import Depends, FastAPI, HTTPException, APIRouter, Form
|
3 |
|
|
from datetime import datetime
|
4 |
|
|
from sqlalchemy.orm import Session
|
5 |
|
|
from sql_app import crud, models, schemas
|
6 |
|
|
from ..database import SessionLocal, engine
|
7 |
|
|
from fastapi import FastAPI, Request
|
8 |
|
|
from fastapi.responses import HTMLResponse
|
9 |
|
|
from fastapi.staticfiles import StaticFiles
|
10 |
|
|
from fastapi.templating import Jinja2Templates
|
11 |
|
|
|
12 |
|
|
models.Base.metadata.create_all(bind=engine)
|
13 |
|
|
|
14 |
4911f0ea
|
Matej Zeman
|
# Path to html templates used in this file
|
15 |
4babde6c
|
Matej Zeman
|
templates = Jinja2Templates(directory="templates/usb-logs")
|
16 |
4911f0ea
|
Matej Zeman
|
|
17 |
|
|
# prefix used for all endpoints in this file
|
18 |
af6f5886
|
Matěj Zeman
|
usblogs_web = APIRouter(prefix="")
|
19 |
b6f0e019
|
Matej Zeman
|
|
20 |
|
|
|
21 |
|
|
# Dependency
|
22 |
|
|
def get_db():
|
23 |
|
|
db = SessionLocal()
|
24 |
|
|
try:
|
25 |
|
|
yield db
|
26 |
|
|
finally:
|
27 |
|
|
db.close()
|
28 |
|
|
|
29 |
|
|
|
30 |
|
|
@usblogs_web.get("/logs-web", response_class=HTMLResponse)
|
31 |
|
|
async def read_logs(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
|
32 |
4911f0ea
|
Matej Zeman
|
"""
|
33 |
|
|
Returns template with all usb logs currently saved in database with its pcs, teams and licenses.
|
34 |
|
|
"""
|
35 |
b6f0e019
|
Matej Zeman
|
logs = crud.get_logs(db, skip=skip, limit=limit)
|
36 |
|
|
pcs = []
|
37 |
|
|
for log in logs:
|
38 |
|
|
if log.pc_id not in pcs:
|
39 |
|
|
pcs.append(log.pc_id)
|
40 |
|
|
pc_obj = crud.find_pcs(db, pcs)
|
41 |
|
|
teams = crud.get_teams(db, skip=skip, limit=limit)
|
42 |
|
|
licenses = crud.get_licenses(db, skip=skip, limit=limit)
|
43 |
|
|
return templates.TemplateResponse("logs.html", {"request": request, "logs": logs, "pcs": pc_obj, "teams": teams,
|
44 |
|
|
"licenses": licenses})
|
45 |
|
|
|
46 |
|
|
|
47 |
|
|
@usblogs_web.post("/logs-web", response_class=HTMLResponse)
|
48 |
|
|
async def filter_logs(request: Request, pc: str = Form("all"), team: str = Form("all"), lic: str = Form("all"),
|
49 |
|
|
skip: int = 0, limit: int = 100,
|
50 |
|
|
db: Session = Depends(get_db)):
|
51 |
4911f0ea
|
Matej Zeman
|
"""
|
52 |
|
|
Endpoint used for filtering usb logs by user given form inputs.
|
53 |
|
|
"""
|
54 |
b6f0e019
|
Matej Zeman
|
log = crud.get_filtered_logs(db, pc, team, lic)
|
55 |
|
|
logs_ids = []
|
56 |
|
|
for l in log:
|
57 |
|
|
logs_ids.append(l[0])
|
58 |
|
|
logs = crud.find_filtered_logs(db, logs_ids)
|
59 |
|
|
pc_obj = crud.get_pcs(db, skip=skip, limit=limit)
|
60 |
|
|
teams = crud.get_teams(db, skip=skip, limit=limit)
|
61 |
|
|
licenses = crud.get_licenses(db, skip=skip, limit=limit)
|
62 |
|
|
return templates.TemplateResponse("logs.html", {"request": request, "logs": logs, "pcs": pc_obj, "teams": teams,
|
63 |
|
|
"licenses": licenses})
|