def query_delete_product(sku):
utilities.execute("DELETE FROM Products " "WHERE SKU='" + sku + "'")
def insert_quantify(sku, staffid):
now = datetime.datetime.now()
utilities.execute(
"INSERT INTO Quantify(SKU,Date_info, Staff_ID) values('" + str(sku) +
"','" + str(now.year) + "/" + str(now.month) + "/" + str(now.day) +
"','" + str(staffid) + "')")
def query_change_salary(self, managerid, salary):
utilities.execute("UPDATE Managers SET Salary = '" + salary +
"' WHERE Staff_ID = " + managerid)
def query_price_update(sku, price):
utilities.execute("UPDATE Products "
"SET Product_Price='" + price + "' "
"WHERE SKU='" + sku + "'")
def query_delete_worker(self, workerid):
utilities.execute("DELETE FROM Staff WHERE Staff_ID = " + workerid)
def query_change_wage(self, workerid, wage):
utilities.execute("UPDATE Workers SET Hourly_Rate = '" + wage +
"' WHERE Staff_ID = " + workerid)
def query_user_info(self, sku, price):
utilities.execute("UPDATE Product SET Product_Price='" + price +
"' WHERE SKU='" + sku + "'")
def query_delete_product(self, sku):
utilities.execute("DELETE FROM Product where SKU='" + sku + "'")
def insert_producer(email, name, phone, owner, address):
utilities.execute("INSERT INTO Producers values (0,'" + email + "','" +
phone + "','" + name + "','" + owner + "','" + address +
"')")
def del_vendor(id_party):
return utilities.execute("DELETE FROM Vendors where V_ID=" + id_party)
def insert_import(email, name, phone, owner, address):
return utilities.execute("INSERT INTO Vendors value (0,'" + email + "','" +
phone + "','" + name + "','" + owner + "','" +
address + "')")