import datetime
import pytz
from sqlalchemy import event, func
from sqlalchemy.sql import func as sql_func
from app.models import db
from app.models.base import SoftDeletionModel
from app.models.feedback import Feedback
from app.models.helpers.versioning import clean_up_string, clean_html
speakers_sessions = db.Table('speakers_sessions',
db.Column('speaker_id', db.Integer, db.ForeignKey('speaker.id', ondelete='CASCADE')),
db.Column('session_id', db.Integer, db.ForeignKey('sessions.id', ondelete='CASCADE')),
db.PrimaryKeyConstraint('speaker_id', 'session_id'))
class Session(SoftDeletionModel):
"""Session model class"""
__tablename__ = 'sessions'
__versioned__ = {
'exclude': []
}
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String, nullable=False)
subtitle = db.Column(db.String)
short_abstract = db.Column(db.Text)
long_abstract = db.Column(db.Text)
comments = db.Column(db.Text)
language = db.Column(db.String)
level = db.Column(db.String)
from app.api.helpers.errors import ConflictError
from app.models import db
from app.models.base import SoftDeletionModel
from app.models.order import Order, OrderTicket
access_codes_tickets = db.Table(
'access_codes_tickets',
db.Column('access_code_id', db.Integer,
db.ForeignKey('access_codes.id', ondelete='CASCADE')),
db.Column('ticket_id', db.Integer,
db.ForeignKey('tickets.id', ondelete='CASCADE')),
db.PrimaryKeyConstraint('access_code_id', 'ticket_id'),
)
discount_codes_tickets = db.Table(
'discount_codes_tickets',
db.Column(
'discount_code_id',
db.Integer,
db.ForeignKey('discount_codes.id', ondelete='CASCADE'),
),
db.Column('ticket_id', db.Integer,
db.ForeignKey('tickets.id', ondelete='CASCADE')),
db.PrimaryKeyConstraint('discount_code_id', 'ticket_id'),
)
ticket_tags_table = db.Table(
'ticket_tagging',
db.Model.metadata,
db.Column('ticket_id', db.Integer,
db.ForeignKey('tickets.id', ondelete='CASCADE')),