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