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)
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"))
# 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')))
# 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')) )
# 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")))
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')))