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)