async def get_products(supplier_id: PositiveInt, db: Session = Depends(get_db)):
db_supplier = crud.get_supplier(db, supplier_id)
if db_supplier is None:
raise HTTPException(status_code=404, detail="Supplier not found")
else:
products = crud.get_products(db, supplier_id)
products = [{"ProductID": product.ProductID, "ProductName": product.ProductName,
"Category":{"CategoryID": product.CategoryID,
"CategoryName": crud.get_product_category(db,product.CategoryID).CategoryName},
"Discontinued": product.Discontinued} for product in products]
return products
async def get_sorted_supplier(pid: PositiveInt, db: Session = Depends(get_db)):
db_products = crud.get_products(db, pid)
if db_products:
data = [{
"ProductID": prod.ProductID,
"ProductName": prod.ProductName,
"Category": {
"CategoryID": prod.CategoryID,
"CategoryName": prod.CategoryName,
},
"Discontinued": prod.Discontinued
} for prod in db_products]
return data
else:
raise HTTPException(status_code=404, detail="Not Oki Doki ID!")
def all_products():
stats = crud.get_products()
product_id = [q[0] for q in db.session.query(Product.product_id).all()]
channel_name = [q[0] for q in db.session.query(Product.channel_name).all()]
product_description = [
q[0] for q in db.session.query(Product.product_description).all()
]
option = [q[0] for q in db.session.query(Product.option).all()]
product_url = [q[0] for q in db.session.query(Product.product_url).all()]
price = [q[0] for q in db.session.query(Product.price).all()]
added_on = [q[0] for q in db.session.query(Product.added_on).all()]
number_sold = [q[0] for q in db.session.query(Product.number_sold).all()]
margin = [q[0] for q in db.session.query(Product.margin).all()]
updated_on = [q[0] for q in db.session.query(Product.updated_on).all()]
# repeat through all columns needed
return render_template('products.html',
product_id=product_id,
channel_name=channel_name,
product_description=product_description,
option=option,
product_url=product_url,
price=price,
added_on=added_on,
number_sold=number_sold,
margin=margin,
updated_on=updated_on)
async def read_products(db: Session = Depends(get_db)):
products = crud.get_products(db)
return products
def read_products(skip: int = 0,
limit: int = 100,
db: Session = Depends(get_db)):
products = crud.get_products(db, skip=skip, limit=limit)
return products
def all_products():
"""View all products on homepage."""
products = crud.get_products()
return render_template('homepage.html', products=products)
def get_products(user: schemas.userSchema, db: Session = Depends(get_db)):
results = crud.get_products(db, user)
return results