Module `sql_app.api.pcs`

Expand source code

from typing import List
from fastapi import Depends, FastAPI, HTTPException, APIRouter
from sqlalchemy.orm import Session
from sql_app import crud, models, schemas
from ..database import SessionLocal, engine

models.Base.metadata.create_all(bind=engine)

# prefix used for all endpoints in this file
pcs = APIRouter(prefix="/api/v1")


# Dependency
def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()


@pcs.post("/pc", response_model=schemas.PC)
def create_pc(pc: schemas.PCCreate, db: Session = Depends(get_db)):
    """
    Endpoint used for creating new pc
    """
    print(crud.create_pc(db=db, user=pc.username, host=pc.hostname))


@pcs.get("/pcs", response_model=List[schemas.PC])
def read_pcs(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
    """
    Returns all pcs currently saved in database
    """
    pcs = crud.get_pcs(db, skip=skip, limit=limit)
    return pcs


@pcs.get("/pc/{pc_id}", response_model=schemas.PC)
def read_pc(pc_id: int, db: Session = Depends(get_db)):
    """
    Returns one specific pc by given id
    """
    db_pc = crud.get_pc(db, pc_id=pc_id)
    if db_pc is None:
        raise HTTPException(status_code=404, detail="Device not found")
    return db_pc

Functions

def create_pc(pc: PCCreate, db: sqlalchemy.orm.session.Session = Depends(get_db))

Endpoint used for creating new pc

Expand source code

@pcs.post("/pc", response_model=schemas.PC)
def create_pc(pc: schemas.PCCreate, db: Session = Depends(get_db)):
    """
    Endpoint used for creating new pc
    """
    print(crud.create_pc(db=db, user=pc.username, host=pc.hostname))

def get_db()

Expand source code

def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()

def read_pc(pc_id: int, db: sqlalchemy.orm.session.Session = Depends(get_db))

Returns one specific pc by given id

Expand source code

@pcs.get("/pc/{pc_id}", response_model=schemas.PC)
def read_pc(pc_id: int, db: Session = Depends(get_db)):
    """
    Returns one specific pc by given id
    """
    db_pc = crud.get_pc(db, pc_id=pc_id)
    if db_pc is None:
        raise HTTPException(status_code=404, detail="Device not found")
    return db_pc

def read_pcs(skip: int = 0, limit: int = 100, db: sqlalchemy.orm.session.Session = Depends(get_db))

Returns all pcs currently saved in database

Expand source code

@pcs.get("/pcs", response_model=List[schemas.PC])
def read_pcs(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
    """
    Returns all pcs currently saved in database
    """
    pcs = crud.get_pcs(db, skip=skip, limit=limit)
    return pcs