def write_txt(team1, team1_id, team2, team2_id):
team1_q = session.query(Team).get(team1_id)
team2_q = session.query(Team).get(team2_id)
home_code = "100"
away_code = "200"
if team1_q.home:
home_team = team1_q
away_team = team2_q
home = team1
away = team2
else:
home_team = team2_q
away_team = team2_q
home = team2
away = team1
team1_abbr = home_team.name[:3]
team2_abbr = away_team.name[:3]
file_name = "{:s}{:s}_FSN.txt".format(team1_abbr.upper(),
team2_abbr.upper())
file = open(file_name, 'w')
file.close()
home_template1 = "1019910"
home_template2 = "1019911"
away_template1 = "2019910"
away_template2 = "2019911"
with open(file_name, 'a') as f:
for player in home:
home_line1 = "W\{:s}{:s}10\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\October ({:s} Gms)\\".format(
home_code, player.jersey_number, home_template1,
player.jersey_number, player.first_name, player.last_name,
str(player.points), str(player.rebounds), str(player.assists),
str(player.played)) + "\\"
home_line2 = "W\{:s}{:s}11\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\October ({:s} Gms)\\".format(
home_code, player.jersey_number, home_template2,
player.jersey_number, player.first_name, player.last_name,
str(player.points), str(player.rebounds), str(
player.fg_percent), str(player.played)) + "\\"
f.write(home_line1)
f.write('\n')
f.write(home_line2)
f.write('\n')
for player in away:
away_line1 = "W\{:s}{:s}10\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\October ({:s} Gms)\\".format(
away_code, player.jersey_number, away_template1,
player.jersey_number, player.first_name, player.last_name,
str(player.points), str(player.rebounds), str(player.assists),
str(player.played)) + "\\"
away_line2 = "W\{:s}{:s}11\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\{:s}\October ({:s} Gms)\\".format(
away_code, player.jersey_number, away_template2,
player.jersey_number, player.first_name, player.last_name,
str(player.points), str(player.rebounds), str(
player.fg_percent), str(player.played)) + "\\"
f.write(away_line1)
f.write('\n')
f.write(away_line2)
f.write('\n')
def get_all_players_games(p_id):
games = session.query(Player).filter_by(player_id=p_id).all()
points = []
rebounds = []
assists = []
fg_percent = []
played = 0
for game in games:
points.append(game.points)
rebounds.append(game.rebounds)
assists.append(game.assists)
fg_percent.append(game.fg_percent)
if game.points != 0 or game.points != 0 or game.assists != 0 or game.rebounds != 0 or game.fg_percent != 0:
played = played + 1
adv = model.AveragePlayer()
adv.first_name = games[0].first_name
adv.last_name = games[0].last_name
adv.jersey_number = games[0].jersey_number
adv.player_id = p_id
adv.team_id = games[0].team_id
adv.points = reduce(lambda x, y: x + y, points) / len(points)
adv.rebounds = reduce(lambda x, y: x + y, rebounds) / len(rebounds)
adv.assists = reduce(lambda x, y: x + y, assists) / len(assists)
adv.fg_percent = reduce(lambda x, y: x + y, fg_percent) / len(fg_percent)
adv.played = played
session.add(adv)
session.flush()
session.commit()
from object import session
import model
from sqlalchemy import desc
Player = model.FinalPlayer
Team = model.Team
magic_id = "583ed157-fb46-11e1-82cb-f4ce4684ea4c"
pistons_id = "583ec928-fb46-11e1-82cb-f4ce4684ea4c"
heat_id = "583ecea6-fb46-11e1-82cb-f4ce4684ea4c" # type: str
spurs_id = "583ecd4f-fb46-11e1-82cb-f4ce4684ea4c"
kings_id = "583ed0ac-fb46-11e1-82cb-f4ce4684ea4c"
raptors_id = "583ecda6-fb46-11e1-82cb-f4ce4684ea4c"
lakers_id = "583ecae2-fb46-11e1-82cb-f4ce4684ea4c"
timberwolves_id = "583eca2f-fb46-11e1-82cb-f4ce4684ea4c"
lakers_q = session.query(Player).filter_by(team_id=lakers_id).order_by(
desc(Player.jersey_number)).all()
pistons_q = session.query(Player).filter_by(team_id=pistons_id).order_by(
desc(Player.jersey_number)).all()
heat_q = session.query(Player).filter_by(team_id=heat_id).order_by(
desc(Player.jersey_number)).all()
spurs_q = session.query(Player).filter_by(team_id=spurs_id).order_by(
desc(Player.jersey_number)).all()
kings_q = session.query(Player).filter_by(team_id=kings_id).order_by(
desc(Player.jersey_number)).all()
raptors_q = session.query(Player).filter_by(team_id=raptors_id).order_by(
desc(Player.jersey_number)).all()
timberwolves_q = session.query(Player).filter_by(
team_id=timberwolves_id).order_by(desc(Player.jersey_number)).all()
magic_q = session.query(Player).filter_by(team_id=magic_id).order_by(
desc(Player.jersey_number)).all()
from object import session
import model
CurrentPlayer = model.CurrentPlayer
AdvPlayer = model.AveragePlayer
FinalPlayer = model.FinalPlayer
adv_q = session.query(AdvPlayer).all()
current_q = session.query(CurrentPlayer).all()
for player in current_q:
p_id = player.player_id
t_id = player.team_id
adv_player = session.query(AdvPlayer).filter_by(player_id=p_id).first()
if adv_player is not None:
first_name = adv_player.first_name
last_name = adv_player.last_name
jersey_number = adv_player.jersey_number
player_id = adv_player.player_id
team_id = adv_player.team_id
points = str(adv_player.points)
rebounds = str(adv_player.rebounds)
assists = str(adv_player.assists)
fg_percent = str(adv_player.fg_percent)
played = str(adv_player.played)
else:
first_name = player.first_name
last_name = player.last_name
jersey_number = player.jersey_number
player_id = player.player_id
from object import session
import model
Player = model.Player
player_q = session.query(Player).distinct(Player.player_id).group_by(
Player.player_id).all()
all_players = []
for player in player_q:
all_players.append(player.player_id)
def get_all_players_games(p_id):
games = session.query(Player).filter_by(player_id=p_id).all()
points = []
rebounds = []
assists = []
fg_percent = []
played = 0
for game in games:
points.append(game.points)
rebounds.append(game.rebounds)
assists.append(game.assists)
fg_percent.append(game.fg_percent)
if game.points != 0 or game.points != 0 or game.assists != 0 or game.rebounds != 0 or game.fg_percent != 0:
played = played + 1
adv = model.AveragePlayer()
adv.first_name = games[0].first_name
adv.last_name = games[0].last_name