def check_existence_of_new_location_and_add_it(self, data_location): #DB CONNECTION db = MyDB() location_exist = False for row in data_location: if row.loc_intitule == self.new_location_box.text: print("This Location already exists") location_exist = True if location_exist == False: #selected_ent_jur = idEntJur= self.ent_jur_listbox.ent_jur_listview.adapter.selection[0].id_jur_ent add_permission_query = "INSERT INTO `Permission`;" get_permission_id_query = """SELECT P.idPermission AS idP FROM Permission P ORDER BY P.idPermission DESC LIMIT 1;""" add_location_query = """INSERT INTO `Location` (idLocation, intitule, idEntJur) VALUES (%d,%s,%d);""" #try: db.query(add_permission_query,[]) db.query(get_permission_id_query,[]) id_permission_data = db.db_fetchone() parameters_query = [id_permission_data,self.new_location_box.text,idEntJur] db.query(add_location_query,parameters_query) db.commit() #except: #db.rollback() self.new_location_box.text = "" self.location_listbox.location_listview.adapter.data = self.location_listbox.get_location_list()