class Owners(db.Model):
PKEY_NAME = "owners_username_pkey"
id = db.Column(db.String, nullable=False)
username = db.Column(db.String, nullable=False)
first_name = db.Column(db.String, nullable=False)
last_name = db.Column(db.String, nullable=False)
db.PrimaryKeyConstraint(username, name=PKEY_NAME)
def __key(self):
return (self.id, self.username, self.first_name, self.last_name)
def __hash__(self):
return hash(self.__key())
def __eq__(self, other):
return isinstance(self, type(other)) and self.__key() == other.__key()
def as_dict(self):
return {
'id': self.id,
'username': self.username,
'first_name': self.first_name,
'last_name': self.last_name
}
def props_dict(self):
return self.as_dict()
class Sackos(db.Model):
PKEY_NAME = "sackos_year_pkey"
year = db.Column(db.Integer, nullable=False)
owner_id = db.Column(db.String, nullable=False)
db.PrimaryKeyConstraint(year, name=PKEY_NAME)
def __str__(self):
return ', '.join("%s: %s" % item for item in vars(self).items() if "_json" not in item)
def __repr__(self):
return ', '.join("%s: %s" % item for item in vars(self).items() if "_json" not in item)
def __key(self):
return (
self.year,
self.owner_id
)
def __hash__(self):
return hash(self.__key())
def __eq__(self, other):
return isinstance(self, type(other)) and self.__key() == other.__key()
def as_dict(self):
return {
'year': self.year,
'owner_id': self.owner_id
}
def props_dict(self):
return self.as_dict()
class Teams(db.Model):
PKEY_NAME = "teams_year_id_pkey"
year = db.Column(db.Integer, nullable=False)
id = db.Column(db.Integer, nullable=False)
owner_id = db.Column(db.String, nullable=False)
abbreviation = db.Column(db.String, nullable=False)
location = db.Column(db.String, nullable=False)
nickname = db.Column(db.String, nullable=False)
db.PrimaryKeyConstraint(year, id, name=PKEY_NAME)
def __str__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __repr__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __key(self):
return (self.year, self.id, self.owner_id, self.abbreviation,
self.location, self.nickname)
def __hash__(self):
return hash(self.__key())
def __eq__(self, other):
return isinstance(self, type(other)) and self.__key() == other.__key()
def as_dict(self):
return {
'year': self.year,
'id': self.id,
'owner_id': self.owner_id,
'abbreviation': self.abbreviation,
'location': self.location,
'nickname': self.nickname
}
def props_dict(self):
return self.as_dict()
class Matchups(db.Model):
PKEY_NAME = "matchups_year_matchup_id_team_id_pkey"
year = db.Column(db.Integer, nullable=False)
matchup_id = db.Column(db.Integer, nullable=False)
team_id = db.Column(db.Integer, nullable=False)
owner_id = db.Column(db.String, nullable=False)
opponent_team_id = db.Column(db.Integer)
opponent_owner_id = db.Column(db.String)
team_score = db.Column(db.Numeric, nullable=False)
opponent_team_score = db.Column(db.Numeric)
is_win = db.Column(db.Boolean, nullable=False)
is_loss = db.Column(db.Boolean, nullable=False)
is_pending = db.Column(db.Boolean, nullable=False)
is_bye = db.Column(db.Boolean, nullable=False)
is_playoffs = db.Column(db.Boolean, nullable=False)
is_consolation = db.Column(db.Boolean, nullable=False)
db.PrimaryKeyConstraint(year, matchup_id, team_id, name=PKEY_NAME)
def __str__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __repr__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __key(self):
return (self.year, self.matchup_id, self.team_id, self.owner_id,
self.opponent_team_id, self.opponent_owner_id, self.team_score,
self.opponent_team_score, self.is_win, self.is_loss,
self.is_pending, self.is_bye, self.is_playoffs,
self.is_consolation)
def __hash__(self):
return hash(self.__key())
def __eq__(self, other):
return isinstance(self, type(other)) and self.__key() == other.__key()
def as_dict(self):
return {
'year': self.year,
'matchup_id': self.matchup_id,
'team_id': self.team_id,
'owner_id': self.owner_id,
'opponent_team_id': self.opponent_team_id,
'opponent_owner_id': self.opponent_owner_id,
'team_score': self.team_score,
'opponent_team_score': self.opponent_team_score,
'is_win': self.is_win,
'is_loss': self.is_loss,
'is_pending': self.is_pending,
'is_bye': self.is_bye,
'is_playoffs': self.is_playoffs,
'is_consolation': self.is_consolation
}
def props_dict(self):
return self.as_dict()
class Records(db.Model):
PKEY_NAME = "records_year_team_id_pkey"
year = db.Column(db.Integer, nullable=False)
team_id = db.Column(db.Integer, nullable=False)
owner_id = db.Column(db.String, nullable=False)
standing = db.Column(db.Integer, nullable=False)
wins = db.Column(db.Integer, nullable=False)
losses = db.Column(db.Integer, nullable=False)
ties = db.Column(db.Integer, nullable=False)
points_for = db.Column(db.Numeric, nullable=False)
points_against = db.Column(db.Numeric, nullable=False)
streak_length = db.Column(db.Integer, nullable=False)
streak_type = db.Column(db.String, nullable=False)
db.PrimaryKeyConstraint(year, team_id, name=PKEY_NAME)
def __str__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __repr__(self):
return ', '.join("%s: %s" % item for item in vars(self).items()
if "_json" not in item)
def __key(self):
return (self.year, self.team_id, self.owner_id, self.standing,
self.wins, self.losses, self.ties, self.points_for,
self.points_against, self.streak_length, self.streak_type)
def __hash__(self):
return hash(self.__key())
def __eq__(self, other):
return isinstance(self, type(other)) and self.__key() == other.__key()
def as_dict(self):
return {
'year': self.year,
'team_id': self.team_id,
'owner_id': self.owner_id,
'standing': self.standing,
'wins': self.wins,
'losses': self.losses,
'ties': self.ties,
'points_for': self.points_for,
'points_against': self.points_against,
'streak_length': self.streak_length,
'streak_type': self.streak_type
}
def props_dict(self):
return self.as_dict()