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 + "')")