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()