def query_teacher_names(cls,
query_dict: dict = None,
unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = NoticeLesson.query.with_entities(
NoticeLesson.lesson_teacher_id, NoticeLesson.lesson_teacher_name,
NoticeLesson.lesson_teacher_unit,
NoticeLesson.lesson_attention_reason,
NoticeLesson.group_name).distinct()
if not unscoped:
query = query.filter(NoticeLesson.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, NoticeLesson)
(lessons, total) = page_query(query, url_condition.page_dict)
print(lessons)
except Exception as e:
raise CustomError(500, 500, str(e))
return [{
'lesson_teacher_name': data.lesson_teacher_name,
'lesson_teacher_id': data.lesson_teacher_id,
'lesson_teacher_unit': data.lesson_teacher_unit,
'lesson_attention_reason': data.lesson_attention_reason,
'group_name': data.group_name
} for data in lessons], total
def update_supervisor(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = {}
if query_dict is None:
query_dict = {}
query = Supervisor.query.filter(Supervisor.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, Supervisor)
(supervisors, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for supervisor in supervisors:
for key, value in data.items():
if hasattr(supervisor, key):
setattr(supervisor, key, value)
db.session.add(supervisor)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def query_lessons(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = Lesson.query
if not unscoped:
query = query.filter(Lesson.using == True)
lesson_or_teacher_name = query_dict.get('lesson_or_teacher_name_or',
None)
if lesson_or_teacher_name is not None and len(
lesson_or_teacher_name) != 0:
del query_dict['lesson_or_teacher_name_or']
lesson_or_teacher_name = lesson_or_teacher_name[0]
query = query.filter(
or_(
Lesson.lesson_name.like(lesson_or_teacher_name + "%"),
Lesson.lesson_teacher_name.like(lesson_or_teacher_name +
"%")))
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, Lesson)
(lessons, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(lesson) for lesson in lessons], total
def update_lesson_record(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = dict()
if query_dict is None:
query_dict = dict()
data = cls.reformatter_update(data)
query = LessonRecord.query.filter(LessonRecord.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, LessonRecord)
(lesson_records, total) = page_query(query,
url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for lesson_record in lesson_records:
for key, value in data.items():
if hasattr(lesson_record, key):
setattr(lesson_record, key, value)
db.session.add(lesson_record)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def update_activity_user(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = {}
if query_dict is None:
query_dict = {}
data = cls.reformatter_update(data)
query = ActivityUser.query.filter(ActivityUser.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, ActivityUser)
(activity_users, total) = page_query(query,
url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for activity_user in activity_users:
for key, value in data.items():
if hasattr(activity_user, key):
setattr(activity_user, key, value)
db.session.add(activity_user)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def update_consult_type(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = {}
if query_dict is None:
query_dict = {}
data = cls.reformatter_update(data)
query = ConsultType.query.filter(ConsultType.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, ConsultType)
(consult_types, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for consult_type in consult_types:
for key, value in data.items():
if hasattr(consult_type, key):
setattr(consult_type, key, value)
db.session.add(consult_type)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def update_model_lesson(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = {}
if query_dict is None:
query_dict = {}
data = cls.reformatter_update(data)
query = ModelLesson.query.filter(ModelLesson.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, ModelLesson)
(model_lessons, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for model_lesson in model_lessons:
for key, value in data.items():
if hasattr(model_lesson, key):
setattr(model_lesson, key, value)
db.session.add(model_lesson)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def update_group(cls,
ctx=True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = {}
if query_dict is None:
query_dict = {}
url_condition = UrlCondition(query_dict)
query = Group.query.filter(Group.using == True)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, Group)
(groups, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for group in groups:
for key, value in data.items():
if hasattr(group, key):
setattr(group, key, value)
db.session.add(group)
if ctx:
try:
db.session.commit()
except Exception as e:
db.session.rollback()
raise CustomError(500, 500, str(e))
return True
def update_work_plan(cls,
ctx: bool = True,
query_dict: dict = None,
data: dict = None):
if data is None:
data = dict()
if query_dict is None:
query_dict = dict()
data = cls.reformatter_update(data)
query = WorkPlan.query.filter(WorkPlan.using == True)
url_condition = mysql_url_condition.UrlCondition(query_dict)
try:
query = mysql_url_condition.process_query(
query, url_condition.filter_dict,
url_condition.sort_limit_dict, WorkPlan)
(work_plans,
total) = mysql_url_condition.page_query(query,
url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for work_plan in work_plans:
for key, value in data.items():
if hasattr(work_plan, key):
setattr(work_plan, key, value)
db.session.add(work_plan)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def query_supervisors(cls, query_dict: dict, unscoped: bool = False):
query = Supervisor.query
if not unscoped:
query = query.filter(Supervisor.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Supervisor)
(supervisors, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(supervisor) for supervisor in supervisors], total
def query_groups(cls, query_dict: dict = None):
if query_dict is None:
query_dict = {}
url_condition = UrlCondition(query_dict)
query = Group.query.filter(Group.using == True)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Group)
(groups, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(data) for data in query], total
def query_activities(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = Activity.query
if not unscoped:
query = query.filter(Activity.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Activity)
(activities, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(activity) for activity in activities], total
def query_teacher_names(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = Lesson.query.with_entities(Lesson.lesson_teacher_name).distinct()
if not unscoped:
query = query.filter(Lesson.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Lesson)
(lessons, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [data.lesson_teacher_name for data in query], total
def query_lesson_cases(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = cls.query
if not unscoped:
query = query.filter(cls.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, cls)
(lesson_cases, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(lesson_case) for lesson_case in lesson_cases], total
def query_events(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = Event.query
if not unscoped:
query = query.filter(Event.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Event)
(events, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(event) for event in events], total
def query_users(cls, query_dict: dict = None, unscoped=False):
if query_dict is None:
query_dict = {}
query = User.query
if not unscoped:
query = query.filter(User.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, User)
(users, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(user) for user in users], total
def query_other_model_lessons(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = {}
query = OtherModelLesson.query
if not unscoped:
query = query.filter(OtherModelLesson.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, OtherModelLesson)
(other_model_lessons, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(other_model_lesson) for other_model_lesson in other_model_lessons], total
def query_terms(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = dict()
url_condition = UrlCondition(query_dict)
query = Term.query
if not unscoped:
query = query.filter(Term.using == True)
if 'time' in query_dict:
query = query.filter(Term.begin_time < query_dict['time']).filter(
Term.end_time >= query_dict['time'])
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Term)
(terms, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(term) for term in terms], total
def query_work_plan(cls, query_dict: dict = None, unscoped: bool = False):
if query_dict is None:
query_dict = dict()
query = WorkPlan.query
if not unscoped:
query = query.filter(WorkPlan.using == True)
url_condition = mysql_url_condition.UrlCondition(query_dict)
try:
query = mysql_url_condition.process_query(
query, url_condition.filter_dict,
url_condition.sort_limit_dict, WorkPlan)
(res,
total) = mysql_url_condition.page_query(query,
url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
return [cls.formatter(data) for data in res], total
def delete_lesson_case(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = cls.query.filter(cls.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, cls)
(lesson_cases, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for lesson_case in lesson_cases:
lesson_case.using = False
db.session.add(lesson_case)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_model_lesson(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = ModelLesson.query.filter(ModelLesson.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, ModelLesson)
(model_lessons, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for model_lesson in model_lessons:
model_lesson.using = False
db.session.add(model_lesson)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_event(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = Event.query.filter(Event.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Event)
(events, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for event in events:
event.using = False
db.session.add(event)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_supervisor(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = Supervisor.query.filter(Supervisor.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, Supervisor)
(supervisors, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for supervisor in supervisors:
supervisor.using = False
db.session.add(supervisor)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_activity_user(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = ActivityUser.query.filter(ActivityUser.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict, url_condition.sort_limit_dict, ActivityUser)
(activity_users, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for activity_user in activity_users:
activity_user.using = False
db.session.add(activity_user)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_consult_type(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = {}
query = ConsultType.query.filter(ConsultType.using == True)
url_condition = UrlCondition(query_dict)
try:
query = process_query(query, url_condition.filter_dict,
url_condition.sort_limit_dict, ConsultType)
(consult_types, total) = page_query(query, url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for consult_type in consult_types:
consult_type.using = False
db.session.add(consult_type)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True
def delete_work_plan(cls, ctx: bool = True, query_dict: dict = None):
if query_dict is None:
query_dict = dict()
query = WorkPlan.query.filter(WorkPlan.using == True)
url_condition = mysql_url_condition.UrlCondition(query_dict)
try:
query = mysql_url_condition.process_query(
query, url_condition.filter_dict,
url_condition.sort_limit_dict, WorkPlan)
(work_plans,
total) = mysql_url_condition.page_query(query,
url_condition.page_dict)
except Exception as e:
raise CustomError(500, 500, str(e))
for work_plan in work_plans:
work_plan.using = False
db.session.add(work_plan)
if ctx:
try:
db.session.commit()
except Exception as e:
raise CustomError(500, 500, str(e))
return True