def get_user_homework_relation_by_id(user_homework_relation_id):
try:
user_homework_relation = UserHomeworkRelation.get_query(
filter_condition=(UserHomeworkRelation.id == user_homework_relation_id))
return jsonify(
data=SerializableModelMixin.serialize_row(user_homework_relation.one())
), 200
except:
return jsonify(
userMessage="해당 관계를 찾을 수 없습니다."
), 404
def get_user_homework_relations():
if request.args.get('userId') is not None:
user_id = int(request.args.get('userId'))
else:
user_id = 0
if request.args.get('homeworkId'):
homework_id = int(request.args.get('homeworkId'))
else:
homework_id = 0
if user_id >= 1 and homework_id >= 1:
filter_condition = (UserHomeworkRelation.user_id == user_id, UserHomeworkRelation.homework_id == homework_id)
elif user_id >= 1 >= homework_id:
filter_condition = (UserHomeworkRelation.user_id == user_id)
elif homework_id >= 1 >= user_id:
filter_condition = (UserHomeworkRelation.homework_id == homework_id)
else:
filter_condition = None
# filter_condition = None
print filter_condition
user_homework_relations = UserHomeworkRelation.get_query(filter_condition=filter_condition)
# start date end date 처리
if request.args.get('date1') is None:
date1 = datetime.date.today()
else:
date1 = datetime.datetime.strptime(request.args.get('date1'), "%Y-%m-%d")
if request.args.get('date2') is None:
date2 = datetime.date.today()
else:
date2 = datetime.datetime.strptime(request.args.get('date2'), "%Y-%m-%d")
user_homework_relations = user_homework_relations.filter(Homework.date.between(date1, date2)).order_by(Homework.id)
return jsonify(
data=map(SerializableModelMixin.serialize_row, user_homework_relations)
), 200
