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}"