Postgres SQLAlchemy: Additional arguments should be named <dialectname>_<argument>, got 'ForeignKey'

Question

I am using postgres database and sqlalchemy in my python code, I created schemas and models and I want to use ForeignKey, but I got this error message:

Additional arguments should be named <dialectname>_<argument>, got 'ForeignKey'

my code:

class table1(Base):
    __tablename__ = 'table1'
    first_id = Column(
        Integer, unique=True, nullable=False, primary_key=True, autoincrement=True
    )


class table2(Base):
    __tablename__ = 'table2'
    second_id = Column(
        Integer,
        nullable=False,
        primary_key=True,
    )
    second = Column(Integer, nullable=False, primary_key=True, ForeignKey=('table1.first_id'))

Could anyone help me with this? Thanks.

Ian Wilson · Accepted Answer · 2022-03-06 19:22:43Z

1

You need to import ForeignKey from sqlalchemy and create it as positional argument to Column.

from sqlalchemy import ForeignKey

class table1(Base):
    __tablename__ = 'table1'
    first_id = Column(
        Integer, unique=True, nullable=False, primary_key=True, autoincrement=True
    )


class table2(Base):
    __tablename__ = 'table2'
    second_id = Column(
        Integer,
        nullable=False,
        primary_key=True,
    )
    second = Column(Integer, ForeignKey('table1.first_id'), nullable=False, primary_key=True)

Documentation

ForeignKey

Column params

answered Mar 6, 2022 at 19:22

Ian Wilson

9,3392 gold badges27 silver badges32 bronze badges

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

2 Comments

Saha Over a year ago

I have imported it, and it is defined in Column

Ian Wilson Over a year ago

You are using the keyword argument "ForeignKey" to Column instead of declaring an instance of ForeignKey. Please look at the second = Column... line in my answer.

Collectives™ on Stack Overflow

Postgres SQLAlchemy: Additional arguments should be named <dialectname>_<argument>, got 'ForeignKey'

1 Answer 1

Documentation

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Documentation

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related