def delete_user_by_name(cls, user_name):
user_name = dbSession.query(cls).filter(
cls.user_name == user_name).first()
if user_name is not None:
dbSession.delete(user_name)
return True
else:
return False
def create_root_user():
# 先查询用户是否存在
user = dbSession.query(UsersInfoModule).filter(
UsersInfoModule.user_role == "root").first()
# 不存在创建用户
if user is None:
user_module = UsersInfoModule()
user_module.user_name = DefaultAdminUser.user_name
user_module.chinese_name = DefaultAdminUser.chinese_name
user_module.nick_name = DefaultAdminUser.nick_name
user_module.pass_word = DefaultAdminUser.pass_word
user_module.address = DefaultAdminUser.address
user_module.department = DefaultAdminUser.department
user_module.email = DefaultAdminUser.email
user_module.user_role = DefaultAdminUser.user_role
user_module.pwd_modified = False
user_module.change_pwd_count = 0
dbSession.add(user_module)
dbSession.commit()
def get_all_organizer_info(cls):
return dbSession.query(cls).all()
def get_all_exchange_apply_info(cls):
return dbSession.query(cls).all()
def get_all_users_info(cls):
return dbSession.query(cls).all()
def get_all_history_info(cls):
return dbSession.query(cls).all()
def get_all_issues_info(cls):
return dbSession.query(cls).all()
def get_all_scoring_criteria(cls):
return dbSession.query(cls).all()
def get_all_exchanged_history(cls):
return dbSession.query(cls).all()
def get_all_attendance_info(cls):
return dbSession.query(cls).all()
def get_all_score_history(cls):
return dbSession.query(cls).all()
def get_all_score_info(cls):
return dbSession.query(cls).all()
def get_all_exchange_rules(cls):
return dbSession.query(cls).all()
def get_all_meeting_info(cls):
return dbSession.query(cls).all()