def get_team_scouting_notes_json(global_config, comp, name, store_json_file=False):
global_config['logger'].debug( 'GET Team %s Scouting Notes 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",\n' % (comp,name))
result.append(' "scouting_notes" : [\n')
team_notes = DataModel.getTeamNotes(session, name, comp)
for note in team_notes:
result.append(' { "tag": "%s", "note": "%s" }' % (note.tag,note.data))
result.append(',\n')
if len(team_notes) > 0:
result = result[:-1]
result.append(' ] }\n')
json_str = ''.join(result)
if store_json_file is True:
try:
FileSync.put( global_config, '%s/EventData/TeamData/team%s_scouting_notes.json' % (comp,name), 'text', json_str)
except:
raise
session.remove()
return json_str
def get_team_notes_page(global_config, name):
global_config['logger'].debug( 'GET Team Notes: %s', name )
session = DbSession.open_db_session(global_config['db_name'] + global_config['this_season'])
#web.header('Content-Type', 'application/json')
notes_string = ''
comp = global_config['this_competition'] + global_config['this_season']
team_notes = DataModel.getTeamNotes(session, name, comp)
for note in team_notes:
notes_string += note.data + '\n'
return notes_string
def get_team_scouting_notes_json(global_config, comp, name):
global_config['logger'].debug( 'GET Team %s Scouting Notes 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",\n' % (comp,name))
result.append(' "scouting_notes" : [\n')
team_notes = DataModel.getTeamNotes(session, name, comp)
for note in team_notes:
result.append(' { "tag": "%s", "note": "%s" }' % (note.tag,note.data))
result.append(',\n')
if len(team_notes) > 0:
result = result[:-1]
result.append(' ] }\n')
return ''.join(result)
def get_team_datafiles_page(global_config, name, display_notes=True):
global_config['logger'].debug( 'GET Team Data Files: %s', name )
if global_config['attr_definitions'] == None:
return None
session = DbSession.open_db_session(global_config['db_name'] + global_config['this_season'])
page=''
team_info = DataModel.getTeamInfo(session, int(name))
if team_info:
page += '<h3>Team Info</h3>'
page += '<li>Team Nickname: ' + team_info.nickname + '</li>'
page += '<li>Affiliation: ' + team_info.fullname + '</li>'
page += '<li>Location: ' + team_info.location + '</li>'
page += '<li>Rookie Season: ' + str(team_info.rookie_season) + '</li>'
page += '<li>Website: <a href="' + team_info.website + '">' + team_info.website + '</a></li>'
page += '<br>'
competitions = []
this_comp = global_config['this_competition']
season = global_config['this_season']
competitions.append(this_comp+season)
competitions_str = global_config['other_competitions']
competitions_str = competitions_str.replace(this_comp,'')
if competitions_str.count(',') > 0:
other_comps = competitions_str.split(',')
for other_comp in other_comps:
if other_comp != '':
competitions.append(other_comp+season)
elif competitions_str != '':
competitions.append(competitions_str+season)
for comp in competitions:
if comp != '':
attrdef_filename = WebCommonUtils.get_attrdef_filename(comp=comp)
attr_definitions = AttributeDefinitions.AttrDefinitions(global_config)
attr_definitions.parse(attrdef_filename)
input_dir = './static/data/' + comp + '/ScoutingData/'
pattern = 'Team' + name + '_' + '[a-zA-Z0-9_]*.txt'
datafiles = get_datafiles(input_dir, re.compile(pattern), False, global_config['logger'])
input_dir = './static/data/' + comp + '/ScoutingPictures/'
pattern = 'Team' + name + '_' + '[a-zA-Z0-9_]*.jpg|mp4'
mediafiles = get_datafiles(input_dir, re.compile(pattern), False, global_config['logger'])
if len(datafiles) == 0 and len(mediafiles) == 0:
continue
page += '<hr>'
page += '<h3> ' + comp + '</h3>'
team_attributes = DataModel.getTeamAttributesInOrder(session, name, comp)
if len(team_attributes) > 0:
page += '<ul>'
page += '<h3>Scouting Data Summary:</h3>'
page += '<ul>'
page += '<table border="1" cellspacing="5">'
page += '<tr>'
page += '<th>Attribute Name</th>'
page += '<th>Matches</th>'
page += '<th>Cumulative Value</th>'
page += '<th>Average Value</th>'
#page += '<th>Last Value</th>'
page += '<th>All Values</th>'
page += '</tr>'
for attribute in team_attributes:
attr_def = attr_definitions.get_definition( attribute.attr_name )
include_attr = False
if attr_def:
if attr_def.has_key('Include_In_Team_Display') \
and attr_def['Include_In_Team_Display'] == 'Yes':
include_attr = True
elif attr_def.has_key('Include_In_Report') \
and attr_def['Include_In_Report'] == 'Yes':
include_attr = True
elif attr_def.has_key('Weight') \
and attr_def['Weight'] != '0':
include_attr = True
if include_attr == True:
page += '<tr>'
if attr_def.has_key('Display_Name'):
page += '<td>%s</td>' % attr_def['Display_Name']
else:
page += '<td>%s</td>' % attr_def['Name']
page += '<td>%s</td>' % str(attribute.num_occurs)
page += '<td>%s</td>' % str(attribute.cumulative_value)
page += '<td>%0.2f</td>' % (attribute.avg_value)
#page += '<td>%s</td>' % str(attribute.attr_value)
page += '<td>%s</td>' % attribute.all_values
page += '</tr>'
page += '</table>'
page += '</ul>'
page += '</ul>'
if len(datafiles) > 0:
page += '<ul>'
page += '<h3>Pit and Match Data:</h3>'
page += '<ul>'
for filename in datafiles:
segments = filename.split('/')
basefile = segments[-1]
# the following line inserts a hyperlink to the file itself, the second line
# inserts a hyperlink to a url that allows the webserver to create a nicer display of
# the file contents
#page += '<li><a href="' + filename.lstrip('.') + '">' + basefile + '</a></li>'
page += '<li><a href="' + '/ScoutingData/' + comp + '/' + basefile + '">' + basefile + '</a></li>'
page += '</ul>'
if len(mediafiles) > 0:
page += '<h3>Pictures and Videos:</h3>'
page += '<ul>'
for filename in mediafiles:
segments = filename.split('/')
basefile = segments[-1]
page += '<li><a href="' + filename.lstrip('.') + '">' + basefile + '</a></li>'
page += '</ul>'
page += '</ul>'
if display_notes == True:
page += '<hr>'
page += '<h3> Notes for Team ' + name + '</h3>'
page += '<ul>'
comp = global_config['this_competition'] + global_config['this_season']
team_notes = DataModel.getTeamNotes(session, name, comp)
for note in team_notes:
page += '<li>' + note.data + '</li>'
page += '</ul>'
session.remove()
return page
