class CategoryStage(Base):
name = db.Column(db.String(250))
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', backref=db.backref('category', lazy='dynamic'))
results = relationship("Result")
def __init__(self, name, category_id):
self.name = name
self.category_id = category_id
class EventStage(Base):
name = db.Column(db.String(250))
event_id = db.Column(db.Integer, db.ForeignKey('event.id'))
event = db.relationship('Event', backref=db.backref('event_stage_event', lazy='dynamic'))
results = relationship("Result")
def __init__(self, name, event_id):
self.name = name
self.event_id = event_id
class SASEvent(Base):
event_reference = db.Column(db.String(250), unique=True)
event_id = db.Column(db.Integer, db.ForeignKey('event.id'))
event = db.relationship('Event',
backref=db.backref('sas_to_event', lazy='dynamic'))
def __init__(self, event_id, event_reference):
self.event_id = event_id
self.event_reference = event_reference
class Category(Base):
name = db.Column(db.String(250), nullable=False)
event_id = db.Column(db.Integer, db.ForeignKey('event.id'))
event = db.relationship('Event', backref=db.backref('event', lazy='dynamic'))
category_stages = relationship("CategoryStage")
results = relationship("Result")
def __init__(self,name, event_id):
self.name = name
self.event_id = event_id
class RTEventStage(Base):
stage_reference = db.Column(db.String(250), unique=True)
event_stage_id = db.Column(db.Integer, db.ForeignKey('event_stage.id'))
event_stage = db.relationship('EventStage',
backref=db.backref('rt_event_stage',
lazy='dynamic'))
def __init__(self, event_stage_id, stage_reference):
self.event_stage_id = event_stage_id
self.stage_reference = stage_reference
class RTCategory(Base):
category_reference = db.Column(db.String(250), unique=True)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category',
backref=db.backref('rt_to_category',
lazy='dynamic'))
def __init__(self, category_reference, category_id):
self.category_reference = category_reference
self.category_id = category_id
class SASCategoryStage(Base):
stage_reference = db.Column(db.String(250), unique=True)
category_stage_id = db.Column(db.Integer,
db.ForeignKey('category_stage.id'))
category_stage = db.relationship('CategoryStage',
backref=db.backref('category_stage',
lazy='dynamic'))
def __init__(self, category_stage_id, stage_reference):
self.category_stage_id = category_stage_id
self.stage_reference = stage_reference
class Result(Base):
position = db.Column(db.Integer)
participant_id = db.Column(db.Integer, db.ForeignKey('participant.id'))
participant = db.relationship('Participant', backref=db.backref('result_category', lazy='dynamic'))
gender_position = db.Column(db.Integer)
time = db.Column(db.Integer)
event_stage_id = db.Column(db.Integer, db.ForeignKey('event_stage.id'))
event_stage = db.relationship('EventStage', backref=db.backref('result_event_stage', lazy='dynamic'))
category_stage_id = db.Column(db.Integer, db.ForeignKey('category_stage.id'))
category_stage = db.relationship('CategoryStage', backref=db.backref('result_category_stage', lazy='dynamic'))
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category', backref=db.backref('result_category', lazy='dynamic'))
def __init__(self, position, participant_id, gender_position, time, event_stage_id, category_stage_id, category_id):
self.position = position
self.participant_id = participant_id
self.gender_position = gender_position
self.time = time
self.event_stage_id = event_stage_id
self.category_stage_id = category_stage_id
self.category_id = category_id