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