Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.8k views
in Technique[技术] by (71.8m points)

flask - How to set foreign keys to one column in sqlalchemy?

class ReportModel(db.Model):
    __tablename__ = "reports"

    id = Column(SmallInteger().with_variant(Integer, "sqlite"), primary_key=True)
    ref_id = Column(
        BigInteger, ForeignKey([PostModel.id, CommentModel.id], nullable=False)
    )
    type = Column(String(20), nullable=False)


    post = relationship("PostModel", backref="post")
    comment = relationship("CommentModel", backref="comment")

There are post, comment tables. I want to make that ref_id to refer post.id and comment.id at once. Is it possible? and how to make it? Thank u!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...