mirror of
https://github.com/nprasad2077/nbaStats.git
synced 2026-11-04 17:19:54 +00:00
241 lines
11 KiB
Python
241 lines
11 KiB
Python
from django.db import models
|
|
from django.core.validators import MaxValueValidator, MinValueValidator
|
|
|
|
# Create your models here.
|
|
class PlayerData(models.Model):
|
|
name = models.CharField(max_length=255, null=True)
|
|
age = models.IntegerField(null=True)
|
|
games = models.IntegerField(null=True)
|
|
games_started = models.IntegerField(null=True)
|
|
minutes_pg = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
field_goals = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
field_attempts = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
field_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
three_fg = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
three_attempts = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
three_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
two_fg = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
two_attempts = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
two_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
effect_fg_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
ft = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
fta = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ft_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
ORB= models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
DRB = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
TRB = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
AST = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
STL = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
BLK = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
TOV = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
PF = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
PTS = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.name
|
|
|
|
class PlayerTotalsData(models.Model):
|
|
player_name = models.CharField(max_length=255, null=True)
|
|
age = models.IntegerField(null=True)
|
|
games = models.IntegerField(null=True)
|
|
games_started = models.IntegerField(null=True)
|
|
minutes_played = models.IntegerField(null=True)
|
|
field_goals = models.IntegerField(null=True)
|
|
field_attempts = models.IntegerField(null=True)
|
|
field_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
three_fg = models.IntegerField(null=True)
|
|
three_attempts = models.IntegerField(null=True)
|
|
three_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
two_fg = models.IntegerField(null=True)
|
|
two_attempts = models.IntegerField(null=True)
|
|
two_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
effect_fg_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
ft = models.IntegerField(null=True)
|
|
fta = models.IntegerField(null=True)
|
|
ft_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
ORB= models.IntegerField(null=True)
|
|
DRB = models.IntegerField(null=True)
|
|
TRB = models.IntegerField(null=True)
|
|
AST = models.IntegerField(null=True)
|
|
STL = models.IntegerField(null=True)
|
|
BLK = models.IntegerField(null=True)
|
|
TOV = models.IntegerField(null=True)
|
|
PF = models.IntegerField(null=True)
|
|
PTS = models.IntegerField(null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
class PlayerAdvancedData(models.Model):
|
|
player_name = models.CharField(max_length=255, null=True)
|
|
age = models.IntegerField(null=True)
|
|
games = models.IntegerField(null=True)
|
|
minutes_played = models.IntegerField(null=True)
|
|
PER = models.DecimalField(max_digits=6, decimal_places=1, null=True)
|
|
TS_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
three_p_attempt_rate = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
ft_attempt_rate = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
orb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
drb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
trb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ast_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
stl_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
blk_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
tov_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
usg_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ows = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
dws = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ws = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ws_per_48 = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
obpm = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
dbpm = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
bpm = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
vorp = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
class PlayerPlayoffTotalsData(models.Model):
|
|
player_name = models.CharField(max_length=255, null=True)
|
|
age = models.IntegerField(null=True)
|
|
games = models.IntegerField(null=True)
|
|
games_started = models.IntegerField(null=True)
|
|
minutes_played = models.IntegerField(null=True)
|
|
field_goals = models.IntegerField(null=True)
|
|
field_attempts = models.IntegerField(null=True)
|
|
field_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
three_fg = models.IntegerField(null=True)
|
|
three_attempts = models.IntegerField(null=True)
|
|
three_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
two_fg = models.IntegerField(null=True)
|
|
two_attempts = models.IntegerField(null=True)
|
|
two_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
effect_fg_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
ft = models.IntegerField(null=True)
|
|
fta = models.IntegerField(null=True)
|
|
ft_percent = models.DecimalField(max_digits=6, decimal_places=3, null=True)
|
|
ORB= models.IntegerField(null=True)
|
|
DRB = models.IntegerField(null=True)
|
|
TRB = models.IntegerField(null=True)
|
|
AST = models.IntegerField(null=True)
|
|
STL = models.IntegerField(null=True)
|
|
BLK = models.IntegerField(null=True)
|
|
TOV = models.IntegerField(null=True)
|
|
PF = models.IntegerField(null=True)
|
|
PTS = models.IntegerField(null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
class PlayerPlayoffAdvancedData(models.Model):
|
|
player_name = models.CharField(max_length=255, null=True)
|
|
age = models.IntegerField(null=True)
|
|
games = models.IntegerField(null=True)
|
|
minutes_played = models.IntegerField(null=True)
|
|
PER = models.DecimalField(max_digits=6, decimal_places=1, null=True)
|
|
TS_percent = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
three_p_attempt_rate = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
ft_attempt_rate = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
orb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
drb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
trb_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ast_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
stl_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
blk_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
tov_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
usg_percent = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ows = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
dws = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ws = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
ws_per_48 = models.DecimalField(max_digits=5, decimal_places=3, null=True)
|
|
obpm = models.DecimalField(max_digits=5, decimal_places=2, null=True, validators=[MinValueValidator(-100), MaxValueValidator(100)])
|
|
dbpm = models.DecimalField(max_digits=5, decimal_places=2, null=True, validators=[MinValueValidator(-100), MaxValueValidator(100)])
|
|
bpm = models.DecimalField(max_digits=5, decimal_places=2, null=True, validators=[MinValueValidator(-100), MaxValueValidator(100)])
|
|
vorp = models.DecimalField(max_digits=5, decimal_places=2, null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def cap_extreme_values(self):
|
|
min_value = -100
|
|
max_value = 100
|
|
|
|
obpm = float(self.obpm)
|
|
if obpm < min_value:
|
|
obpm = min_value
|
|
elif obpm > max_value:
|
|
obpm = max_value
|
|
self.obpm = obpm
|
|
|
|
dbpm = float(self.dbpm)
|
|
if dbpm < min_value:
|
|
dbpm = min_value
|
|
elif dbpm > max_value:
|
|
dbpm = max_value
|
|
self.dbpm = dbpm
|
|
|
|
bpm = float(self.bpm)
|
|
if bpm < min_value:
|
|
bpm = min_value
|
|
elif bpm > max_value:
|
|
bpm = max_value
|
|
self.bpm = bpm
|
|
|
|
|
|
def save(self, *args, **kwargs):
|
|
self.cap_extreme_values()
|
|
super(PlayerPlayoffAdvancedData, self).save(*args, **kwargs)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
class PlayerSalaryData(models.Model):
|
|
player_name = models.CharField(max_length=255, null=True)
|
|
salary = models.IntegerField(null=True)
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
class PlayerShotChartData(models.Model):
|
|
player_name = models.CharField(max_length=255, default='')
|
|
top = models.IntegerField(null=True)
|
|
left = models.IntegerField(null=True)
|
|
date = models.CharField(max_length=255, default='')
|
|
qtr = models.CharField(max_length=255, default='')
|
|
time_remaining = models.CharField(max_length=12, default='')
|
|
result = models.BooleanField(null=True, default='')
|
|
shot_type = models.CharField(max_length=6, default='')
|
|
distance_ft = models.IntegerField(null=True)
|
|
lead = models.BooleanField(null=True)
|
|
lebron_team_score = models.IntegerField(null=True)
|
|
opponent_team_score = models.IntegerField(null=True)
|
|
opponent = models.CharField(max_length=30, default='')
|
|
team = models.CharField(max_length=30, default='')
|
|
season = models.IntegerField(null=True)
|
|
|
|
def __str__(self):
|
|
return self.player_name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|