How to set up a foreign key foreignkey in sqlalchemy can be associated with your own table, such as comment related reply, comment and reply all belong to Comment

problem description

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)
class Comment (Model):

"""

comment and reply

"""
__tablename__ = "comment"
id = Column(Integer, primary_key=True, autoincrement=True)
comments = relationship("Comment", back_populates="comment")
parent_comment_id = Column(Integer, ForeignKey("comment.id"), nullable=True)

what result do you expect? What is the error message actually seen?

sqlalchemy.exc.NoForeignKeysError: Could not determine join condition between parent/child tables on relationship Comment.comments-there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a "primaryjoin" expression.

Jul.21,2021
Menu