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']
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']
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']
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']
season_map = migration.season_map(old_db, orm.Season)
old_rounds = old_db.execute("select * from round")
for r in old_rounds:
round_args = {
'is_finals': r[1],
'name': r[3],
'num_bogs': r[4],
'num_games': r[6],
'season': season_map[r[7]],
'status': r[9],
'start_time': r[10],
'tipping_deadline': r[11]
}
rnd = orm.Round(**round_args)
rnd.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()
