def select(id):
sql = 'SELECT * FROM bookings WHERE id = %s'
values = [id]
results = run_sql(sql, values)[0]
member = member_repository.select(results['member_id'])
activity = activity_repository.select(results['activity_id'])
booking = Booking(member, activity, results['note'], results['id'])
return booking
def update_booking(id):
member_id = request.form["member_id"]
activity_id = request.form["activity_id"]
member = member_repository.select(member_id)
activity = activity_repository.select(activity_id)
booking = Booking(member, activity, id)
booking_repository.update(booking)
return redirect("/bookings")
def create_workout():
activity_id = request.form['activity_id']
day = request.form['day']
time = request.form['time']
capacity = request.form['capacity']
activity = activity_repository.select(activity_id)
workout = Workout(activity, day, time, capacity)
workout_repository.save(workout)
return redirect('/workouts')
def activities(id):
activities = []
sql = 'SELECT activity_id FROM bookings WHERE member_id = %s'
values = [id]
results = run_sql(sql, values)
for row in results:
activity = activity_repository.select(row['activity_id'])
activities.append(activity)
return activities
def select(id):
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"])
activity = activity_repository.select(result["activity_id"])
booking = Booking(member, activity, result["id"])
return booking
def select_all():
bookings = []
sql = 'SELECT * FROM bookings'
results = run_sql(sql)
for row in results:
member = member_repository.select(row['member_id'])
activity = activity_repository.select(row['activity_id'])
booking = Booking(member, activity, row['note'], row['id'])
bookings.append(booking)
return bookings
def create_booking():
member_id = request.form["member_id"]
member = member_repository.select(member_id)
activity_id = request.form["activity_id"]
activity = activity_repository.select(activity_id)
new_booking = Booking(member, activity)
if booking_repository.save(new_booking) is not None:
return redirect("/bookings")
else:
return render_template("/bookings/full.html")
def select_all():
workouts = []
sql = "SELECT * FROM workouts"
results = run_sql(sql)
for row in results:
activity = activity_repository.select(row['activity_id'])
workout = Workout(activity, row['day'], row['time'], row['capacity'],
row['id'])
workouts.append(workout)
return workouts
def update_workout(id):
activity_id = request.form['activity_id']
day = request.form['day']
time = request.form['time']
capacity = request.form['capacity']
activity = activity_repository.select(activity_id)
workout = Workout(activity, day, time, capacity, id)
workout_repository.update(workout)
return redirect("/workouts")
def select(id):
workout = None
sql = "SELECT * FROM workouts WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
activity = activity_repository.select(result['activity_id'])
workout = Workout(activity, result['day'], result['time'],
result['capacity'], result['id'])
return workout
def bookings(id):
bookings = []
sql = 'SELECT bookings.* FROM bookings INNER JOIN activities ON bookings.activity_id = activities.id WHERE bookings.activity_id = %s'
values = [id]
results = run_sql(sql, values)
for row in results:
member = member_repository.select(row['member_id'])
activity = activity_repository.select(row['activity_id'])
booking = Booking(member, activity, row['note'], row['id'])
bookings.append(booking)
return bookings
def create_booking():
activity_id = request.form['activity_id']
activity = activity_repository.select(activity_id)
member_id = request.form['member_id']
member = member_repository.select(member_id)
note = request.form['note']
booking = Booking(member, activity, note)
booked = activity_repository.bookings_amount(activity_id)
if booked < activity.capacity:
booking_repository.save(booking)
return redirect("/activities/" + activity_id)
return render_template('bookings/error.html')
def update_activity(id):
name = request.form["name"]
photo = request.files["photo"].filename
if photo == '':
activity = activity_repository.select(id)
photo = activity.photo
trainer = request.form["trainer"]
activity = Activity(name, photo, trainer, id)
activity_repository.update(activity)
return redirect("/activities")
def update_booking(id):
member_id = request.form['member_id']
member = member_repository.select(member_id)
activity_id = request.form['activity_id']
activity = activity_repository.select(activity_id)
note = request.form['note']
booking = Booking(member, activity, note, id)
booking_repository.update(booking)
return redirect('/activities/' + activity_id)
def workouts(member):
values = [member.id]
sql = """
SELECT workouts.* FROM workouts
INNER JOIN bookings
ON workouts.id = bookings.workout_id
WHERE member_id = %s
"""
results = run_sql(sql, values)
workouts = []
for row in results:
activity = activity_repository.select(row["activity_id"])
workout = Workout(activity, row['day'], row['time'], row['capacity'])
workouts.append(workout)
return workouts
def edit_activity(id):
activity = activity_repository.select(id)
trainers = trainer_repository.select_all()
return render_template("/activities/edit.html",
activity=activity,
trainers=trainers)
def show_activity(id, message=None):
activity = activity_repository.select(id)
bookings = activity_repository.bookings(id)
return render_template("/activities/show.html",
activity=activity,
bookings=bookings)
def show(id):
found_activity = activity_repository.select(id)
found_members = activity_repository.members(found_activity)
return render_template("activities/show.html",
activity=found_activity,
members=found_members)
def edit_activity(id):
activity = activity_repository.select(id)
all_gyms = gym_repository.select_all()
return render_template("activities/edit.html",
activity=activity,
all_gyms=all_gyms)
def edit_activity(id):
activity = activity_repository.select(id)
return render_template('activities/edit.html', activity=activity)
def show(id):
activity = activity_repository.select(id)
members = activity_repository.members(activity)
return render_template("activities/show.html",
activity=activity,
members=members)
