def process_files_obj(f_name):
try:
with open(f_name) as tFile:
data = tFile.readline()
tmp_list = data.strip().split(',')
return(customobj_inh(tmp_list.pop(0), tmp_list.pop(0), tmp_list))
except IOError as err:
print('File error: '+str(err))
return(None)
def get_athlete_from_id(athlete_id):
connection = sqlite3.connect(db_name)
cursor = connection.cursor()
results = cursor.execute("""SELECT name, dob FROM athletes WHERE id=?""",(athlete_id,))
(name, dob) = results.fetchone()
results = cursor.execute("""SELECT value FROM timing_data WHERE athlete_id=?""",(athlete_id,))
data = [row[0] for row in results.fetchall()]
#Due to unknown order inside database, so we need sorted the data via customobj_inh class before display
m_tmp_item = customobj_inh(name, dob, data)
response = {'Name': m_tmp_item.name,
'DOB': m_tmp_item.dob,
'data': m_tmp_item.clean_data,
'top3': m_tmp_item.top3()}
connection.close()
return(response)
