def create_snapshot(cls, **kwargs): snapshot = StockItemSnapshot( stock_item_id=kwargs['stock_item_id'], maintainer_id=kwargs['maintainer_id'], unit_of_measure_id=kwargs['unit_of_measure_id'], quantity=kwargs['quantity']) save(snapshot)
def create_stock(cls, **kwargs): '''Create a new `Stock` record kwargs: stock_name: str - The name of the stock. ''' stock = Stock(name=kwargs['stock_name']) save(stock)
def update_stock(cls, **kwargs): '''Update a `Stock` record associated with a given stock id. kwargs: stock_id: str - The id of the stock record to update. stock_name: str (optional) - The name of the stock. Discussion: If any optional kwarg is not provided, that column value will remain unchanged ''' stock = Stock.query.get(kwargs['stock_id']) stock.name = kwargs.get('stock_name', stock.name) save(stock)
def create_item(cls, **kwargs): stock_item = StockItem(stock_id=kwargs['stock_id'], item_id=kwargs['item_id']) save(stock_item)
def update_item(cls, **kwargs): stock_item = StockItem.query.get(kwargs['stock_item_id']) stock_item.stock_id = kwargs.get('stock_id', stock_item.stock_id) stock_item.item_id = kwargs.get('item_id', stock_item.item_id) save(stock_item)
def add_stock_maintainer(cls, **kwargs): stock = Stock.query.get(kwargs['stock_id']) maintainer = Maintainer.query.get(kwargs['maintainer_id']) stock.maintainers.append(maintainer) save(stock)
def remove_stock_maintainer(cls, **kwargs): stock = Stock.query.get(kwargs['stock_id']) maintainer = Maintainer.query.get(kwargs['maintainer_id']) stock.maintainers.remove(maintainer) save(stock)