def parent_child_grades(parent_id, student_id):
'''Show the student's grades'''
# hypermedia
links = build_link('parent_child_grades', parent_id=parent_id, student_id=student_id,
rel='self')
links += build_link('parent_child_grades', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/gradelist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_child', parent_id=parent_id, rel='http://relations.backtoschool.io/studentlist')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
student = session.query(Student).get(student_id)
if not student or parent_id != student.parent_id:
return build_response(error='Student not found.', links=links), 404
# collect subject names
subjects = session.query(Subject).all()
subjects_names = {}
for s in subjects:
subjects_names[s.id] = s.name
# query grades
grades = []
for g in student.grades:
grades.append(
{'grade': {'id': g.id, 'date': g.date, 'value': g.value, 'subject': subjects_names[g.subject_id]}})
res = {'grades': grades}
return build_response(res, links=links)
def parent_appointment_with_id(parent_id, appointment_id):
# hypermedia
links = build_link('parent_appointment_with_id', parent_id=parent_id, appointment_id=appointment_id, rel='self')
links += build_link('parent_appointment_with_id', parent_id=parent_id, appointment_id=appointment_id,
rel='http://relations.backtoschool.io/appointment')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
appointment = session.query(Appointment).filter_by(id=appointment_id).filter_by(parent_id=parent_id).one()
if not appointment:
return build_response('Appointment not found.')
if request.method == 'PUT':
'''Edit appointment'''
try:
data = request.get_json()
except TypeError:
return build_response(error='The request was not valid JSON.', links=links), 400
# check json content
if not validate_schema(data, 'parent_appointment_with_id', request.method):
return build_response(error="The request didn't follow the provided schema.", links=links), 400
if 'date' in data:
try:
new_date = datetime.datetime.strptime(data['date'], '%Y-%m-%d %H:%M:%S')
except (ValueError, TypeError):
return build_response(error='"date" must be a string following the format "yyyy-mm-dd hh:mm:ss"',
links=links), 400
if check_appointment_time_constraint(new_date):
appointment.date = new_date
appointment.parent_accepted = 0
else:
return build_response(error='Wrong date/time.', links=links), 400
if 'parent_accepted' in data:
appointment.parent_accepted = int(data['parent_accepted'])
session.commit()
teacher = session.query(Teacher).get(appointment.teacher_id)
return build_response({'appointment': {'date': appointment.date, 'room': appointment.room,
'teacher_accepted': appointment.teacher_accepted,
'parent_accepted': appointment.parent_accepted,
'teacher': {'name': teacher.name, 'lastname': teacher.lastname}}}, links=links)
else:
'''Show appointment info'''
teacher = session.query(Teacher).filter_by(id=appointment.teacher_id).one()
return build_response({'appointment': {'date': appointment.date, 'room': appointment.room,
'teacher_accepted': appointment.teacher_accepted,
'parent_accepted': appointment.parent_accepted,
'teacher': {'name': teacher.name, 'lastname': teacher.lastname}}}, links=links)
def parent_notifications(parent_id):
'''Show notifications for this parent'''
# hypermedia
links = build_link('parent_notifications', parent_id=parent_id, rel='self')
links += build_link('parent_notifications', parent_id=parent_id,
rel='http://relations.backtoschool.io/notificationlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
# query
notifications_all = session.query(Notification).filter_by(scope='all').all()
notifications_teachers = session.query(Notification).filter_by(scope='parents').all()
notifications_one_parent = session.query(Notification).filter_by(scope='one_parent').filter_by(
parent_id=parent_id).all()
children_not_list = []
for c in parent.children:
notifications_class_parent = session.query(Notification).filter_by(class_id=c.class_id).all()
child_not_list = []
for n in notifications_class_parent:
child_not_list.append({'date': n.date, 'text': n.text, 'class_notification_scope': n.scope})
children_not_list.append(
{'student': {'name': c.name, 'lastname': c.lastname}, 'notifications': child_not_list})
notifications_teachers_list = []
for n in notifications_teachers:
notifications_teachers_list.append({'date': n.date, 'text': n.text})
notifications_all_list = []
for n in notifications_all:
notifications_all_list.append({'date': n.date, 'text': n.text})
notifications_one_parent_list = []
for n in notifications_one_parent:
notifications_one_parent_list.append({'date': n.date, 'text': n.text})
return build_response([{'scope': 'class', 'notifications': "children_not_list"},
{'scope': 'parents', 'notifications': notifications_teachers_list},
{'scope': 'all', 'notifications': notifications_all_list},
{'scope': 'one_parent', 'notifications': notifications_one_parent_list}], links=links)
def parent_child(parent_id):
'''List children of this parent'''
# hypermedia
links = build_link('parent_child', parent_id=parent_id, rel='self')
links += build_link('parent_child', parent_id=parent_id, rel='http://relations.backtoschool.io/studentlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
if not parent.children:
return build_response(error='No students found.', links=links), 404
children = []
for c in parent.children:
children.append({'name': c.name, 'lastname': c.lastname, 'id': c.id})
res = {'students': children}
# more hypermedia
for i in range(min(10, len(children))):
links += build_link('parent_child_with_id', parent_id=parent_id, student_id=children[i]['id'],
rel='http://relations.backtoschool.io/student')
return build_response(res, links=links)
def parent_payment_pending(parent_id):
'''list pending payments'''
# hypermedia
links = build_link('parent_payment_pending', parent_id=parent_id, rel='self')
links += build_link('parent_payment_pending', parent_id=parent_id,
rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_payment', parent_id=parent_id,
rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_payment_paid', parent_id=parent_id,
rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
payments = []
for p in parent.payments:
if (p.is_pending):
payments.append({'id': p.id, 'amount': p.amount, 'date': p.date, 'reason': p.reason})
# more hypermedia
for i in range(min(5, len(parent.payments))):
links += build_link('parent_payment_with_id', parent_id=parent_id, payment_id=parent.payments[i].id,
rel='http://relations.backtoschool.io/payment')
return build_response({'payments': payments}, links=links)
def parent_appointment_day(parent_id, teacher_id, year, month, day):
'''Show appointments, free slots for the day'''
# hypermedia
links = build_link('parent_appointment_day', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month, day=day, rel='self')
links += build_link('parent_appointment_day', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month, day=day, rel='http://relations.backtoschool.io/freeslots')
links += build_link('parent_appointment_month', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month, rel='http://relations.backtoschool.io/freedays')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
if datetime.datetime(year, month, day) < datetime.datetime.today():
return build_response(
error='Wait a minute. Wait a minute, Doc. Ah... Are you telling me that you built a time machine... out of a DeLorean?',
links=links), 404
w_day = datetime.datetime(year, month, day).weekday()
if w_day == 6:
return build_response(error="No slots available on Sunday.", links=links)
teacher = session.query(Teacher).get(teacher_id)
if not teacher:
return build_response(error='Teacher not found.', links=links), 404
# setto tutti gli slot a 1=libero
daily_slots = {}
for i in range(8, 13):
daily_slots[str(i) + '00'] = 1
daily_slots[str(i) + '30'] = 1
for a in teacher.appointments:
if (a.date.year == year and a.date.month == month and a.date.day == day and a.teacher_accepted == 1):
daily_slots[str(a.date.hour) + str(a.date.minute)] = 0
for s in teacher.subjects:
schedule = json.loads(s.timetable)
for t in schedule:
if t['day'] == w_day:
for x in range(t['start_hour'], t['end_hour']):
# setto 2 slot come occupati -> lezioni vanno di ora in ora
daily_slots[str(x) + '00'] = 0
daily_slots[str(x) + '30'] = 0
free = []
for key, value in daily_slots.items():
if value == 1:
free.append(key)
res = {'date': datetime.datetime(year, month, day), 'free_slots': free}
if not res:
return build_response(error="No slots available.", links=links)
return build_response(res, links=links)
def parent_with_id(parent_id):
'''parent main index: parent info, hypermedia'''
# hypermedia
links = build_link('parent_with_id', parent_id=parent_id,
rel='self')
links += build_link('parent_with_id', parent_id=parent_id,
rel='http://relations.backtoschool.io/index')
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found', links=links), 404
res = {'name': parent.name,
'lastname': parent.lastname}
# more hypermedia
links += build_link('parent_data', parent_id=parent_id, rel='http://relations.backtoschool.io/data')
links += build_link('parent_child', parent_id=parent_id, rel='http://relations.backtoschool.io/studentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
links += build_link('parent_payment', parent_id=parent_id, rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_notifications', parent_id=parent_id,
rel='http://relations.backtoschool.io/notificationlist')
return build_response(res, links=links)
def parent_child_data(parent_id, student_id):
# hypermedia
links = build_link('parent_child_data', parent_id=parent_id, student_id=student_id,
rel='self')
links += build_link('parent_child_data', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/data')
links += build_link('parent_child_data', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/updatedata')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_child', parent_id=parent_id, rel='http://relations.backtoschool.io/studentlist')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
student = session.query(Student).get(student_id)
if not student or parent_id != student.parent_id:
return build_response(error='Student not found.', links=links), 404
if request.method == 'PUT':
'''Edit child personal data'''
try:
data = request.get_json()
except TypeError:
return build_response(error='The request was not valid JSON.', links=links), 400
# check json content
if not validate_schema(data, 'parent_child_data', request.method):
return build_response(error="The request didn't follow the provided schema.", links=links), 400
if 'name' in data:
student.name = data['name']
if 'lastname' in data:
student.lastname = data['lastname']
session.commit()
res = {'data': {'name': student.name, 'lastname': student.lastname}}
return build_response(res, links=links)
else:
'''Show child personal data'''
res = {'data': {'name': student.name, 'lastname': student.lastname}}
return build_response(res, links=links)
def parent_child_teacher(parent_id, student_id):
'''List the child's teachers'''
# hypermedia
links = build_link('parent_child_teacher', parent_id=parent_id, student_id=student_id,
rel='self')
links += build_link('parent_child_teacher', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/teacherlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_child', parent_id=parent_id, rel='http://relations.backtoschool.io/studentlist')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
student = session.query(Student).get(student_id)
if not student or parent_id != student.parent_id:
return build_response(error='Student not found.', links=links), 404
# query
c = session.query(Class).get(student.class_id)
t_list = []
if c:
# get all teachers who have this class
teachers = session.query(Teacher).all()
for t in teachers:
if c in t.classes:
subjects = [s for s in t.subjects if s.class_id == student.class_id]
s_list = []
for s in subjects:
s_list.append({'id': s.id, 'name': s.name})
t_list.append({'id': t.id, 'name': t.name, 'lastname': t.lastname, 'subjects': s_list})
res = {'teachers': t_list}
# more hypermedia
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
return build_response(res, links=links)
def parent_child_with_id(parent_id, student_id):
'''Show info for this student'''
# hypermedia
links = build_link('parent_child_with_id', parent_id=parent_id, student_id=student_id, rel='self')
links += build_link('parent_child_with_id', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/student')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
student = session.query(Student).filter_by(parent_id=parent_id).filter_by(id=student_id).one()
if not student:
return build_response(error='Student not found.', links=links), 404
# query
c = session.query(Class).get(student.class_id)
if c:
subjects = []
for s in c.subjects:
subjects.append({'id': s.id, 'name': s.name})
c_obj = {'id': c.id, 'name': c.name, 'room': c.room, 'subjects': subjects}
else:
c_obj = None
res = {'student': {'name': student.name, 'lastname': student.lastname, 'id': student.id, 'class': c_obj}}
# more hypermedia
links += build_link('parent_child_data', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/data')
links += build_link('parent_child_data', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/updatedata')
links += build_link('parent_child_grades', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/gradelist')
links += build_link('parent_child_teacher', parent_id=parent_id, student_id=student_id,
rel='http://relations.backtoschool.io/teacherlist')
return build_response(res, links=links)
def parent_pay(parent_id, payment_id):
'''Magic payment endpoint'''
# hypermedia
links = build_link('parent_pay', parent_id=parent_id, payment_id=payment_id, rel='self')
links += build_link('parent_pay', parent_id=parent_id, payment_id=payment_id,
rel='http://relations.backtoschool.io/completepayment')
links += build_link('parent_payment', parent_id=parent_id, rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
# checks
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
payment = session.query(Payment).get(payment_id)
if not payment or payment.parent_id != parent_id:
return build_response(error='Payment not found.', links=links), 404
if payment.is_pending:
# MAGIC HAPPENS!
payment.is_pending = False
session.commit()
return build_response('Payment confirmed.', links=links)
def parent_appointment_month(parent_id, teacher_id, year, month):
'''Show which days have appointments and free slots for the month'''
# hypermedia
links = build_link('parent_appointment_month', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month, rel='self')
links += build_link('parent_appointment_month', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month, rel='http://relations.backtoschool.io/freedays')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
if month > 12 or month < 1:
return build_response(error='Insert existing month.', links=links), 404
if year < datetime.date.today().year or (
year == datetime.date.today().year and month < datetime.date.today().month):
return build_response(
error='Wait a minute. Wait a minute, Doc. Ah... Are you telling me that you built a time machine... out of a DeLorean?',
links=links), 404
teacher = session.query(Teacher).get(teacher_id)
if not teacher:
return build_response(error='Teacher not found.', links=links), 404
res = []
for d in calendar.Calendar().itermonthdates(year, month):
if d.month == month and d >= datetime.date.today() and available_slot_in_day(d,
teacher.appointments, teacher.subjects):
res.append({'date': d})
if not res:
return build_response(error='No available appointments for this month.', links=links), 404
# more hypermedia
for d in res:
links += build_link('parent_appointment_day', parent_id=parent_id, teacher_id=teacher_id,
year=year, month=month,
day=d['date'].day, rel='http://relations.backtoschool.io/freeslots')
return build_response({'available_days': res}, links=links)
def parent_payment_with_id(parent_id, payment_id):
'''show payment info'''
# hypermedia
links = build_link('parent_payment_with_id', parent_id=parent_id, payment_id=payment_id, rel='self')
links += build_link('parent_payment_with_id', parent_id=parent_id, payment_id=payment_id,
rel='http://relation.backtoschool.io/payment')
links += build_link('parent_payment', parent_id=parent_id, rel='http://relations.backtoschool.io/paymentlist')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
# checks
payment = session.query(Payment).get(payment_id)
if not payment or payment.parent_id != parent_id:
return build_response(error='Payment not found.', links=links), 404
res = {'amount': payment.amount, 'date': payment.date, 'reason': payment.reason, 'pending': payment.is_pending}
# more hypermedia
if payment.is_pending:
links += build_link('parent_pay', parent_id=parent_id, payment_id=payment_id,
rel='http://relations.backtoschool.io/completepayment')
return build_response(res, links=links)
def parent_appointment(parent_id):
# hypermedia
links = build_link('parent_appointment', parent_id=parent_id, rel='self')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/appointmentlist')
links += build_link('parent_appointment', parent_id=parent_id,
rel='http://relations.backtoschool.io/createappointment')
links += build_link('parent_with_id', parent_id=parent_id, rel='http://relations.backtoschool.io/index')
parent = session.query(Parent).get(parent_id)
if not parent:
return build_response(error='Parent not found.', links=links), 404
# more hypermedia
ts = session.query(Teacher).all()
for t in ts:
if any(c.class_id in [x.id for x in t.classes] for c in parent.children):
links += build_link('parent_appointment_month', parent_id=parent_id, teacher_id=t.id,
year=datetime.datetime.now().year, month=datetime.datetime.now().month,
rel='http://relations.backtoschool.io/freedays')
links += build_link('parent_appointment_day', parent_id=parent_id, teacher_id=t.id,
year=datetime.datetime.now().year, month=datetime.datetime.now().month,
day=datetime.datetime.now().day, rel='http://relations.backtoschool.io/freeslots')
if request.method == 'POST':
'''Create new appointment'''
try:
data = request.get_json()
except TypeError:
return build_response(error='The request was not valid JSON.', links=links), 400
# check json content
if not validate_schema(data, 'parent_appointment', request.method):
return build_response(error="The request didn't follow the provided schema.", links=links), 400
teacher = session.query(Teacher).filter_by(id=data['teacher_id']).one()
if not teacher:
return build_response(error='Teacher not found.', links=links), 404
try:
new_date = datetime.datetime.strptime(data['date'], '%Y-%m-%d %H:%M:%S')
except (ValueError, TypeError):
return build_response(error='"date" must be a string following the format "yyyy-mm-dd hh:mm:ss"',
links=links), 400
# check if teacher available
if (check_appointment_time_constraint(new_date)):
if (teacher_available(new_date, teacher.appointments, teacher.subjects)):
new_appointment = Appointment(date=new_date, teacher_accepted=0, parent_accepted=1,
teacher_id=data['teacher_id'], parent_id=parent_id)
session.add(new_appointment)
session.commit()
a = new_appointment
# more hypermedia
links += build_link('parent_appointment_with_id', parent_id=parent_id, appointment_id=a.id,
rel='http://relations.backtoschool.io/appointment')
res = {'id': a.id, 'date': a.date, 'room': a.room, 'teacher accepted': a.teacher_accepted,
'parent_accepted': a.parent_accepted,
'teacher': {'id': a.teacher_id, 'name': teacher.name, 'lastname': teacher.lastname}}
response = build_response(res, links=links)
response.headers['Location'] = url_for('parent_appointment_with_id', parent_id=parent_id, appointment_id=a.id)
return response, 201
else:
return build_response(error='Teacher not available. Choose a free slot.', links=links), 400
else:
return build_response(error='Wrong date/time format.', links=links), 400
else:
'''Show all appointments'''
appointments = []
for a in parent.appointments:
teacher = session.query(Teacher).filter_by(id=a.teacher_id).one()
appointments.append({'id': a.id, 'date': a.date, 'room': a.room, 'teacher accepted': a.teacher_accepted,
'parent_accepted': a.parent_accepted,
'teacher': {'id': a.teacher_id, 'name': teacher.name, 'lastname': teacher.lastname}})
# more hypermedia
for i in range(min(10, len(appointments))):
links += build_link('parent_appointment_with_id', parent_id=parent_id,
appointment_id=parent.appointments[i].id,
rel='http://relations.backtoschool.io/appointment')
return build_response(appointments, links=links)