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