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:
player1 = player_repository.select(result['player1'])
player2 = player_repository.select(result['player2'])
game = Game(result['number'], player1, player2, result['id'])
return game
def add_player():
new_player1 = request.form['player1']
new_player2 = request.form['player2']
new_game = request.form['game_number']
player1 = player_repository.select(new_player1)
player2 = player_repository.select(new_player2)
# number = game_repository.select(new_game)
game = Game(new_game, player1, player2)
game_repository.save(game)
return redirect('/games')
def create_game():
game_id_name = request.form['game_number']
winner_name = request.form['winner']
loser_name = request.form['loser']
game_id = game_repository.select(game_id_name)
winner = player_repository.select(winner_name)
loser = player_repository.select(loser_name)
tournament = Tournament(game_id, winner, loser)
tournament_repository.save(tournament)
return redirect('/tournaments')
def select_all():
tournaments = []
sql = "SELECT * FROM tournaments"
results = run_sql(sql)
for row in results:
game = game_repository.select(row['game_id'])
winner = player_repository.select(row['winner'])
loser = player_repository.select(row['loser'])
tournament = Tournament(game, winner, loser, row['id'])
tournaments.append(tournament)
return tournaments
def select_all():
games = []
sql = "SELECT * FROM games"
results = run_sql(sql)
for row in results:
# this gives player 1 and 2 a value from the player file
player1 = player_repository.select(row['player1'])
player2 = player_repository.select(row['player2'])
game = Game(row['number'], player1, player2, row['id'])
games.append(game)
return games
def select_all():
predictions = []
sql = "SELECT * FROM predictions"
results = run_sql(sql)
for row in results:
player = player_repository.select(row['player_id'])
match = match_repository.select(row['match_id'])
if row['team_1_id'] == None:
home_player_team = None
else:
home_player_team = player_team_repository.select(row['team_1_id'])
if row['team_2_id'] == None:
away_player_team = None
else:
away_player_team = player_team_repository.select(row['team_2_id'])
prediction = Prediction(player, match, home_player_team,
away_player_team, row['id'])
prediction.has_prediction = row['has_prediction']
prediction.goals['home'] = row['home_goals']
prediction.goals['away'] = row['away_goals']
predictions.append(prediction)
return predictions
def join_player_league():
player_id = join_player_league.user_id
post_data = request.get_json()
if not isinstance(player_id, str):
league = league_repository.select_by_join_code(
post_data.get('join_code'))
if league is not None:
try:
active_player = player_repository.select(player_id)
player_league = PlayerLeague(league, active_player)
player_league_repository.save(player_league)
response = {
'status':
'success',
'message':
'Successfully joined the ' + league.name + ' league!'
}
return make_response(jsonify(response)), 200
except Exception as e:
response = {'status': 'fail', 'message': e}
return make_response(jsonify(response)), 200
else:
response = {
'status': 'fail',
'message': 'League could not be found.'
}
return make_response(jsonify(response)), 200
else:
response = {'status': 'fail', 'message': player_id}
return make_response(jsonify(response)), 401
def update_predictions():
player_id = update_predictions.user_id
put_data = request.get_json()
if not isinstance(player_id, str):
try:
for id, goals in put_data.items():
if goals["home"] is not None and goals["away"] is not None:
prediction = prediction_repository.select(id)
prediction.set_goals(goals["home"], goals["away"])
player_team_repository.update(prediction.home_player_team)
player_team_repository.update(prediction.away_player_team)
prediction_repository.update(prediction)
active_player = player_repository.select(player_id)
player_groups = player_repository.player_groups(active_player)
player_group_repository.update_all(player_groups)
response = {
'status': 'success',
'message': 'Your predictions have been saved successfully!'
}
return make_response(jsonify(response)), 200
except Exception as e:
response = {'status': 'fail', 'message': e}
return make_response(jsonify(response)), 200
else:
response = {'status': 'fail', 'message': player_id}
return make_response(jsonify(response)), 401
def select(id):
prediction = None
sql = "SELECT * FROM predictions WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
player = player_repository.select(result['player_id'])
match = match_repository.select(result['match_id'])
if result['team_1_id'] == None:
home_player_team = None
else:
home_player_team = player_team_repository.select(
result['team_1_id'])
if result['team_2_id'] == None:
away_player_team = None
else:
away_player_team = player_team_repository.select(
result['team_2_id'])
prediction = Prediction(player, match, home_player_team,
away_player_team, result['id'])
prediction.has_prediction = result['has_prediction']
prediction.goals['home'] = result['home_goals']
prediction.goals['away'] = result['away_goals']
return prediction
def select(id):
player_league = None
sql = "SELECT * FROM player_leagues WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
player = player_repository.select(result['player_id'])
league = league_repository.select(result['league_id'])
player_league = PlayerLeague(league, player, result['id'])
return player_league
def select_all():
player_leagues = []
sql = "SELECT * FROM player_leagues"
results = run_sql(sql)
for row in results:
player = player_repository.select(row['player_id'])
league = league_repository.select(row['league_id'])
player_league = PlayerLeague(league, player, row['id'])
player_leagues.append(player_league)
return player_leagues
def show_active_player():
player_id = show_active_player.user_id
if not isinstance(player_id, str):
try:
active_player = player_repository.select(player_id)
player = get_player_info(active_player)
return make_response(jsonify(player)), 200
except Exception as e:
response = {'status': 'fail', 'message': e}
return make_response(jsonify(response)), 200
else:
response = {'status': 'fail', 'message': player_id}
return make_response(jsonify(response)), 401
def select(id):
group = None
sql = "SELECT * FROM player_groups WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
player = player_repository.select(result['player_id'])
team_1 = player_team_repository.select(result['team_1_id'])
team_2 = player_team_repository.select(result['team_2_id'])
team_3 = player_team_repository.select(result['team_3_id'])
team_4 = player_team_repository.select(result['team_4_id'])
player_teams = [team_1, team_2, team_3, team_4]
group = PlayerGroup(player, result['name'], player_teams, result['id'])
return group
def select_all():
player_groups = []
sql = "SELECT * FROM player_groups"
results = run_sql(sql)
for row in results:
player = player_repository.select(row['player_id'])
team_1 = player_team_repository.select(row['team_1_id'])
team_2 = player_team_repository.select(row['team_2_id'])
team_3 = player_team_repository.select(row['team_3_id'])
team_4 = player_team_repository.select(row['team_4_id'])
player_teams = [team_1, team_2, team_3, team_4]
group = PlayerGroup(player, row['name'], player_teams, row['id'])
player_groups.append(group)
return player_groups
def new_player_league():
player_id = new_player_league.user_id
post_data = request.get_json()
if not isinstance(player_id, str):
try:
active_player = player_repository.select(player_id)
league = League(post_data.get('name'))
league_repository.save(league)
player_league = PlayerLeague(league, active_player)
player_league_repository.save(player_league)
response = {
'status': 'success',
'message': league.name + ' code: ' + league.join_code
}
return make_response(jsonify(response)), 201
except Exception as e:
response = {'status': 'fail', 'message': e}
return make_response(jsonify(response)), 200
else:
response = {'status': 'fail', 'message': player_id}
return make_response(jsonify(response)), 401
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 select_all():
player_teams = []
sql = "SELECT * FROM player_teams"
results = run_sql(sql)
for row in results:
player = player_repository.select(row['player_id'])
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 show_player(id):
selected_player = player_repository.select(id)
player = get_player_info(selected_player)
return make_response(jsonify(player)), 200
def show(id):
player = player_repository.select(id)
games = player_repository.games(player)
return render_template("players/show.html", player=player, games=games)
def edit_player(id):
player = player_repository.select(id)
teams = team_repository.select_all()
return render_template('clubs/players/edit.html',
player=player,
teams=teams)
def show_team(id):
player = player_repository.select(id)
teams = team_repository.select_all()
return render_template("clubs/players/show.html",
player=player,
teams=teams)