def add_timetable():
instructor_id = request.form['instructor_id']
schedule_id = request.form['schedule_id']
start_date = request.form['start_date']
instructor = details_repository.select(instructor_id)
schedule = schedule_repository.select(schedule_id)
timetable = InstructorTimetable(start_date, instructor, schedule, id)
timetable_repository.save(timetable)
return redirect('/instructors')
def select_all():
timetables = []
sql = "SELECT * FROM instructor_timetables"
results = run_sql(sql)
for row in results:
detail = details_repository.select(row['i_details_id'])
schedule = schedule_repository.select(row['i_schedules_id'])
timetable = InstructorTimetable(row['week_start'], detail, schedule, row['id'])
timetables.append(timetable)
return timetables
def select(id):
schedule = None
sql = "SELECT * FROM schedules WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
instructor = instructor_repository.select(result['instructor_id'])
gym_class = gym_class_repository.select(result['class_id'])
room = room_repository.select(result['room_id'])
schedule = Schedule(result['class_date'], result['start_time'], result['length_mins'], instructor,
gym_class, room, result['id'])
return schedule
def select_all():
schedules = []
sql = "SELECT * FROM schedules ORDER BY class_date"
results = run_sql(sql)
for row in results:
instructor = instructor_repository.select(row['instructor_id'])
gym_class = gym_class_repository.select(row['class_id'])
room = room_repository.select(row['room_id'])
schedule = Schedule(row['class_date'], row['start_time'], row['length_mins'], instructor,
gym_class, room, row['id'])
schedules.append(schedule)
return schedules
def add_schedule():
class_date = request.form['class_date']
start_time = request.form['start_time']
length_mins = request.form['length_mins']
instructor_id = request.form['instructor_id']
class_id = request.form['class_id']
room_id = request.form['room_id']
instructor = details_repository.select(instructor_id)
gym_class = gym_class_repository.select(class_id)
room = room_repository.select(room_id)
schedule = Schedule(class_date, start_time, length_mins, instructor,
gym_class, room, id)
schedule_repository.save(schedule)
return redirect('/schedule')
def select_dates():
schedules_list = []
sql = "SELECT * FROM schedules WHERE class_date = %s ORDER BY start_time"
for index in range(7):
schedules = []
values = [date.today() + timedelta(days=index)]
results = run_sql(sql, values)
if results is not None:
for row in results:
instructor = instructor_repository.select(row['instructor_id'])
gym_class = gym_class_repository.select(row['class_id'])
room = room_repository.select(row['room_id'])
schedule = Schedule(row['class_date'], row['start_time'], row['length_mins'], instructor,
gym_class, room, row['id'])
schedules.append(schedule)
else:
schedule = None
schedules.append(schedule)
schedules_list.append(schedules)
return schedules_list
def e_details(id):
details = details_repository.select(id)
return render_template('instructor/edit_dets.html', details=details)