Flask-SQLAlchemy

[Gatalist]

movie_genre = db.Table('movie_genre',
db.Column('movie_id', db.Integer, db.ForeignKey('movie.id')),
db.Column('genre_id', db.Integer, db.ForeignKey('genre.id')),)

class Genre(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), index=True, unique=True)
movies = db.relationship('Movie', backref='genre', lazy='dynamic')

def __repr__(self):
    return self.name

class Movie(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100))
slug = db.Column(db.String(150), index=True, unique=True)
genres_id = db.Column(db.Integer, db.ForeignKey('genre.id'))
release_date = db.Column(db.DateTime, index=True, default=datetime.utcnow)
producer_id = db.Column(db.Integer, db.ForeignKey('producer.id'))
body = db.Column(db.Text(500))
# rating = db.Column(db.String(100))
poster = db.Column(db.String())
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
publication = db.Column(db.DateTime, index=True, default=datetime.utcnow)

genres = db.relationship('Genre', secondary=movie_genre, backref=db.backref('movie', lazy='dynamic'))

def __repr__(self):
    return self.title

def get_absolute_url(self):
    return f'/movie/{self.slug}'