now added it

This commit is contained in:
2024-12-19 15:20:02 +01:00
parent ba37903a5d
commit 4e378d290c
6 changed files with 37 additions and 2797 deletions

View File

@@ -32,9 +32,14 @@ class AddressDAO:
print("FINISHED")#
def getAddressData(self, all = True, zipcode = None):
if self.__cur:
self.__cur.callproc("getAddress", (all, zipcode,))
self.__data = self.__cur.fetchall()
return self.__data
else:
return None
try:
if self.__cur:
self.__cur.callproc("getAddress", (all, zipcode,))
self.__data = self.__cur.fetchall()
return self.__data
else:
return None
except mariadb.Error as e:
print(str(e))

View File

@@ -10,9 +10,12 @@ class BTypeDAO:
self.__cur = self.__con.cursor()
def getBType(self):
if self.__cur:
self.__cur.callproc("getBtype", (None, None, ))
data = self.__cur.fetchall()
return(data)
else:
return None
try:
if self.__cur:
self.__cur.callproc("getBtype", (None, None, ))
data = self.__cur.fetchall()
return(data)
else:
return None
except mariadb.Error as e:
print(str(e))

View File

@@ -17,12 +17,15 @@ class BusinessDAO(QObject):
self.__cur = self.__con.cursor()
def getBusiness(self, enc_key, criterion = "Alle"):
if self.__cur:
self.__cur.callproc("getCustomerView", (enc_key, criterion,))
self.__all_cols = [desc[0] for desc in self.__cur.description]
return self.__cur.fetchall(), self.__all_cols
else:
return None, None
try:
if self.__cur:
self.__cur.callproc("getCustomerView", (enc_key, criterion,))
self.__all_cols = [desc[0] for desc in self.__cur.description]
return self.__cur.fetchall(), self.__all_cols
else:
return None, None
except mariadb.Error as e:
print(str(e))
def addBusiness(self, data, contact_id):
try:

View File

@@ -26,12 +26,14 @@ class UserDAO:
return user_created
def getUser(self, username):
if self.__cur:
self.__cur.callproc("getUser", (username,))
return self.__cur.fetchone()
else:
return None
try:
if self.__cur:
self.__cur.callproc("getUser", (username,))
return self.__cur.fetchone()
else:
return None
except mariadb.Error as e:
print(str(e))