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