def create_supplier(db: Session, supplier: schemas.Supplier): """Create new supplier and return its details.""" new_id = db.query(func.max(models.Supplier.supplier_id)).scalar() + 1 supplier.supplier_id = new_id db.add(models.Supplier(**supplier.dict())) db.commit() return read_supplier(db, supplier_id=new_id)
async def post_suppliers(supplier: schemas.NewSupplier, db: Session = Depends(get_db)): new_supplier_id = db.query(models.Supplier).count() + 1 new_supplier = models.Supplier(SupplierID=new_supplier_id, CompanyName=supplier.CompanyName, ContactName=supplier.ContactName, ContactTitle=supplier.ContactTitle, Address=supplier.Address, City=supplier.City, PostalCode=supplier.PostalCode, Country=supplier.Country, Phone=supplier.Phone) db.add(new_supplier) db.commit() return db.query(models.Supplier).filter(models.Supplier.SupplierID == new_supplier_id).first()
def add_supplier(db: Session, supplier: schemas.Supplier): last_id = db.query(models.Supplier).order_by( models.Supplier.SupplierID.desc()).first() s = models.Supplier(SupplierID=last_id.SupplierID + 1, CompanyName=supplier.CompanyName, ContactName=supplier.ContactName, ContactTitle=supplier.ContactTitle, Address=supplier.Address, City=supplier.City, Region=supplier.Region, PostalCode=supplier.PostalCode, Country=supplier.Country, Phone=supplier.Phone, Fax=supplier.Fax, HomePage=supplier.HomePage) print(s.SupplierID) return (db.add(s))
def add_supplier(db: Session, supplier: schemas.AddSupplier): supplier_id = db.query(models.Supplier).count() + 1 db_supplier = models.Supplier(SupplierID=supplier_id, CompanyName=supplier.CompanyName, ContactName=supplier.ContactName, ContactTitle=supplier.ContactTitle, Address=supplier.Address, City=supplier.City, PostalCode=supplier.PostalCode, Country=supplier.Country, Phone=supplier.Phone, Fax=supplier.Fax, HomePage=supplier.HomePage) db.add(db_supplier) db.commit() db.refresh(db_supplier) return db_supplier
def create_supplier(db: Session, supplier_from_msg: schemas.SupplierCreate): max_id = db.query(func.max(models.Supplier.SupplierID)).scalar() id_free = max_id + 1 db_sup_from_msg = models.Supplier( SupplierID=id_free, CompanyName=supplier_from_msg.CompanyName, ContactName=supplier_from_msg.ContactName, ContactTitle=supplier_from_msg.ContactTitle, Address=supplier_from_msg.Address, City=supplier_from_msg.City, PostalCode=supplier_from_msg.PostalCode, Country=supplier_from_msg.Country, Phone=supplier_from_msg.Phone) db.add(db_sup_from_msg) db.commit() return db_sup_from_msg
def create_supplier(db: Session, new_supplier: schemas.NewSupplier): highest_id = db.query(func.max(models.Supplier.SupplierID)).scalar() new_supplier.SupplierID = highest_id + 1 db.add(models.Supplier(**new_supplier.dict())) db.commit() return get_supplier(db, highest_id + 1)
def insert_supplier(db: Session, supplier: schemas.SupplierCreate): supplier_id = db.query(models.Supplier).count() + 1 db_supplier = models.Supplier(SupplierID=supplier_id, **supplier.dict()) db.add(db_supplier) db.commit() return db_supplier
def add_supplier(db: Session, supplier: schemas.SupplierRequest, id: int): new_supplier = models.Supplier(SupplierID = id, CompanyName = supplier.CompanyName, ContactName = supplier.ContactName, ContactTitle = supplier.ContactTitle, Address = supplier.Address, City = supplier.City, PostalCode = supplier.PostalCode, Country = supplier.Country, Phone = supplier.Phone) db.add(new_supplier) db.commit()
def post_suppliers(db: Session, new_supplier: schemas.PostSupplier): new_supplier.SupplierID = db.query(func.max( models.Supplier.SupplierID)).scalar() + 1 db.add(models.Supplier(**new_supplier.dict())) db.commit() return get_suppliers_id(db, new_supplier.SupplierID)