Re: many to many relation with foreign key to composite primary key

2018-12-14 Thread patrick payet
e] {} > INFO [sqlalchemy.engine.base.Engine] > CREATE TABLE users_permissions ( > users_id BIGINT NOT NULL, > permissions_id BIGINT NOT NULL, > PRIMARY KEY (users_id, permissions_id), > FOREIGN KEY(permissions_id) REFERENCES permissions (id), > FOREIGN KE

Re: many to many relation with foreign key to composite primary key

2018-12-13 Thread patrick payet
nal constraints of the database. > But why Alembic can’t create this model in auto-generation mode? > > Best regards > > Le jeu. 13 déc. 2018 à 14:44, Mike Bayer a > écrit : > >> On Thu, Dec 13, 2018 at 7:11 AM patrick payet wrote: >> > >> > Hi Mike, >

Re: many to many relation with foreign key to composite primary key

2018-12-13 Thread patrick payet
previously ( there is no unique constraint matching given keys for referenced table "users_roles"). I will send you the CREATE TABLE statements by email in a moment. Best regards, Patrick Le mer. 12 déc. 2018 à 19:40, Mike Bayer a écrit : > On Wed, Dec 12, 2018 at 1:01 PM patrick payet wro

many to many relation with foreign key to composite primary key

2018-12-12 Thread patrick payet
I had a SQLAlchemy model like - class User(DeclarativeBase): __tablename__ = 'users' id = Column(BigInteger, primary_key=True) email = Column(String(100), unique=True, nullable=False) name = Column(String(100), nullable=False) hashed_password = Column(String(100),