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