def seed_2021_tournament_round3():
tournament = Tournament.query.filter(Tournament.year == 2021).one()
tournament.last_round_completed = 3
# West
Gonzaga = College.query.filter(College.name == 'Gonzaga').one()
gonzaga = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Gonzaga.id).one()
Creighton = College.query.filter(College.name == 'Creighton').one()
creighton = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Creighton.id).one()
USC = College.query.filter(College.name == 'USC').one()
uSC = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == USC.id).one()
Oregon = College.query.filter(College.name == 'Oregon').one()
oregon = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon.id).one()
# South
Baylor = College.query.filter(College.name == 'Baylor').one()
baylor = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Baylor.id).one()
Villanova = College.query.filter(College.name == 'Villanova').one()
villanova = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Villanova.id).one()
Arkansas = College.query.filter(College.name == 'Arkansas').one()
arkansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Arkansas.id).one()
Oral_Roberts = College.query.filter(College.name == 'Oral Roberts').one()
oral_Roberts = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oral_Roberts.id).one()
# Midwest
Loyola_Chicago = College.query.filter(
College.name == 'Loyola Chicago').one()
loyola_Chicago = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Loyola_Chicago.id).one()
Oregon_State = College.query.filter(College.name == 'Oregon State').one()
oregon_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon_State.id).one()
Syracuse = College.query.filter(College.name == 'Syracuse').one()
syracuse = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Syracuse.id).one()
Houston = College.query.filter(College.name == 'Houston').one()
houston = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Houston.id).one()
# East
Michigan = College.query.filter(College.name == 'Michigan').one()
michigan = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Michigan.id).one()
Florida_State = College.query.filter(College.name == 'Florida State').one()
florida_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Florida_State.id).one()
UCLA = College.query.filter(College.name == 'UCLA').one()
uCLA = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCLA.id).one()
Alabama = College.query.filter(College.name == 'Alabama').one()
alabama = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Alabama.id).one()
game_49 = Game.query.filter(Game.game_num == 49).filter(
Game.tournament_id == tournament.id).one()
game_49.winning_team_id = gonzaga.id
game_50 = Game.query.filter(Game.game_num == 50).filter(
Game.tournament_id == tournament.id).one()
game_50.winning_team_id = uSC.id
game_51 = Game.query.filter(Game.game_num == 51).filter(
Game.tournament_id == tournament.id).one()
game_51.winning_team_id = michigan.id
game_52 = Game.query.filter(Game.game_num == 52).filter(
Game.tournament_id == tournament.id).one()
game_52.winning_team_id = uCLA.id
game_53 = Game.query.filter(Game.game_num == 53).filter(
Game.tournament_id == tournament.id).one()
game_53.winning_team_id = baylor.id
game_54 = Game.query.filter(Game.game_num == 54).filter(
Game.tournament_id == tournament.id).one()
game_54.winning_team_id = arkansas.id
game_55 = Game.query.filter(Game.game_num == 55).filter(
Game.tournament_id == tournament.id).one()
game_55.winning_team_id = oregon_State.id
game_56 = Game.query.filter(Game.game_num == 56).filter(
Game.tournament_id == tournament.id).one()
game_56.winning_team_id = houston.id
db.session.commit()
game_49_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_49.id).filter(
Game_Team_Score.team_id == gonzaga.id).one()
game_49_win_score.score = 83
game_49_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_49.id).filter(
Game_Team_Score.team_id == creighton.id).one()
game_49_lose_score.score = 65
game_50_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_50.id).filter(
Game_Team_Score.team_id == uSC.id).one()
game_50_win_score.score = 82
game_50_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_50.id).filter(
Game_Team_Score.team_id == oregon.id).one()
game_50_lose_score.score = 68
game_51_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_51.id).filter(
Game_Team_Score.team_id == michigan.id).one()
game_51_win_score.score = 76
game_51_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_51.id).filter(
Game_Team_Score.team_id == florida_State.id).one()
game_51_lose_score.score = 58
game_52_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_52.id).filter(
Game_Team_Score.team_id == uCLA.id).one()
game_52_win_score.score = 88
game_52_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_52.id).filter(
Game_Team_Score.team_id == alabama.id).one()
game_52_lose_score.score = 78
game_53_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_53.id).filter(
Game_Team_Score.team_id == baylor.id).one()
game_53_win_score.score = 62
game_53_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_53.id).filter(
Game_Team_Score.team_id == villanova.id).one()
game_53_lose_score.score = 51
game_54_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_54.id).filter(
Game_Team_Score.team_id == arkansas.id).one()
game_54_win_score.score = 72
game_54_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_54.id).filter(
Game_Team_Score.team_id == oral_Roberts.id).one()
game_54_lose_score.score = 70
game_55_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_55.id).filter(
Game_Team_Score.team_id == oregon_State.id).one()
game_55_win_score.score = 65
game_55_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_55.id).filter(
Game_Team_Score.team_id == loyola_Chicago.id).one()
game_55_lose_score.score = 58
game_56_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_56.id).filter(
Game_Team_Score.team_id == houston.id).one()
game_56_win_score.score = 62
game_56_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_56.id).filter(
Game_Team_Score.team_id == syracuse.id).one()
game_56_lose_score.score = 46
db.session.commit()
game_57 = Game(game_num=57,
round_num=4,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_57)
game_58 = Game(game_num=58,
round_num=4,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_58)
game_59 = Game(game_num=59,
round_num=4,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_59)
game_60 = Game(game_num=60,
round_num=4,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_60)
db.session.commit()
game_49.child_game_id = game_57.id
game_50.child_game_id = game_57.id
game_51.child_game_id = game_58.id
game_52.child_game_id = game_58.id
game_53.child_game_id = game_59.id
game_54.child_game_id = game_59.id
game_55.child_game_id = game_60.id
game_56.child_game_id = game_60.id
db.session.commit()
game_57_win_score = Game_Team_Score(game_id=game_57.id,
team_id=gonzaga.id,
score=None)
game_57_lose_score = Game_Team_Score(game_id=game_57.id,
team_id=uSC.id,
score=None)
game_57.game_team_scores = [game_57_win_score, game_57_lose_score]
game_58_win_score = Game_Team_Score(game_id=game_58.id,
team_id=michigan.id,
score=None)
game_58_lose_score = Game_Team_Score(game_id=game_58.id,
team_id=uCLA.id,
score=None)
game_58.game_team_scores = [game_58_win_score, game_58_lose_score]
game_59_win_score = Game_Team_Score(game_id=game_59.id,
team_id=baylor.id,
score=None)
game_59_lose_score = Game_Team_Score(game_id=game_59.id,
team_id=arkansas.id,
score=None)
game_59.game_team_scores = [game_59_win_score, game_59_lose_score]
game_60_win_score = Game_Team_Score(game_id=game_60.id,
team_id=oregon_State.id,
score=None)
game_60_lose_score = Game_Team_Score(game_id=game_60.id,
team_id=houston.id,
score=None)
game_60.game_team_scores = [game_60_win_score, game_60_lose_score]
db.session.commit()
print('done')
def seed_2021_tournament_round1():
tournament = Tournament.query.filter(Tournament.year == 2021).one()
tournament.last_round_completed = 1
# West
Gonzaga = College.query.filter(College.name == 'Gonzaga').one()
gonzaga = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Gonzaga.id
).one()
Norfolk_State = College.query.filter(College.name == 'Norfolk St.').one()
norfolk_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Norfolk_State.id
).one()
Oklahoma = College.query.filter(College.name == 'Oklahoma').one()
oklahoma = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oklahoma.id
).one()
Missouri = College.query.filter(College.name == 'Missouri').one()
missouri = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Missouri.id
).one()
Creighton = College.query.filter(College.name == 'Creighton').one()
creighton = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Creighton.id
).one()
UCSB = College.query.filter(College.name == 'UCSB').one()
uCSB = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCSB.id
).one()
Virginia = College.query.filter(College.name == 'Virginia').one()
virginia = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Virginia.id
).one()
Ohio = College.query.filter(College.name == 'Ohio').one()
ohio = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Ohio.id
).one()
USC = College.query.filter(College.name == 'USC').one()
uSC = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == USC.id
).one()
Drake = College.query.filter(College.name == 'Drake').one()
drake = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Drake.id
).one()
Kansas = College.query.filter(College.name == 'Kansas').one()
kansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Kansas.id
).one()
Eastern_Washington = College.query.filter(
College.name == 'Eastern Washington').one()
eastern_Washington = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Eastern_Washington.id
).one()
Oregon = College.query.filter(College.name == 'Oregon').one()
oregon = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon.id
).one()
VCU = College.query.filter(College.name == 'VCU').one()
vCU = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == VCU.id
).one()
Iowa = College.query.filter(College.name == 'Iowa').one()
iowa = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Iowa.id
).one()
Grand_Canyon = College.query.filter(College.name == 'Grand Canyon').one()
grand_Canyon = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Grand_Canyon.id
).one()
# South
Baylor = College.query.filter(College.name == 'Baylor').one()
baylor = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Baylor.id
).one()
Hartford = College.query.filter(College.name == 'Hartford').one()
hartford = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Hartford.id
).one()
North_Carolina = College.query.filter(
College.name == 'North Carolina').one()
north_Carolina = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == North_Carolina.id
).one()
Wisconsin = College.query.filter(College.name == 'Wisconsin').one()
wisconsin = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Wisconsin.id
).one()
Villanova = College.query.filter(College.name == 'Villanova').one()
villanova = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Villanova.id
).one()
Winthrop = College.query.filter(College.name == 'Winthrop').one()
winthrop = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Winthrop.id
).one()
Purdue = College.query.filter(College.name == 'Purdue').one()
purdue = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Purdue.id
).one()
North_Texas = College.query.filter(College.name == 'North Texas').one()
north_Texas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == North_Texas.id
).one()
Texas_Tech = College.query.filter(College.name == 'Texas Tech').one()
texas_Tech = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Texas_Tech.id
).one()
Utah_State = College.query.filter(College.name == 'Utah State').one()
utah_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Utah_State.id
).one()
Arkansas = College.query.filter(College.name == 'Arkansas').one()
arkansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Arkansas.id
).one()
Colgate = College.query.filter(College.name == 'Colgate').one()
colgate = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Colgate.id
).one()
Florida = College.query.filter(College.name == 'Florida').one()
florida = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Florida.id
).one()
Virginia_Tech = College.query.filter(College.name == 'Virginia Tech').one()
virginia_Tech = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Virginia_Tech.id
).one()
Ohio_State = College.query.filter(College.name == 'Ohio State').one()
ohio_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Ohio_State.id
).one()
Oral_Roberts = College.query.filter(College.name == 'Oral Roberts').one()
oral_Roberts = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oral_Roberts.id
).one()
# Midwest
Illinois = College.query.filter(College.name == 'Illinois').one()
illinois = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Illinois.id
).one()
Drexel = College.query.filter(College.name == 'Drexel').one()
drexel = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Drexel.id
).one()
Loyola_Chicago = College.query.filter(
College.name == 'Loyola Chicago').one()
loyola_Chicago = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Loyola_Chicago.id
).one()
Georgia_Tech = College.query.filter(College.name == 'Georgia Tech').one()
georgia_Tech = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Georgia_Tech.id
).one()
Tennessee = College.query.filter(College.name == 'Tennessee').one()
tennessee = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Tennessee.id
).one()
Oregon_State = College.query.filter(College.name == 'Oregon State').one()
oregon_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon_State.id
).one()
Oklahoma_State = College.query.filter(
College.name == 'Oklahoma State').one()
oklahoma_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oklahoma_State.id
).one()
Liberty = College.query.filter(College.name == 'Liberty').one()
liberty = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Liberty.id
).one()
San_Diego_State = College.query.filter(
College.name == 'San Diego State').one()
san_Diego_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == San_Diego_State.id
).one()
Syracuse = College.query.filter(College.name == 'Syracuse').one()
syracuse = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Syracuse.id
).one()
West_Virginia = College.query.filter(College.name == 'West Virginia').one()
west_Virginia = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == West_Virginia.id
).one()
Morehead_State = College.query.filter(
College.name == 'Morehead State').one()
morehead_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Morehead_State.id
).one()
Clemson = College.query.filter(College.name == 'Clemson').one()
clemson = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Clemson.id
).one()
Rutgers = College.query.filter(College.name == 'Rutgers').one()
rutgers = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Rutgers.id
).one()
Houston = College.query.filter(College.name == 'Houston').one()
houston = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Houston.id
).one()
Cleveland_State = College.query.filter(
College.name == 'Cleveland State').one()
cleveland_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Cleveland_State.id
).one()
# East
Michigan = College.query.filter(College.name == 'Michigan').one()
michigan = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Michigan.id
).one()
Texas_Southern = College.query.filter(
College.name == 'Texas Southern').one()
texas_Southern = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Texas_Southern.id
).one()
LSU = College.query.filter(College.name == 'LSU').one()
lSU = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == LSU.id
).one()
St_Bonaventure = College.query.filter(
College.name == 'St. Bonaventure').one()
st_Bonaventure = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == St_Bonaventure.id
).one()
Colorado = College.query.filter(College.name == 'Colorado').one()
colorado = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Colorado.id
).one()
Georgetown = College.query.filter(College.name == 'Georgetown').one()
georgetown = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Georgetown.id
).one()
Florida_State = College.query.filter(College.name == 'Florida State').one()
florida_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Florida_State.id
).one()
UNC_Greensboro = College.query.filter(
College.name == 'UNC Greensboro').one()
uNC_Greensboro = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UNC_Greensboro.id
).one()
BYU = College.query.filter(College.name == 'BYU').one()
bYU = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == BYU.id
).one()
UCLA = College.query.filter(
College.name == 'UCLA').one()
uCLA = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCLA.id
).one()
Texas = College.query.filter(College.name == 'Texas').one()
texas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Texas.id
).one()
Abilene_Christian = College.query.filter(
College.name == 'Abilene Christian').one()
abilene_Christian = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Abilene_Christian.id
).one()
UCONN = College.query.filter(College.name == 'UCONN').one()
uCONN = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCONN.id
).one()
Maryland = College.query.filter(College.name == 'Maryland').one()
maryland = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Maryland.id
).one()
Alabama = College.query.filter(College.name == 'Alabama').one()
alabama = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Alabama.id
).one()
Iona = College.query.filter(College.name == 'Iona').one()
iona = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Iona.id
).one()
game_1 = Game.query.filter(
Game.game_num == 1
).filter(
Game.tournament_id == tournament.id
).one()
game_1.winning_team_id = gonzaga.id
game_2 = Game.query.filter(
Game.game_num == 2
).filter(
Game.tournament_id == tournament.id
).one()
game_2.winning_team_id = oklahoma.id
game_3 = Game.query.filter(
Game.game_num == 3
).filter(
Game.tournament_id == tournament.id
).one()
game_3.winning_team_id = creighton.id
game_4 = Game.query.filter(
Game.game_num == 4
).filter(
Game.tournament_id == tournament.id
).one()
game_4.winning_team_id = ohio.id
game_5 = Game.query.filter(
Game.game_num == 5
).filter(
Game.tournament_id == tournament.id
).one()
game_5.winning_team_id = uSC.id
game_6 = Game.query.filter(
Game.game_num == 6
).filter(
Game.tournament_id == tournament.id
).one()
game_6.winning_team_id = kansas.id
game_7 = Game.query.filter(
Game.game_num == 7
).filter(
Game.tournament_id == tournament.id
).one()
game_7.winning_team_id = oregon.id
game_8 = Game.query.filter(
Game.game_num == 8
).filter(
Game.tournament_id == tournament.id
).one()
game_8.winning_team_id = iowa.id
game_9 = Game.query.filter(
Game.game_num == 9
).filter(
Game.tournament_id == tournament.id
).one()
game_9.winning_team_id = michigan.id
game_10 = Game.query.filter(
Game.game_num == 10
).filter(
Game.tournament_id == tournament.id
).one()
game_10.winning_team_id = lSU.id
game_11 = Game.query.filter(
Game.game_num == 11
).filter(
Game.tournament_id == tournament.id
).one()
game_11.winning_team_id = colorado.id
game_12 = Game.query.filter(
Game.game_num == 12
).filter(
Game.tournament_id == tournament.id
).one()
game_12.winning_team_id = florida_State.id
game_13 = Game.query.filter(
Game.game_num == 13
).filter(
Game.round_num == 1
).filter(
Game.tournament_id == tournament.id
).one()
game_13.winning_team_id = uCLA.id
game_14 = Game.query.filter(
Game.game_num == 14
).filter(
Game.tournament_id == tournament.id
).one()
game_14.winning_team_id = abilene_Christian.id
game_15 = Game.query.filter(
Game.game_num == 15
).filter(
Game.tournament_id == tournament.id
).one()
game_15.winning_team_id = maryland.id
game_16 = Game.query.filter(
Game.game_num == 16
).filter(
Game.tournament_id == tournament.id
).one()
game_16.winning_team_id = alabama.id
game_17 = Game.query.filter(
Game.game_num == 17
).filter(
Game.tournament_id == tournament.id
).one()
game_17.winning_team_id = baylor.id
game_18 = Game.query.filter(
Game.game_num == 18
).filter(
Game.tournament_id == tournament.id
).one()
game_18.winning_team_id = wisconsin.id
game_19 = Game.query.filter(
Game.game_num == 19
).filter(
Game.tournament_id == tournament.id
).one()
game_19.winning_team_id = villanova.id
game_20 = Game.query.filter(
Game.game_num == 20
).filter(
Game.tournament_id == tournament.id
).one()
game_20.winning_team_id = north_Texas.id
game_21 = Game.query.filter(
Game.game_num == 21
).filter(
Game.tournament_id == tournament.id
).one()
game_21.winning_team_id = texas_Tech.id
game_22 = Game.query.filter(
Game.game_num == 22
).filter(
Game.tournament_id == tournament.id
).one()
game_22.winning_team_id = arkansas.id
game_23 = Game.query.filter(
Game.game_num == 23
).filter(
Game.tournament_id == tournament.id
).one()
game_23.winning_team_id = florida.id
game_24 = Game.query.filter(
Game.game_num == 24
).filter(
Game.tournament_id == tournament.id
).one()
game_24.winning_team_id = oral_Roberts.id
game_25 = Game.query.filter(
Game.game_num == 25
).filter(
Game.tournament_id == tournament.id
).one()
game_25.winning_team_id = illinois.id
game_26 = Game.query.filter(
Game.game_num == 26
).filter(
Game.tournament_id == tournament.id
).one()
game_26.winning_team_id = loyola_Chicago.id
game_27 = Game.query.filter(
Game.game_num == 27
).filter(
Game.tournament_id == tournament.id
).one()
game_27.winning_team_id = oregon_State.id
game_28 = Game.query.filter(
Game.game_num == 28
).filter(
Game.tournament_id == tournament.id
).one()
game_28.winning_team_id = oklahoma_State.id
game_29 = Game.query.filter(
Game.game_num == 29
).filter(
Game.tournament_id == tournament.id
).one()
game_29.winning_team_id = syracuse.id
game_30 = Game.query.filter(
Game.game_num == 30
).filter(
Game.tournament_id == tournament.id
).one()
game_30.winning_team_id = west_Virginia.id
game_31 = Game.query.filter(
Game.game_num == 31
).filter(
Game.tournament_id == tournament.id
).one()
game_31.winning_team_id = rutgers.id
game_32 = Game.query.filter(
Game.game_num == 32
).filter(
Game.tournament_id == tournament.id
).one()
game_32.winning_team_id = houston.id
db.session.commit()
game_1_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_1.id).filter(
Game_Team_Score.team_id == gonzaga.id
).one()
game_1_win_score.score = 98
game_1_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_1.id).filter(
Game_Team_Score.team_id == norfolk_State.id
).one()
game_1_lose_score.score = 55
game_2_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_2.id).filter(
Game_Team_Score.team_id == oklahoma.id
).one()
game_2_win_score.score = 72
game_2_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_2.id).filter(
Game_Team_Score.team_id == missouri.id
).one()
game_2_lose_score.score = 68
game_3_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_3.id).filter(
Game_Team_Score.team_id == creighton.id
).one()
game_3_win_score.score = 63
game_3_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_3.id).filter(
Game_Team_Score.team_id == uCSB.id
).one()
game_3_lose_score.score = 63
game_4_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_4.id).filter(
Game_Team_Score.team_id == ohio.id
).one()
game_4_win_score.score = 62
game_4_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_4.id).filter(
Game_Team_Score.team_id == virginia.id
).one()
game_4_lose_score.score = 58
game_5_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_5.id).filter(
Game_Team_Score.team_id == uSC.id
).one()
game_5_win_score.score = 72
game_5_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_5.id).filter(
Game_Team_Score.team_id == drake.id
).one()
game_5_lose_score.score = 56
game_6_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_6.id).filter(
Game_Team_Score.team_id == kansas.id
).one()
game_6_win_score.score = 93
game_6_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_6.id).filter(
Game_Team_Score.team_id == eastern_Washington.id
).one()
game_6_lose_score.score = 84
game_7_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_7.id).filter(
Game_Team_Score.team_id == oregon.id
).one()
game_7_win_score.score = 1
game_7_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_7.id).filter(
Game_Team_Score.team_id == vCU.id
).one()
game_7_lose_score.score = 0
game_8_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_8.id).filter(
Game_Team_Score.team_id == iowa.id
).one()
game_8_win_score.score = 86
game_8_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_8.id).filter(
Game_Team_Score.team_id == grand_Canyon.id
).one()
game_8_lose_score.score = 74
game_9_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_9.id).filter(
Game_Team_Score.team_id == michigan.id
).one()
game_9_win_score.score = 82
game_9_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_9.id).filter(
Game_Team_Score.team_id == texas_Southern.id
).one()
game_9_lose_score.score = 66
game_10_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_10.id).filter(
Game_Team_Score.team_id == lSU.id
).one()
game_10_win_score.score = 76
game_10_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_10.id).filter(
Game_Team_Score.team_id == st_Bonaventure.id
).one()
game_10_lose_score.score = 61
game_11_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_11.id).filter(
Game_Team_Score.team_id == colorado.id
).one()
game_11_win_score.score = 96
game_11_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_11.id).filter(
Game_Team_Score.team_id == georgetown.id
).one()
game_11_lose_score.score = 73
game_12_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_12.id).filter(
Game_Team_Score.team_id == florida_State.id
).one()
game_12_win_score.score = 64
game_12_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_12.id).filter(
Game_Team_Score.team_id == uNC_Greensboro.id
).one()
game_12_lose_score.score = 54
game_13_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_13.id).filter(
Game_Team_Score.team_id == uCLA.id
).one()
game_13_win_score.score = 73
game_13_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_13.id).filter(
Game_Team_Score.team_id == bYU.id
).one()
game_13_lose_score.score = 62
game_14_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_14.id).filter(
Game_Team_Score.team_id == abilene_Christian.id
).one()
game_14_win_score.score = 53
game_14_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_14.id).filter(
Game_Team_Score.team_id == texas.id
).one()
game_14_lose_score.score = 52
game_15_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_15.id).filter(
Game_Team_Score.team_id == maryland.id
).one()
game_15_win_score.score = 63
game_15_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_15.id).filter(
Game_Team_Score.team_id == uCONN.id
).one()
game_15_lose_score.score = 54
game_16_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_16.id).filter(
Game_Team_Score.team_id == alabama.id
).one()
game_16_win_score.score = 68
game_16_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_16.id).filter(
Game_Team_Score.team_id == iona.id
).one()
game_16_lose_score.score = 55
game_17_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_17.id).filter(
Game_Team_Score.team_id == baylor.id
).one()
game_17_win_score.score = 79
game_17_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_17.id).filter(
Game_Team_Score.team_id == hartford.id
).one()
game_17_lose_score.score = 55
game_18_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_18.id).filter(
Game_Team_Score.team_id == wisconsin.id
).one()
game_18_win_score.score = 85
game_18_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_18.id).filter(
Game_Team_Score.team_id == north_Carolina.id
).one()
game_18_lose_score.score = 62
game_19_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_19.id).filter(
Game_Team_Score.team_id == villanova.id
).one()
game_19_win_score.score = 73
game_19_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_19.id).filter(
Game_Team_Score.team_id == winthrop.id
).one()
game_19_lose_score.score = 63
game_20_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_20.id).filter(
Game_Team_Score.team_id == north_Texas.id
).one()
game_20_win_score.score = 78
game_20_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_20.id).filter(
Game_Team_Score.team_id == purdue.id
).one()
game_20_lose_score.score = 69
game_21_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_21.id).filter(
Game_Team_Score.team_id == texas_Tech.id
).one()
game_21_win_score.score = 65
game_21_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_21.id).filter(
Game_Team_Score.team_id == utah_State.id
).one()
game_21_lose_score.score = 53
game_22_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_22.id).filter(
Game_Team_Score.team_id == arkansas.id
).one()
game_22_win_score.score = 85
game_22_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_22.id).filter(
Game_Team_Score.team_id == colgate.id
).one()
game_22_lose_score.score = 68
game_23_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_23.id).filter(
Game_Team_Score.team_id == florida.id
).one()
game_23_win_score.score = 75
game_23_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_23.id).filter(
Game_Team_Score.team_id == virginia_Tech.id
).one()
game_23_lose_score.score = 70
game_24_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_24.id).filter(
Game_Team_Score.team_id == oral_Roberts.id
).one()
game_24_win_score.score = 75
game_24_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_24.id).filter(
Game_Team_Score.team_id == ohio_State.id
).one()
game_24_lose_score.score = 72
game_25_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_25.id).filter(
Game_Team_Score.team_id == illinois.id
).one()
game_25_win_score.score = 78
game_25_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_25.id).filter(
Game_Team_Score.team_id == drexel.id
).one()
game_25_lose_score.score = 49
game_26_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_26.id).filter(
Game_Team_Score.team_id == loyola_Chicago.id
).one()
game_26_win_score.score = 71
game_26_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_26.id).filter(
Game_Team_Score.team_id == georgia_Tech.id
).one()
game_26_lose_score.score = 60
game_27_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_27.id).filter(
Game_Team_Score.team_id == oregon_State.id
).one()
game_27_win_score.score = 70
game_27_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_27.id).filter(
Game_Team_Score.team_id == tennessee.id
).one()
game_27_lose_score.score = 56
game_28_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_28.id).filter(
Game_Team_Score.team_id == oklahoma_State.id
).one()
game_28_win_score.score = 69
game_28_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_28.id).filter(
Game_Team_Score.team_id == liberty.id
).one()
game_28_lose_score.score = 60
game_29_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_29.id).filter(
Game_Team_Score.team_id == syracuse.id
).one()
game_29_win_score.score = 78
game_29_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_29.id).filter(
Game_Team_Score.team_id == san_Diego_State.id
).one()
game_29_lose_score.score = 62
game_30_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_30.id).filter(
Game_Team_Score.team_id == west_Virginia.id
).one()
game_30_win_score.score = 84
game_30_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_30.id).filter(
Game_Team_Score.team_id == morehead_State.id
).one()
game_30_lose_score.score = 67
game_31_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_31.id).filter(
Game_Team_Score.team_id == rutgers.id
).one()
game_31_win_score.score = 60
game_31_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_31.id).filter(
Game_Team_Score.team_id == clemson.id
).one()
game_31_lose_score.score = 56
game_32_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_32.id).filter(
Game_Team_Score.team_id == houston.id
).one()
game_32_win_score.score = 87
game_32_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_32.id).filter(
Game_Team_Score.team_id == cleveland_State.id
).one()
game_32_lose_score.score = 56
db.session.commit()
game_33 = Game(game_num=33, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_33)
game_34 = Game(game_num=34, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_34)
game_35 = Game(game_num=35, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_35)
game_36 = Game(game_num=36, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_36)
game_37 = Game(game_num=37, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_37)
game_38 = Game(game_num=38, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_38)
game_39 = Game(game_num=39, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_39)
game_40 = Game(game_num=40, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_40)
game_41 = Game(game_num=41, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_41)
game_42 = Game(game_num=42, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_42)
game_43 = Game(game_num=43, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_43)
game_44 = Game(game_num=44, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_44)
game_45 = Game(game_num=45, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_45)
game_46 = Game(game_num=46, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_46)
game_47 = Game(game_num=47, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_47)
game_48 = Game(game_num=48, round_num=2,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_48)
db.session.commit()
game_1.child_game_id = game_33.id
game_2.child_game_id = game_33.id
game_3.child_game_id = game_34.id
game_4.child_game_id = game_34.id
game_5.child_game_id = game_35.id
game_6.child_game_id = game_35.id
game_7.child_game_id = game_36.id
game_8.child_game_id = game_36.id
game_9.child_game_id = game_37.id
game_10.child_game_id = game_37.id
game_11.child_game_id = game_38.id
game_12.child_game_id = game_38.id
game_13.child_game_id = game_39.id
game_14.child_game_id = game_39.id
game_15.child_game_id = game_40.id
game_16.child_game_id = game_40.id
game_17.child_game_id = game_41.id
game_18.child_game_id = game_41.id
game_19.child_game_id = game_42.id
game_20.child_game_id = game_42.id
game_21.child_game_id = game_43.id
game_22.child_game_id = game_43.id
game_23.child_game_id = game_44.id
game_24.child_game_id = game_44.id
game_25.child_game_id = game_45.id
game_26.child_game_id = game_45.id
game_27.child_game_id = game_46.id
game_28.child_game_id = game_46.id
game_29.child_game_id = game_47.id
game_30.child_game_id = game_47.id
game_31.child_game_id = game_48.id
game_32.child_game_id = game_48.id
db.session.commit()
game_33_win_score = Game_Team_Score(
game_id=game_33.id, team_id=gonzaga.id, score=None)
game_33_lose_score = Game_Team_Score(
game_id=game_33.id, team_id=oklahoma.id, score=None)
game_33.game_team_scores = [game_33_win_score, game_33_lose_score]
game_34_win_score = Game_Team_Score(
game_id=game_34.id, team_id=creighton.id, score=None)
game_34_lose_score = Game_Team_Score(
game_id=game_34.id, team_id=ohio.id, score=None)
game_34.game_team_scores = [game_34_win_score, game_34_lose_score]
game_35_win_score = Game_Team_Score(
game_id=game_35.id, team_id=uSC.id, score=None)
game_35_lose_score = Game_Team_Score(
game_id=game_35.id, team_id=kansas.id, score=None)
game_35.game_team_scores = [game_35_win_score, game_35_lose_score]
game_36_win_score = Game_Team_Score(
game_id=game_36.id, team_id=oregon.id, score=None)
game_36_lose_score = Game_Team_Score(
game_id=game_36.id, team_id=iowa.id, score=None)
game_36.game_team_scores = [game_36_win_score, game_36_lose_score]
game_37_win_score = Game_Team_Score(
game_id=game_37.id, team_id=michigan.id, score=None)
game_37_lose_score = Game_Team_Score(
game_id=game_37.id, team_id=lSU.id, score=None)
game_37.game_team_scores = [game_37_win_score, game_37_lose_score]
game_38_win_score = Game_Team_Score(
game_id=game_38.id, team_id=colorado.id, score=None)
game_38_lose_score = Game_Team_Score(
game_id=game_38.id, team_id=florida_State.id, score=None)
game_38.game_team_scores = [game_38_win_score, game_38_lose_score]
game_39_win_score = Game_Team_Score(
game_id=game_39.id, team_id=uCLA.id, score=None)
game_39_lose_score = Game_Team_Score(
game_id=game_39.id, team_id=abilene_Christian.id, score=None)
game_39.game_team_scores = [game_39_win_score, game_39_lose_score]
game_40_win_score = Game_Team_Score(
game_id=game_40.id, team_id=maryland.id, score=None)
game_40_lose_score = Game_Team_Score(
game_id=game_40.id, team_id=alabama.id, score=None)
game_40.game_team_scores = [game_40_win_score, game_40_lose_score]
game_41_win_score = Game_Team_Score(
game_id=game_41.id, team_id=baylor.id, score=None)
game_41_lose_score = Game_Team_Score(
game_id=game_41.id, team_id=wisconsin.id, score=None)
game_41.game_team_scores = [game_41_win_score, game_41_lose_score]
game_42_win_score = Game_Team_Score(
game_id=game_42.id, team_id=villanova.id, score=None)
game_42_lose_score = Game_Team_Score(
game_id=game_42.id, team_id=north_Texas.id, score=None)
game_42.game_team_scores = [game_42_win_score, game_42_lose_score]
game_43_win_score = Game_Team_Score(
game_id=game_43.id, team_id=texas_Tech.id, score=None)
game_43_lose_score = Game_Team_Score(
game_id=game_43.id, team_id=arkansas.id, score=None)
game_43.game_team_scores = [game_43_win_score, game_43_lose_score]
game_44_win_score = Game_Team_Score(
game_id=game_44.id, team_id=florida.id, score=None)
game_44_lose_score = Game_Team_Score(
game_id=game_44.id, team_id=oral_Roberts.id, score=None)
game_44.game_team_scores = [game_44_win_score, game_44_lose_score]
game_45_win_score = Game_Team_Score(
game_id=game_45.id, team_id=illinois.id, score=None)
game_45_lose_score = Game_Team_Score(
game_id=game_45.id, team_id=loyola_Chicago.id, score=None)
game_45.game_team_scores = [game_45_win_score, game_45_lose_score]
game_46_win_score = Game_Team_Score(
game_id=game_46.id, team_id=oregon_State.id, score=None)
game_46_lose_score = Game_Team_Score(
game_id=game_46.id, team_id=oklahoma_State.id, score=None)
game_46.game_team_scores = [game_46_win_score, game_46_lose_score]
game_47_win_score = Game_Team_Score(
game_id=game_47.id, team_id=syracuse.id, score=None)
game_47_lose_score = Game_Team_Score(
game_id=game_47.id, team_id=west_Virginia.id, score=None)
game_47.game_team_scores = [game_47_win_score, game_47_lose_score]
game_48_win_score = Game_Team_Score(
game_id=game_48.id, team_id=rutgers.id, score=None)
game_48_lose_score = Game_Team_Score(
game_id=game_48.id, team_id=houston.id, score=None)
game_48.game_team_scores = [game_48_win_score, game_48_lose_score]
db.session.commit()
print('done')
def seed_2021_tournament_round2():
tournament = Tournament.query.filter(Tournament.year == 2021).one()
tournament.last_round_completed = 2
# West
Gonzaga = College.query.filter(College.name == 'Gonzaga').one()
gonzaga = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Gonzaga.id).one()
Oklahoma = College.query.filter(College.name == 'Oklahoma').one()
oklahoma = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oklahoma.id).one()
Creighton = College.query.filter(College.name == 'Creighton').one()
creighton = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Creighton.id).one()
Ohio = College.query.filter(College.name == 'Ohio').one()
ohio = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Ohio.id).one()
USC = College.query.filter(College.name == 'USC').one()
uSC = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == USC.id).one()
Kansas = College.query.filter(College.name == 'Kansas').one()
kansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Kansas.id).one()
Oregon = College.query.filter(College.name == 'Oregon').one()
oregon = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon.id).one()
Iowa = College.query.filter(College.name == 'Iowa').one()
iowa = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Iowa.id).one()
# South
Baylor = College.query.filter(College.name == 'Baylor').one()
baylor = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Baylor.id).one()
Wisconsin = College.query.filter(College.name == 'Wisconsin').one()
wisconsin = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Wisconsin.id).one()
Villanova = College.query.filter(College.name == 'Villanova').one()
villanova = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Villanova.id).one()
North_Texas = College.query.filter(College.name == 'North Texas').one()
north_Texas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == North_Texas.id).one()
Texas_Tech = College.query.filter(College.name == 'Texas Tech').one()
texas_Tech = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Texas_Tech.id).one()
Arkansas = College.query.filter(College.name == 'Arkansas').one()
arkansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Arkansas.id).one()
Florida = College.query.filter(College.name == 'Florida').one()
florida = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Florida.id).one()
Oral_Roberts = College.query.filter(College.name == 'Oral Roberts').one()
oral_Roberts = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oral_Roberts.id).one()
# Midwest
Illinois = College.query.filter(College.name == 'Illinois').one()
illinois = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Illinois.id).one()
Loyola_Chicago = College.query.filter(
College.name == 'Loyola Chicago').one()
loyola_Chicago = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Loyola_Chicago.id).one()
Oregon_State = College.query.filter(College.name == 'Oregon State').one()
oregon_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon_State.id).one()
Oklahoma_State = College.query.filter(
College.name == 'Oklahoma State').one()
oklahoma_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oklahoma_State.id).one()
Syracuse = College.query.filter(College.name == 'Syracuse').one()
syracuse = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Syracuse.id).one()
West_Virginia = College.query.filter(College.name == 'West Virginia').one()
west_Virginia = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == West_Virginia.id).one()
Rutgers = College.query.filter(College.name == 'Rutgers').one()
rutgers = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Rutgers.id).one()
Houston = College.query.filter(College.name == 'Houston').one()
houston = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Houston.id).one()
# East
Michigan = College.query.filter(College.name == 'Michigan').one()
michigan = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Michigan.id).one()
LSU = College.query.filter(College.name == 'LSU').one()
lSU = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == LSU.id).one()
Colorado = College.query.filter(College.name == 'Colorado').one()
colorado = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Colorado.id).one()
Florida_State = College.query.filter(College.name == 'Florida State').one()
florida_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Florida_State.id).one()
UCLA = College.query.filter(College.name == 'UCLA').one()
uCLA = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCLA.id).one()
Abilene_Christian = College.query.filter(
College.name == 'Abilene Christian').one()
abilene_Christian = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Abilene_Christian.id).one()
Maryland = College.query.filter(College.name == 'Maryland').one()
maryland = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Maryland.id).one()
Alabama = College.query.filter(College.name == 'Alabama').one()
alabama = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Alabama.id).one()
game_33 = Game.query.filter(Game.game_num == 33).filter(
Game.tournament_id == tournament.id).one()
game_33.winning_team_id = gonzaga.id
game_34 = Game.query.filter(Game.game_num == 34).filter(
Game.tournament_id == tournament.id).one()
game_34.winning_team_id = creighton.id
game_35 = Game.query.filter(Game.game_num == 35).filter(
Game.tournament_id == tournament.id).one()
game_35.winning_team_id = uSC.id
game_36 = Game.query.filter(Game.game_num == 36).filter(
Game.tournament_id == tournament.id).one()
game_36.winning_team_id = oregon.id
game_37 = Game.query.filter(Game.game_num == 37).filter(
Game.tournament_id == tournament.id).one()
game_37.winning_team_id = michigan.id
game_38 = Game.query.filter(Game.game_num == 38).filter(
Game.tournament_id == tournament.id).one()
game_38.winning_team_id = florida_State.id
game_39 = Game.query.filter(Game.game_num == 39).filter(
Game.tournament_id == tournament.id).one()
game_39.winning_team_id = uCLA.id
game_40 = Game.query.filter(Game.game_num == 40).filter(
Game.tournament_id == tournament.id).one()
game_40.winning_team_id = alabama.id
game_41 = Game.query.filter(Game.game_num == 41).filter(
Game.tournament_id == tournament.id).one()
game_41.winning_team_id = baylor.id
game_42 = Game.query.filter(Game.game_num == 42).filter(
Game.tournament_id == tournament.id).one()
game_42.winning_team_id = villanova.id
game_43 = Game.query.filter(Game.game_num == 43).filter(
Game.tournament_id == tournament.id).one()
game_43.winning_team_id = arkansas.id
game_44 = Game.query.filter(Game.game_num == 44).filter(
Game.tournament_id == tournament.id).one()
game_44.winning_team_id = oral_Roberts.id
game_45 = Game.query.filter(Game.game_num == 45).filter(
Game.tournament_id == tournament.id).one()
game_45.winning_team_id = loyola_Chicago.id
game_46 = Game.query.filter(Game.game_num == 46).filter(
Game.tournament_id == tournament.id).one()
game_46.winning_team_id = oregon_State.id
game_47 = Game.query.filter(Game.game_num == 47).filter(
Game.tournament_id == tournament.id).one()
game_47.winning_team_id = syracuse.id
game_48 = Game.query.filter(Game.game_num == 48).filter(
Game.tournament_id == tournament.id).one()
game_48.winning_team_id = houston.id
db.session.commit()
game_33_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_33.id).filter(
Game_Team_Score.team_id == gonzaga.id).one()
game_33_win_score.score = 87
game_33_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_33.id).filter(
Game_Team_Score.team_id == oklahoma.id).one()
game_33_lose_score.score = 71
game_34_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_34.id).filter(
Game_Team_Score.team_id == creighton.id).one()
game_34_win_score.score = 72
game_34_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_34.id).filter(
Game_Team_Score.team_id == ohio.id).one()
game_34_lose_score.score = 58
game_35_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_35.id).filter(
Game_Team_Score.team_id == uSC.id).one()
game_35_win_score.score = 85
game_35_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_35.id).filter(
Game_Team_Score.team_id == kansas.id).one()
game_35_lose_score.score = 51
game_36_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_36.id).filter(
Game_Team_Score.team_id == oregon.id).one()
game_36_win_score.score = 95
game_36_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_36.id).filter(
Game_Team_Score.team_id == iowa.id).one()
game_36_lose_score.score = 80
game_37_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_37.id).filter(
Game_Team_Score.team_id == michigan.id).one()
game_37_win_score.score = 86
game_37_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_37.id).filter(
Game_Team_Score.team_id == lSU.id).one()
game_37_lose_score.score = 78
game_38_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_38.id).filter(
Game_Team_Score.team_id == florida_State.id).one()
game_38_win_score.score = 71
game_38_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_38.id).filter(
Game_Team_Score.team_id == colorado.id).one()
game_38_lose_score.score = 53
game_39_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_39.id).filter(
Game_Team_Score.team_id == uCLA.id).one()
game_39_win_score.score = 67
game_39_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_39.id).filter(
Game_Team_Score.team_id == abilene_Christian.id).one()
game_39_lose_score.score = 47
game_40_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_40.id).filter(
Game_Team_Score.team_id == alabama.id).one()
game_40_win_score.score = 96
game_40_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_40.id).filter(
Game_Team_Score.team_id == maryland.id).one()
game_40_lose_score.score = 77
game_41_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_41.id).filter(
Game_Team_Score.team_id == baylor.id).one()
game_41_win_score.score = 76
game_41_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_41.id).filter(
Game_Team_Score.team_id == wisconsin.id).one()
game_41_lose_score.score = 63
game_42_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_42.id).filter(
Game_Team_Score.team_id == villanova.id).one()
game_42_win_score.score = 84
game_42_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_42.id).filter(
Game_Team_Score.team_id == north_Texas.id).one()
game_42_lose_score.score = 61
game_43_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_43.id).filter(
Game_Team_Score.team_id == arkansas.id).one()
game_43_win_score.score = 68
game_43_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_43.id).filter(
Game_Team_Score.team_id == texas_Tech.id).one()
game_43_lose_score.score = 66
game_44_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_44.id).filter(
Game_Team_Score.team_id == oral_Roberts.id).one()
game_44_win_score.score = 81
game_44_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_44.id).filter(
Game_Team_Score.team_id == florida.id).one()
game_44_lose_score.score = 78
game_45_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_45.id).filter(
Game_Team_Score.team_id == loyola_Chicago.id).one()
game_45_win_score.score = 71
game_45_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_45.id).filter(
Game_Team_Score.team_id == illinois.id).one()
game_45_lose_score.score = 58
game_46_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_46.id).filter(
Game_Team_Score.team_id == oregon_State.id).one()
game_46_win_score.score = 80
game_46_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_46.id).filter(
Game_Team_Score.team_id == oklahoma_State.id).one()
game_46_lose_score.score = 70
game_47_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_47.id).filter(
Game_Team_Score.team_id == syracuse.id).one()
game_47_win_score.score = 75
game_47_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_47.id).filter(
Game_Team_Score.team_id == west_Virginia.id).one()
game_47_lose_score.score = 72
game_48_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_48.id).filter(
Game_Team_Score.team_id == houston.id).one()
game_48_win_score.score = 63
game_48_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_48.id).filter(
Game_Team_Score.team_id == rutgers.id).one()
game_48_lose_score.score = 60
db.session.commit()
game_49 = Game(game_num=49,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_49)
game_50 = Game(game_num=50,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_50)
game_51 = Game(game_num=51,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_51)
game_52 = Game(game_num=52,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_52)
game_53 = Game(game_num=53,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_53)
game_54 = Game(game_num=54,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_54)
game_55 = Game(game_num=55,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_55)
game_56 = Game(game_num=56,
round_num=3,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_56)
db.session.commit()
game_33.child_game_id = game_49.id
game_34.child_game_id = game_49.id
game_35.child_game_id = game_50.id
game_36.child_game_id = game_50.id
game_37.child_game_id = game_51.id
game_38.child_game_id = game_51.id
game_39.child_game_id = game_52.id
game_40.child_game_id = game_52.id
game_41.child_game_id = game_53.id
game_42.child_game_id = game_53.id
game_43.child_game_id = game_54.id
game_44.child_game_id = game_54.id
game_45.child_game_id = game_55.id
game_46.child_game_id = game_55.id
game_47.child_game_id = game_56.id
game_48.child_game_id = game_56.id
db.session.commit()
game_49_win_score = Game_Team_Score(game_id=game_49.id,
team_id=gonzaga.id,
score=None)
game_49_lose_score = Game_Team_Score(game_id=game_49.id,
team_id=creighton.id,
score=None)
game_49.game_team_scores = [game_49_win_score, game_49_lose_score]
game_50_win_score = Game_Team_Score(game_id=game_50.id,
team_id=uSC.id,
score=None)
game_50_lose_score = Game_Team_Score(game_id=game_50.id,
team_id=oregon.id,
score=None)
game_50.game_team_scores = [game_50_win_score, game_50_lose_score]
game_51_win_score = Game_Team_Score(game_id=game_51.id,
team_id=michigan.id,
score=None)
game_51_lose_score = Game_Team_Score(game_id=game_51.id,
team_id=florida_State.id,
score=None)
game_51.game_team_scores = [game_51_win_score, game_51_lose_score]
game_52_win_score = Game_Team_Score(game_id=game_52.id,
team_id=uCLA.id,
score=None)
game_52_lose_score = Game_Team_Score(game_id=game_52.id,
team_id=alabama.id,
score=None)
game_52.game_team_scores = [game_52_win_score, game_52_lose_score]
game_53_win_score = Game_Team_Score(game_id=game_53.id,
team_id=baylor.id,
score=None)
game_53_lose_score = Game_Team_Score(game_id=game_53.id,
team_id=villanova.id,
score=None)
game_53.game_team_scores = [game_53_win_score, game_53_lose_score]
game_54_win_score = Game_Team_Score(game_id=game_54.id,
team_id=arkansas.id,
score=None)
game_54_lose_score = Game_Team_Score(game_id=game_54.id,
team_id=oral_Roberts.id,
score=None)
game_54.game_team_scores = [game_54_win_score, game_54_lose_score]
game_55_win_score = Game_Team_Score(game_id=game_55.id,
team_id=loyola_Chicago.id,
score=None)
game_55_lose_score = Game_Team_Score(game_id=game_55.id,
team_id=oregon_State.id,
score=None)
game_55.game_team_scores = [game_55_win_score, game_55_lose_score]
game_56_win_score = Game_Team_Score(game_id=game_56.id,
team_id=syracuse.id,
score=None)
game_56_lose_score = Game_Team_Score(game_id=game_56.id,
team_id=houston.id,
score=None)
game_56.game_team_scores = [game_56_win_score, game_56_lose_score]
db.session.commit()
print('done')
def seed_2021_tournament_round4():
tournament = Tournament.query.filter(Tournament.year == 2021).one()
tournament.last_round_completed = 4
# West
Gonzaga = College.query.filter(College.name == 'Gonzaga').one()
gonzaga = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Gonzaga.id
).one()
USC = College.query.filter(College.name == 'USC').one()
uSC = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == USC.id
).one()
# South
Baylor = College.query.filter(College.name == 'Baylor').one()
baylor = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Baylor.id
).one()
Arkansas = College.query.filter(College.name == 'Arkansas').one()
arkansas = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Arkansas.id
).one()
# Midwest
Oregon_State = College.query.filter(College.name == 'Oregon State').one()
oregon_State = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Oregon_State.id
).one()
Houston = College.query.filter(College.name == 'Houston').one()
houston = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Houston.id
).one()
# East
Michigan = College.query.filter(College.name == 'Michigan').one()
michigan = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == Michigan.id
).one()
UCLA = College.query.filter(
College.name == 'UCLA').one()
uCLA = March_Madness_Team.query.filter(
March_Madness_Team.tournament_id == tournament.id).filter(
March_Madness_Team.college_id == UCLA.id
).one()
game_57 = Game.query.filter(
Game.game_num == 57
).filter(
Game.tournament_id == tournament.id
).one()
game_57.winning_team_id = gonzaga.id
game_58 = Game.query.filter(
Game.game_num == 58
).filter(
Game.tournament_id == tournament.id
).one()
game_58.winning_team_id = uCLA.id
game_59 = Game.query.filter(
Game.game_num == 59
).filter(
Game.tournament_id == tournament.id
).one()
game_59.winning_team_id = baylor.id
game_60 = Game.query.filter(
Game.game_num == 60
).filter(
Game.tournament_id == tournament.id
).one()
game_60.winning_team_id = houston.id
db.session.commit()
game_57_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_57.id).filter(
Game_Team_Score.team_id == gonzaga.id
).one()
game_57_win_score.score = 85
game_57_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_57.id).filter(
Game_Team_Score.team_id == uSC.id
).one()
game_57_lose_score.score = 66
game_58_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_58.id).filter(
Game_Team_Score.team_id == uCLA.id
).one()
game_58_win_score.score = 51
game_58_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_58.id).filter(
Game_Team_Score.team_id == michigan.id
).one()
game_58_lose_score.score = 49
game_59_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_59.id).filter(
Game_Team_Score.team_id == baylor.id
).one()
game_59_win_score.score = 81
game_59_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_59.id).filter(
Game_Team_Score.team_id == arkansas.id
).one()
game_59_lose_score.score = 72
game_60_win_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_60.id).filter(
Game_Team_Score.team_id == houston.id
).one()
game_60_win_score.score = 67
game_60_lose_score = Game_Team_Score.query.filter(
Game_Team_Score.game_id == game_60.id).filter(
Game_Team_Score.team_id == oregon_State.id
).one()
game_60_lose_score.score = 61
db.session.commit()
game_61 = Game(game_num=61, round_num=5,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_61)
game_62 = Game(game_num=62, round_num=5,
winning_team_id=None, tournament_id=tournament.id)
db.session.add(game_62)
db.session.commit()
game_57.child_game_id = game_61.id
game_58.child_game_id = game_61.id
game_59.child_game_id = game_62.id
game_60.child_game_id = game_62.id
db.session.commit()
game_61_win_score = Game_Team_Score(
game_id=game_61.id, team_id=gonzaga.id, score=None)
game_61_lose_score = Game_Team_Score(
game_id=game_61.id, team_id=uCLA.id, score=None)
game_61.game_team_scores = [game_61_win_score, game_61_lose_score]
game_62_win_score = Game_Team_Score(
game_id=game_62.id, team_id=baylor.id, score=None)
game_62_lose_score = Game_Team_Score(
game_id=game_62.id, team_id=houston.id, score=None)
game_62.game_team_scores = [game_62_win_score, game_62_lose_score]
db.session.commit()
print('done')
def seed_2021_tournament():
tournament = Tournament(year=2021,
region1='West',
region2='East',
region3='South',
region4='Midwest',
last_round_completed=0)
db.session.add(tournament)
db.session.commit()
# West
Gonzaga = College.query.filter(College.name == 'Gonzaga').one()
gonzaga = March_Madness_Team(tournament_id=tournament.id,
seed_number=1,
region='West',
college_id=Gonzaga.id)
db.session.add(gonzaga)
Norfolk_State = College.query.filter(College.name == 'Norfolk St.').one()
norfolk_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=16,
region='West',
college_id=Norfolk_State.id)
db.session.add(norfolk_State)
Oklahoma = College.query.filter(College.name == 'Oklahoma').one()
oklahoma = March_Madness_Team(tournament_id=tournament.id,
seed_number=8,
region='West',
college_id=Oklahoma.id)
db.session.add(oklahoma)
Missouri = College.query.filter(College.name == 'Missouri').one()
missouri = March_Madness_Team(tournament_id=tournament.id,
seed_number=9,
region='West',
college_id=Missouri.id)
db.session.add(missouri)
Creighton = College.query.filter(College.name == 'Creighton').one()
creighton = March_Madness_Team(tournament_id=tournament.id,
seed_number=5,
region='West',
college_id=Creighton.id)
db.session.add(creighton)
UCSB = College.query.filter(College.name == 'UCSB').one()
uCSB = March_Madness_Team(tournament_id=tournament.id,
seed_number=12,
region='West',
college_id=UCSB.id)
db.session.add(uCSB)
Virginia = College.query.filter(College.name == 'Virginia').one()
virginia = March_Madness_Team(tournament_id=tournament.id,
seed_number=4,
region='West',
college_id=Virginia.id)
db.session.add(virginia)
Ohio = College.query.filter(College.name == 'Ohio').one()
ohio = March_Madness_Team(tournament_id=tournament.id,
seed_number=13,
region='West',
college_id=Ohio.id)
db.session.add(ohio)
USC = College.query.filter(College.name == 'USC').one()
uSC = March_Madness_Team(tournament_id=tournament.id,
seed_number=6,
region='West',
college_id=USC.id)
db.session.add(uSC)
Drake = College.query.filter(College.name == 'Drake').one()
drake = March_Madness_Team(tournament_id=tournament.id,
seed_number=11,
region='West',
college_id=Drake.id)
db.session.add(drake)
Kansas = College.query.filter(College.name == 'Kansas').one()
kansas = March_Madness_Team(tournament_id=tournament.id,
seed_number=3,
region='West',
college_id=Kansas.id)
db.session.add(kansas)
Eastern_Washington = College.query.filter(
College.name == 'Eastern Washington').one()
eastern_Washington = March_Madness_Team(tournament_id=tournament.id,
seed_number=14,
region='West',
college_id=Eastern_Washington.id)
db.session.add(eastern_Washington)
Oregon = College.query.filter(College.name == 'Oregon').one()
oregon = March_Madness_Team(tournament_id=tournament.id,
seed_number=7,
region='West',
college_id=Oregon.id)
db.session.add(oregon)
VCU = College.query.filter(College.name == 'VCU').one()
vCU = March_Madness_Team(tournament_id=tournament.id,
seed_number=10,
region='West',
college_id=VCU.id)
db.session.add(vCU)
Iowa = College.query.filter(College.name == 'Iowa').one()
iowa = March_Madness_Team(tournament_id=tournament.id,
seed_number=2,
region='West',
college_id=Iowa.id)
db.session.add(iowa)
Grand_Canyon = College.query.filter(College.name == 'Grand Canyon').one()
grand_Canyon = March_Madness_Team(tournament_id=tournament.id,
seed_number=15,
region='West',
college_id=Grand_Canyon.id)
db.session.add(grand_Canyon)
# South
Baylor = College.query.filter(College.name == 'Baylor').one()
baylor = March_Madness_Team(tournament_id=tournament.id,
seed_number=1,
region='South',
college_id=Baylor.id)
db.session.add(baylor)
Hartford = College.query.filter(College.name == 'Hartford').one()
hartford = March_Madness_Team(tournament_id=tournament.id,
seed_number=16,
region='South',
college_id=Hartford.id)
db.session.add(hartford)
North_Carolina = College.query.filter(
College.name == 'North Carolina').one()
north_Carolina = March_Madness_Team(tournament_id=tournament.id,
seed_number=8,
region='South',
college_id=North_Carolina.id)
db.session.add(north_Carolina)
Wisconsin = College.query.filter(College.name == 'Wisconsin').one()
wisconsin = March_Madness_Team(tournament_id=tournament.id,
seed_number=9,
region='South',
college_id=Wisconsin.id)
db.session.add(wisconsin)
Villanova = College.query.filter(College.name == 'Villanova').one()
villanova = March_Madness_Team(tournament_id=tournament.id,
seed_number=5,
region='South',
college_id=Villanova.id)
db.session.add(villanova)
Winthrop = College.query.filter(College.name == 'Winthrop').one()
winthrop = March_Madness_Team(tournament_id=tournament.id,
seed_number=12,
region='South',
college_id=Winthrop.id)
db.session.add(winthrop)
Purdue = College.query.filter(College.name == 'Purdue').one()
purdue = March_Madness_Team(tournament_id=tournament.id,
seed_number=4,
region='South',
college_id=Purdue.id)
db.session.add(purdue)
North_Texas = College.query.filter(College.name == 'North Texas').one()
north_Texas = March_Madness_Team(tournament_id=tournament.id,
seed_number=13,
region='South',
college_id=North_Texas.id)
db.session.add(north_Texas)
Texas_Tech = College.query.filter(College.name == 'Texas Tech').one()
texas_Tech = March_Madness_Team(tournament_id=tournament.id,
seed_number=6,
region='South',
college_id=Texas_Tech.id)
db.session.add(texas_Tech)
Utah_State = College.query.filter(College.name == 'Utah State').one()
Utah_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=11,
region='South',
college_id=Utah_State.id)
db.session.add(Utah_State)
Arkansas = College.query.filter(College.name == 'Arkansas').one()
arkansas = March_Madness_Team(tournament_id=tournament.id,
seed_number=3,
region='South',
college_id=Arkansas.id)
db.session.add(arkansas)
Colgate = College.query.filter(College.name == 'Colgate').one()
colgate = March_Madness_Team(tournament_id=tournament.id,
seed_number=14,
region='South',
college_id=Colgate.id)
db.session.add(colgate)
Florida = College.query.filter(College.name == 'Florida').one()
florida = March_Madness_Team(tournament_id=tournament.id,
seed_number=7,
region='South',
college_id=Florida.id)
db.session.add(florida)
Virginia_Tech = College.query.filter(College.name == 'Virginia Tech').one()
virginia_Tech = March_Madness_Team(tournament_id=tournament.id,
seed_number=10,
region='South',
college_id=Virginia_Tech.id)
db.session.add(virginia_Tech)
Ohio_State = College.query.filter(College.name == 'Ohio State').one()
ohio_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=2,
region='South',
college_id=Ohio_State.id)
db.session.add(ohio_State)
Oral_Roberts = College.query.filter(College.name == 'Oral Roberts').one()
Oral_Roberts = March_Madness_Team(tournament_id=tournament.id,
seed_number=15,
region='South',
college_id=Oral_Roberts.id)
db.session.add(Oral_Roberts)
# Midwest
Illinois = College.query.filter(College.name == 'Illinois').one()
illinois = March_Madness_Team(tournament_id=tournament.id,
seed_number=1,
region='Midwest',
college_id=Illinois.id)
db.session.add(illinois)
Drexel = College.query.filter(College.name == 'Drexel').one()
drexel = March_Madness_Team(tournament_id=tournament.id,
seed_number=16,
region='Midwest',
college_id=Drexel.id)
db.session.add(drexel)
Loyola_Chicago = College.query.filter(
College.name == 'Loyola Chicago').one()
loyola_Chicago = March_Madness_Team(tournament_id=tournament.id,
seed_number=8,
region='Midwest',
college_id=Loyola_Chicago.id)
db.session.add(loyola_Chicago)
Georgia_Tech = College.query.filter(College.name == 'Georgia Tech').one()
georgia_Tech = March_Madness_Team(tournament_id=tournament.id,
seed_number=9,
region='Midwest',
college_id=Georgia_Tech.id)
db.session.add(georgia_Tech)
Tennessee = College.query.filter(College.name == 'Tennessee').one()
tennessee = March_Madness_Team(tournament_id=tournament.id,
seed_number=5,
region='Midwest',
college_id=Tennessee.id)
db.session.add(tennessee)
Oregon_State = College.query.filter(College.name == 'Oregon State').one()
oregon_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=12,
region='Midwest',
college_id=Oregon_State.id)
db.session.add(oregon_State)
Oklahoma_State = College.query.filter(
College.name == 'Oklahoma State').one()
oklahoma_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=4,
region='Midwest',
college_id=Oklahoma_State.id)
db.session.add(oklahoma_State)
Liberty = College.query.filter(College.name == 'Liberty').one()
liberty = March_Madness_Team(tournament_id=tournament.id,
seed_number=13,
region='Midwest',
college_id=Liberty.id)
db.session.add(liberty)
San_Diego_State = College.query.filter(
College.name == 'San Diego State').one()
san_Diego_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=6,
region='Midwest',
college_id=San_Diego_State.id)
db.session.add(san_Diego_State)
Syracuse = College.query.filter(College.name == 'Syracuse').one()
syracuse = March_Madness_Team(tournament_id=tournament.id,
seed_number=11,
region='Midwest',
college_id=Syracuse.id)
db.session.add(syracuse)
West_Virginia = College.query.filter(College.name == 'West Virginia').one()
west_Virginia = March_Madness_Team(tournament_id=tournament.id,
seed_number=3,
region='Midwest',
college_id=West_Virginia.id)
db.session.add(west_Virginia)
Morehead_State = College.query.filter(
College.name == 'Morehead State').one()
morehead_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=14,
region='Midwest',
college_id=Morehead_State.id)
db.session.add(morehead_State)
Clemson = College.query.filter(College.name == 'Clemson').one()
clemson = March_Madness_Team(tournament_id=tournament.id,
seed_number=7,
region='Midwest',
college_id=Clemson.id)
db.session.add(clemson)
Rutgers = College.query.filter(College.name == 'Rutgers').one()
rutgers = March_Madness_Team(tournament_id=tournament.id,
seed_number=10,
region='Midwest',
college_id=Rutgers.id)
db.session.add(rutgers)
Houston = College.query.filter(College.name == 'Houston').one()
houston = March_Madness_Team(tournament_id=tournament.id,
seed_number=2,
region='Midwest',
college_id=Houston.id)
db.session.add(houston)
Cleveland_State = College.query.filter(
College.name == 'Cleveland State').one()
Cleveland_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=15,
region='Midwest',
college_id=Cleveland_State.id)
db.session.add(Cleveland_State)
# East
Michigan = College.query.filter(College.name == 'Michigan').one()
michigan = March_Madness_Team(tournament_id=tournament.id,
seed_number=1,
region='East',
college_id=Michigan.id)
db.session.add(michigan)
Texas_Southern = College.query.filter(
College.name == 'Texas Southern').one()
texas_Southern = March_Madness_Team(tournament_id=tournament.id,
seed_number=16,
region='East',
college_id=Texas_Southern.id)
db.session.add(texas_Southern)
LSU = College.query.filter(College.name == 'LSU').one()
lSU = March_Madness_Team(tournament_id=tournament.id,
seed_number=8,
region='East',
college_id=LSU.id)
db.session.add(lSU)
St_Bonaventure = College.query.filter(
College.name == 'St. Bonaventure').one()
st_Bonaventure = March_Madness_Team(tournament_id=tournament.id,
seed_number=9,
region='East',
college_id=St_Bonaventure.id)
db.session.add(st_Bonaventure)
Colorado = College.query.filter(College.name == 'Colorado').one()
colorado = March_Madness_Team(tournament_id=tournament.id,
seed_number=5,
region='East',
college_id=Colorado.id)
db.session.add(colorado)
Georgetown = College.query.filter(College.name == 'Georgetown').one()
georgetown = March_Madness_Team(tournament_id=tournament.id,
seed_number=12,
region='East',
college_id=Georgetown.id)
db.session.add(georgetown)
Florida_State = College.query.filter(College.name == 'Florida State').one()
florida_State = March_Madness_Team(tournament_id=tournament.id,
seed_number=4,
region='East',
college_id=Florida_State.id)
db.session.add(florida_State)
UNC_Greensboro = College.query.filter(
College.name == 'UNC Greensboro').one()
uNC_Greensboro = March_Madness_Team(tournament_id=tournament.id,
seed_number=13,
region='East',
college_id=UNC_Greensboro.id)
db.session.add(uNC_Greensboro)
BYU = College.query.filter(College.name == 'BYU').one()
bYU = March_Madness_Team(tournament_id=tournament.id,
seed_number=6,
region='East',
college_id=BYU.id)
db.session.add(bYU)
UCLA = College.query.filter(College.name == 'UCLA').one()
uCLA = March_Madness_Team(tournament_id=tournament.id,
seed_number=11,
region='East',
college_id=UCLA.id)
db.session.add(uCLA)
Texas = College.query.filter(College.name == 'Texas').one()
texas = March_Madness_Team(tournament_id=tournament.id,
seed_number=3,
region='East',
college_id=Texas.id)
db.session.add(texas)
Abilene_Christian = College.query.filter(
College.name == 'Abilene Christian').one()
abilene_Christian = March_Madness_Team(tournament_id=tournament.id,
seed_number=14,
region='East',
college_id=Abilene_Christian.id)
db.session.add(abilene_Christian)
UCONN = College.query.filter(College.name == 'UCONN').one()
uCONN = March_Madness_Team(tournament_id=tournament.id,
seed_number=7,
region='East',
college_id=UCONN.id)
db.session.add(uCONN)
Maryland = College.query.filter(College.name == 'Maryland').one()
maryland = March_Madness_Team(tournament_id=tournament.id,
seed_number=10,
region='East',
college_id=Maryland.id)
db.session.add(maryland)
Alabama = College.query.filter(College.name == 'Alabama').one()
alabama = March_Madness_Team(tournament_id=tournament.id,
seed_number=2,
region='East',
college_id=Alabama.id)
db.session.add(alabama)
Iona = College.query.filter(College.name == 'Iona').one()
iona = March_Madness_Team(tournament_id=tournament.id,
seed_number=15,
region='East',
college_id=Iona.id)
db.session.add(iona)
db.session.commit()
game_1 = Game(game_num=1,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_1)
game_2 = Game(game_num=2,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_2)
game_3 = Game(game_num=3,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_3)
game_4 = Game(game_num=4,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_4)
game_5 = Game(game_num=5,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_5)
game_6 = Game(game_num=6,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_6)
game_7 = Game(game_num=7,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_7)
game_8 = Game(game_num=8,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_8)
game_9 = Game(game_num=9,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_9)
game_10 = Game(game_num=10,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_10)
game_11 = Game(game_num=11,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_11)
game_12 = Game(game_num=12,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_12)
game_13 = Game(game_num=13,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_13)
game_14 = Game(game_num=14,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_14)
game_15 = Game(game_num=15,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_15)
game_16 = Game(game_num=16,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_16)
game_17 = Game(game_num=17,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_17)
game_18 = Game(game_num=18,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_18)
game_19 = Game(game_num=19,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_19)
game_20 = Game(game_num=20,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_20)
game_21 = Game(game_num=21,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_21)
game_22 = Game(game_num=22,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_22)
game_23 = Game(game_num=23,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_23)
game_24 = Game(game_num=24,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_24)
game_25 = Game(game_num=25,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_25)
game_26 = Game(game_num=26,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_26)
game_27 = Game(game_num=27,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_27)
game_28 = Game(game_num=28,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_28)
game_29 = Game(game_num=29,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_29)
game_30 = Game(game_num=30,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_30)
game_31 = Game(game_num=31,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_31)
game_32 = Game(game_num=32,
round_num=1,
winning_team_id=None,
tournament_id=tournament.id)
db.session.add(game_32)
db.session.commit()
game_1_win_score = Game_Team_Score(game_id=game_1.id,
team_id=gonzaga.id,
score=None)
game_1_lose_score = Game_Team_Score(game_id=game_1.id,
team_id=norfolk_State.id,
score=None)
game_1.game_team_scores = [game_1_win_score, game_1_lose_score]
game_2_win_score = Game_Team_Score(game_id=game_2.id,
team_id=oklahoma.id,
score=None)
game_2_lose_score = Game_Team_Score(game_id=game_2.id,
team_id=missouri.id,
score=None)
game_2.game_team_scores = [game_2_win_score, game_2_lose_score]
game_3_win_score = Game_Team_Score(game_id=game_3.id,
team_id=creighton.id,
score=None)
game_3_lose_score = Game_Team_Score(game_id=game_3.id,
team_id=uCSB.id,
score=None)
game_3.game_team_scores = [game_3_win_score, game_3_lose_score]
game_4_win_score = Game_Team_Score(game_id=game_4.id,
team_id=virginia.id,
score=None)
game_4_lose_score = Game_Team_Score(game_id=game_4.id,
team_id=ohio.id,
score=None)
game_4.game_team_scores = [game_4_win_score, game_4_lose_score]
game_5_win_score = Game_Team_Score(game_id=game_5.id,
team_id=uSC.id,
score=None)
game_5_lose_score = Game_Team_Score(game_id=game_5.id,
team_id=drake.id,
score=None)
game_5.game_team_scores = [game_5_win_score, game_5_lose_score]
game_6_win_score = Game_Team_Score(game_id=game_6.id,
team_id=kansas.id,
score=None)
game_6_lose_score = Game_Team_Score(game_id=game_6.id,
team_id=eastern_Washington.id,
score=None)
game_6.game_team_scores = [game_6_win_score, game_6_lose_score]
game_7_win_score = Game_Team_Score(game_id=game_7.id,
team_id=oregon.id,
score=None)
game_7_lose_score = Game_Team_Score(game_id=game_7.id,
team_id=vCU.id,
score=None)
game_7.game_team_scores = [game_7_win_score, game_7_lose_score]
game_8_win_score = Game_Team_Score(game_id=game_8.id,
team_id=iowa.id,
score=None)
game_8_lose_score = Game_Team_Score(game_id=game_8.id,
team_id=grand_Canyon.id,
score=None)
game_8.game_team_scores = [game_8_win_score, game_8_lose_score]
game_9_win_score = Game_Team_Score(game_id=game_9.id,
team_id=michigan.id,
score=None)
game_9_lose_score = Game_Team_Score(game_id=game_9.id,
team_id=texas_Southern.id,
score=None)
game_9.game_team_scores = [game_9_win_score, game_9_lose_score]
game_10_win_score = Game_Team_Score(game_id=game_10.id,
team_id=lSU.id,
score=None)
game_10_lose_score = Game_Team_Score(game_id=game_10.id,
team_id=st_Bonaventure.id,
score=None)
game_10.game_team_scores = [game_10_win_score, game_10_lose_score]
game_11_win_score = Game_Team_Score(game_id=game_11.id,
team_id=colorado.id,
score=None)
game_11_lose_score = Game_Team_Score(game_id=game_11.id,
team_id=georgetown.id,
score=None)
game_11.game_team_scores = [game_11_win_score, game_11_lose_score]
game_12_win_score = Game_Team_Score(game_id=game_12.id,
team_id=florida_State.id,
score=None)
game_12_lose_score = Game_Team_Score(game_id=game_12.id,
team_id=uNC_Greensboro.id,
score=None)
game_12.game_team_scores = [game_12_win_score, game_12_lose_score]
game_13_win_score = Game_Team_Score(game_id=game_13.id,
team_id=bYU.id,
score=None)
game_13_lose_score = Game_Team_Score(game_id=game_13.id,
team_id=uCLA.id,
score=None)
game_13.game_team_scores = [game_13_win_score, game_13_lose_score]
game_14_win_score = Game_Team_Score(game_id=game_14.id,
team_id=texas.id,
score=None)
game_14_lose_score = Game_Team_Score(game_id=game_14.id,
team_id=abilene_Christian.id,
score=None)
game_14.game_team_scores = [game_14_win_score, game_14_lose_score]
game_15_win_score = Game_Team_Score(game_id=game_15.id,
team_id=uCONN.id,
score=None)
game_15_lose_score = Game_Team_Score(game_id=game_15.id,
team_id=maryland.id,
score=None)
game_15.game_team_scores = [game_15_win_score, game_15_lose_score]
game_16_win_score = Game_Team_Score(game_id=game_16.id,
team_id=alabama.id,
score=None)
game_16_lose_score = Game_Team_Score(game_id=game_16.id,
team_id=iona.id,
score=None)
game_16.game_team_scores = [game_16_win_score, game_16_lose_score]
game_17_win_score = Game_Team_Score(game_id=game_17.id,
team_id=baylor.id,
score=None)
game_17_lose_score = Game_Team_Score(game_id=game_17.id,
team_id=hartford.id,
score=None)
game_17.game_team_scores = [game_17_win_score, game_17_lose_score]
game_18_win_score = Game_Team_Score(game_id=game_18.id,
team_id=north_Carolina.id,
score=None)
game_18_lose_score = Game_Team_Score(game_id=game_18.id,
team_id=wisconsin.id,
score=None)
game_18.game_team_scores = [game_18_win_score, game_18_lose_score]
game_19_win_score = Game_Team_Score(game_id=game_19.id,
team_id=villanova.id,
score=None)
game_19_lose_score = Game_Team_Score(game_id=game_19.id,
team_id=winthrop.id,
score=None)
game_19.game_team_scores = [game_19_win_score, game_19_lose_score]
game_20_win_score = Game_Team_Score(game_id=game_20.id,
team_id=purdue.id,
score=None)
game_20_lose_score = Game_Team_Score(game_id=game_20.id,
team_id=north_Texas.id,
score=None)
game_20.game_team_scores = [game_20_win_score, game_20_lose_score]
game_21_win_score = Game_Team_Score(game_id=game_21.id,
team_id=texas_Tech.id,
score=None)
game_21_lose_score = Game_Team_Score(game_id=game_21.id,
team_id=Utah_State.id,
score=None)
game_21.game_team_scores = [game_21_win_score, game_21_lose_score]
game_22_win_score = Game_Team_Score(game_id=game_22.id,
team_id=arkansas.id,
score=None)
game_22_lose_score = Game_Team_Score(game_id=game_22.id,
team_id=colgate.id,
score=None)
game_22.game_team_scores = [game_22_win_score, game_22_lose_score]
game_23_win_score = Game_Team_Score(game_id=game_23.id,
team_id=florida.id,
score=None)
game_23_lose_score = Game_Team_Score(game_id=game_23.id,
team_id=virginia_Tech.id,
score=None)
game_23.game_team_scores = [game_23_win_score, game_23_lose_score]
game_24_win_score = Game_Team_Score(game_id=game_24.id,
team_id=ohio_State.id,
score=None)
game_24_lose_score = Game_Team_Score(game_id=game_24.id,
team_id=Oral_Roberts.id,
score=None)
game_24.game_team_scores = [game_24_win_score, game_24_lose_score]
game_25_win_score = Game_Team_Score(game_id=game_25.id,
team_id=illinois.id,
score=None)
game_25_lose_score = Game_Team_Score(game_id=game_25.id,
team_id=drexel.id,
score=None)
game_25.game_team_scores = [game_25_win_score, game_25_lose_score]
game_26_win_score = Game_Team_Score(game_id=game_26.id,
team_id=loyola_Chicago.id,
score=None)
game_26_lose_score = Game_Team_Score(game_id=game_26.id,
team_id=georgia_Tech.id,
score=None)
game_26.game_team_scores = [game_26_win_score, game_26_lose_score]
game_27_win_score = Game_Team_Score(game_id=game_27.id,
team_id=tennessee.id,
score=None)
game_27_lose_score = Game_Team_Score(game_id=game_27.id,
team_id=oregon_State.id,
score=None)
game_27.game_team_scores = [game_27_win_score, game_27_lose_score]
game_28_win_score = Game_Team_Score(game_id=game_28.id,
team_id=oklahoma_State.id,
score=None)
game_28_lose_score = Game_Team_Score(game_id=game_28.id,
team_id=liberty.id,
score=None)
game_28.game_team_scores = [game_28_win_score, game_28_lose_score]
game_29_win_score = Game_Team_Score(game_id=game_29.id,
team_id=san_Diego_State.id,
score=None)
game_29_lose_score = Game_Team_Score(game_id=game_29.id,
team_id=syracuse.id,
score=None)
game_29.game_team_scores = [game_29_win_score, game_29_lose_score]
game_30_win_score = Game_Team_Score(game_id=game_30.id,
team_id=west_Virginia.id,
score=None)
game_30_lose_score = Game_Team_Score(game_id=game_30.id,
team_id=morehead_State.id,
score=None)
game_30.game_team_scores = [game_30_win_score, game_30_lose_score]
game_31_win_score = Game_Team_Score(game_id=game_31.id,
team_id=clemson.id,
score=None)
game_31_lose_score = Game_Team_Score(game_id=game_31.id,
team_id=rutgers.id,
score=None)
game_31.game_team_scores = [game_31_win_score, game_31_lose_score]
game_32_win_score = Game_Team_Score(game_id=game_32.id,
team_id=houston.id,
score=None)
game_32_lose_score = Game_Team_Score(game_id=game_32.id,
team_id=Cleveland_State.id,
score=None)
game_32.game_team_scores = [game_32_win_score, game_32_lose_score]
db.session.commit()
