def get_all():
cursor = execute_query(
'select id, username, school_id from school_manager')
return cursor.fetchall()
def check_password(manager_name, password):
cursor = execute_query(
'select count(*) from school_manager where username=? and password=?',
(manager_name, password))
return cursor.fetchone()[0] == 1
def get_by_id(manager_id):
cursor = execute_query(
'select id, username, school_id from school_manager where id=?',
[manager_id])
return cursor.fetchone()
def get_by_name(manager_name):
cursor = execute_query(
'select id, username, school_id from school_manager where username=?',
(manager_name, ))
return cursor.fetchone()
def get_by_user(user_id):
cursor = execute_query(
'select document.id, type, description, content, course_id, course.name, content '
'from document left join course on document.course_id=course.id where document.id in (select doc_id from '
'user_doc where user_id=?)', [user_id])
return cursor.fetchall()
def is_visible_to_school(school_id, doc_id):
cursor = execute_query(
'select count(1) from school_doc where school_id=? and doc_id=?',
[school_id, doc_id])
return cursor.fetchone()[0] == 1
def get_by_id(document_id):
cursor = execute_query(
'select document.id, type, description, content, course_id, course.name, content'
' from document left join course on document.course_id=course.id where document.id=? ',
[document_id])
return cursor.fetchone()
def get_by_name(manager_name):
cursor = execute_query(
'select id, username, is_super from backend_manager where username=?',
(manager_name, ))
return cursor.fetchone()
def get_by_id(school_id):
cursor = execute_query('select id, name from school where id=?',
[school_id])
return cursor.fetchone()
def get_by_name(school_name):
cursor = execute_query('select id, name from school where name=?',
(school_name, ))
return cursor.fetchone()
def get_all():
cursor = execute_query(
'select id, username, school_id, (select count(1) from user_doc where user_id=school_user.id) as doc_number'
' from school_user')
return cursor.fetchall()
def get_by_name(username):
cursor = execute_query(
'select id, username, school_id, (select count(1) from user_doc where user_id=school_user.id) as doc_number'
' from school_user where username=?', (username, ))
return cursor.fetchone()
def get_all():
cursor = execute_query(
'select id, username, is_super from backend_manager')
return cursor.fetchall()
def get_by_id(course_id):
cursor = execute_query('select id, name from course where id=?', [course_id])
return cursor.fetchone()
def get_all():
cursor = execute_query(
'select document.id, type, description, content, course_id, course.name, content'
' from document left join course on document.course_id=course.id')
return cursor.fetchall()
def get_all():
cursor = execute_query('select id, name from course')
return cursor.fetchall()
def get_by_id(manager_id):
cursor = execute_query(
'select id, username, is_super from backend_manager where id=?',
[manager_id])
return cursor.fetchone()
