def create_booking():
member_id = request.form["member_id"]
lesson_id = request.form["lesson_id"]
member = member_repository.select(member_id)
lesson = lesson_repository.select(lesson_id)
new_booking = Booking(member, lesson)
booking_repository.save(new_booking)
return redirect("/bookings")
def select_lesson(id):
members = booking_repository.select_members_in_class(id)
lesson = lesson_repository.select(id)
slots = slot_repository.select_all()
return render_template("lessons/lesson_info.html",
lesson=lesson,
slots=slots,
members=members)
def select(id):
sql = 'SELECT * FROM bookings WHERE id = %s'
values = [id]
result = run_sql(sql, values)[0]
member = member_repository.select(result['member_id'])
lesson = lesson_repository.select(result['lesson_id'])
booking = Booking(member, lesson, result['id'])
return booking
def show(id):
lesson = lesson_repository.select(id)
members = lesson_repository.members(lesson)
member_number = len(lesson_repository.members(lesson))
return render_template("lessons/show.html",
lesson=lesson,
members=members,
member_number=member_number)
def create_booking():
member_id = request.form['member_id']
lesson_id = request.form['lesson_id']
member = member_repository.select(member_id)
lesson = lesson_repository.select(lesson_id)
booking = Booking(member, lesson)
booking_repository.save(booking)
return redirect('/bookings')
def new_booking(lesson_id):
slots = slot_repository.select_all()
lesson = lesson_repository.select(lesson_id)
members = member_repository.select_all()
return render_template('/bookings/new.html',
lesson=lesson,
members=members,
slots=slots)
def select_all():
bookings = []
sql = 'SELECT * FROM bookings'
results = run_sql(sql)
for row in results:
member = member_repository.select(row["member_id"])
lesson = lesson_repository.select(row['lesson_id'])
booking = Booking(member, lesson, row['id'])
bookings.append(booking)
return bookings
def edit_lesson(id):
lesson = lesson_repository.select(id)
slots = slot_repository.select_all()
return render_template('lessons/update.html', lesson=lesson, slots=slots)
def edit_lesson(id):
lesson = lesson_repository.select(id)
return render_template("lessons/edit.html", lesson=lesson)
def class_info(lesson_id):
lesson = lesson_repository.select(lesson_id)
slots = slot_repository.select_all()
return render_template('/members/class_info.html', lesson = lesson, slots = slots)
