class Slot(db.Model):
"""Time slot."""
__tablename__ = 'slots'
id = db.Column(db.Integer, primary_key=True)
kind = db.Column(
db.Enum('break',
'meal',
'keynote',
'talk',
'tutorial',
name='slotkind'),
nullable=False,
)
content_override = db.Column(db.Text)
start = db.Column(db.Time, nullable=False)
end = db.Column(db.Time, nullable=False)
day_id = db.Column(db.Integer, db.ForeignKey('days.id'), nullable=False)
day = db.relationship('Day', backref=db.backref('slots', lazy='dynamic'))
rooms = db.relationship(
'Room',
secondary=rooms_slots,
backref=db.backref('slots', lazy='dynamic'),
order_by=Room.order,
)
def __str__(self):
"""Return a printable representation."""
start = self.start.strftime('%I:%M %p')
end = self.end.strftime('%I:%M %p')
rooms = ', '.join(map(str, self.rooms))
return '{} - {} on {}, {}'.format(start, end, self.day, rooms)
@cached_property
def duration(self):
"""Return the duration as a :class:`~datetime.timedelta`."""
return self.end - self.start
class Talk(db.Model):
"""Talk."""
__tablename__ = 'talks'
query_class = EventQuery
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
description = db.Column(db.Text, nullable=False)
status = db.Column(
db.Enum('draft', 'submitted', 'accepted', 'rejected', name='status'),
default='draft',
nullable=False,
)
level = db.Column(
db.Enum('novice', 'intermediate', 'advanced', name='level'),
nullable=False,
)
type = db.Column(
db.Enum('talk', 'tutorial', name='type'),
nullable=False,
)
duration_id = db.Column(db.ForeignKey('durations.id'), nullable=False)
duration = db.relationship('Duration')
recording_release = db.Column(db.Boolean, nullable=True)
abstract = db.Column(db.Text)
additional_requirements = db.Column(db.Text)
objectives = db.Column(db.Text)
outline = db.Column(db.Text)
target_audience = db.Column(db.Text)
event_id = db.Column(
db.Integer,
db.ForeignKey('events.id'),
nullable=False,
)
event = db.relationship(
'Event',
backref=db.backref('talks', lazy='dynamic'),
)
category_id = db.Column(db.Integer,
db.ForeignKey('categories.id'),
nullable=True)
category = db.relationship(
'Category',
backref=db.backref('talks', lazy='dynamic'),
)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
user = db.relationship('User', backref=db.backref('talks', lazy='dynamic'))
video_url = db.Column(db.String(255))
def __str__(self):
"""Return a printable representation."""
return self.name
@property
def is_accepted(self):
"""Return whether the instance is accepted."""
return self.status == 'accepted'
@property
def slug(self):
"""Return a slug for the instance."""
return slugify(self.name, max_length=25)