def create(movie_id, movie_type, date, time):
projection = Projection(movie_id=movie_id,
type=movie_type,
date=date,
time=time)
session.add(projection)
session.commit()
def add_movies():
session.add_all([
Movie(name="The Hunger Games: Catching Fire", rating=7.5),
Movie(name="Wreck-It Ralph", rating=7.8),
Movie(name="Her", rating=8.3),
Movie(name="Avengers: Infinity War", rating=8.8)])
session.commit()
def create(name, rating):
if rating < LOW_MOVIE_RATING or rating > HIGH_MOVIE_RATING:
raise MovieRatingOutOfRangeError()
else:
movie = Movie(name=name, rating=rating)
session.add(movie)
session.commit()
def add_projections():
session.add_all([Projection(movie_id=1,
type="3D",
date="2018-05-25",
time="21:55:00"),
Projection(movie_id=1,
type="4DX",
date="2018-05-27",
time="21:55:00"),
Projection(movie_id=1,
type="2D",
date="2018-05-26",
time="15:30:00"),
Projection(movie_id=1,
type="3D",
date="2018-05-25",
time="21:30:00")])
session.commit()
def log_out(user_id):
user = session.query(User).filter(User.id == user_id).one_or_none()
user.is_active = 0
session.commit()
def log_in(username):
user = UserController.get_by_username(username)
user.is_active = 1
session.commit()
def create(username, password):
user = User(username=username, password=password)
session.add(user)
session.commit()
def add_reservations():
session.add_all([Reservation(user_id=1, projection_id=2, row=2, column=3),
Reservation(user_id=1, projection_id=2, row=2, column=4)])
session.commit()
def add_users():
session.add_all([User(username="******", password="******", is_active=0),
User(username="******", password="******", is_active=0)
])
session.commit()