class Movies_Recommended(db.Model):
__tablename__ = "movies_recommended"
id = db.Column(db.Integer, primary_key=True)
imdb_id = db.Column(db.String(64))
Prob_score = db.Column(db.Float)
def __repr__(self):
return f"Movies_Recommended {self.id}"
class Preference(db.Model):
__tablename__ = 'preference'
id = db.Column(db.Integer, primary_key=True)
genre1 = db.Column(db.String(64))
genre2 = db.Column(db.String(64))
year_range = db.Column(db.Integer)
def __repr__(self):
return f"{self.id}, {self.genre1}, {self.genre2}, {self.year_range}"
class Movies(db.Model):
__tablename__ = 'movies'
id = db.Column(db.Integer, primary_key=True)
imdb_id = db.Column(db.String(64))
title = db.Column(db.String(64), nullable=False)
year = db.Column(db.Integer, nullable=False)
genre = db.Column(db.String)
def __repr__(self):
return f"User {self.id}"
class Likelist(db.Model):
__tablename__ = "likelist"
id = db.Column(db.Integer(), nullable=False, primary_key=True)
moviename = db.Column(db.VARCHAR(64), nullable=False)
likemovie = db.relationship("Movie_model",
backref="likelist",
lazy="subquery",
cascade="all,delete")
def __repr__(self):
return f"Likelist {self.id}"
class Movie_model(db.Model):
__tablename__ = "movie_model"
id = db.Column(db.Integer(), nullable=False, primary_key=True)
moviename = db.Column(db.VARCHAR(64), nullable=False)
year = db.Column(db.Integer(), nullable=True)
rating = db.Column(db.Integer(), nullable=True)
genre = db.Column(db.VARCHAR(128), nullable=False)
summary = db.Column(db.VARCHAR(400), nullable=False)
like_id = db.Column(db.Integer(),
db.ForeignKey("likelist.id"),
nullable=True)
def __repr__(self):
return f"Movie_model {self.id}"