Python ForeignKey Examples

Example #1

class BezorgingRelatedModel(BaseModel):
    __abstract__ = True

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

Example #2

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

Example #3

class EditieRelatedModel(BaseModel):
    __abstract__ = True

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

Example #4

File: user.py Project: Katel212/MyPersonalKitchenBot

class UserRelatedModel(BaseModel):
    __abstract__ = True

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

Example #5

class WijkRelatedModel(BaseModel):
    __abstract__ = True

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

Example #6

class PlaatsRelatedModel(BaseModel):
    __abstract__ = True

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

Example #7

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