def reserve_seat_in_the_map(cls, projection_id): all_reserved_seats = (session.query( Reservations.row, Reservations.col).filter( Reservations.projections_id == projection_id).all()) for row, col in all_reserved_seats: cls.main_projection.reserve_seat(row, col)
def show_all_movies(cls): for item in session.query(Movies).all(): print(item)
def list_all_reservation_ids_by_id(cls, user_id): result = (session.query( Reservations.id).filter(Reservations.user_id == user_id).all()) return [item[0] for item in result]
def show_if_seat_is_reserved(cls, projection_id, row, column): result = (session.query(Reservations.id).filter( Reservations.row == row, Reservations.col == column, Reservations.projections_id == projection_id).first()) return result
def list_all_reservations_by_id(cls, user_id): result = (session.query(Reservations).filter( Reservations.user_id == user_id).all()) for item in result: print(f"{item.id} {item}")
def show_seats_for_projection(cls, p_id): result = (session.query(Reservations.projections_id).filter( Reservations.projections_id == p_id).count()) return 100 - result
def show_movie_date_time_projection(cls, pr_id): result = (session.query(Projections).filter( Projections.id == pr_id).first()) new_str_movie = f"Movie: {''.join(str(result.movie).split(' - ')[1:])}" new_result = f"Date and time: {''.join(str(result).split(' - ')[1:])}" return f"{new_str_movie}\n{new_result}"
def show_movie_name_by_id(cls, id_movie): result = (session.query(Projections).filter( Projections.movie_id == id_movie).first()) ProjectionValidator.check_projections_movie(result) m_name = result.movie.name return m_name
def show_all_projections_by_id_and_date(cls, movie_id, projection_date): result = (session.query(Projections).filter( Projections.movie_id == movie_id, Projections.date == projection_date).all()) return result
def show_all_projection_ids_by_movie_id(cls, movie_id): result = (session.query( Projections.id).filter(Projections.movie_id == movie_id).all()) return [item[0] for item in result]
def show_all_projections_by_id(cls, movie_id): result = (session.query(Projections).filter( Projections.movie_id == movie_id).all()) return result