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)