def login(self, *args): global user_id email_input = self.ids.email_input user_email = email_input.text password_input = self.ids.password_input user_password = password_input.text res = session.query(User).filter(and_(User.email == user_email, User.password == user_password)).count() sql = "SELECT id, name \ FROM users \ WHERE email='%s' \ AND password='******'" % (user_email, user_password) alchemysql = alchemy_text(sql) res = engine.execute(alchemysql) res = [r for r in res] if len(res)==1: res = res [0] user_id, name = res ScreenMain=app.my_screenmanager.get_screen('ScreenMain') ScreenMain.new_user(user_id, name) app.my_screenmanager.current = 'ScreenMain' else: self.popupwrong_password()
def add_classes(self): # sql get classes for user # is user a from teacher ? # change spinner text & values sql = 'SELECT sg.id, s.name \ FROM studygroups sg \ JOIN subjects s ON (sg.subject_id = s.id) \ WHERE sg.staff_id=%d \ AND sg.schYr = %d' % (user_id, 2016) alchemysql = alchemy_text(sql) result = engine.execute(alchemysql) classes = [r for r in result] self.create_dropdown(classes) if not classes: return print classes first_id = classes[0][0] first_name = classes[0][1] ddbtn = self.ids.btn_ddID ddbtn.text = str(first_name) return first_id
def add_children(self): global user_id, children_dict children_dict = {} print 'add_children' # sql get children for parent user_id = 180 # test sql = 'SELECT id, name \ FROM students \ WHERE father_id=180' alchemysql = alchemy_text(sql) result = engine.execute(alchemysql) children = [r for r in result] count_children = len(children) for sid, name in children: children_dict[sid] = name print 'children_dict',children_dict self.create_dropdown(children) first_id = children[0][0] first_name = children[0][1] ddbtn = self.ids.btn_ddID ddbtn.text = str(first_name) return first_id
def class_selected(self, *args ): class_id = args[0] student_list_widget = self.ids.student_list student_list_widget.clear_widgets() if not class_id: return sql = 'SELECT s.id, s.name \ FROM students_by_studygroup ss \ JOIN students s ON (ss.student_id = s.id) \ WHERE ss.studygroup_id=%d ' % (class_id,) alchemysql = alchemy_text(sql) result = engine.execute(alchemysql) # convert to a python list students = [r for r in result] self.add_students(students)