with python sqlalchemy, how do define multiple-column primary key

Question

I am following the tutorial at https://docs.sqlalchemy.org/en/latest/core/tutorial.html

I see an example for primary key, it seems to use just one column

>>> users = Table('users', metadata,
...     Column('id', Integer, primary_key=True),
...     Column('name', String),
...     Column('fullname', String),
... )

how do define primary key with a sequence of columns?

stackoverflow.com/questions/9034271/…, applicable to Core Table pretty much as is, docs.sqlalchemy.org/en/latest/core/… in the official docs. — Ilja Everilä
– Ilja Everilä, Commented Aug 20, 2018 at 19:40

Amirio · Accepted Answer · 2020-08-10 04:57:33Z

4

try like this:

    >>> users = Table('users', metadata,
...     Column('id', Integer, primary_key=True),
...     Column('name', String, primary_key=True),
...     Column('fullname', String),
... )

use primary_key=True on any column to primary as key.

answered Aug 10, 2020 at 4:57

Amirio

7881 gold badge8 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

with python sqlalchemy, how do define multiple-column primary key

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related