sqlalchemy-如何在同一表中设置与back_population to popupulation

发布于 2025-02-08 18:34:17 字数 874 浏览 2 评论 0原文

我尝试设置 parent_id 包含一个人的 id 以 PEOPUR 表中的 id 以的方式进行 id ，以ORM的方式进行，并在它们之间进行了背部填充，但行不通。

class People(Base):
    __tablename__ = "people"

    id = Column(Integer, primary_key=True)
    name = Column(String(20), nullable=False, unique=True)
    parent_id = Column(Integer, ForeignKey('people.id'))
    parent = relationship("People", back_populates="parent", uselist=False)

engine = create_engine(
    f'mssql://{username}:{password}@{server_name}/{db_name}?driver=SQL+Server&trusted_connection=yes')

Session = sessionmaker(bind=engine)
session = Session()
session.add(People(name='me'))

提高sa_exc.argumenterror（ sqlalchemy.exc.argumenterror：people.parent和back-reference people.parent都是相同的方向符号（'Onetomany'）。您的意思是将远程_SEDE设置在多对一方面吗？

原文

I try to set fk which parent_id contains id of a person in People table in orm manner and backpopulate between them but it does not work.

class People(Base):
    __tablename__ = "people"

    id = Column(Integer, primary_key=True)
    name = Column(String(20), nullable=False, unique=True)
    parent_id = Column(Integer, ForeignKey('people.id'))
    parent = relationship("People", back_populates="parent", uselist=False)

engine = create_engine(
    f'mssql://{username}:{password}@{server_name}/{db_name}?driver=SQL+Server&trusted_connection=yes')

Session = sessionmaker(bind=engine)
session = Session()
session.add(People(name='me'))

raise sa_exc.ArgumentError(
sqlalchemy.exc.ArgumentError: People.parent and back-reference People.parent are both of the same direction symbol('ONETOMANY'). Did you mean to set remote_side on the many-to-one side ?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

只涨不跌 2025-02-15 18:34:17

您可以使用远程_SEDE参数。

这是我使用的代码适应您的示例：

class People(Base):
    __tablename__ = "people"

    id = Column(Integer, primary_key=True)
    parent_id = Column(Integer, ForeignKey('people.id'))

    parent = relationship('People', foreign_keys=parent_id, remote_side=id)
    children = relationship('People', back_populates='parent')

You can use the remote_side argument.

Here's code I'm using adapted to your example:

class People(Base):
    __tablename__ = "people"

    id = Column(Integer, primary_key=True)
    parent_id = Column(Integer, ForeignKey('people.id'))

    parent = relationship('People', foreign_keys=parent_id, remote_side=id)
    children = relationship('People', back_populates='parent')

回复收藏 0 原文

~没有更多了~