def forwards(self, orm):
old_db = dbs['old']
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from brownlow_ladder')
for ladder in ladders:
ladder_args = {
'club': club_map[ladder[2]],
'position': ladder[12],
'previous_position': ladder[10],
'round': round_map[ladder[1]],
'score': ladder[8],
'max_score': ladder[14],
'min_score': ladder[0],
'avg_score': ladder[5],
'strike_rate': ladder[3],
'five': ladder[9],
'four': ladder[7],
'three': ladder[4],
'two': ladder[6],
'one': ladder[13],
'nothing': ladder[11],
}
new_ladder = orm.BrownlowLadder(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
club_map = migration.club_map(old_db, orm.Club)
season_map = migration.season_map(old_db, orm.Season)
# Get the asistant coaches
assistants = set(
('Bernard Bialecki', 'Ben West', 'Peter Moran', 'Chris Balkos')
)
coaches = old_db.execute('select * from coach')
for c in coaches:
name = '{} {}'.format(c[0], c[1])
is_assistant = name in assistants
coach = orm.Coach(
club=club_map[c[3]],
first_name=c[0],
has_paid_fees=c[5],
is_assistant=is_assistant,
last_name=c[1],
season=season_map[c[4]]
)
coach.save()
def forwards(self, orm):
old_db = dbs["old"]
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
byes = old_db.execute("select * from bye")
tips_query = """
select t.* from tip t
join afl_fixture af on af.id = t.afl_fixture_id
where af.round_id = {} and t.club_id = {}
"""
for b in byes:
tips = old_db.execute(tips_query.format(b[2], b[1]))
bye_args = {"club": club_map[b[1]], "round": round_map[b[2]], "score": b[3], "winners_bonus": b[4]}
# Add quarter scores
scores = self.scores(tips)
for key in ("winners", "margins", "crowds", "supercoach"):
bye_args["{}_score".format(key)] = scores[key]
bye = orm.Bye(**bye_args)
bye.save()
def forwards(self, orm):
old_db = dbs['old']
season_map = migration.season_map(old_db, orm.Season)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from past_legends_ladder')
for ladder in ladders:
try:
club = club_map[ladder[1]]
except KeyError:
club = None
ladder_args = {
'club': club,
'avg_score': ladder[2],
'position': ladder[5],
'score': ladder[6],
'season': season_map[ladder[7]],
'played': ladder[8],
'win': ladder[9],
'draw': ladder[10],
'loss': ladder[11],
'points_for': ladder[12],
'points_against': ladder[13],
'avg_points_for': ladder[3],
'avg_points_against': ladder[4],
'percentage': ladder[14],
}
new_ladder = orm.PastLegendsLadder(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
season_map = migration.season_map(old_db, orm.Season)
club_map = migration.club_map(old_db, orm.Club)
for name in ('brownlow', 'coleman', 'crowds', 'margins'):
table = 'past_{}_ladder'.format(name)
model = 'Past{}Ladder'.format(name.title())
ladders = old_db.execute('select * from {}'.format(table))
for ladder in ladders:
try:
club = club_map[ladder[1]]
except KeyError:
club = None
ladder_args = {
'club': club,
'avg_score': ladder[2],
'position': ladder[3],
'score': ladder[4],
'season': season_map[ladder[5]],
}
new_ladder = getattr(orm, model)(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from legends_ladder')
for ladder in ladders:
ladder_args = {
'club': club_map[ladder[8]],
'position': ladder[16],
'previous_position': ladder[9],
'round': round_map[ladder[6]],
'played': ladder[3],
'win': ladder[7],
'loss': ladder[0],
'draw': ladder[1],
'score_for': ladder[10],
'score_against': ladder[20],
'points': ladder[12],
'percentage': ladder[17],
'bye_for': ladder[4],
'total_for': ladder[14],
'max_for': ladder[13],
'min_for': ladder[2],
'avg_for': ladder[15],
'max_against': ladder[11],
'min_against': ladder[5],
'avg_against': ladder[18],
}
new_ladder = orm.LegendsLadder(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from afl_ladder')
for ladder in ladders:
ladder_args = {
'club': club_map[ladder[6]],
'position': ladder[10],
'previous_position': ladder[7],
'round': round_map[ladder[4]],
'played': ladder[3],
'win': ladder[5],
'loss': ladder[0],
'draw': ladder[1],
'score_for': ladder[8],
'score_against': ladder[2],
'points': ladder[9],
'percentage': ladder[11],
}
new_ladder = orm.AFLLadder(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
club_map = migration.club_map(old_db, orm.Club)
game_map = migration.game_map(
old_db, orm.Game, fk_models={'round': orm.Round, 'club': orm.Club})
tips = old_db.execute('select * from tip')
for t in tips:
tip_args = {
'game': game_map[t[0]],
'club': club_map[t[7]],
'crowd': t[3],
'crowds_score': t[2],
'is_default': t[9],
'margin': t[11],
'margins_score': t[5],
'total': t[10],
'supercoach_score': t[6],
'winner': club_map[t[8]],
'winners_score': t[1]
}
tip = orm.Tip(**tip_args)
tip.save()
def forwards(self, orm):
old_db = dbs['old']
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ground_map = migration.ground_map(old_db, orm.Ground)
afl_games = old_db.execute('select * from afl_fixture')
leg_query = 'select * from legends_fixture where afl_fixture_id = {}'
tips_query = '''
select t.* from tip t
join legends_fixture lf on lf.id = t.legends_fixture_id
join round r on r.id = lf.round_id
where r.id = {} and t.club_id = {}
'''
for afl_game in afl_games:
legends_game = old_db.execute(leg_query.format(afl_game[-1]))[0]
away_tips = old_db.execute(
tips_query.format(afl_game[6], legends_game[0])
)
home_tips = old_db.execute(
tips_query.format(afl_game[6], legends_game[5])
)
game_args = {
'crowd': afl_game[4],
'finals_game': afl_game[10],
'game_date': afl_game[5],
'round': round_map[afl_game[6]],
'status': afl_game[0],
'tipping_deadline': afl_game[8],
'ground': ground_map[afl_game[3]],
'afl_away': club_map[afl_game[1]],
'afl_away_score': afl_game[13],
'afl_home': club_map[afl_game[9]],
'afl_home_score': afl_game[11],
'legends_away': club_map[legends_game[0]],
'legends_away_score': legends_game[8],
'legends_away_winners_bonus': legends_game[4],
'legends_home': club_map[legends_game[5]],
'legends_home_score': legends_game[7],
'legends_home_winners_bonus': legends_game[1]
}
# Add quarter scores for legends games
quarters = ('winners', 'margins', 'crowds', 'supercoach')
scores = self.legends_scores(away_tips)
for qtr in quarters:
game_args['legends_away_{}_score'.format(qtr)] = scores[qtr]
scores = self.legends_scores(home_tips)
for qtr in quarters:
game_args['legends_home_{}_score'.format(qtr)] = scores[qtr]
game = orm.Game(**game_args)
game.save()
def forwards(self, orm):
old_db = dbs['old']
club_map = migration.club_map(old_db, orm.Club)
season_map = migration.season_map(old_db, orm.Season)
old_players = old_db.execute("select * from player")
for p in old_players:
player_args = {
'first_name': p[0],
'last_name': p[1],
'initial': p[2],
'club': club_map[p[3]],
'supercoach_name': p[4],
'season': season_map[p[5]]
}
player = orm.Player(**player_args)
player.save()
def forwards(self, orm):
old_db = dbs["old"]
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute("select * from streak_ladder")
for ladder in ladders:
ladder_args = {
"club": club_map[ladder[2]],
"position": ladder[7],
"previous_position": ladder[1],
"round": round_map[ladder[4]],
"wins": ladder[5],
"draws": ladder[3],
"losses": ladder[6],
"streak": ladder[0],
}
new_ladder = orm.StreakLadder(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
season_map = migration.season_map(old_db, orm.Season)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from past_category_winner')
for ladder in ladders:
try:
club = club_map[ladder[2]]
except KeyError:
club = None
ladder_args = {
'club': club,
'category': ladder[1],
'season': season_map[ladder[3]],
}
new_ladder = orm.PastCategoryWinner(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
season_map = migration.season_map(old_db, orm.Season)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from past_coach')
for ladder in ladders:
try:
club = club_map[ladder[1]]
except KeyError:
club = None
ladder_args = {
'club': club,
'first_name': ladder[2],
'last_name': ladder[3],
'season': season_map[ladder[4]],
}
new_ladder = orm.PastCoach(**ladder_args)
new_ladder.save()
def forwards(self, orm):
old_db = dbs['old']
round_map = migration.round_map(old_db, orm.Round)
club_map = migration.club_map(old_db, orm.Club)
ladders = old_db.execute('select * from coleman_ladder')
for ladder in ladders:
ladder_args = {
'club': club_map[ladder[1]],
'position': ladder[15],
'previous_position': ladder[19],
'round': round_map[ladder[12]],
'score': ladder[11],
'winners': ladder[13],
'bonus': ladder[10],
'max_score': ladder[18],
'min_score': ladder[6],
'avg_score': ladder[2],
'strike_rate': ladder[8],
'nine': ladder[21],
'eight': ladder[22],
'seven': ladder[0],
'six': ladder[7],
'five': ladder[14],
'four': ladder[4],
'three': ladder[9],
'two': ladder[3],
'one': ladder[17],
'nothing': ladder[16],
'bonus_strike_rate': ladder[20],
}
new_ladder = orm.ColemanLadder(**ladder_args)
new_ladder.save()