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