1 |
b6f0e019
|
Matej Zeman
|
from typing import List
|
2 |
|
|
|
3 |
|
|
from fastapi import Depends, FastAPI, HTTPException, APIRouter, Form
|
4 |
|
|
from sqlalchemy.orm import Session
|
5 |
|
|
from sql_app import crud, models, schemas
|
6 |
|
|
from datetime import datetime
|
7 |
|
|
from ..database import SessionLocal, engine
|
8 |
|
|
from fastapi import FastAPI, Request
|
9 |
|
|
from fastapi.responses import HTMLResponse
|
10 |
|
|
from fastapi.staticfiles import StaticFiles
|
11 |
|
|
from fastapi.templating import Jinja2Templates
|
12 |
|
|
|
13 |
|
|
models.Base.metadata.create_all(bind=engine)
|
14 |
|
|
templates = Jinja2Templates(directory="../templates/devices")
|
15 |
|
|
|
16 |
|
|
device_web = APIRouter(prefix="/api/v1")
|
17 |
|
|
|
18 |
|
|
|
19 |
|
|
# Dependency
|
20 |
|
|
def get_db():
|
21 |
|
|
db = SessionLocal()
|
22 |
|
|
try:
|
23 |
|
|
yield db
|
24 |
|
|
finally:
|
25 |
|
|
db.close()
|
26 |
|
|
|
27 |
|
|
|
28 |
|
|
@device_web.get("/devices-web", response_class=HTMLResponse)
|
29 |
|
|
async def read_devices(request: Request, skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
|
30 |
|
|
devices = crud.get_devices(db, skip=skip, limit=limit)
|
31 |
|
|
return templates.TemplateResponse("devices.html", {"request": request, "devs": devices})
|
32 |
|
|
|
33 |
|
|
|
34 |
|
|
@device_web.post("/devices-web", response_class=HTMLResponse)
|
35 |
|
|
async def filter_devices(request: Request, skip: int = 0, limit: int = 100, lic: str = Form("all"),
|
36 |
|
|
db: Session = Depends(get_db)):
|
37 |
|
|
devices = crud.get_devices(db, skip=skip, limit=limit)
|
38 |
|
|
def_devices = []
|
39 |
|
|
for dev in devices:
|
40 |
|
|
for l in dev.licenses:
|
41 |
|
|
if dev not in def_devices and l.licenses.name == lic:
|
42 |
|
|
def_devices.append(dev)
|
43 |
|
|
if lic == "all":
|
44 |
|
|
def_devices = devices
|
45 |
|
|
return templates.TemplateResponse("devices.html", {"request": request, "devs": def_devices})
|