Python ForeignKey示例

示例#1

class BezorgingRelatedModel(BaseModel):
    __abstract__ = True

    groep_id = db.Column(
        db.ForeignKey(f"{Bezorging.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )

示例#2

class ChatRelatedMixin:
    chat_id = db.Column(
        db.ForeignKey(f"{Chat.__tablename__}.id",
                      ondelete="CASCADE",
                      onupdate="CASCADE"),
        nullable=False,
    )

示例#3

class EditieRelatedModel(BaseModel):
    __abstract__ = True

    editie_id = db.Column(
        db.ForeignKey(f"{Editie.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )

示例#4

文件： user.py 项目： Katel212/MyPersonalKitchenBot

class UserRelatedModel(BaseModel):
    __abstract__ = True

    user_id = db.Column(
        db.ForeignKey(f"{User.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )

示例#5

class WijkRelatedModel(BaseModel):
    __abstract__ = True

    straat_id = db.Column(
        db.ForeignKey(f"{Wijk.__tablename__}.id",
                      ondelete="CASCADE",
                      onupdate="CASCADE"),
        nullable=True,
    )

示例#6

class PlaatsRelatedModel(BaseModel):
    __abstract__ = True

    plaats_id = db.Column(
        db.ForeignKey(f"{Plaats.__tablename__}.id",
                      ondelete="CASCADE",
                      onupdate="CASCADE"),
        nullable=True,
    )

示例#7

class UserRelatedMixin:
    user_id = db.Column(
        db.ForeignKey(f"{User.__tablename__}.id", ondelete="CASCADE", onupdate="CASCADE"),
        nullable=False,
    )