Python ForeignKey示例

示例#1

class guest_event_table(db.Model):

    __tablename__ = 'guest_event_table'

    event_id = db.Column(db.Integer,
                         db.ForeignKey('events.id'),
                         primary_key=True)
    guest_id = db.Column(db.Integer,
                         db.ForeignKey('guests.id'),
                         primary_key=True)

示例#2

文件： models.py 项目： flask-django-independent-study/week-5-events-app

class GuestEventLink(db.Model):
    """Joining table for guests & events."""

    id = db.Column(db.Integer, primary_key=True)
    guest_id = db.Column(db.Integer, db.ForeignKey("guest.id"))
    event_id = db.Column(db.Integer, db.ForeignKey("event.id"))
    event = db.relationship("Event",
                            backref=backref("link",
                                            cascade="all, delete-orphan"))
    guest = db.relationship("Guest",
                            backref=backref("link",
                                            cascade="all, delete-orphan"))

示例#3

# TODO: Create a model called `Event` with the following fields:
# - id: primary key
# - title: String column
# - description: String column
# - date_and_time: DateTime column
# - guests: relationship to "Guest" table with a secondary table

# STRETCH CHALLENGE: Add a field `event_type` as an Enum column that denotes the
# type of event (Party, Study, Networking, etc)


class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    description = db.Column(db.String(200), nullable=False)
    date_and_time = db.Column(db.DateTime(100), nullable=False)

    guests = db.relationship('Guest',
                             secondary='table',
                             back_populates="events_attending")


# TODO: Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)

guest_event_table = db.Table(
    "table", db.Column('guest_id', db.Integer, db.ForeignKey('guest.id')),
    db.Column('event_id', db.Integer, db.ForeignKey('event.id')))

示例#4

文件： models.py 项目： Ignl94/bew_events

# TODO: Create a model called `Event` with the following fields:
# - id: primary key
# - title: String column
# - description: String column
# - date_and_time: DateTime column
# - guests: relationship to "Guest" table with a secondary table

# STRETCH CHALLENGE: Add a field `event_type` as an Enum column that denotes the
# type of event (Party, Study, Networking, etc)


class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), unique=True, nullable=False)
    description = db.Column(db.String(120), unique=False, nullable=False)
    date_and_time = db.Column(db.DateTime(),)
    guests = db.relationship(
        'Guest', secondary='guest_event', back_populates='events_attending')

# TODO: Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)


guest_event_table = db.Table('guest_event',
                             db.Column('event_id', db.Integer,
                                       db.ForeignKey('event.id')),
                             db.Column('guest_id', db.Integer,
                                       db.ForeignKey('guest.id'))
                             )

示例#5

# Create a model called `Event` with the following fields:
# - id: primary key
# - title: String column
# - description: String column
# - date_and_time: DateTime column
# - guests: relationship to "Guest" table with a secondary table

# STRETCH CHALLENGE: Add a field `event_type` as an Enum column that denotes the
# type of event (Party, Study, Networking, etc)


class Event(db.Model):
    """Event model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    description = db.Column(db.String(1000), nullable=False)
    date_and_time = db.Column(db.DateTime, nullable=False)
    # event_type = db.Column(db.Enum, nullable = True)
    guests = db.relationship("Guest",
                             secondary="guest_event_table",
                             back_populates="events_attending")


# Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)

guest_event_table = db.Table(
    "guest_event_table",
    db.Column("event_id", db.Integer, db.ForeignKey("event.id")),
    db.Column("guest_id", db.Integer, db.ForeignKey("guest.id")))

示例#6

    PARTY = 1
    STUDY = 2
    NETWORKING = 3
    ALL = 4


class Guest(db.Model):
    """Guest Model"""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    email = db.Column(db.String(80), nullable=False)
    phone = db.Column(db.String(80), nullable=False)
    events_attending = db.relationship(
        'Event', secondary='guest_event', back_populates='guests')


class Event(db.Model):
    """Event Model"""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    description = db.Column(db.String(80), nullable=False)
    date_and_time = db.Column(
        db.DateTime, nullable=False)
    event_type = db.Column(db.Enum(Type), default=Type.ALL)
    guests = db.relationship(
        'Guest', secondary='guest_event', back_populates='events_attending')


guest_event_table = db.Table('guest_event', db.Column('event_id', db.Integer, db.ForeignKey(
    'event.id')), db.Column('guest_id', db.Integer, db.ForeignKey('guest.id')))