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)
