class WyLeague(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
wyid = db.Column(db.Integer)
tier = db.Column(db.Integer)
name = db.Column(db.String(50))
country_name = db.Column(db.String(50))
def __init__(self, wyid, name, tier, country):
self.wyid = wyid
self.name = name
self.tier = tier
self.country_name = country
class SparkWyPassesSonarSeasonPlayer(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
team_wyid = db.Column(db.Integer)
player_wyid = db.Column(db.Integer)
acc_passes = db.Column(db.String)
inacc_passes = db.Column(db.String)
acc_passes_total = db.Column(db.Integer)
inacc_passes_total = db.Column(db.Integer)
def __init__(self):
pass
class JSONWyPassesMatchPlayer(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
player_wyid = db.Column(db.Integer)
player_name = db.Column(db.String)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
match_wyid = db.Column(db.Integer)
team_wyid = db.Column(db.Integer)
json = db.Column(db.String)
def __init__(self):
pass
class JSONWyShotsMatchTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
match_wyid = db.Column(db.Integer)
team_wyid = db.Column(db.Integer)
team_name = db.Column(db.String)
other_team_wyid = db.Column(db.Integer)
json = db.Column(db.String)
def __init__(self):
pass
class JSONWyPassingCentersMatchTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
match_wyid = db.Column(db.Integer)
team_wyid = db.Column(db.Integer)
passes = db.Column(db.String)
players = db.Column(db.String)
def __init__(self):
pass
class JSONWyShotsSeasonPlayer(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
team_wyid = db.Column(db.Integer)
player_wyid = db.Column(db.Integer)
player_name = db.Column(db.String)
json = db.Column(db.String)
def __init__(self):
pass
class JSONWyPassesZonesMatchTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_instatid = db.Column(db.Integer)
season = db.Column(db.String)
match_instatid = db.Column(db.Integer)
team_instatid = db.Column(db.Integer)
json = db.Column(db.String)
def __init__(self):
pass
class WyMatchPlayerStats(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
match_wyid = db.Column(db.Integer)
player_wyid = db.Column(db.Integer)
match_date = db.Column(db.String(255))
team_wyid = db.Column(db.Integer)
league_wyid = db.Column(db.Integer)
season_wyid = db.Column(db.Integer)
minutes = db.Column(db.Integer)
shirt_number = db.Column(db.Integer)
def __init__(self, match_wyid, player_wyid, match_date, team_wyid,
league_wyid, season_wyid, minutes, shirt_number):
self.match_wyid = match_wyid
self.player_wyid = player_wyid
self.match_date = match_date
self.team_wyid = team_wyid
self.league_wyid = league_wyid
self.season_wyid = season_wyid
self.minutes = minutes
self.shirt_number = shirt_number
class WyTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
wyid = db.Column(db.Integer)
league_wyid = db.Column(db.Integer)
name = db.Column(db.String(50))
city = db.Column(db.String(50))
country = db.Column(db.String(30))
def __init__(self, wyid, league_wyid, name, city, country):
self.wyid = wyid
self.league_wyid = league_wyid
self.name = name
self.city = city
self.country = country
class SparkWyModelsMatchTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
season_wyid = db.Column(db.Integer)
match_wyid = db.Column(db.Integer)
team_wyid = db.Column(db.Integer)
defensive_actions_low = db.Column(db.Float)
defensive_actions_mid = db.Column(db.Float)
defensive_actions_high = db.Column(db.Float)
op_shots = db.Column(db.Float)
op_xG = db.Column(db.Float)
season = db.Column(db.String)
team_name = db.Column(db.String)
ppda = db.Column(db.Float)
other_teams_seconds_in_possession = db.Column(db.Float)
build_up_seconds = db.Column(db.Float)
xG_after_corner = db.Column(db.Float)
xG_after_free_kick = db.Column(db.Float)
xG_after_throw_in = db.Column(db.Float)
maintenance = db.Column(db.Float)
sustained_threat = db.Column(db.Float)
counter_attacks = db.Column(db.Float)
fast_tempo = db.Column(db.Float)
minutes = db.Column(db.Float)
match_count = db.Column(db.Float)
op_xG_per_shot = db.Column(db.Float)
avg_def_line = db.Column(db.Float)
wp_opp_half_count = db.Column(db.Float)
wp_own_half_count = db.Column(db.Float)
opp_half_left_wp_percentage = db.Column(db.Float)
opp_half_mid_wp_percentage = db.Column(db.Float)
opp_half_right_wp_percentage = db.Column(db.Float)
own_half_left_wp_percentage = db.Column(db.Float)
own_half_mid_wp_percentage = db.Column(db.Float)
own_half_right_wp_percentage = db.Column(db.Float)
returned_possession_percentage = db.Column(db.Float)
pressed_sequence_percentage = db.Column(db.Float)
possession_percentage = db.Column(db.Float)
attack_speed = db.Column(db.Float)
passes_per_possession = db.Column(db.Float)
xG_after_corner_p90 = db.Column(db.Float)
xG_after_throw_in_p90 = db.Column(db.Float)
xG_after_free_kick_p90 = db.Column(db.Float)
sustained_threat_p90 = db.Column(db.Float)
counter_attacks_p90 = db.Column(db.Float)
fast_tempo_p90 = db.Column(db.Float)
possessions_seconds_total = db.Column(db.Integer)
enemy_passes = db.Column(db.Integer)
defensive_actions_count = db.Column(db.Integer)
lost_possessions = db.Column(db.Integer)
enemy_possessions_count = db.Column(db.Integer)
seconds_in_possession = db.Column(db.Integer)
passes = db.Column(db.Integer)
maintenance_p90 = db.Column(db.Float)
class WyTeamLeagueLink(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
team_wyid = db.Column(db.Integer)
league_wyid = db.Column(db.Integer)
season = db.Column(db.String)
class SparkWyModelsSeasonTeam(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
league_wyid = db.Column(db.Integer)
league_name = db.Column(db.String)
team_wyid = db.Column(db.Integer)
season = db.Column(db.String)
team_name = db.Column(db.String)
xG_after_corner = db.Column(db.Float)
xG_after_free_kick = db.Column(db.Float)
xG_after_throw_in = db.Column(db.Float)
minutes = db.Column(db.Integer)
op_shots = db.Column(db.Float)
op_xG = db.Column(db.Float)
maintenance = db.Column(db.Float)
sustained_threat = db.Column(db.Float)
counter_attacks = db.Column(db.Float)
fast_tempo = db.Column(db.Float)
ppda = db.Column(db.Float)
op_xG_per_shot = db.Column(db.Float)
avg_def_line = db.Column(db.Float)
opp_half_left_wp_percentage = db.Column(db.Float)
opp_half_mid_wp_percentage = db.Column(db.Float)
opp_half_right_wp_percentage = db.Column(db.Float)
own_half_left_wp_percentage = db.Column(db.Float)
own_half_mid_wp_percentage = db.Column(db.Float)
own_half_right_wp_percentage = db.Column(db.Float)
returned_possession_percentage = db.Column(db.Float)
pressed_sequence_percentage = db.Column(db.Float)
possession_percentage = db.Column(db.Float)
attack_speed = db.Column(db.Float)
passes_per_possession = db.Column(db.Float)
xG_after_corner_p90 = db.Column(db.Float)
xG_after_throw_in_p90 = db.Column(db.Float)
xG_after_free_kick_p90 = db.Column(db.Float)
maintenance_p90 = db.Column(db.Float)
sustained_threat_p90 = db.Column(db.Float)
counter_attacks_p90 = db.Column(db.Float)
fast_tempo_p90 = db.Column(db.Float)
class WySeasonPercentiles(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
primary_position_code = db.Column(db.String)
type = db.Column(db.String)
percentile = db.Column(db.String)
minutes = db.Column(db.Integer)
number_of_events = db.Column(db.Integer)
runs_p100_actions = db.Column(db.Float)
passes_p100_actions = db.Column(db.Float)
average_x = db.Column(db.Float)
average_y = db.Column(db.Float)
average_shot_distance = db.Column(db.Float)
scoring_contribution_p90 = db.Column(db.Float)
counterpressing_recoveries_low_p90 = db.Column(db.Float)
counterpressing_recoveries_mid_p90 = db.Column(db.Float)
counterpressing_recoveries_high_p90 = db.Column(db.Float)
recoveries_low_p90 = db.Column(db.Float)
recoveries_mid_p90 = db.Column(db.Float)
recoveries_high_p90 = db.Column(db.Float)
infractions_low_p90 = db.Column(db.Float)
infractions_mid_p90 = db.Column(db.Float)
infractions_high_p90 = db.Column(db.Float)
padj_interceptions_p90 = db.Column(db.Float)
padj_aerial_duels_p90 = db.Column(db.Float)
padj_sliding_tackles_p90 = db.Column(db.Float)
padj_clearance_p90 = db.Column(db.Float)
padj_offensive_duels_p90 = db.Column(db.Float)
padj_defensive_duels_p90 = db.Column(db.Float)
padj_recoveries_low_p90 = db.Column(db.Float)
padj_recoveries_mid_p90 = db.Column(db.Float)
padj_recoveries_high_p90 = db.Column(db.Float)
padj_loose_ball_duels_p90 = db.Column(db.Float)
padj_ball_recoveries_p90 = db.Column(db.Float)
assists_p90 = db.Column(db.Float)
second_assists_p90 = db.Column(db.Float)
third_assists_p90 = db.Column(db.Float)
key_passes_p90 = db.Column(db.Float)
passes_to_final_third_p90 = db.Column(db.Float)
progressive_passes_p90 = db.Column(db.Float)
forward_passes_p90 = db.Column(db.Float)
passes_p90 = db.Column(db.Float)
lateral_passes_p90 = db.Column(db.Float)
back_passes_p90 = db.Column(db.Float)
long_passes_p90 = db.Column(db.Float)
linkup_plays_p90 = db.Column(db.Float)
missed_balls_p90 = db.Column(db.Float)
crosses_p90 = db.Column(db.Float)
progressive_run_p90 = db.Column(db.Float)
accelerations_p90 = db.Column(db.Float)
interceptions_p90 = db.Column(db.Float)
sliding_tackles_p90 = db.Column(db.Float)
aerial_duels_p90 = db.Column(db.Float)
clearances_p90 = db.Column(db.Float)
offensive_duels_p90 = db.Column(db.Float)
defensive_duels_p90 = db.Column(db.Float)
loose_ball_duels_p90 = db.Column(db.Float)
ball_recoveries_p90 = db.Column(db.Float)
shots_blocked_p90 = db.Column(db.Float)
successful_passes_low_p90 = db.Column(db.Float)
successful_passes_mid_p90 = db.Column(db.Float)
successful_passes_high_p90 = db.Column(db.Float)
short_or_medium_passes_p90 = db.Column(db.Float)
pressing_duels_p90 = db.Column(db.Float)
passes_to_penalty_area_p90 = db.Column(db.Float)
deep_completions_p90 = db.Column(db.Float)
head_passes_p90 = db.Column(db.Float)
deep_completed_crosses_p90 = db.Column(db.Float)
free_kick_crosses_p90 = db.Column(db.Float)
dribble_defences_p90 = db.Column(db.Float)
shots_by_left_p90 = db.Column(db.Float)
shots_by_right_p90 = db.Column(db.Float)
shots_by_head_or_other_p90 = db.Column(db.Float)
xg_p90 = db.Column(db.Float)
xg_per_shot = db.Column(db.Float)
non_penalty_goals_p90 = db.Column(db.Float)
goals_by_head_or_other_p90 = db.Column(db.Float)
opp_half_touches_p90 = db.Column(db.Float)
open_play_shots_p90 = db.Column(db.Float)
shots_p90 = db.Column(db.Float)
big_chances_p90 = db.Column(db.Float)
shots_after_long_pass_p90 = db.Column(db.Float)
shots_after_cross_p90 = db.Column(db.Float)
shots_after_through_pass_p90 = db.Column(db.Float)
own_shots_p90 = db.Column(db.Float)
non_fk_outside_box_shots_p90 = db.Column(db.Float)
non_p_dz_shots_p90 = db.Column(db.Float)
long_balls_p90 = db.Column(db.Float)
long_balls_received_p90 = db.Column(db.Float)
crosses_into_small_box_p90 = db.Column(db.Float)
received_passes_into_box_p90 = db.Column(db.Float)
op_xA_p90 = db.Column(db.Float)
op_second_xA_p90 = db.Column(db.Float)
op_third_xA_p90 = db.Column(db.Float)
op_xg_build_up_p90 = db.Column(db.Float)
op_xg_chain_p90 = db.Column(db.Float)
take_ons_p90 = db.Column(db.Float)
spaces_p90 = db.Column(db.Float)
take_ons_in_final_third_p90 = db.Column(db.Float)
take_ons_in_box_p90 = db.Column(db.Float)
danger_zone_entries_p90 = db.Column(db.Float)
dispossessed_p90 = db.Column(db.Float)
free_kick_shots_p90 = db.Column(db.Float)
lost_balls_opp_half_p90 = db.Column(db.Float)
lost_balls_own_half_p90 = db.Column(db.Float)
lost_balls_leading_to_opp_shot_p90 = db.Column(db.Float)
lost_balls_p90 = db.Column(db.Float)
sp_xG_p90 = db.Column(db.Float)
sp_xA_p90 = db.Column(db.Float)
xG_from_corner_p90 = db.Column(db.Float)
high_crosses_p90 = db.Column(db.Float)
low_crosses_p90 = db.Column(db.Float)
blocked_crosses_p90 = db.Column(db.Float)
touches_in_box_p90 = db.Column(db.Float)
successful_passes_to_final_third_percentage = db.Column(db.Float)
passes_runs_percentage = db.Column(db.Float)
spaces_total_runs_percentage = db.Column(db.Float)
xA_per_key_passes = db.Column(db.Float)
successful_take_ons_in_box_percentage = db.Column(db.Float)
successful_crosses_percentage = db.Column(db.Float)
successful_dribbles_percentage = db.Column(db.Float)
successful_take_ons_percentage = db.Column(db.Float)
successful_spaces_percentage = db.Column(db.Float)
long_balls_completion = db.Column(db.Float)
opp_half_touches_ratio = db.Column(db.Float)
successful_crosses_into_small_box_percentage = db.Column(db.Float)
accurate_dz_shots_percentage = db.Column(db.Float)
successful_progressive_passes_percentage = db.Column(db.Float)
won_dribble_defences_percentage = db.Column(db.Float)
dz_scoring_percentage = db.Column(db.Float)
own_shots_percentage = db.Column(db.Float)
scoring_percentage = db.Column(db.Float)
successful_long_passes_percentage = db.Column(db.Float)
conversion_rate = db.Column(db.Float)
successful_head_passes_percentage = db.Column(db.Float)
successful_passes_to_penalty_area_percentage = db.Column(db.Float)
loose_ball_duels_won_percentage = db.Column(db.Float)
successful_short_or_medium_passes_percentage = db.Column(db.Float)
offensive_duels_won_percentage = db.Column(db.Float)
defensive_duels_won_percentage = db.Column(db.Float)
successful_sliding_tackles_percentage = db.Column(db.Float)
air_challenges_completion = db.Column(db.Float)
patch_p90 = db.Column(db.Float)
counterpressing_recoveries_p90 = db.Column(db.Float)
lost_dribble_defences_p90 = db.Column(db.Float)
final_third_touches_p90 = db.Column(db.Float)
infractions_p90 = db.Column(db.Float)
shots_by_primary_foot_percentage = db.Column(db.Float)
yellow_cards_p90 = db.Column(db.Float)
padj_offensive_ground_duels_p90 = db.Column(db.Float)
padj_defensive_ground_duels_p90 = db.Column(db.Float)
lost_balls_p90 = db.Column(db.Float)
dribbles_p90 = db.Column(db.Float)
returned_possessions_p90 = db.Column(db.Float)
passes_into_final_third_p90 = db.Column(db.Float)
received_passes_into_box_p90 = db.Column(db.Float)
final_third_entries_p90 = db.Column(db.Float)
successful_defensive_ground_duels_percentage = db.Column(db.Float)
successful_offensive_ground_duels_percentage = db.Column(db.Float)
padj_returned_possession_p90 = db.Column(db.Float)
padj_counterpressing_recoveries_p90 = db.Column(db.Float)
padj_patch_p90 = db.Column(db.Float)
smart_and_through_passes_p90 = db.Column(db.Float)
smart_passes_p90 = db.Column(db.Float)
successful_smart_passes_percentage = db.Column(db.Float)
through_passes_p90 = db.Column(db.Float)
successful_through_passes_percentage = db.Column(db.Float)
successful_smart_and_through_passes_percentage = db.Column(db.Float)
red_cards_p90 = db.Column(db.Float)
op_xG_p90 = db.Column(db.Float)
np_xG_p90 = db.Column(db.Float)
xA_p90 = db.Column(db.Float)
padj_lost_dribble_defences_p90 = db.Column(db.Float)
class WyEvents(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
wyid = db.Column(db.Integer)
player_wyid = db.Column(db.Integer)
team_wyid = db.Column(db.Integer)
match_wyid = db.Column(db.Integer)
league_wyid = db.Column(db.Integer)
match_period = db.Column(db.Integer)
event_sec = db.Column(db.Float)
event_id = db.Column(db.Integer)
event_name = db.Column(db.String)
px = db.Column(db.Integer)
py = db.Column(db.Integer)
to_px = db.Column(db.Integer)
to_py = db.Column(db.Integer)
sub_event_id = db.Column(db.Integer)
sub_event_name = db.Column(db.String)
tag_labels = db.Column(db.String)
tag_ids = db.Column(db.String)
def __init__(self, wyid, player_wyid, team_wyid, match_wyid, league_wyid,
match_period, event_sec, event_id, event_name, px, py, to_px,
to_py, sub_event_id, sub_event_name, tag_labels, tag_ids):
self.wyid = wyid
self.player_wyid = player_wyid
self.team_wyid = team_wyid
self.match_wyid = match_wyid
self.league_wyid = league_wyid
self.match_period = match_period
self.event_sec = event_sec
self.event_id = event_id
self.event_name = event_name
self.px = px
self.py = py
self.to_px = to_px
self.to_py = to_py
self.sub_event_id = sub_event_id
self.sub_event_name = sub_event_name
self.tag_labels = tag_labels
self.tag_ids = tag_ids
class WyPlayer(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
wyid = db.Column(db.Integer)
name = db.Column(db.String(50))
name_unaccent = db.Column(db.String(50))
height = db.Column(db.Integer)
weight = db.Column(db.Integer)
birthday = db.Column(db.String(255))
nationality = db.Column(db.String(50))
position = db.Column(db.String(20))
foot = db.Column(db.String)
team_wyid = db.Column(db.Integer)
league_wyid = db.Column(db.Integer)
def __init__(self, wyid, name, height, weight, birthday, nationality,
position, foot, team_wyid, league_wyid):
self.wyid = wyid
self.name = name
self.height = height
self.weight = weight
self.birthday = birthday
self.nationality = nationality
self.position = position
self.foot = foot
self.team_wyid = team_wyid
self.league_wyid = league_wyid
class WyMatch(db.Model, CRUD):
id = db.Column(db.Integer, primary_key=True)
wyid = db.Column(db.Integer)
match_date = db.Column(db.String(255))
league_wyid = db.Column(db.Integer)
season_wyid = db.Column(db.Integer)
round_wyid = db.Column(db.Integer)
week = db.Column(db.Integer)
home_team_wyid = db.Column(db.Integer)
guest_team_wyid = db.Column(db.Integer)
score = db.Column(db.String(255))
season = db.Column(db.String(20))
season = db.Column(db.String(255))
def __init__(self, wyid, match_date, league_wyid, season_wyid, round_wyid,
week, home_team_wyid, guest_team_wyid, score, season):
self.wyid = wyid
self.match_date = match_date
self.league_wyid = league_wyid
self.season_wyid = season_wyid
self.round_wyid = round_wyid
self.week = week
self.home_team_wyid = home_team_wyid
self.guest_team_wyid = guest_team_wyid
self.score = score
self.season = season