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