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, 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 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): 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 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("players.html", # 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 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( "players.html", # 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) 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 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( "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, 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, 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, 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 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): 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, 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 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 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): 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", "") 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, 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, 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_player_by_name(name): players = models.players({'name': name}) if len(players) == 1: return players[0] else: return None
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_player_by_name(name): players = models.players({'name': name}) if len(players) == 1: return players[0] else: return None
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')