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)
def query():
db = Basketballdb()
theTeam = request.args.get('team', False)
teams = db.getTeams()
filterteams = filterByTeamName(teams,theTeam)
return json.dumps(filterteams)
