def clear_db(): session = db_session() session.query(Reservation).delete() session.query(MovieSchedule).delete() session.query(User).delete() session.query(Movie).delete() session.commit()
def default_movie(): movie = Movie(name="DefaultMovie", picture="DefaultMovie.png", info="Default info.", actors="Default actors", duration="2:00:00") session = db_session() session.add(movie) session.commit() return movie
def default_user(): user = User(username="******", firstname="DefaultUser", lastname="DefaultUser", email="*****@*****.**", password_hash=User.hash_password("user"), phone_number=".!.", photo="user.png", role='user') user.password = '******' user.credentials = b64encode(b'DefaultUser:user') user.wrong_credentials = b64encode(b'DefaultUser:user1') user.headers = {"Authorization": "Basic {}".format(user.credentials)} user.wrong_credentials_headers = { "Authorization": "Basic {}".format(user.wrong_credentials) } session = db_session() session.add(user) session.commit() return user
def admin(): admin = User(username="******", firstname="admin", lastname="admin", email="*****@*****.**", password_hash=User.hash_password("admin"), phone_number=".!.", photo="photo.jpeg", role='admin') admin.password = '******' admin.credentials = b64encode(b'admin:admin') admin.wrong_credentials = b64encode(b'admin:admin1') admin.headers = {"Authorization": "Basic {}".format(admin.credentials)} admin.wrong_credentials_headers = { "Authorization": "Basic {}".format(admin.wrong_credentials) } session = db_session() session.add(admin) session.commit() return admin
def session(): session = db_session() return session
from movie_app.models import User, Movie, MovieSchedule, Reservation from movie_app import db_session # TODO : rewrite and test session = db_session() data = \ [ [ User(id=1, username="******", firstname="Ivan", lastname="Manchur", email="*****@*****.**", password_hash=User.hash_password("lavuna2002"), phone_number="90123123", photo="photo.jpeg"), User(id=2, username="******", firstname="Borys", lastname="Laplas", email="*****@*****.**", password_hash=User.hash_password("laplap2002"), phone_number="901231233", photo="photo.jpeg"), User(id=3, username="******", firstname="Ostap", lastname="Manchur", email="*****@*****.**", password_hash=User.hash_password("ostap19991999"), phone_number="517294381", photo="photo.jpeg"), User(id=4, username="******", firstname="Julian", lastname="*********", email="*****@*****.**", password_hash=User.hash_password("qwerty123"), phone_number="872368923", photo="photo.jpeg"), User(id=5, username="******", firstname="Adrian", lastname="Bilder", email="*****@*****.**", password_hash=User.hash_password("all123"), phone_number="90121233123",photo="photo.jpeg") ], [ MovieSchedule(id=1, movie_id=1, date="1999-03-14", time="12:53:42"), MovieSchedule(id=2, movie_id=1, date="1999-03-14", time="15:19:32"), MovieSchedule(id=3, movie_id=1, date="1999-03-14", time="18:54:49"), MovieSchedule(id=4, movie_id=1, date="1999-04-14", time="12:53:42"), MovieSchedule(id=5, movie_id=1, date="1999-04-14", time="15:19:32"), MovieSchedule(id=6, movie_id=1, date="1999-04-14", time="18:54:49"), MovieSchedule(id=7, movie_id=1, date="1999-05-14", time="12:53:42"), MovieSchedule(id=8, movie_id=1, date="1999-05-14", time="15:19:32"), MovieSchedule(id=9, movie_id=1, date="1999-05-14", time="18:54:49"), MovieSchedule(id=10, movie_id=2, date="1999-03-14", time="10:53:42"), MovieSchedule(id=11, movie_id=2, date="1999-03-14", time="13:19:32"), MovieSchedule(id=12, movie_id=2, date="1999-03-14", time="21:54:49"), MovieSchedule(id=13, movie_id=2, date="1999-04-14", time="10:53:42"), MovieSchedule(id=14, movie_id=2, date="1999-04-14", time="13:19:32"), MovieSchedule(id=15, movie_id=2, date="1999-04-14", time="21:54:49"), MovieSchedule(id=16, movie_id=2, date="1999-05-14", time="10:53:42"),