Python Column 예제들

예제 #1

파일: models.py 프로젝트: Panda64/BEW-1.2-Events_Homework

class Guest(db.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="guest")

예제 #2

파일: models.py 프로젝트: Ignl94/bew_events

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

예제 #3

파일: models.py 프로젝트: Pondorasti/BEW-1.2

class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String)
    description = db.Column(db.String)
    date_and_time = db.Column(db.DateTime)
    event_type = db.Column(db.Enum(PartyType), default=PartyType.Party)
    guests = db.relationship("Guest", secondary="guest_events")

예제 #4

파일: models.py 프로젝트: Ignl94/bew_events

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

예제 #5

파일: models.py 프로젝트: asood92/events-hw

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, nullable=False)
    date_and_time = db.Column(db.DateTime, nullable=False)
    guests = db.relationship(
        "Guest", secondary="guest_events", back_populates="events_attending"
    )

예제 #6

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

예제 #7

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(100), nullable=False)
    phone = db.Column(db.String(20), nullable=False)
    events_attending = db.relationship("Event",
                                       secondary="guest_event_table",
                                       back_populates="guests")

예제 #8

파일: models.py 프로젝트: Panda64/BEW-1.2-Events_Homework

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(80), nullable=False)
    date_and_time = db.Column(db.Date)

    guest = db.relationship('Guest', secondary="guest_event", back_populates="events_attending")

    event_type = db.Column(db.Enum(EventType), default=EventType.GENERAL)

예제 #9

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.Text, nullable=False)
    date_and_time = db.Column(db.DateTime, nullable=False)
    guests = db.relationship("Guest",
                             secondary="guest_event_table",
                             back_populates="events_attending")
    event_type = db.Column(db.Enum(Event_Type), default=Event_Type.PARTY)

예제 #10

파일: models.py 프로젝트: shah-a/bew1.2-03-events-site

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

예제 #11

파일: models.py 프로젝트: JustJoshRiley/Events

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

예제 #12

파일: models.py 프로젝트: ruot-nyak/BEW-1.2-Events-Homework

class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)

# TODO: Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)
    title = db.Column(db.String(50), nullable=False)
    description = db.Column(db.String(100))
    date_and_time = db.Column(db.Date)
    guests = db.relationship('Guest', secondary='guest_event', back_populates='events_attending')

예제 #13

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

예제 #14

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)

예제 #15

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

예제 #16

파일: models.py 프로젝트: shah-a/bew1.2-03-events-site

class Event(db.Model):
    """Event model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80))
    description = db.Column(db.String(80))
    date_and_time = db.Column(db.DateTime)
    event_type = db.Column(db.Enum(Event_Type), default=Event_Type.OTHER)
    guests = db.relationship('Guest',
                             secondary='guest_event',
                             back_populates='events')

예제 #17

파일: models.py 프로젝트: CptnReef/BEW-1.2-Events-Homework

class Event(db.Model):
    __tablename__ = 'events'

    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80))
    description = db.Column(db.String(80))
    date_and_time = db.DateTime(db.DateTime())
    event_type = db.Column(db.Enum(EVENT_TYPE))
    guests = db.relationship('Guest',
                             back_populates="events_attending",
                             secondary='guest_event_table')

예제 #18

파일: models.py 프로젝트: CptnReef/BEW-1.2-Events-Homework

class Guest(db.Model):
    #SQL Error??
    __tablename__ = 'guests'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80))
    email = db.Column(db.String(80))
    phone = db.Column(db.String(80))
    events_attending = db.relationship('Event',
                                       back_populates="guests",
                                       secondary='guest_event_table')

예제 #19

파일: models.py 프로젝트: brianross93/flaskformsbew12

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(80), nullable=False)
    date_and_time = db.Column(db.DateTime,
                              nullable=False,
                              default=datetime.strftime(
                                  datetime.today(), "%b %d %Y"))
    guests = db.relationship('Guest',
                             secondary='guest_event_table',
                             back_populates='events_attending')

예제 #20

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(80))
    date_and_time = db.Column(db.Date)
    guests = db.relationship('Guest', secondary='guest_event')

    def __str__(self):
        return f'<Event Title: {self.title}>'

    def __repr__(self):
        return f'<Event Title: {self.title}>'

예제 #21

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

    def __str__(self):
        return f'<Name:{self.name}'

    def __repr__(self):
        return f'<Name:{self.name}'

예제 #22

파일: 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"))

예제 #23

파일: models.py 프로젝트: ruot-nyak/BEW-1.2-Events-Homework

class Guest(db.Model):
    id = db.Column(db.Integer, primary_key=True)

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

예제 #24

파일: models.py 프로젝트: shahirkingali/BEW-Homework-2-Events-Site

class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    # TODO: Create a table `guest_event_table` with the following columns:
    # - event_id: Integer column (foreign key)
    # - guest_id: Integer column (foreign key)
    title = db.Column(db.String(80), nullable=False)
    description = db.Column(db.String(140))
    date_and_time = db.Column(db.DateTime)
    event_type = db.Column(db.Enum(Type), default=Type.ALL)
    guests = db.relationship("Guest",
                             secondary="guest_event",
                             back_populates="events_attending")

예제 #25

파일: models.py 프로젝트: flask-django-independent-study/week-5-events-app

class Guest(db.Model):
    """Create Guest model."""

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(55), nullable=False)
    email = db.Column(db.String(40), nullable=False)
    plus_one = db.Column(db.String(55), nullable=True)
    phone = db.Column(db.String(12), nullable=False)
    events_attending = db.relationship("Event", secondary="guest_event_link")

    def __repr__(self):
        """Define how we want this to look when printed."""
        return self.name

예제 #26

파일: models.py 프로젝트: flask-django-independent-study/week-5-events-app

class Event(db.Model):
    """Create Event model."""

    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(90), nullable=False)
    description = db.Column(db.String(140), nullable=False)
    date = db.Column(db.DateTime, nullable=False)
    time = db.Column(db.DateTime, nullable=False)
    guests = db.relationship("Guest", secondary="guest_event_link")

    def __repr__(self):
        """Define how we want this to look when printed."""
        return self.title, self.description

예제 #27

파일: models.py 프로젝트: ahmadshahrour951/BEW-1.2-Events-Homework

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

    def __str__(self):
        return f'<Guest: {self.name}>'

    def __repr__(self):
        return f'<Guest: {self.name}>'

예제 #28

파일: models.py 프로젝트: LWRGitHub/events-app

class Guest(db.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.Integer, nullable=False)

    # - events_attending: relationship to "Event" table with a secondary table
    events_attending = db.relationship('Event', secondary='guest_event_table', back_populates='guests')

    def __str__(self):
        return f'<Guest: {self.name}>'

    def __repr__(self):
        return f'<Guest: {self.name}>'

예제 #29

파일: models.py 프로젝트: LWRGitHub/events-app

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(80), nullable=False)
    date_and_time = db.Column(db.Integer, nullable=False)
    guests = db.relationship('Guest', secondary='guest_event_table', back_populates='events_attending')

    # `event_type` as an Enum column that denotes the
    # type of event 
    event_type = db.Column(db.Enum(Event_type), default=Event_type.ALL)

    def __str__(self):
        return f'<Event: {self.title}>'

    def __repr__(self):
        return f'<Event: {self.title}>'

예제 #30

파일: models.py 프로젝트: ahmadshahrour951/BEW-1.2-Events-Homework

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

    def __str__(self):
        return f'<Event: {self.title}>'

    def __repr__(self):
        return f'<Event: {self.title}>'