Re: [sqlalchemy] forcing (composite) primary key order?

2020-06-02 Thread Jonathan Vanasco
thanks mike! On Monday, June 1, 2020 at 7:15:23 PM UTC-4, Mike Bayer wrote: > > yes use the PrimaryKeyConstraint() construct > > > > https://docs.sqlalchemy.org/en/13/core/constraints.html?highlight=primarykeyconstraint#sqlalchemy.schema.PrimaryKeyConstraint > > here you'd want to put it in your

Re: [sqlalchemy] forcing (composite) primary key order?

2020-06-01 Thread Mike Bayer
yes use the PrimaryKeyConstraint() construct https://docs.sqlalchemy.org/en/13/core/constraints.html?highlight=primarykeyconstraint#sqlalchemy.schema.PrimaryKeyConstraint here you'd want to put it in your __table_args__ and remove primary_key=True from each column On Mon, Jun 1, 2020, at

[sqlalchemy] forcing (composite) primary key order?

2020-06-01 Thread Jonathan Vanasco
is it possible to force the order of primary keys? for example in this setup... class AcmeDnsServer2Domain(Base): __tablename__ = "acme_dns_server_2_domain" acme_dns_server_id = sa.Column( sa.Integer, sa.ForeignKey("acme_dns_server.id"), primary_key=True ) domain_id =