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