def create_fixture():
team1 = request.form["team1_id"]
team2 = request.form["team2_id"]
team1 = team_repository.select(team1)
team2 = team_repository.select(team2)
new_fixture = Fixture(team1, team2)
fixture_repository.save(new_fixture)
return redirect("/fixtures")
def select(id):
sql = "SELECT * FROM fixtures WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
team1 = team_repository.select(result["team1_id"])
team2 = team_repository.select(result["team2_id"])
fixture = Fixture(team1, team2, result['team1_score'],
result['team2_score'], id)
return fixture
def select_all():
fixtures = []
sql = "SELECT * FROM fixtures"
results = run_sql(sql)
for result in results:
team1 = team_repository.select(result["team1_id"])
team2 = team_repository.select(result["team2_id"])
fixture = Fixture(team1, team2, result["id"])
fixtures.append(fixture)
return fixtures
def select_all():
games = []
sql = "SELECT * FROM games"
results = run_sql(sql)
for row in results:
team_1 = team_repository.select(row['team_1_id'])
team_2 = team_repository.select(row['team_2_id'])
game = Game(row['date'], row['venue'], team_1, team_2, row['team_1_score'], row['team_2_score'], row['id'])
games.append(game)
return games
def edit_match(id):
match = match_repository.select(id)
home_team = team_repository.select(match.home_team_id)
away_team = team_repository.select(match.away_team_id)
teams = team_repository.select_all()
return render_template('matches/edit.html',
match=match,
home_team=home_team,
away_team=away_team,
teams=teams)
def select(id):
game = None
sql = "SELECT * FROM games WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
team_1 = team_repository.select(result['team_1_id'])
team_2 = team_repository.select(result['team_2_id'])
game = Game(result['date'], result['venue'], team_1, team_2, result['team_1_score'], result['team_2_score'], result['id'])
return game
def update_game(id):
date = request.form["date"]
venue = request.form["venue"]
team_1_id = request.form["team_1_id"]
team_1 = team_repository.select(team_1_id)
team_2_id = request.form["team_2_id"]
team_2 = team_repository.select(team_2_id)
team_1_score = request.form["team_1_score"]
team_2_score = request.form["team_2_score"]
game = Game(date, venue, team_1, team_2, team_1_score, team_2_score, id)
game_repository.update(game)
return redirect("/games")
def create_game():
date = request.form["date"]
venue = request.form["venue"]
team_1_id = request.form["team_1_id"]
team_1 = team_repository.select(team_1_id)
team_2_id = request.form["team_2_id"]
team_2 = team_repository.select(team_2_id)
team_1_score = request.form["team_1_score"]
team_2_score = request.form["team_2_score"]
new_game = Game(date, venue, team_1, team_2, team_1_score, team_2_score)
game_repository.save(new_game)
return redirect('/games')
def update_fixture(id):
team1_id = request.form["team1_id"]
team2_id = request.form["team2_id"]
team1 = team_repository.select(team1_id)
team2 = team_repository.select(team2_id)
team1_score = request.form["team1_score"]
team2_score = request.form["team2_score"]
fixture = Fixture(team1, team2, team1_score, team2_score, id)
fixture_repository.update(fixture)
return redirect("/fixtures")
def select(id):
group = None
sql = "SELECT * FROM groups WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
team_1 = team_repository.select(result['team_1_id'])
team_2 = team_repository.select(result['team_2_id'])
team_3 = team_repository.select(result['team_3_id'])
team_4 = team_repository.select(result['team_4_id'])
teams = [team_1, team_2, team_3, team_4]
group = Group(result['name'], teams, result['id'])
return group
def select_all():
groups = []
sql = "SELECT * FROM groups"
results = run_sql(sql)
for row in results:
team_1 = team_repository.select(row['team_1_id'])
team_2 = team_repository.select(row['team_2_id'])
team_3 = team_repository.select(row['team_3_id'])
team_4 = team_repository.select(row['team_4_id'])
teams = [team_1, team_2, team_3, team_4]
group = Group(row['name'], teams, row['id'])
groups.append(group)
return groups
def show_team(id):
team = team_repository.select(id)
teams = team_repository.select_all()
fixtures = fixture_repository.select_all()
return render_template("clubs/show.html",
team=team,
teams=teams,
fixtures=fixtures)
def select_all():
players = []
sql = "SELECT * FROM players"
results = run_sql(sql)
for row in results:
team = team_repository.select(row['team_id'])
player = Player(row['name'], row['position'], team, row['id'])
players.append(player)
def select(id):
match = None
sql = "SELECT * FROM matches WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
if result['team_1_id'] == None:
team_1 = None
else:
team_1 = team_repository.select(result['team_1_id'])
if result['team_2_id'] == None:
team_2 = None
else:
team_2 = team_repository.select(result['team_2_id'])
match = Match(result['round_number'], result['date'], result['location'], result['group_name'], team_1, team_2, result['id'])
match.set_goals(result['home_goals'], result['away_goals'])
return match
def select(id):
player = None
sql = "SELECT * FROM players WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
team = team_repository.select(result['team_id'])
player = Player(result['name'], result['position'], team, result['id'])
return player
def select_all():
competitions = []
sql = "SELECT * FROM competitions"
results = run_sql(sql)
for row in results:
team = team_repository.select(row['team_id'])
game = game_repository.select(row['game_id'])
competition = Competition(team, game, row['id'])
competitions.append(competition)
return competitions
def show_team_fixtures(id):
sql = "SELECT * FROM fixtures WHERE team1_id = %s OR team2_id = %s"
fixtures = []
values = [id, id]
results = run_sql(sql, values)
for result in results:
# get instance of Team class for the team that matches team1_id
# get instance of team class for the team matching team2_id
# create fixture object that has team1, team2, score1 and score2
# then append to fixtures
team1 = team_repository.select(result["team1_id"])
team2 = team_repository.select(result["team2_id"])
fixture = Fixture(team1, team2, result["team1_score"],
result["team2_score"])
# import pdb; pdb.set_trace()
fixtures.append(fixture)
return fixtures
def select_all():
matches = []
sql = "SELECT * FROM matches ORDER BY date ASC"
results = run_sql(sql)
for row in results:
if row['team_1_id'] == None:
team_1 = None
else:
team_1 = team_repository.select(row['team_1_id'])
if row['team_2_id'] == None:
team_2 = None
else:
team_2 = team_repository.select(row['team_2_id'])
match = Match(row['round_number'], row['date'], row['location'], row['group_name'], team_1, team_2, row['id'])
match.set_goals(row['home_goals'], row['away_goals'])
matches.append(match)
return matches
def select_by_player_and_team(player, team):
player_team = None
sql = "SELECT * FROM player_teams WHERE player_id = %s AND team_id = %s"
values = [player.id, team.id]
result = run_sql(sql, values)[0]
if result is not None:
player = player_repository.select(result['player_id'])
team = team_repository.select(result['team_id'])
group_info = {
"played": result['matches_played'],
"won": result['won'],
"drawn": result['drawn'],
"lost": result['lost'],
"for": result['goals_for'],
"against": result['goals_against'],
"difference": result['goal_difference'],
"points": result['points'],
"rank": result['group_rank']
}
player_team = PlayerTeam(player, team, result['id'])
player_team.group_info = group_info
return player_team
def player_teams(player):
player_teams = []
sql = "SELECT * FROM player_teams WHERE player_id = %s"
values = [player.id]
results = run_sql(sql, values)
for row in results:
team = team_repository.select(row['team_id'])
group_info = {
"played": row['matches_played'],
"won": row['won'],
"drawn": row['drawn'],
"lost": row['lost'],
"for": row['goals_for'],
"against": row['goals_against'],
"difference": row['goal_difference'],
"points": row['points'],
"rank": row['group_rank']
}
player_team = PlayerTeam(player, team, row['id'])
player_team.group_info = group_info
player_teams.append(player_team)
return player_teams
def edit_team(id):
team = team_repository.select(id)
teams = team_repository.select_all()
return render_template('clubs/edit.html', team=team, teams=teams)
def edit_team(id):
team = team_repository.select(id)
# games = game_repository.select_all()
return render_template("teams/edit.html", team=team) # games = games
def show_team(id):
team = team_repository.select(id)
return make_response(jsonify(team.__dict__)), 200
def show(id):
team = team_repository.select(id)
# game = team_repository.game(team)
return render_template("teams/show.html", team=team) #, games = games
def show_fixtures(id):
team = team_repository.select(id)
fixtures = fixture_repository.show_team_fixtures(id)
# import pdb; pdb.set_trace()
return render_template('/teams/show.html', team=team, fixtures=fixtures)
def show_team(id):
# players = team_repository.players(id)
games = team_repository.games(id)
team = team_repository.select(id)
return render_template("teams/show.html",games=games, team=team)
def edit_team(id):
team = team_repository.select(id)
return render_template("teams/edit.html", team = team)
