def addManufacturer(self, cursor):
try:
db = database()
self.manufacturerName = input("Enter name of manufacturer.")
mname = self.manufacturerName
while not validator.nameValidate(mname):
mname = input("Enter name of manufacturer.")
self.manufacturerName = mname
self.manufacturerAddr = input("Enter manufacturer's address.")
addr = self.manufacturerAddr
while not validator.addrValidate(addr):
addr = input("Enter manufacturer's address.")
self.manufacturerAddr = addr
self.manufacturerEmail = input("Enter manufacturer's email.")
addr = self.manufacturerEmail
while not validator.emailValidate(addr):
addr = input("Enter manufacturer's email.")
self.manufacturerEmail = addr
self.manufacturerPhno = input(
"Enter manufacturer's contact number.")
addr = self.manufacturerPhno
while not validator.numberValidate(addr):
addr = input("Enter manufacturer's contact number.")
self.manufacturerPhno = addr
db.insertMf(self.manufacturerName, self.manufacturerAddr,
self.manufacturerEmail, self.manufacturerPhno)
print("Record inserted successfully in Manufacturer table.!")
except:
print("Something went wrong.!! Contact the administrator.!")
def updateManufacturer(self, cursor):
try:
name = input("Enter name of manufacturer. !")
args = ['%' + name + '%']
cursor.execute(
'SELECT * FROM dbo.Manufacturer where manufacturer_name like ?',
args)
dash = '-' * 150
data = cursor.fetchall()
if len(data) != 0:
print("Manufacturer found with name entered.! ")
print(dash)
print('{:<5s}{:>30s}{:>30s}{:>30s}{:>30s}'.format(
"Id", "Name", "Location", "Email", "Phone-number"))
print(dash)
for row in data:
print('{:<5s}{:>30s}{:>30s}{:>30s}{:>30s}'.format(
str(row[0]), row[1], row[2], row[3], row[4]))
for row in data:
self.manufacturerId = row[0]
db = database()
self.manufacturerName = input("Enter name of manufacturer.")
mname = self.manufacturerName
while not validator.nameValidate(mname):
mname = input("Enter name of manufacturer.")
self.manufacturerName = mname
self.manufacturerAddr = input("Enter manufacturer's address.")
addr = self.manufacturerAddr
while not validator.addrValidate(addr):
addr = input("Enter manufacturer's address.")
self.manufacturerAddr = addr
self.manufacturerEmail = input("Enter manufacturer's email.")
addr = self.manufacturerEmail
while not validator.emailValidate(addr):
addr = input("Enter manufacturer's email.")
self.manufacturerEmail = addr
self.manufacturerPhno = input(
"Enter manufacturer's contact number.")
addr = self.manufacturerPhno
while not validator.numberValidate(addr):
addr = input("Enter manufacturer's contact number.")
self.manufacturerPhno = addr
db.updateMf(self.manufacturerName, self.manufacturerAddr,
self.manufacturerEmail, self.manufacturerPhno,
self.manufacturerId)
print("Record updated successfully in Manufacturer table.!")
else:
print("No manufacturer found with that name.!")
except:
print("Something went wrong.!! Contact the administrator.!")