class Author(db.Model):
__tablename__ = 'author'
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(255))
def __repr__(self) -> str:
return self.name
class Book(db.Model):
__tablename__ = 'book'
id = db.Column(db.Integer(), primary_key=True)
title = db.Column(db.String(255))
authors = db.relationship(Author, secondary='authors_books', backref=db.backref('books', lazy=True))
def __repr__(self) -> str:
return self.title
class RolesUsers(db.Model):
__tablename__ = 'roles_users'
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column('user_id', db.Integer(), db.ForeignKey('user.id'))
role_id = db.Column('role_id', db.Integer(), db.ForeignKey('role.id'))
class AuthorsBooks(db.Model):
__tablename__ = 'authors_books'
author_id = db.Column(db.Integer(), db.ForeignKey('author.id'), primary_key=True)
book_id = db.Column(db.Integer(), db.ForeignKey('book.id'), primary_key=True)
class Role(db.Model, RoleMixin):
__tablename__ = 'role'
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))