def nascar_load_template():
type1 = request.form['type']
year = request.form['year']
series = request.form['series']
file = request.form['file']
data = Utils.get_from_sportradar(series, year, type1, file)
race_list = Sched_Event.extract_sportradar_data(data)
#load_list = Sched_Event.define_load_list(race_list)
#if len(load_list) == 0:
# load_list = "none"
load_list = []
ignore_list = []
for race in race_list:
test = race.get_race_id()
test1 = Sched_Event.find_by_race_id(test)
if test1 is True:
race.save_to_mongo()
load_list.append(race)
else:
ignore_list.append(race)
#races_loaded = load_list[0]
races = Database.find(collection="races", query={"year": int(year)})
#races_ignored = load_list[1]
text = "load successful"
return render_template('races_list.html', text=text, races=load_list, ignore_list = ignore_list)
def load_entrants():
type1 = 'races'
race_id = request.form['race_drop_down_abc']
series = request.form['series_drop_down']
file = 'entry_list.json'
data = Utils.get_from_sportradar(series, type1, race_id, file)
if data is not None:
entrant_list = Entrants.extract_sportradar_data(data)
else:
text = "No data returned from SportRadar"
return render_template('drivers_load.html', text=text)
load_list = []
ignore_list = []
for entrant in entrant_list:
test_race_id = entrant.get_race_id()
test_drv_id = entrant.get_drv_id()
test = Entrants.find_by_race_and_drv_id(test_race_id, test_drv_id)
if test is True:
entrant.save_to_mongo()
load_list.append(entrant)
else:
ignore_list.append(entrant)
#races = Database.find(collection="entrants", query={"race_id": race_id})
text = "load successful"
return render_template('drivers_load.html', text=text, entrants=load_list, ignore_list=ignore_list)
def load_race_results():
type1 = 'races'
#race_id ='4daedbcd-f1c6-4bc1-9690-f85d1fd1af4a'
race_id = request.form['race_drop_down_abc_rr']
series = request.form['series_drop_down_rr']
file = 'results.json'
data = Utils.get_from_sportradar(series, type1, race_id, file)
#json_object = json.loads(data)
print_str = json.dumps(data,indent=2)
print(print_str)
if data is not None:
results_list = Results.extract_sportradar_data(data)
else:
text = "No data returned from SportRadar"
return render_template('results_load.html', text=text)
load_list = []
ignore_list = []
for result in results_list:
test_race_id = result.get_race_id()
test_drv_id = result.get_drv_id()
test = Results.find_by_race_and_drv_id(test_race_id, test_drv_id)
if test is True:
result.save_to_mongo()
load_list.append(result)
else:
#query = Results.get_by_race_and_drv_id(test_race_id, test_drv_id)
#record_json = record.json()
rec_json =result.json()
#obj_id_to_replace = record_json["_id"]
#obj_id_to_replace = "5ec5f4b93acf8b000bfe6ec3"
#print(str(obj_id_to_replace))
#print(type(obj_id_to_replace))
#query = {"_id": record_json["_id"]}
print(str(result.position)+ " - "+ str(result.drv_full))
print(str(rec_json["position"]) + " - " + str(rec_json["drv_full"]))
# stage_2_points, laps_led, laps_completed}
query_update_data = {"$set": {"race_status": str(rec_json["race_status"]), "start_pos": int(rec_json["start_pos"]), "position": int(rec_json["position"]),
"drv_status": str(rec_json["drv_status"]), "points": int(rec_json["points"]), "bonus_points": int(rec_json["bonus_points"]),
"penalty_points": int(rec_json["penalty_points"]), "stage_1_points": int(rec_json["stage_1_points"]),
"stage_2_points": rec_json["stage_2_points"], "laps_led": rec_json["laps_led"], "laps_completed": rec_json["laps_completed"]}}
replace_dir = Database.update_one("results", {"$and":
[{"race_id": test_race_id}, {"drv_id": test_drv_id},]}, query_update_data)
print(str(dir(replace_dir.modified_count)))
print(replace_dir.raw_result)
ignore_list.append(result)
races = Database.find(collection="results", query={"race_id": race_id})
text = "load successful"
return render_template('results_load.html', text=text, results=load_list, ignore_list=ignore_list)
