Revize aba60b70
Přidáno uživatelem Matěj Zeman před více než 2 roky(ů)
server/sql_app/main.py | ||
---|---|---|
1 |
from fastapi import FastAPI |
|
2 |
import fastapi |
|
3 |
from pydantic import BaseModel |
|
4 |
from typing import Optional, List |
|
5 |
|
|
6 |
app = FastAPI() |
|
7 |
|
|
8 |
class Device(BaseModel): |
|
9 |
vendor_id: int |
|
10 |
product_id: int |
|
11 |
serial_number: str |
|
12 |
|
|
13 |
class USBLog(BaseModel): |
|
14 |
username: str |
|
15 |
hostname: str |
|
16 |
timestamp: str |
|
17 |
device: Device |
|
18 |
status:str |
|
19 |
|
|
20 |
@app.post("/api/v1/usb-logs/") |
|
21 |
async def root_post(usb_log: USBLog): |
|
22 |
print(usb_log) |
|
23 |
return {"message": "Sucess"} |
|
24 |
|
|
25 |
@app.post("/api/v1/devices/") |
|
26 |
async def root_dev_post(device: Device): |
|
27 |
print(device) |
|
28 |
return {"message": "Sucess"} |
|
29 |
|
|
30 |
@app.get("/") |
|
31 |
async def root_read(): |
|
32 |
print("Hello") |
|
33 |
return {"message":"Hello World"} |
|
1 |
from typing import List |
|
2 |
|
|
3 |
from fastapi import Depends, FastAPI, HTTPException |
|
4 |
from sqlalchemy.orm import Session |
|
5 |
from sql_app import crud, models, schemas |
|
6 |
import uvicorn |
|
7 |
from database import SessionLocal, engine |
|
8 |
|
|
9 |
models.Base.metadata.create_all(bind=engine) |
|
10 |
|
|
11 |
app = FastAPI(root_path="/api/v1") |
|
12 |
|
|
13 |
|
|
14 |
# Dependency |
|
15 |
def get_db(): |
|
16 |
db = SessionLocal() |
|
17 |
try: |
|
18 |
yield db |
|
19 |
finally: |
|
20 |
db.close() |
|
21 |
|
|
22 |
|
|
23 |
@app.post("/device/", response_model=schemas.Device) |
|
24 |
def create_device(device: schemas.DeviceCreate, db: Session = Depends(get_db)): |
|
25 |
print(crud.create_device(db=db, device=device)) |
|
26 |
|
|
27 |
|
|
28 |
@app.get("/devices/", response_model=List[schemas.Device]) |
|
29 |
def read_devices(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)): |
|
30 |
devices = crud.get_devices(db, skip=skip, limit=limit) |
|
31 |
return devices |
|
32 |
|
|
33 |
|
|
34 |
@app.get("/device/{device_id}", response_model=schemas.Device) |
|
35 |
def read_device(device_id: int, db: Session = Depends(get_db)): |
|
36 |
db_device = crud.get_device(db, device_id=device_id) |
|
37 |
if db_device is None: |
|
38 |
raise HTTPException(status_code=404, detail="Device not found") |
|
39 |
return db_device |
|
40 |
|
|
41 |
|
|
42 |
@app.post("/usb-logs/", response_model=schemas.USBLog) |
|
43 |
def create_device_logs(log: schemas.USBTempBase, db: Session = Depends(get_db)): |
|
44 |
dev = crud.find_device(db, log.device) |
|
45 |
if dev is None: |
|
46 |
dev = crud.create_device(db=db, device=log.device) |
|
47 |
|
|
48 |
print(crud.create_device_logs(db=db, item=log, dev_id=dev.id)) |
|
49 |
|
|
50 |
|
|
51 |
@app.get("/logs/", response_model=List[schemas.USBLog]) |
|
52 |
def read_logs(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)): |
|
53 |
items = crud.get_logs(db, skip=skip, limit=limit) |
|
54 |
return items |
|
55 |
|
|
56 |
|
|
57 |
@app.get("/logs/{device_id}", response_model=List[schemas.USBLog]) |
|
58 |
def read_log(device_id: int, db: Session = Depends(get_db)): |
|
59 |
db_log = crud.get_log(db, device_id=device_id) |
|
60 |
if db_log is None: |
|
61 |
raise HTTPException(status_code=404, detail="Logs not found") |
|
62 |
return db_log |
|
63 |
|
|
64 |
|
|
65 |
if __name__ == "__main__": |
|
66 |
uvicorn.run(app, host="192.168.0.22", port=8000) |
Také k dispozici: Unified diff
re #9425 Implemented Entities for communicating with db