def query(): #get full players and teams db = Basketballdb() teams = db.getTeams() players = db.getPlayers() #start with full teams and players filterteams = teams filterplayers = players #filters if (request.args.get('team', False)): filterteams = filterByTeamName(filterteams, request.args.get('team', False)) if (request.args.get('player_last_name', False)): filterplayers = filterByPlayerName( players, request.args.get('player_last_name', False)) data = { 'teams': teams, 'players': players, 'filteredTeams': filterteams[:50], 'filteredPlayers': filterplayers[:50] } return render_template('main.html', data=data)
def query(): db = Basketballdb() theTeam = request.args.get('team', False) teams = db.getTeams() filterteams = filterByTeamName(teams,theTeam) thePosition = request.args.get('position', False) positions = db.getPositions() filterpositions = filterByPositionName(positions,thePosition) return json.dumps(filterteams) return json.dumps(filerpositions)
def query(): #get full players and teams db = Basketballdb() teams = db.getTeams() players = db.getPlayers() #start with full teams and players filterteams = teams filterplayers = players #filters if( request.args.get('team', False) ): filterteams = filterByTeamName(filterteams, request.args.get('team', False)) data = { 'teams' : teams, 'players' : players, 'filteredTeams' : filterteams[:50], 'filteredPlayers' : filterplayers[:50] } return render_template('main.html', data=data)
def query(): #get full players and teams db = Basketballdb() teams = db.getTeams() players = db.getPlayers() #combine players with their team for player in players: for team in teams: if player['team'] == team['team']: player['team_league'] = team['leag'] player['team_location'] = team['location'] player['team_name'] = team['name'] #start with full teams and players filterteams = teams filterplayers = players #TEAM NAME FILTER team_name = request.args.get('team', False) if( team_name ): if( team_name != 'Any' ): filterplayers = filterByTeamName(filterplayers, team_name) #PLAYER LAST NAME player_last_name = request.args.get('player_last_name', False) if( player_last_name ): filterplayers = filterByPlayerLastName(filterplayers, player_last_name) #PLAYER FIRST NAME player_first_name = request.args.get('player_first_name', False) if( player_first_name ): filterplayers = filterByPlayerFirstName(filterplayers, player_first_name) #FILTER BY YEAR player_year = request.args.get('year', False) if( player_year ): filterplayers = filterByYear(filterplayers, player_year) #Filter By Points player_points = request.args.get('points', False) if(player_points): filterplayers = filterByPoints(filterplayers, player_points) #Filter By Rebounds player_rebounds = request.args.get('rebounds', False) if(player_rebounds): filterplayers = filterByRebounds(filterplayers, player_rebounds) #Filter By Asists player_asists = request.args.get('asists', False) if(player_asists): filterplayers = filterByAsists(filterplayers, player_asists) #Filter By Steals player_steals = request.args.get('steals', False) if(player_steals): filterplayers = filterBySteals(filterplayers, player_steals) if(len(filterplayers) == 0): return 'No Players Match Your Query' data = { 'teams' : teams, 'players' : players, 'filteredPlayers' : filterplayers[:100] } return render_template('main.html', data=data)
def query(): db = Basketballdb() theTeam = request.args.get('team', False) teams = db.getTeams() filterteams = filterByTeamName(teams,theTeam) return json.dumps(filterteams)
def query(): # get full players and teams db = Basketballdb() teams = db.getTeams() players = db.getPlayers() # combine players with their team for player in players: for team in teams: if player["team"] == team["team"]: player["team_league"] = team["leag"] player["team_location"] = team["location"] player["team_name"] = team["name"] # start with full teams and players filterteams = teams filterplayers = players # TEAM NAME FILTER team_name = request.args.get("team", False) if team_name: if team_name != "Any": filterplayers = filterByTeamName(filterplayers, team_name) # PLAYER LAST NAME player_last_name = request.args.get("player_last_name", False) if player_last_name: filterplayers = filterByPlayerLastName(filterplayers, player_last_name) # PLAYER FIRST NAME player_first_name = request.args.get("player_first_name", False) if player_first_name: filterplayers = filterByPlayerFirstName(filterplayers, player_first_name) # FILTER BY YEAR player_year = request.args.get("year", False) if player_year: filterplayers = filterByYear(filterplayers, player_year) # Filter By Points player_points = request.args.get("points", False) if player_points: filterplayers = filterByPoints(filterplayers, player_points) # Filter By Rebounds player_rebounds = request.args.get("rebounds", False) if player_rebounds: filterplayers = filterByRebounds(filterplayers, player_rebounds) # Filter By Asists player_asists = request.args.get("asists", False) if player_asists: filterplayers = filterByAsists(filterplayers, player_asists) # Filter By Steals player_steals = request.args.get("steals", False) if player_steals: filterplayers = filterBySteals(filterplayers, player_steals) if len(filterplayers) == 0: return "No Players Match Your Query" data = {"teams": teams, "players": players, "filteredPlayers": filterplayers[:100]} return render_template("main.html", data=data)
def query(): #get full players and teams db = Basketballdb() teams = db.getTeams() players = db.getPlayers() #combine players with their team for player in players: for team in teams: if player['team'] == team['team']: player['team_league'] = team['leag'] player['team_location'] = team['location'] player['team_name'] = team['name'] #start with full teams and players filterteams = teams filterplayers = players #TEAM NAME FILTER team_name = request.args.get('team', False) if (team_name): if (team_name != 'Any'): filterplayers = filterByTeamName(filterplayers, team_name) #PLAYER LAST NAME player_last_name = request.args.get('player_last_name', False) if (player_last_name): filterplayers = filterByPlayerLastName(filterplayers, player_last_name) #PLAYER FIRST NAME player_first_name = request.args.get('player_first_name', False) if (player_first_name): filterplayers = filterByPlayerFirstName(filterplayers, player_first_name) #FILTER BY YEAR player_year = request.args.get('year', False) if (player_year): filterplayers = filterByYear(filterplayers, player_year) #Filter By Points player_points = request.args.get('points', False) if (player_points): filterplayers = filterByPoints(filterplayers, player_points) #Filter By Rebounds player_rebounds = request.args.get('rebounds', False) if (player_rebounds): filterplayers = filterByRebounds(filterplayers, player_rebounds) #Filter By Asists player_asists = request.args.get('asists', False) if (player_asists): filterplayers = filterByAsists(filterplayers, player_asists) #Filter By Steals player_steals = request.args.get('steals', False) if (player_steals): filterplayers = filterBySteals(filterplayers, player_steals) if (len(filterplayers) == 0): return 'No Players Match Your Query' data = { 'teams': teams, 'players': players, 'filteredPlayers': filterplayers[:100] } return render_template('main.html', data=data)