def get(self, year):
year = int(year)
if year == 2017:
results, points = self.db.cup_results_2017()
self.render("esko_cup2017.html",
cups=models.cups({'name': 'EsKo Cup', 'year':2017}, 'month'),
players=models.players({'member':True}, 'name'),
course_dict=self.db.course_name_dict(),
results=results,
points=points,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
else:
first_stage_results = self.db.cup_results_2018(True)
self.render("esko_cup2018.html",
players=models.players({'member':True}, 'name'),
results=self.db.cup_results_2018(),
first_stage_results=first_stage_results,
handicap_results=self.db.cup_results_2018_with_handicaps(first_stage_results),
cup_courses=models.cup_courses(2018),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self):
player_ids = self.get_arguments("player")
course_id = self.get_argument("course", None)
special_rules = self.get_argument("special_rules", None)
if not player_ids:
self.render("new_game.html",
message="Valitse pelaajia!",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=player_ids,
chosen_course=course_id,
special_rules=special_rules,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
elif not course_id:
self.render("new_game.html",
message="Valitse rata",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=player_ids,
chosen_course=course_id,
special_rules=special_rules,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
else:
game = models.new_game(course_id, player_ids, special_rules)
self.redirect("/game/{}/".format(int(game.id)))
def get(self):
self.render("games.html",
games=models.games({}, 'start_time desc'),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render(
"games.html",
games=models.games({}, 'start_time desc'),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def render_unauthorized(self):
self.render("unauthorized.html",
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self, player_id):
values = [
self.get_argument(field, None) for field in models.Player.fields
]
player = models.Player(values)
user = self.get_current_user()
if user:
if player.password and player.user_name and (
user.priviledges == 'admin'
or int(user.id) == int(player.id)):
player.set_password()
elif not (player.password or player.user_name):
player.values['password'] = None
player.values['user_name'] = None
if player.member == None:
player.values['member'] = False
if player.save():
self.redirect("/")
self.render(
"new_player.html",
tittle="Pelaajan tiedot",
player=player,
message="Pelaaja on jo tietokannassa!",
# For template
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self):
values = [
self.get_argument(field, None) for field in models.Player.fields
]
player = models.Player(values)
user = self.get_current_user()
if user:
if player.password and player.user_name and user.priviledges == 'admin':
player.set_password()
if player.member == None and user.priviledges in ('admin',
'hallitus'):
player._values['member'] = False
else:
player._values['user_name'] = None
player._values['password'] = None
if player.save():
self.redirect("/")
else:
self.render(
"new_player.html",
tittle="Uusi pelaaja",
player=player,
message="Pelaaja on jo tietokannassa!",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self):
values = [self.get_argument(field, None) for field in models.Player.fields]
player = models.Player(values)
user = self.get_current_user()
if user:
if player.password and player.user_name and user.priviledges == 'admin':
player.set_password()
if player.member == None and user.priviledges in ('admin', 'hallitus'):
player._values['member'] = False
else:
player._values['user_name'] = None
player._values['password'] = None
if player.save():
self.redirect("/")
else:
self.render("new_player.html",
tittle="Uusi pelaaja",
player=player,
message="Pelaaja on jo tietokannassa!",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self, course_id=None):
values = [
self.get_argument(field, None) for field in models.Course.fields
]
course = models.Course(values)
use_old_holes = self.get_argument('use_old_holes', False)
try:
course.save()
self.db.generate_default_holes(course.id, course.holes)
if use_old_holes:
self.redirect("/course/{}/reuse_holes_from/{}/".format(
course.id, course_id))
else:
self.redirect("/course/{}/update_holes".format(course.id))
except Exception as e:
raise e
self.render(
"new_course.html",
tittle="Uusi rata",
terrains=self.db.terrains(),
course=course,
new_layout=True,
use_old_holes=use_old_holes,
message="Rata on jo tietokannassa!",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self, player_id):
values = [self.get_argument(field, None) for field in models.Player.fields]
player = models.Player(values)
user = self.get_current_user()
if user:
if player.password and player.user_name and (
user.priviledges == 'admin' or int(user.id) == int(player.id)):
player.set_password()
elif not (player.password or player.user_name):
player.values['password'] = None
player.values['user_name'] = None
if player.member == None:
player.values['member'] = False
if player.save():
self.redirect("/")
self.render("new_player.html",
tittle="Pelaajan tiedot",
player=player,
message="Pelaaja on jo tietokannassa!",
# For template
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render("login.html",
message="",
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def render_unauthorized(self):
self.render(
"unauthorized.html",
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
self.render(
"login.html",
message="",
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
self.render('api_table.html',
courses=models.courses(),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, hole_id):
self.render('hole_map.html',
hole_id=hole_id,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render(
'api_table.html',
courses=models.courses(),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, player_id):
self.render("player_stats.html",
player=models.player(player_id),
stats=self.db.player_stats(player_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, hole_id):
self.render(
'hole_map.html',
hole_id=hole_id,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, course_id):
self.render("graph.html",
course=models.course(course_id),
players=self.db.player_with_games_on_course(course_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, course_id):
self.render(
"update_holes.html",
course=models.course(course_id),
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, player_id):
self.render(
"player_stats.html",
player=models.player(player_id),
stats=self.db.player_stats(player_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, course_id):
self.render(
"graph.html",
course=models.course(course_id),
players=self.db.player_with_games_on_course(course_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
self.render("new_rules.html",
message="",
name='',
description='',
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render("new_player.html",
tittle="Uusi pelaaja",
player=None,
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render("mainpage.html",
current_season=date.today().year,
latest=self.db.get_latest_games(),
bests=self.db.get_course_bests(),
active_results=self.db.get_active_results(),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, player_id):
player = models.player(player_id)
self.render("new_player.html",
tittle="Pelaajan tiedot",
player=player,
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
self.render(
"new_rules.html",
message="",
name='',
description='',
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
self.render(
"new_player.html",
tittle="Uusi pelaaja",
player=None,
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
self.render(
"mainpage.html",
current_season=date.today().year,
latest=self.db.get_latest_games(),
bests=self.db.get_course_bests(),
active_results=self.db.get_active_results(),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, player_id):
player = models.player(player_id)
self.render(
"new_player.html",
tittle="Pelaajan tiedot",
player=player,
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, game_id):
game = models.game(game_id)
course = models.course(game.course)
self.render(
"game.html",
players=models.players({'active': game_id}),
course=course,
game=game,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, game_id):
game = models.game(game_id)
old_course = models.course(game.course)
self.render(
"change_course.html",
game=game,
old_course=old_course,
courses=models.courses({'holes': old_course.holes}),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
now = datetime.now()
self.render("cup_form.html",
message="",
courses=models.playable_courses(),
cup=None,
year=now.year,
month=now.month,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, course_id):
selected_player = self.get_argument("player", "")
course = models.course(course_id)
self.render(
"course.html",
selected_game_date=self.get_argument("game_date", ""),
selected_player=selected_player,
course=models.course(course_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, course_id):
course = models.course(course_id)
self.render("update_holes.html",
terrains=self.db.terrains(),
hole_types=self.db.hole_types(),
course=course,
holes=models.holes({'course':course.id}),
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self):
player_ids = self.get_arguments("player")
course_id = self.get_argument("course", None)
special_rules = self.get_argument("special_rules", None)
if not player_ids:
self.render(
"new_game.html",
message="Valitse pelaajia!",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=player_ids,
chosen_course=course_id,
special_rules=special_rules,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
elif not course_id:
self.render(
"new_game.html",
message="Valitse rata",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=player_ids,
chosen_course=course_id,
special_rules=special_rules,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
else:
game = models.new_game(course_id, player_ids, special_rules)
self.redirect("/game/{}/".format(int(game.id)))
def get(self, course_id):
selected_player = self.get_argument("player", "")
holes, hole_dict = models.holes_and_dict({'course':course_id}, 'hole')
par_sum = sum([hole.par for hole in holes])
self.render("course.html",
selected_game_date=self.get_argument("game_date", ""),
selected_player=selected_player,
# player_dict=models.player_dict(),
course=models.course(course_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
chosen_course = self.get_argument('course', None)
self.render("new_game.html",
message="",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=[],
chosen_course=chosen_course,
special_rules=None,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self):
now = datetime.now()
self.render(
"cup_form.html",
message="",
courses=models.playable_courses(),
cup=None,
year=now.year,
month=now.month,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self):
player = None
players = models.players({'user_name':self.get_argument('user_name')})
if len(players) == 1:
player = players[0]
if player and player.verify(self.get_argument('password', "")):
self.set_secure_cookie("user", str(player.id))
self.redirect("/")
else:
self.render("login.html",
message="Wrong password or user name.",
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def get(self, course_id=None):
course = models.course(course_id) if course_id else models.Course([])
self.render(
"new_course.html",
tittle="Uusi rata",
terrains=self.db.terrains(),
course=course,
new_layout=True,
use_old_holes=bool(course_id),
message="",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self):
chosen_course = self.get_argument('course', None)
self.render(
"new_game.html",
message="",
courses=models.playable_courses(),
rule_sets=models.rule_sets(),
chosen_players=[],
chosen_course=chosen_course,
special_rules=None,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self):
player = None
players = models.players({'user_name': self.get_argument('user_name')})
if len(players) == 1:
player = players[0]
if player and player.verify(self.get_argument('password', "")):
self.set_secure_cookie("user", str(player.id))
self.redirect("/")
else:
self.render(
"login.html",
message="Wrong password or user name.",
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get(self, game_id):
game = models.game(game_id)
course=models.course(game.course)
holes=models.holes({'course':course.id})
par_sum = sum([hole.par for hole in holes])
self.render("game2.html",
players=models.players({'active':game_id}),
course=course,
holes=holes,
game=game,
par_sum=par_sum,
current_hole=self.db.next_hole(game_id),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self, course_id, old_course_id):
hole_mappings = self.get_arguments('hole')
if len([x for x in hole_mappings if x != 'new']) != len(
set([x for x in hole_mappings if x != 'new'])):
self.render(
"reuse_holes.html",
old_course=models.course(old_course_id),
new_course=models.course(course_id),
message="Error: Same hole can not be in the new course twice.",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user())
else:
for hole in range(len(hole_mappings)):
if hole_mappings[hole] != 'new':
self.db.merge_holes(old_course_id, hole_mappings[hole],
course_id, hole + 1)
self.redirect("/course/{}/update_holes".format(course_id))
def post(self):
values = [self.get_argument(field, None) for field in models.Cup.fields]
cup = models.Cup(values)
try:
cup.save()
self.redirect("/")
except:
now = datetime.now()
self.render("cup_form.html",
message="Virhe!",
courses=models.playable_courses(),
cup=cup,
year=now.year,
month=now.month,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self):
values = [self.get_argument(field, None) for field in models.Course.fields]
course = models.Course(values)
try:
course.save()
models.generate_default_holes(course)
self.redirect("/holes/%s/update" % course.id)
except Exception as e:
raise e
self.render("new_course.html",
tittle="Uusi rata",
terrains=self.db.terrains(),
course=course,
message="Rata on jo tietokannassa!",
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self):
values = [
self.get_argument(field, None) for field in models.Cup.fields
]
cup = models.Cup(values)
try:
cup.save()
self.redirect("/")
except:
now = datetime.now()
self.render(
"cup_form.html",
message="Virhe!",
courses=models.playable_courses(),
cup=cup,
year=now.year,
month=now.month,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def post(self):
name = self.get_argument('name', '')
description = self.get_argument('description', '')
if name:
try:
self.db.new_rule_set(name, description)
self.redirect('/')
return
except Exception as e:
message="Nimi on varattu."
else:
message="Nimi puuttuu."
self.render("new_rules.html",
message=message,
name=name,
description=description,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active':True}),
user=self.get_current_user(),
)
def post(self):
name = self.get_argument('name', '')
description = self.get_argument('description', '')
if name:
try:
self.db.new_rule_set(name, description)
self.redirect('/')
return
except Exception as e:
message = "Nimi on varattu."
else:
message = "Nimi puuttuu."
self.render(
"new_rules.html",
message=message,
name=name,
description=description,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get_active_games_by_course_id(course_id):
return models.games({'course': course_id, 'active': True})
def get(self, year):
year = int(year)
membership_filter = "id IN (SELECT player FROM membership WHERE year={})"
if year == 2017:
results, points = self.db.cup_results_2017()
self.render(
"esko_cup2017.html",
cups=models.cups({
'name': 'EsKo Cup',
'year': 2017
}, 'month'),
players=models.players(
{},
'name',
additional_where=membership_filter.format(2017)),
course_dict=self.db.course_name_dict(),
results=results,
points=points,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
elif year == 2018:
first_stage_results = self.db.cup_results_2018(True)
self.render(
"esko_cup2018.html",
players=models.players(
{},
'name',
additional_where=membership_filter.format(2018)),
results=self.db.cup_results_2018(),
first_stage_results=first_stage_results,
handicap_results=self.db.cup_results_2018_with_handicaps(
first_stage_results),
cup_courses=models.cup_courses(2018),
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
else:
first_stage_results, first_stage_points, course_bests = self.db.cup_results_2019_rules(
year, 1)
second_stage_results, second_stage_points, _ = self.db.cup_results_2019_rules(
year, 2)
overall_results, _, _ = self.db.cup_results_2019_rules(year)
self.render(
"esko_cup2019.html",
players=models.players(
{},
'name',
additional_where=membership_filter.format(year)),
results=overall_results,
first_stage_results=first_stage_results,
points_from_first_stage=first_stage_points,
second_stage_results=second_stage_results,
points_from_second_stage=second_stage_points,
course_bests=course_bests,
cup_courses=models.cup_courses(year),
year=year,
# For template
all_players=models.players(),
course_name_dict=self.db.course_name_dict(),
active_games=models.games({'active': True}),
user=self.get_current_user(),
)
def get_active_games_by_course_id(course_id):
return models.games({'course': course_id, 'active': True})
def fill():
print('entered fill()')
db.session.remove()
print('db.session.remove()...')
db.drop_all()
print('db.drop_all()...')
db.create_all()
print('db.create_all()...')
for c_name in conf_json :
print('here in the first for loop')
c_info = conf_json[c_name]
c_data = conf(name = c_info['name'],
founded = c_info['founded'],
num_teams = c_info['num_teams'],
comm = c_info['comm'],
champ = c_info['champ'])
db.session.add(c_data)
db.session.commit()
print('conf made')
for t_name in teams_json :
print('entered teams building...')
t_info = teams_json[t_name]
t_data = teams(name = t_name,
location = t_info['location'],
head_coach = t_info['coach'],
confname = t_info['conference'])
db.session.add(t_data)
db.session.commit()
print('team made')
for p_id in players_json :
p_info = players_json[p_id]
if (p_info['team'] != 'UAB'):
p_data = players(id = p_id,
name = p_info['name'],
no = p_info['no'],
pos = p_info['pos'],
team = p_info['team'],
ht = p_info['ht'],
wt = p_info['wt'],
hometown = p_info['hometown'],
year = p_info['year'],
hs = p_info['hs'],
photo = p_info['pic'])
db.session.add(p_data)
db.session.commit()
print('players made')
for g_id in games_json :
g_info = games_json[g_id]
away_t = "NOT FBS"
home_t = "NOT FBS"
if g_info['away'] in teams_json:
away_t = g_info['away']
if g_info['home'] in teams_json:
home_t = g_info['home']
g_data = games(id = g_id,
date = g_info['date'],
home_team = home_t,
away_team = away_t,
location = 'TBD',
time = g_info['time'])
db.session.add(g_data)
db.session.commit()
print('games made')
sched = games.query.all()
for s_data in sched :
home = s_data.home_team
away = s_data.away_team
db.session.execute(schedule.insert().values([s_data.home_team,s_data.id]))
db.session.commit()
db.session.execute(schedule.insert().values([s_data.away_team,s_data.id]))
db.session.commit()
print('schedule made')
