def updateStrStreet(self, n_street):
if n_street != "":
address_id = self.getStrAddressID()
cursor = self.connection.cursor()
update = ('UPDATE ADDRESS SET street="{}" WHERE id={};'.format(
n_street, address_id))
cursor.execute(update)
self.connection.commit()
else:
nameError = UpdateManagerErrors.NameErrorWindow(self.getUsername())
nameError.show()
self.close()
def updateLastName(self, new_l_name):
if new_l_name != "":
cursor = self.connection.cursor()
update = (
'UPDATE USERR SET last_name="{}" WHERE username="******";'.format(
new_l_name, self.getUsername()))
cursor.execute(update)
self.connection.commit()
else:
nameError = UpdateManagerErrors.NameErrorWindow(self.getUsername())
nameError.show()
self.close()
def updateHouseNum(self, n_street_num):
if CheckRegistration.validHouseNum(n_street_num):
address_id = self.getStrAddressID()
cursor = self.connection.cursor()
update = ('UPDATE ADDRESS SET house_number={} WHERE id={};'.format(
n_street_num, address_id))
cursor.execute(update)
self.connection.commit()
else:
houseError = UpdateManagerErrors.HouseErrorWindow(
self.getUsername())
houseError.show()
self.close()
def updateStrMng(self, n_name):
if n_name != "":
store_id = self.getStoreID()
cursor = self.connection.cursor()
update = (
'UPDATE GROCERYSTORE SET store_name="{}" WHERE store_id={};'.
format(n_name, store_id))
cursor.execute(update)
self.connection.commit()
else:
nameError = UpdateManagerErrors.NameErrorWindow(self.getUsername())
nameError.show()
self.close()
def updateEmail(self, n_email):
if CheckRegistration.validEmail(n_email):
cursor = self.connection.cursor()
update = (
'UPDATE USERR SET email="{}" WHERE username="******";'.format(
n_email, self.getUsername()))
cursor.execute(update)
self.connection.commit()
else:
emailError = UpdateManagerErrors.EmailErrorWindow(
self.getUsername())
emailError.show()
self.close()
def updatePassword(self, n_password, n_conf_password):
if CheckRegistration.validPassword(n_password, n_conf_password):
cursor = self.connection.cursor()
update = (
'UPDATE USERR SET password="******" WHERE username="******";'.format(
n_password, self.getUsername()))
cursor.execute(update)
self.connection.commit()
else:
passError = UpdateManagerErrors.PasswordErrorWindow(
self.getUsername())
passError.show()
self.close()
def updatePhone(self, n_phone):
if (len(n_phone) == 10 and n_phone.isdigit()):
store_id = self.getStoreID()
cursor = self.connection.cursor()
update = (
'UPDATE GROCERYSTORE SET phone={} WHERE store_id={};'.format(
n_phone, store_id))
cursor.execute(update)
self.connection.commit()
else:
emailError = UpdateManagerErrors.EmailErrorWindow(
self.getUsername())
emailError.show()
self.close()
def updateUsername(self, n_username):
if CheckRegistration.validUsername(n_username):
cursor = self.connection.cursor()
update = (
'UPDATE USERR SET username="******" WHERE username="******";'.format(
n_username, self.getUsername()))
cursor.execute(update)
self.connection.commit()
self.setUsername(n_username)
else:
userError = UpdateManagerErrors.UsernameErrorWindow(
self.getUsername())
userError.show()
self.close()