def get_user_by_email(email, type=None): if not type: user = db_session.query(User).filter_by(email=email).first() else: user = db_session.query(User).filter_by(email=email, type=type).first() return user
def user_login(user, remember): u = db_session.query(User).filter_by(email=user.email, passwd=user.passwd).first() if not u: raise DaixieError(USER_NOT_EXIST) user.id = u.id login_user(u, remember=remember) return USER_LOGIN_OK
def admin_login(admin, remember): u = db_session.query(Admin).filter_by(email=admin.email, passwd=admin.passwd).first() if not u: raise DaixieError(USER_NOT_EXIST) admin.id = u.id login_user(u, remember=remember) return USER_LOGIN_OK
def get_solver_by_email(email): cs = db_session.query(Admin).filter_by(email=email, type=Admin.ADMIN_TYPE.SOLVER).first() return cs
def get_cs_by_email(email, type=Admin.ADMIN_TYPE.CS): cs = db_session.query(Admin).filter_by(email=email, type=Admin.ADMIN_TYPE.CS).first() return cs
def get_admin_by_email(email): cs = db_session.query(Admin).filter_by(email=email).first() return cs
def get_transaction_by_user_id(user_id): transaction_list = db_session.query(Transaction).filter_by( user_id=user_id).order_by(Transaction.id.desc()).all() return transaction_list
def get_solver_by_email(email): cs = db_session.query(Admin).filter_by( email=email, type=Admin.ADMIN_TYPE.SOLVER).first() return cs
def get_all_cs_qq(): cs_list = db_session.query(Admin).filter_by(type=Admin.ADMIN_TYPE.CS).all() qq_list = list(cs.qq for cs in cs_list) return dict(qq_list=qq_list)
def get_all_user(): all_solver = db_session.query(User).all() #pass the admin return all_solver
def get_user_by_id(id): user = db_session.query(User).get(id) return user
def get_all_cs_qq(): cs_list = db_session.query(Admin).filter_by( type=Admin.ADMIN_TYPE.CS).all() qq_list = list(cs.qq for cs in cs_list) return dict(qq_list=qq_list)
def get_all_CS(): all_cs = db_session.query(Admin).filter( Admin.type != Admin.ADMIN_TYPE.ADMIN).all() #pass the admin return all_cs
def get_all_CS(): all_cs = db_session.query(Admin).filter(Admin.type != Admin.ADMIN_TYPE.ADMIN).all() #pass the admin return all_cs
def get_cs_by_email(email, type=Admin.ADMIN_TYPE.CS): cs = db_session.query(Admin).filter_by( email=email, type=Admin.ADMIN_TYPE.CS).first() return cs
def get_transaction_by_id(id): transaction = db_session.query(Transaction).get(id) return transaction
def get_transaction_by_user_id(user_id): transaction_list = db_session.query(Transaction).filter_by(user_id=user_id).order_by(Transaction.id.desc()).all() return transaction_list
def get_all_transaction(): all_transaction_list = db_session.query(Transaction).order_by(Transaction.id.desc()).all() return all_transaction_list
def get_admin_by_id(id): admin = db_session.query(Admin).get(id) return admin
def get_all_transaction(): all_transaction_list = db_session.query(Transaction).order_by( Transaction.id.desc()).all() return all_transaction_list