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,