Flask-sqlalchemy, Primary Key For Secondary Table In Many-to-many Relationship

I am trying to build simple many-to-many relationship using Flask-Sqlalchemy for Postgresql Database: from app import db from sqlalchemy.dialects.postgresql import UUID authors_bo

Solution 1:

https://groups.google.com/forum/#!topic/sqlalchemy/WAHaPIuzqZQ

authors_books = db.Table(
    'authors_books',
    db.Column('id', UUID(as_uuid=True), primary_key=True, default=lambda: uuid.uuid4().hex),
    db.Column('author_id', UUID(as_uuid=True), db.ForeignKey('authors.id')),
    db.Column('book_id', UUID(as_uuid=True), db.ForeignKey('books.id')),
)