class Game(db.Model):
__tablename__ = 'games'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participants = db.relationship('Participant', secondary = 'participants_games', back_populates = 'game')
name = db.Column(db.Text)
map = db.Column(db.Text)
game_winner = db.Column(db.Text)
start_time = db.Column(db.DateTime)
end_time = db.Column(db.DateTime)
category = db.Column(db.Text)
expansion = db.Column(db.Text)
time_zone = db.Column(db.Float)
def __repr__(self):
return '<Game (map = ' + str(self.map) + ', ' + str(self.start_time) + ') >'
def __str__(self):
return 'game'
@classmethod
def all(cls):
return db.session.query(cls).all()
class BasicCommandEvent(db.Model):
__tablename__ = 'basiccommandevent'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participant = db.relationship('Participant', back_populates = 'events_BCE')
name = db.Column(db.Text)
second = db.Column(db.Float)
ability_name = db.Column(db.Text)
def __repr__(self):
return '<' + self.name + ' (player = ' + self.participant.name + ') >'
@classmethod
def all(cls):
return db.session.query(cls).all()
class UpgradeCompleteEvent(db.Model):
__tablename__ = 'upgradecompleteevents'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participant = db.relationship('Participant', back_populates = 'events_UCE')
name = db.Column(db.Text)
second = db.Column(db.Float)
upgrade_type_name = db.Column(db.Text)
def __repr__(self):
return '<' + self.name + ' (player = ' + self.participant.name + ') >'
@classmethod
def all(cls):
return db.session.query(cls).all()
class UnitBornEvent(db.Model):
__tablename__ = 'unitbornevents'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participant = db.relationship('Participant', back_populates = 'events_UBE')
name = db.Column(db.Text)
second = db.Column(db.Float)
unit_type_name = db.Column(db.Text)
loc_x = db.Column(db.Float)
loc_y = db.Column(db.Float)
def __repr__(self):
return '<' + self.name + ' (player = ' + self.participant.name + ') >'
@classmethod
def get_col_names(cls):
return ['id', 'participant_id', 'name', 'second', 'unit_type_name', 'loc_x', 'loc_y']
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participants = db.relationship('Participant', secondary = 'participants_users', back_populates = 'user')
name = db.Column(db.Text)
region = db.Column(db.Text)
subregion = db.Column(db.Integer)
def __repr__(self):
return '<User (name = ' + self.name + ') >'
def __str__(self):
return 'user'
@classmethod
def all(cls):
return db.session.query(cls).all()
class Participants_Users(db.Model):
__tablename__ = 'participants_users'
id = db.Column(db.Integer, primary_key = True)
player_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
class Participants_Games(db.Model):
__tablename__ = 'participants_games'
id = db.Column(db.Integer, primary_key = True)
player_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
game_id = db.Column(db.Integer, db.ForeignKey('games.id'))
class PlayerStatsEvent(db.Model):
__tablename__ = 'playerstatsevents'
id = db.Column(db.Integer, primary_key = True)
participant_id = db.Column(db.Integer, db.ForeignKey('participants.id'))
participant = db.relationship('Participant', back_populates = 'events_PSE')
name = db.Column(db.Text)
second = db.Column(db.Float)
minerals_current = db.Column(db.Float)
vespene_current = db.Column(db.Float)
minerals_collection_rate = db.Column(db.Float)
vespene_collection_rate = db.Column(db.Float)
workers_active_count = db.Column(db.Float)
minerals_used_in_progress_army = db.Column(db.Float)
minerals_used_in_progress_economy = db.Column(db.Float)
minerals_used_in_progress_technology = db.Column(db.Float)
minerals_used_in_progress = db.Column(db.Float)
vespene_used_in_progress_army = db.Column(db.Float)
vespene_used_in_progress_economy = db.Column(db.Float)
vespene_used_in_progress_technology = db.Column(db.Float)
vespene_used_in_progress = db.Column(db.Float)
resources_used_in_progress = db.Column(db.Float)
minerals_used_current_army = db.Column(db.Float)
minerals_used_current_economy = db.Column(db.Float)
minerals_used_current_technology = db.Column(db.Float)
minerals_used_current = db.Column(db.Float)
vespene_used_current_army = db.Column(db.Float)
vespene_used_current_economy = db.Column(db.Float)
vespene_used_current_technology = db.Column(db.Float)
vespene_used_current = db.Column(db.Float)
resources_used_current = db.Column(db.Float)
minerals_lost_army = db.Column(db.Float)
minerals_lost_economy = db.Column(db.Float)
minerals_lost_technology = db.Column(db.Float)
minerals_lost = db.Column(db.Float)
vespene_lost_army = db.Column(db.Float)
vespene_lost_economy = db.Column(db.Float)
vespene_lost_technology = db.Column(db.Float)
vespene_lost = db.Column(db.Float)
resources_lost = db.Column(db.Float)
minerals_killed_army = db.Column(db.Float)
minerals_killed_economy = db.Column(db.Float)
minerals_killed_technology = db.Column(db.Float)
minerals_killed = db.Column(db.Float)
vespene_killed_army = db.Column(db.Float)
vespene_killed_economy = db.Column(db.Float)
vespene_killed_technology = db.Column(db.Float)
vespene_killed = db.Column(db.Float)
resources_killed = db.Column(db.Float)
food_used = db.Column(db.Float)
food_made = db.Column(db.Float)
minerals_used_active_forces = db.Column(db.Float)
vespene_used_active_forces = db.Column(db.Float)
ff_minerals_lost_army = db.Column(db.Float)
ff_minerals_lost_economy = db.Column(db.Float)
ff_minerals_lost_technology = db.Column(db.Float)
ff_vespene_lost_army = db.Column(db.Float)
ff_vespene_lost_economy = db.Column(db.Float)
ff_vespene_lost_technology = db.Column(db.Float)
def __repr__(self):
return '<' + self.name + ' (player = ' + self.participant.name + ') >'
def column_names():
return []