def availabe_netStock():
print('Preparing to calculate net stock:')
print('Catergories.........')
displayAllCategories()
print('Stocks..............')
displayStocks()
category_id = input('Please select the category:')
cid = Category.find(category_id)
# cate = getCategoriesId(category_id)
user_choice = input(
f'Are you sure want to calculatae net amount of stock net ammount: y/n:'
)
if (user_choice == 'y'):
# increaseAmount = int(input('How do you want to increse :'))
# cid = int(category_id)
stock_id = int(
input('Enter the stock_id for the category that you input above:'))
sid = Stock.find(stock_id)
# cursor.execute('SELECT * FROM assignweek3.stocks where categories_id = %s and id = %s;',[cid,s])
# for sii in cursor.fetchall():
# sin = sid.stockin
# sout = sid.stockout
cid.stock = (int(sid.stockin) + int(cid.stock)) - int(sid.stockout)
print('This is your update')
cid.update()
# mydb.commit()
print('Categories.....')
displayAllCategories()
def test_add_stock(self):
stock = Stock()
stock.add("MLK")
value = stock.find("MLK")
self.assertEqual(value, False)
def getStockByID(id):
stock = Stock.find(id)
stock.category = Category.find(stock.category_id)
return stock
