def get_team_score_json(global_config, name, comp, store_json_file=False): global_config['logger'].debug( 'GET Team %s Score For Competition %s', name, comp ) season = WebCommonUtils.map_comp_to_season(comp) session = DbSession.open_db_session(global_config['db_name'] + season) result = [] result.append('{ "competition" : "%s", "team" : "%s", ' % (comp,name)) team_scores = DataModel.getTeamScore(session, name, comp) if len(team_scores)==1: result.append('"score": "%s" }' % team_scores[0].score) else: result.append(' "score": [') for score in team_scores: result.append(score.json()) result.append(',\n') if len(team_scores) > 0: result = result[:-1] result.append(']}') json_str = ''.join(result) if store_json_file is True: try: FileSync.put( global_config, '%s/EventData/TeamData/team%s_scouting_score.json' % (comp,name), 'text', json_str) except: raise session.remove() return json_str
def get_team_comp_list(this_comp, team): my_config = ScoutingAppMainWebServer.global_config complist = list() if this_comp == None: this_comp = my_config["this_competition"] + my_config["this_season"] season = my_config["this_season"] else: season = map_comp_to_season(this_comp) complist.append(this_comp) team_complist = WebTeamData.get_team_event_list_from_tba(my_config, team, season) if not team_complist: session = DbSession.open_db_session(my_config["db_name"] + my_config["this_season"]) team_scores = DataModel.getTeamScore(session, team) for score in team_scores: comp = score.competition.upper() # currently, the competition season is stored in the database # as part of the competition. So, we need to add it for the comparison, # but not as we define the complist itself if comp != this_comp.upper(): complist.append(comp) else: for comp in team_complist: if comp.upper() != this_comp.upper(): complist.append(comp) return complist
def get_team_score_page(global_config, name): global_config['logger'].debug( 'GET Team Score: %s', name ) session = DbSession.open_db_session(global_config['db_name'] + global_config['this_season']) web.header('Content-Type', 'application/json') result = [] result.append('{ "score": [') comp = global_config['this_competition'] + global_config['this_season'] team_score = DataModel.getTeamScore(session, name, comp) for score in team_score: result.append(score.json()) result.append(',\n') if len(team_score) > 0: result = result[:-1] result.append(']}') return ''.join(result)
def get_team_score_json(global_config, name, comp): global_config['logger'].debug( 'GET Team %s Score For Competition %s', name, comp ) session = DbSession.open_db_session(global_config['db_name']) web.header('Content-Type', 'application/json') result = [] result.append('{ "competition" : "%s", "team" : "%s", ' % (comp,name)) team_scores = DataModel.getTeamScore(session, name, comp) if len(team_scores)==1: result.append('"score": "%s" }' % team_scores[0].score) else: result.append(' "score": [') for score in team_scores: result.append(score.json()) result.append(',\n') if len(team_scores) > 0: result = result[:-1] result.append(']}') return ''.join(result)
def get_team_comp_list(this_comp, team): my_config = ScoutingAppMainWebServer.global_config complist = list() if this_comp == None: this_comp = my_config['this_competition'] + my_config['this_season'] complist.append(this_comp) session = DbSession.open_db_session(my_config['db_name']) team_scores = DataModel.getTeamScore(session, team) for score in team_scores: comp = score.competition # currently, the competition season is stored in the database # as part of the competition. So, we need to add it for the comparison, # but not as we define the complist itself if comp != this_comp: complist.append(comp) return complist