def create_class():
instructor = instructor_repository.select(request.form['instructor'])
location = location_repository.select(request.form["location"])
new_gym_class = GymClass(request.form['class_type'], instructor,
request.form['date'], request.form['time'],
request.form['duration'], location)
gym_class_repository.save(new_gym_class)
return redirect('/classes')
def edit_class(id):
name = request.form['name']
description = request.form['description']
max_time = request.form['max_time']
capacity = request.form['capacity']
gym_class = GymClass(name, description, max_time, capacity, id)
class_repository.update(gym_class)
return redirect('/classes')
def update_class(id):
instructor = instructor_repository.select(request.form['instructor'])
location = location_repository.select(request.form["location"])
updated_class = GymClass(request.form['class_type'], instructor,
request.form['date'], request.form['time'],
request.form['duration'], location, id)
gym_class_repository.update(updated_class)
return redirect(f'/classes/{id}')
def select_all():
gym_classes = []
sql = "SELECT * FROM classes ORDER BY id"
results = run_sql(sql)
for row in results:
gym_class = GymClass(row['class_name'], row['description'],
row['max_time'], row['capacity'], row['id'])
gym_classes.append(gym_class)
return gym_classes
def setUp(self):
classdate = datetime.date(2020, 1, 1)
classtime = datetime.time(13, 0, 0)
self.gym_class1 = GymClass("Yoga", classdate, classtime, 10, 60)
start_date = datetime.date(2020, 1, 1)
self.member1 = Member("John", "Smith", "standard", start_date, True)
self.booking1 = Booking(self.member1, self.gym_class1)
def select_all():
gym_classes = []
sql = "SELECT * FROM gym_classes"
results = run_sql(sql)
for row in results:
gym_class = GymClass(row['type'], row['date'], row['time'],
row['capacity'], row['duration'], row['id'])
gym_classes.append(gym_class)
return gym_classes
def select(id):
gym_class = None
sql = "SELECT * FROM classes WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
gym_class = GymClass(result['class_name'], result['description'],
result['max_time'], result['capacity'],
result['id'])
return gym_class
def select(id):
gym_class = None
sql = "SELECT * FROM gym_classes WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
gym_class = GymClass(result["type"], result["date"], result["time"],
result["capacity"], result["duration"],
result["id"])
return gym_class
def gym_classes(member_id):
gym_classes = []
sql = "SELECT gym_classes.* FROM gym_classes INNER JOIN bookings ON gym_classes.id = bookings.gym_class_id WHERE bookings.member_id = %s"
values = [member_id]
results = run_sql(sql, values)
for row in results:
gym_class = GymClass(row['type'], row['date'], row['time'],
row['capacity'], row['duration'], row['id'])
gym_classes.append(gym_class)
return gym_classes
def add_gym_class():
class_type = request.form["gym_class_type"]
check = gym_class_repository.check_type_exists(class_type)
if check == False:
gym_class_repository.new_type(class_type)
date = request.form["date"]
time = request.form["time"]
capacity = request.form["capacity"]
duration = request.form["duration"]
new_class = GymClass(class_type, date, time, capacity, duration)
gym_class_repository.save(new_class)
return redirect("/gym_classes")
def update_gym_class(id):
class_type = request.form["gym_class_type"]
check = gym_class_repository.check_type_exists(class_type)
if check == False:
gym_class_repository.new_type(class_type)
date = request.form["date"]
time = request.form["time"]
capacity = request.form["capacity"]
duration = request.form["duration"]
edited_class = GymClass(class_type, date, time, capacity, duration, id)
gym_class_repository.update(edited_class)
redirect_gym_class = gym_class_repository.select(id)
redirect_class_types = gym_class_repository.select_types()
return redirect("/gym_classes/" + id)
def select(id):
sql = "SELECT * FROM gym_classes WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
instructor = instructor_repository.select(result["instructor_id"])
location = location_repository.select(result["location_id"])
class_found = GymClass(result["class_type"],
instructor,
result["class_date"],
result["class_time"],
result["duration"],
location,
result["id"]
)
return class_found
def select_all():
all_classes = []
sql = "SELECT * FROM gym_classes ORDER BY class_date, class_time"
results = run_sql(sql)
for row in results:
instructor = instructor_repository.select(row["instructor_id"])
location = location_repository.select(row["location_id"])
gym_class = GymClass(row["class_type"],
instructor,
row["class_date"],
row["class_time"],
row["duration"],
location,
row["id"]
)
all_classes.append(gym_class)
return all_classes
def classes(instructor):
classes_found = []
sql = "SELECT * FROM gym_classes WHERE instructor_id = %s"
values = [instructor.id]
results = run_sql(sql, values)
for row in results:
location = location_repository.select(row["location_id"])
class_found = GymClass(row["class_type"],
instructor,
row["class_date"],
row["class_time"],
row["duration"],
location,
row["id"]
)
classes_found.append(class_found)
return classes_found
def classes(member):
gym_classes = []
sql = """
SELECT gym_classes.*
FROM gym_classes
INNER JOIN attendees
ON attendees.class_id = gym_classes.id
WHERE member_id = %s
"""
values = [member.id]
results = run_sql(sql, values)
for row in results:
instructor = instructor_repository.select(row["instructor_id"])
location = location_repository.select(row["location_id"])
gym_class = GymClass(row["class_type"], instructor, row["class_date"],
row["class_time"], row["duration"], location,
row["id"])
gym_classes.append(gym_class)
return gym_classes
def setUp(self):
date = datetime.date(2020, 1, 1)
time = datetime.time(13, 0, 0)
self.gym_class1 = GymClass("Yoga", date, time, 10, 60)
from models.gym_class import GymClass
from models.member import Member
from models.room import Room
from models.instructor import InstructorDetails, InstructorSchedule, InstructorTimetable
from models.schedule import Schedule
import repositories.gym_class_repository as class_repository
import repositories.member_repository as member_repository
import repositories.room_repository as room_repository
import repositories.instructor_timetable_repository as timetable_repository
import repositories.instructor_details_repository as details_repository
import repositories.instructor_schedule_repository as i_schedule_repository
import repositories.schedule_repository as schedule_repository
import datetime
class_1 = GymClass('Hot Yoga', 'Yoga in a very warm studio', 60, 16)
class_2 = GymClass('CrossFit', 'Bodyweight workout', 90, 24)
class_3 = GymClass('Spinning', 'Stationary indoor cycling', 60, 20)
class_4 = GymClass('Adult Swimming Lessons', 'Adult Swimming Lessons', 60, 20)
class_5 = GymClass('Water Aerobics', 'Water Exercises', 60, 25)
class_repository.save(class_1)
class_repository.save(class_2)
class_repository.save(class_3)
class_repository.save(class_4)
class_repository.save(class_5)
member_1 = Member('John', 'Smith', '*****@*****.**', '07595964019',
datetime.date(1997, 5, 17), True, False,
datetime.date(2021, 3, 21), datetime.date(2022, 3, 21))
member_2 = Member('Luke', 'Jones', '*****@*****.**', '07595964018',
datetime.date(1992, 1, 15), False, False, None, None)
start_date2 = datetime.date(2020, 2, 1)
start_date3 = datetime.date(2020, 3, 1)
start_date4 = datetime.date(2020, 4, 1)
member_repository.new_type("Standard")
member_repository.new_type("Premium")
member1 = Member("John", "Smith", "Standard", start_date1)
member2 = Member("Jane", "Doe", "Standard", start_date2)
member3 = Member("Richard", "Richards", "Standard", start_date3)
member4 = Member("Max", "Power", "Premium", start_date4)
member_repository.save(member1)
member_repository.save(member2)
member_repository.save(member3)
member_repository.save(member4)
gym_class_repository.new_type("Yoga")
gym_class_repository.new_type("Spin")
class_date1 = datetime.date(2020, 1, 1)
class_time1 = datetime.time(13, 0, 0)
gym_class1 = GymClass("Yoga", class_date1, class_time1, 10, 60)
class_date2 = datetime.date(2020, 1, 2)
class_time2 = datetime.time(14, 30, 0)
gym_class2 = GymClass("Spin", class_date2, class_time2, 10, 60)
gym_class_repository.save(gym_class1)
gym_class_repository.save(gym_class2)
def setUp(self):
self.gym_class = GymClass('Hot Yoga',
'Yoga performed in a very warm studio', 60,
16)
location_1 = Location("Free Weights Gym", 15)
location_2 = Location("Yoga Studio", 10)
location_3 = Location("Boxing Gym", 12)
location_4 = Location("Cycling Studio", 20)
location_5 = Location("Swimming Pool", 20)
location_6 = Location("Dance Studio", 20)
location_repository.save(location_1)
location_repository.save(location_2)
location_repository.save(location_3)
location_repository.save(location_4)
location_repository.save(location_5)
location_repository.save(location_6)
class_1 = GymClass("Bodybuilding", instructor_3, "2021-03-25", "14:00", 90,
location_1)
class_2 = GymClass("Yoga", instructor_2, "2021-03-27", "13:30", 60, location_2)
class_3 = GymClass("Spin", instructor_6, "2021-03-26", "09:00", 45, location_4)
class_4 = GymClass("Swimming", instructor_5, "2021-03-25", "08:30", 60,
location_5)
class_5 = GymClass("Body Pump", instructor_2, "2021-03-26", "18:00", 60,
location_6)
class_6 = GymClass("Cardio", instructor_3, "2021-03-25", "17:30", 60,
location_6)
class_7 = GymClass("Zumba", instructor_2, "2021-03-27", "19:30", 60,
location_6)
class_8 = GymClass("Bodybuilding 2", instructor_1, "2021-03-28", "12:30", 60,
location_1)
class_9 = GymClass("Kickboxing", instructor_6, "2021-03-27", "10:00", 60,
location_3)
class_10 = GymClass("Boxing", instructor_2, "2021-03-27", "07:45", 90,
