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 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_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_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 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_user():
all_solver = db_session.query(User).all() #pass the admin
return all_solver
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_user_by_id(id):
user = db_session.query(User).get(id)
return user
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_transaction_by_id(id):
transaction = db_session.query(Transaction).get(id)
return transaction
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
def get_admin_by_id(id):
admin = db_session.query(Admin).get(id)
return admin
