def delete_sport_lesson(self, lesson_id: str, sport_id: str):
with self._database_engine.new_session() as session:
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get(lesson_id)
sport_dao = SportDAO(session)
sport = sport_dao.get(sport_id)
lesson_dao.delete_sport(lesson, sport, session)
def update_lesson(self, lesson_id: str, lesson_data: dict):
self._check_profile_data(lesson_data, update=True)
with self._database_engine.new_session() as session:
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get(lesson_id)
lesson = lesson_dao.update(lesson, lesson_data)
return lesson.to_dict()
def delete_coach_lesson(self, lesson_id: str, coach_id: str):
with self._database_engine.new_session() as session:
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get(lesson_id)
coach_dao = CoachDAO(session)
coach = coach_dao.get(coach_id)
lesson_dao.delete_coach(lesson, coach, session)
def get_lesson_by_date_time(self, date: str, start_time: int,
end_time: int):
with self._database_engine.new_session() as session:
lesson = LessonDAO(session).get_by_date_time(
date, start_time, end_time)
lesson_data = lesson.to_dict()
return lesson_data
def delete_lesson(self, member_id: str, lesson_id: str):
with self._database_engine.new_session() as session:
member_dao = MemberDAO(session)
member = member_dao.get(member_id)
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get(lesson_id)
member_dao.delete_lesson(member, lesson, session)
def create_lesson(self, data: dict):
self._check_profile_data(data)
try:
with self._database_engine.new_session() as session:
# Save lesson in database
lesson = LessonDAO(session).create(data)
lesson_data = lesson.to_dict()
return lesson_data
except Error as e:
# log error
raise e
def search_lesson(self, date: str, start_time: int, end_time: int):
# Query database
with self._database_engine.new_session() as session:
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get_by_date_time(date, start_time, end_time)
return lesson.to_dict()
def delete_lesson(self, lesson_id: str):
with self._database_engine.new_session() as session:
lesson_dao = LessonDAO(session)
lesson = lesson_dao.get(lesson_id)
lesson_dao.delete(lesson)
def get_lesson(self, lesson_id: str):
with self._database_engine.new_session() as session:
lesson = LessonDAO(session).get(lesson_id)
lesson_data = lesson.to_dict()
return lesson_data
def list_lessons(self):
with self._database_engine.new_session() as session:
lessons = LessonDAO(session).get_all()
lessons_data = [lesson.to_dict() for lesson in lessons]
return lessons_data