def get_homework_by_id(group_id, homework_id):
try:
homework = Homework.get_query(filter_condition=(Homework.id == homework_id))
return jsonify(
data=SerializableModelMixin.serialize_row(homework.one())
), 200
except:
return jsonify(
userMessage="해당 숙제를 찾을 수 없습니다."
), 404
def get_homeworks(group_id=0):
if group_id != 0:
filter_condition = (Homework.group_id == group_id)
else:
filter_condition = None
q = Homework.get_query(filter_condition=filter_condition)
# start date end date 처리
if request.args.get('date1') is None:
date1 = datetime.date.today()
print request.args.get('date')
else:
date1 = datetime.datetime.strptime(request.args.get('date1'), "%Y-%m-%d")
print request.args.get('date1')
if request.args.get('date2') is None:
date2 = datetime.date.today()
print request.args.get('date')
else:
date2 = datetime.datetime.strptime(request.args.get('date2'), "%Y-%m-%d")
print request.args.get('date2')
homeworks = q.filter(Homework.date.between(date1, date2)).order_by(Homework.id)
prev_date = None
return_object = {}
for row in homeworks:
# homework, group, course를 dictionary화 하기
(homework, group, course) = row
if prev_date != homework.date:
return_object[str(homework.date)] = []
prev_date = homework.date
homework_object = SerializableModelMixin.serialize_row(row)
# 위에서 생성된 dictionary에 user 정보 추가해서 보내주기
user_homework_relations = db.session.query(UserHomeworkRelation).filter(
UserHomeworkRelation.homework_id == homework.id)
total_user_number = user_homework_relations.count()
is_submitted_number = user_homework_relations.filter(UserHomeworkRelation.is_submitted == True).count()
homework_object['users'] = {'isSubmitted': is_submitted_number, 'count': total_user_number}
return_object[str(homework.date)].append(homework_object)
return jsonify(
data=return_object
), 200