def update(self, sTable, dField, dOption={'ID': 1}):
if (sTable in Tables.keys()):
aListExecute = []
Query = """ UPDATE """
Query += str(sTable)
Query += " SET "
for j in dField.keys():
if (j in Tables[sTable].keys()):
Query += str(j) + " = ?, "
aListExecute.append(dField[j])
else:
#erro
print("ERROR FIELD OR RETURN NOT IN TABLES COLUMNS")
return
Query = Query[:-2]
Query += " WHERE "
for k in dOption.keys():
if (k in Tables[sTable].keys()):
Query += str(k) + " = '" + str(dOption[k]) + "' AND "
else:
#erro
print(
"ERROR FIELD OR RETURN NOT IN TABLES COLUMNS RESEARCH")
return
Query = Query[:-4]
cursor = self.hMaster.cursor()
cursor.execute(Query, aListExecute)
self.hMaster.commit()
print('UPDATED!')
else:
#Error
print('ERROR TABLE DONT EXISTS')
return
def selector(self, sTable, aField, bAll=False, iNumberR=1):
if (sTable in Tables.keys()):
aReturnList = []
Query = """ SELECT """
for j in aField:
if (j in Tables[sTable].keys()):
pass
else:
#erro
print("ERROR FIELD OR RETURN NOT IN TABLES COLUMNS ")
return
cursor = self.hMaster.cursor()
preList = str(aField).strip('[')
preList = preList.strip(']')
preList = preList.replace("'", '')
Query += preList
Query += " FROM {0} ".format(str(sTable))
cursor.execute(Query)
if (bAll == True):
aReturnList = cursor.fetchall()
else:
for _ in range(iNumberR):
try:
aReturnList.append(cursor.fetchone())
except:
#error
print("PAS ASSEZ DE VALEURS A RETOURNER")
pass
return [list(x) for x in aReturnList]
else:
#Error
print('ERROR TABLE DONT EXISTS')
def insert(self, sTable, dField):
if (sTable in Tables.keys()):
aReturnList = []
aListExecute = []
Query = """ INSERT INTO """
Query += str(sTable) + "("
for j in dField.keys():
if (j in Tables[sTable].keys()):
pass
else:
#error
print("ERROR FIELD OR RETURN NOT IN TABLES COLUMNS")
return
for i in dField.keys():
if (isinstance(dField[i], Tables[sTable][i])):
Query += str(i) + ","
else:
#error
print('ERROR FIELD INSERT NOT CORRESPOND TO TYPE DATA')
return
Query = Query[:-1] + ")"
Query += " VALUES("
for d in dField.keys():
Query += ":" + str(d) + ", "
Query = Query[:-2] + ")"
cursor = self.hMaster.cursor()
cursor.execute(Query, dField)
self.hMaster.commit()
else:
#Error
print('ERROR TABLE DONT EXISTS')
return
def exists(self, sTable, sField, sCompare):
if (sTable in Tables.keys()):
if (sField in Tables[sTable].keys()):
if (self.search(sTable, [sField], {sField: sCompare}) == []):
return False
else:
return True
else:
#error
print('ERROR FIELD DONT EXISTS IN TABLE')
return
else:
#error
print('ERROR TABLE DONT EXISTS')
return
def verifyDictionnary(self,
dFields,
bAll=True,
sTable=QueryTables['Users'][0]):
if (bAll):
if (sTable in Tables.keys()):
LenFieldUsers = len(Tables[sTable]) - QueryTables[sTable][1]
if (len(dFields.keys()) == LenFieldUsers):
for field in dFields.keys():
if (field in Tables[sTable].keys()):
if (isinstance(dFields[field],
Tables[sTable][field])):
pass
else:
#Error
print('ERROR FIELDS NOT CORRECT TYPE VALUE')
return False
else:
#Error
print('ERROR FIELDS NOT CORRECT ID DICTIONNARY')
return False
return True
else:
#Error
print('ERROR NOT ALL FIELDS FOR CREATE USER')
return False
else:
#error
print('ERROR TABLE DONT EXISTS')
return False
else:
for field in dFields.keys():
if (field in Tables[sTable].keys()):
if (isinstance(dFields[field], Tables[sTable][field])):
pass
else:
#Error
print('ERROR FIELDS NOT CORRECT TYPE VALUE')
return False
else:
#Error
print('ERROR FIELDS NOT CORRECT ID DICTIONNARY USER')
return False
return True
def search(self, sTable, aField, dOption={'ID': 1}):
if (sTable in Tables.keys()):
aReturnList = []
aListExecute = []
Query = """ SELECT """
for j in aField:
if (j in Tables[sTable].keys()):
pass
else:
#erro
print("ERROR FIELD OR RETURN NOT IN TABLES COLUMNS")
return
for k in dOption.keys():
if (k in Tables[sTable].keys()):
pass
else:
#erro
print(
"ERROR FIELD OR RETURN NOT IN TABLES COLUMNS RESEARCH")
return
cursor = self.hMaster.cursor()
preList = str(aField).strip('[')
preList = preList.strip(']')
preList = preList.replace("'", '')
Query += preList
Query += " FROM {0} ".format(str(sTable))
Query += "WHERE "
for index in dOption.keys():
Query += "{0} = (?) AND ".format(index)
aListExecute.append(str(dOption[index]))
Query = Query[:-4]
cursor.execute(Query, aListExecute)
aReturnList = cursor.fetchall()
if aReturnList == []:
return []
else:
return [list(x) for x in aReturnList]
else:
#Error
print('ERROR TABLE DONT EXISTS')
return
def delete(self, sTable, dOption={'ID': 1}):
if (sTable in Tables.keys()):
aReturnList = []
aListExecute = []
Query = """ DELETE FROM """
Query += str(sTable)
Query += " WHERE "
for k in dOption.keys():
if (k in Tables[sTable].keys()):
Query += str(k) + " = :" + str(k) + " AND "
else:
#erro
print(
"ERROR FIELD OR RETURN NOT IN TABLES COLUMNS RESEARCH")
return
Query = Query[:-4]
cursor = self.hMaster.cursor()
cursor.execute(Query, dOption)
self.hMaster.commit()
print("DELETED")
else:
#Error
print('ERROR TABLE DONT EXISTS')
return
def getByID(self, sTable, iID):
if (sTable in Tables.keys()):
return self.search(sTable, ['*'], {'ID': iID})
else:
#error
print('ERROR TABLE DONT EXISTS')
def delByID(self, sTable, iID):
if (sTable in Tables.keys()):
self.delete(sTable, {'ID': iID})
else:
#Error
print('ERROR TABLE DONT EXISTS')