def delete_state_by_id(id_stock, goods):
delCur = postgresConnect.cursor()
delCur.execute(
f"select delete_state_by_id({id_stock}, '{goods}')"
)
delCur.close()
postgresConnect.commit()
def delete_goods(title):
delCur = postgresConnect.cursor()
delCur.execute(
f"select delete_goods('{title}')"
)
delCur.close()
postgresConnect.commit()
def delete_state(address, title):
delCur = postgresConnect.cursor()
delCur.execute(
f"select delete_state('{address}', '{title}')"
)
delCur.close()
postgresConnect.commit()
def delete_stock(address):
delCur = postgresConnect.cursor()
delCur.execute(
f"select delete_stock('{address}')"
)
delCur.close()
postgresConnect.commit()
def add_stock(title, address):
add = postgresConnect.cursor()
add.execute(
f"select add_stock('{title}', '{address}')"
)
add.close()
postgresConnect.commit()
def update_quantity(goods, id_stock, quantity):
updateCur = postgresConnect.cursor()
updateCur.execute(
f"select update_quantity('{goods}', {id_stock}, {quantity})"
)
updateCur.close()
postgresConnect.commit()
def add_stock_state(address, title, quantity):
add = postgresConnect.cursor()
add.execute(
f"select add_stock_state('{address}', '{title}', {quantity})"
)
add.close()
postgresConnect.commit()
def add_goods(title):
add = postgresConnect.cursor()
add.execute(
f"select add_goods('{title}')"
)
add.close()
postgresConnect.commit()
