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 User(db.Model, UserMixin):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(32))
active = db.Column(db.Boolean())
roles = db.relationship(
Role, secondary='roles_users',
backref=db.backref('users', lazy='dynamic')
)
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))