class Director(UserMixin, db.Model):
def __repr__(self):
return self.first_name + ' ' + self.last_name
__tablename__ = "directors"
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(32))
last_name = db.Column(db.String(64))
movies = db.relationship('Movie', backref='directors')
class User(UserMixin, db.Model):
__tablename__ = "users"
id = db.Column(db.Integer, primary_key=True)
user_name = db.Column(db.String(64))
user_email = db.Column(db.String(320), unique=True)
user_password = db.Column(db.String(128))
creation_date = db.Column(db.DateTime)
def check_password(self, password):
return check_password_hash(self.user_password, password)
class Movie(UserMixin, db.Model):
__tablename__ = "movies"
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(64))
director_id = db.Column(db.Integer, db.ForeignKey('directors.id'))
release_year = db.Column(db.Integer)
roles = db.relationship('Role', backref='movies')
genres = db.relationship('MovieGenres', backref='movies')
visitor_amount = db.Column(db.Integer)
gross_income = db.Column(db.Integer)
playtime = db.Column(db.Integer)
genre = db.Column(db.String(32))
trailer_url = db.Column(db.String(64))
class MovieGenres(db.Model):
__tablename__ = "movie_genre"
id = db.Column(db.Integer, primary_key=True)
movie_id = db.Column(db.Integer, db.ForeignKey('movies.id'))
genre_id = db.Column(db.Integer, db.ForeignKey('genres.id'))
class Genre(db.Model):
__tablename__ = "genres"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(32))
movies = db.relationship('MovieGenres', backref='genres')
class Role(UserMixin, db.Model):
__tablename__ = "roles"
id = db.Column(db.Integer, primary_key=True)
movie_id = db.Column(db.Integer, db.ForeignKey('movies.id'))
actor_id = db.Column(db.Integer, db.ForeignKey('actors.id'))
playing_as = db.Column(db.String(64))