def create_game():
name = request.form["name"]
home_team = team_repo.select(request.form["home_team_id"])
away_team = team_repo.select(request.form["away_team_id"])
new_game = Game(name, home_team, away_team)
game_repo.save(new_game)
return redirect("/games")
def end_game(league_id, game_id):
game = game_repo.select(game_id)
game_repo.end_game(game)
team1 = team_repo.select(game.team_1.id)
team2 = team_repo.select(game.team_2.id)
if game.team_1_score > game.team_2_score:
team1.wins += 1
team2.losses += 1
elif game.team_1_score < game.team_2_score:
team1.losses += 1
team2.wins += 1
else:
team1.draws += 1
team2.draws += 1
team1.games_played += 1
team1.goals_for += game.team_1_score
team1.goals_against += game.team_2_score
team1.goal_difference = team1.goals_for - team1.goals_against
team1.points = 3 * team1.wins + team1.draws
team2.games_played += 1
team2.goals_for += game.team_2_score
team2.goals_against += game.team_1_score
team2.goal_difference = team2.goals_for - team2.goals_against
team2.points = 3 * team2.wins + team2.draws
team_repo.play_game(team1, team2)
return redirect(f"/edit/games/league/{league_id}")
def select(id):
sql = "SELECT * FROM games WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
home_team = team_repo.select(result['home_team_id'])
away_team = team_repo.select(result['away_team_id'])
game = Game(result["name"], home_team, away_team, result["id"])
return game
def update_game(id):
name = request.form["name"]
home_team = team_repo.select(request.form["home_team_id"])
away_team = team_repo.select(request.form["away_team_id"])
game = Game(name, home_team, away_team, id)
print("This is where I'm printing", game)
game_repo.update(game)
return redirect("/games")
def select_all():
games = []
sql = "SELECT * FROM games"
results = run_sql(sql)
for row in results:
home_team = team_repo.select(row['home_team_id'])
away_team = team_repo.select(row['away_team_id'])
game = Game(row['name'], home_team, away_team, row['id'])
games.append(game)
return games
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_repo.select(result['team_1_id'])
team_2 = team_repo.select(result['team_2_id'])
league = league_repo.select(result['league_id'])
game = Game(team_1, team_2, league, result['round_no'],
result['game_no'], result['team_1_score'],
result['team_2_score'], result['started'],
result['finished'], result['id'])
return game
def select(id):
sql = "SELECT * FROM players WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
team = team_repo.select(result["team_id"])
player = Player(result["name"], result["position"], result["rating"], team, result["id"])
return player
def show_team(id):
team = team_repo.select(id)
players = team_repo.players(team)
return render_template("teams/show.html",
title=team.name,
team=team,
players=players)
def show_team_games(id):
team = team_repo.select(id)
games = team_repo.games(team)
return render_template("teams/fixtures-results.html",
title=team.name,
team=team,
games=games)
def select_all():
games = []
sql = "SELECT * FROM games"
results = run_sql(sql)
for result in results:
team_1 = team_repo.select(result['team_1_id'])
team_2 = team_repo.select(result['team_2_id'])
league = league_repo.select(result['league_id'])
game = Game(team_1, team_2, league, result['round_no'],
result['game_no'], result['team_1_score'],
result['team_2_score'], result['started'],
result['finished'], result['id'])
games.append(game)
return games
def results(league):
games = []
sql = "SELECT * FROM games WHERE league_id = %s AND games.finished = TRUE ORDER BY games.game_no ASC"
values = [league.id]
results = run_sql(sql, values)
for result in results:
team_1 = team_repo.select(result['team_1_id'])
team_2 = team_repo.select(result['team_2_id'])
game = Game(team_1, team_2, league, result['round_no'],
result['game_no'], result['team_1_score'],
result['team_2_score'], result['started'],
result['finished'], result['id'])
games.append(game)
return games
def create_player():
name = request.form["name"]
position = request.form["position"]
rating = request.form["rating"]
team_id = request.form["team_id"]
team = team_repo.select(team_id)
new_player = Player(name, position, rating, team)
player_repo.save(new_player)
return redirect("/players")
def update_player(id):
name = request.form["name"]
position = request.form["position"]
rating = request.form["rating"]
team_id = request.form["team_id"]
team = team_repo.select(team_id)
player = Player(name, position, rating, team, id)
player_repo.update(player)
return redirect("/players")
def add_player():
team_id = request.form['team_id']
team = team_repo.select(team_id)
name = request.form['name']
age = request.form['age']
number = request.form['number']
position = request.form['position']
player = Player(team, name, age, number, position)
player_repo.save(player)
return redirect("/edit/players")
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_repo.select(result['team_id'])
player = Player(team, result['name'], result['age'], result['number'], result['position'], result['goals_scored'], result['id'])
return player
def select_all():
players = []
sql = "SELECT * FROM players ORDER BY name ASC"
results = run_sql(sql)
for result in results:
team = team_repo.select(result['team_id'])
player = Player(team, result['name'], result['age'], result['number'], result['position'], result['goals_scored'], result['id'])
players.append(player)
return players
def select_all():
players = []
sql = "SELECT * FROM players"
results = run_sql(sql)
# print(results)
for row in results:
team = team_repo.select(row["team_id"])
print(team)
player = Player(row['name'], row['position'], row['rating'], team, row['id'])
players.append(player)
# print(players)
return players
def top_scorer(league):
player = None
sql = "SELECT players.* FROM players INNER JOIN teams ON players.team_id = teams.id WHERE teams.league_id = %s ORDER BY goals_scored DESC"
values = [league.id]
results = run_sql(sql, values)
for result in results:
team = team_repo.select(result['team_id'])
player = Player(team, result['name'], result['age'], result['number'],
result['position'], result['goals_scored'],
result['id'])
break
return player
def players(league):
players = []
sql = "SELECT players.* FROM players INNER JOIN teams ON teams.id = players.team_id WHERE league_id = %s ORDER BY teams.id ASC, players.name ASC"
values = [league.id]
results = run_sql(sql, values)
for result in results:
team = team_repo.select(result['team_id'])
player = Player(team, result['name'], result['age'], result['number'],
result['position'], result['goals_scored'],
result['id'])
players.append(player)
return players
import repositories.playlist_repo as playlist_repo
from models.possible_game import PossibleGame
import repositories.possible_game_repo as possible_game_repo
from models.red import Red
import repositories.red_repo as red_repo
from models.team import Team
import repositories.team_repo as team_repo
from models.yellow import Yellow
import repositories.yellow_repo as yellow_repo
goals = goal_repo.select_all()
for goal in goals:
game = game_repo.select(goal.game.id)
player = player_repo.select(goal.player.id)
team = team_repo.select(goal.player.team.id)
if team.id == game.team_1.id:
game.team_1_score += 1
elif team.id == game.team_2.id:
game.team_2_score += 1
player.goals_scored += 1
game_repo.goal_scored(game)
player_repo.goal_scored(player)
games = game_repo.finished_games()
for game in games:
team1 = team_repo.select(game.team_1.id)
team2 = team_repo.select(game.team_2.id)
if game.team_1_score > game.team_2_score:
team1.wins += 1
def edit_teams(id):
team = team_repo.select(id)
return render_template("/teams/edit.html", team=team)
def show(id):
team = team_repo.select(id)
players = team_repo.select_players(team)
return render_template("/teams/show.html", team=team, players=players)
def change_team_name():
id = request.form['team_id']
team = team_repo.select(id)
team.name = request.form['new_name']
team_repo.update(team)
return redirect("/edit/teams/name")
