CODEWITHSUNDEEP
pythonsqlsqlalchemy
yigal
yigal

Reputation: 4725

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

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?

Upvotes: 5

Views: 3554

Answers (1)

Amirio
Amirio

Reputation: 788

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.

Upvotes: 4

Related Questions