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 show_game(id): game = game_repo.select(id) team_1_goals = game_repo.team_1_goals(game) team_2_goals = game_repo.team_2_goals(game) return render_template("games/show.html", title="SCORECARD", game=game, team_1_goals=team_1_goals, team_2_goals=team_2_goals)
def get_winner(id): game = game_repo.select(id) winner = game.winner(game.home_team, game.away_team) return render_template("/games/simulate.html", game=game, winner=winner) # @games_blueprint.route("/games/<id>/book") # def book_tickets(id): # game = game_repo.select(id) # return render_template("/games/book.html", game=game)
def select(id): green = None sql = "SELECT * FROM greens WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: player = player_repo.select(result['player_id']) game = game_repo.select(result['game_id']) green = Green(player, game, result['id']) return green
def select(id): yellow = None sql = "SELECT * FROM yellows WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: player = player_repo.select(result['player_id']) game = game_repo.select(result['game_id']) yellow = Yellow(player, game, result['id']) return yellow
def select_all(): greens = [] sql = "SELECT * FROM greens" results = run_sql(sql) for result in results: player = player_repo.select(result['player_id']) game = game_repo.select(result['game_id']) green = Green(player, game, result['id']) greens.append(green) return greens
def update_individual_game(id): game = game_repo.select(id) players = game_repo.players(game) team_1_goals = game_repo.team_1_goals(game) team_2_goals = game_repo.team_2_goals(game) return render_template("games/show.html", title="SCORECARD - EDITING", game=game, team_1_goals=team_1_goals, team_2_goals=team_2_goals, players=players, editing=True)
def select_all(): yellows = [] sql = "SELECT * FROM yellows" results = run_sql(sql) for result in results: player = player_repo.select(result['player_id']) game = game_repo.select(result['game_id']) yellow = Yellow(player, game, result['id']) yellows.append(yellow) return yellows
def select_all(): reds = [] sql = "SELECT * FROM reds" results = run_sql(sql) for result in results: player = player_repo.select(result['player_id']) game = game_repo.select(result['game_id']) red = Red(player, game, result['id']) reds.append(red) return reds
def new_goal_individual(league_id, game_id): game = game_repo.select(game_id) player_id = request.form['player_id'] player = player_repo.select(player_id) goal = Goal(player, game) goal_repo.save(goal) if player.team.id == game.team_1.id: game.team_1_score += 1 else: game.team_2_score += 1 player.goals_scored += 1 game_repo.goal_scored(game) player_repo.goal_scored(player) return redirect(f"/edit/games/{game_id}")
def show(id): game = game_repo.select(id) return render_template("/games/show.html", game=game)
def edit_game(id): teams = team_repo.select_all() game = game_repo.select(id) return render_template('/games/edit.html', game=game, teams=teams)
import repositories.player_repo as player_repo from models.playlist import Playlist 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)
def start_game(league_id, game_id): game = game_repo.select(game_id) game_repo.start_game(game) return redirect(f"/edit/games/league/{league_id}")