def select(id):
sql = "SELECT * FROM bookings WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
workout = workout_repository.select(result["workout_id"])
member = member_repository.select(result["member_id"])
booking = Booking(workout, member, result["id"])
return booking
def create_booking():
member_id = request.form['member_id']
workout_id = request.form['workout_id']
member = member_repository.select(member_id)
workout = workout_repository.select(workout_id)
booking = Booking(member, workout)
booking_repository.save(booking)
return redirect('/members')
def update_booking(id):
workout_id = request.form["workout_id"]
member_id = request.form["member_id"]
workout = workout_repository.select(workout_id)
member = member_repository.select(member_id)
booking = Booking(workout, member, id)
booking_repository.update(booking)
return redirect("/bookings")
def create_booking():
workout_id = request.form["workout_id"]
member_id = request.form["member_id"]
workout = workout_repository.select(workout_id)
member = member_repository.select(member_id)
new_booking = Booking(workout, member)
booking_repository.save(new_booking)
return redirect("/bookings")
def select_all():
bookings = []
sql = "SELECT * FROM bookings"
results = run_sql(sql)
for result in results:
workout = workout_repository.select(result["workout_id"])
member = member_repository.select(result["member_id"])
booking = Booking(workout, member, result["id"])
bookings.append(booking)
return bookings
def select_all():
bookings = []
sql = "SELECT * FROM bookings"
results = run_sql(sql)
for row in results:
member = member_repository.select(row['member_id'])
workout = workout_repository.select(row['workout_id'])
booking = Booking(member, workout, row['id'])
bookings.append(booking)
return bookings
def select(id):
booking = None
sql = "SELECT * FROM bookings WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
member = member_repository.select(result['member_id'])
workout = workout_repository.select(result['workout_id'])
booking = Booking(member, workout)
return booking
def remove_booking(id):
# Select workout from booking
booking = booking_repository.select(id)
workout_id = booking.workout.id
workout = workout_repository.select(workout_id)
# Delete booking
booking_repository.delete(id)
# Decrease booked in workout and updte db
workout.decrease_booked()
workout_repository.update(workout)
# Flash success message
flash(f"Removed {booking.member.first_name} from {booking.workout.name}!", "success")
# Redirect
return redirect('/bookings')
def create_booking():
# Get data from form
member_id = request.form['member']
workout_id = request.form['workout']
# Select existing member and workout
member = member_repository.select(member_id)
workout = workout_repository.select(workout_id)
# Create new booking object
booking = Booking(member, workout)
# Save to db
booking_repository.save(booking)
# Increment booking to workout and update workout
booking.workout.increment_booked()
workout_repository.update(workout)
# Flash success message
flash(f"{booking.member.first_name} was added to {booking.workout.name}!", "success")
# Redirect
return redirect('/bookings')
def edit_workout(id):
activities = activity_repository.select_all()
workout = workout_repository.select(id)
return render_template("/workouts/edit.html",
workout=workout,
activities=activities)
def show(id):
found_workout = workout_repository.select(id)
found_members = workout_repository.members(found_workout)
return render_template("workouts/show.html",
workout=found_workout,
members=found_members)
def edit_workout(id):
workout = workout_repository.select(id)
return render_template('workouts/edit.html', workout=workout)
def show(id):
workout = workout_repository.select(id)
members = workout_repository.select_members_of_workout(id)
return render_template("workouts/show.html",
workout=workout,
members=members)
