def check_existence_of_new_location_and_add_it(self, data_location): #DB CONNECTION db = MyDB() location_text = str(self.new_location_box.text) location_id = self.ent_jur_button.id_object location_exist = db.check_existence_of_new_location_and_add_it_db(data_location,location_text,location_id) self.new_location_box.text = "" self.location_listbox.location_listview.adapter.data = self.location_listbox.get_location_list()
def check_existence_of_new_service_and_add_it(self, data_service): # DB CONNECTION db = MyDB() service_text = self.new_service_box.text location_id = self.location_button.id_object service_exist = db.check_existence_of_new_service_and_add_it_db(data_service, service_text, location_id) self.new_service_box.text = "" self.service_listbox.service_listview.adapter.data = self.service_listbox.get_service_list()
def get_ent_jur_list(self): #DB CONNECTION db = MyDB() #Execute la requete SQL get_all_legal_entities_query = "SELECT *FROM EntiteJuridique;" try: db.query(get_all_legal_entities_query,[]) db.commit() except: db.rollback() #On obtient une matrice legal_entities_data = db.db_fetchall() # Liste d'entite Juridique data_ent_jur = ListEntJur(legal_entities_data) return data_ent_jur
def check_login(self, *args): user_login = self.login_box.text user_password = self.password_box.text # DB CONNECTION db = MyDB() login_query = "SELECT * FROM utilisateur WHERE login =%s AND password = %s" parameters_query =[user_login,user_password] try: db.query(login_query,parameters_query) db.commit() except: db.rollback() login_data = db.db_fetchall() if login_data: user_logged = User(user_login) self.dispatch('on_right_id') else: self.login_box.focus = True self.remove_widget(self.pan_screen) self.error_box.text = "Wrong credentials" # create an animation object. This object could be stored # and reused each call or reused across different widgets. # += is a sequential step, while &= is in parallel animation = Animation(x=(0), t='out_bounce') # apply the animation on the button, passed in the "instance" argument # Notice that default 'click' animation (changing the button # color while the mouse is down) is unchanged. animation.start(self.login_area)
def get_module_available(self): ###################Looking into Module##################### #DB CONNECTION db = MyDB() modules_query = """SELECT m.intitule, o.intitule FROM module AS m , outil AS o, utilisateur AS u, utilisateuroutil AS uo WHERE u.login =%s AND uo.idUtilisateur = u.idUtilisateur AND uo.idOutil = o.idOutil AND o.idModule = m.idModule""" user_logged = User() parameters_query =[user_logged.login] try: db.query(modules_query,parameters_query) db.commit() except: db.rollback() modules_data = db.db_fetchall() return modules_data
def get_object_list(self): db = MyDB() data_ent_jur = db.get_all_ent_jur() return data_ent_jur
def get_location_list(self): #DB CONNECTION db = MyDB() data_location = db.get_location_list_db() return data_location
def get_service_list(self): # DB CONNECTION db = MyDB() data_service = db.get_service_list_db() return data_service