def evt_upload(request):
if request.method == 'POST':
memcache.delete("raceshtml")
file_contents = request.FILES['evt'].read().strip()
#file_contents = self.request.get('lif').strip()
import csv
imported = []
importReader = csv.reader(file_contents.split('\n'))
for row in importReader:
imported += [row]
for row in imported:
if len(row) == 4:
fields = row[3].strip().split(" ")
events = Event.all().filter("eventClass =", fields[2])
matched = None
for e in events:
if e.distance.strip("m") == fields[4].strip("m") and e.gender == fields[3]:
matched = e
if matched is not None:
races = matched.race_set.filter("heatNumber =", "H" + row[2]).fetch(1000)
if races is not None and races[0] is not None:
race = races[0]
race.raceNumber = int(row[0])
race.put()
return render_to_response(request, 'results/evtupload.html', {'messages':messages})
def show_bios_overview_mobile(request):
#memcache.delete("biosHtml")
#data = memcache.get('biosHtml')
#if data is not None:
# return data
countryList = Country.all().order("name")
data = UA_object_list(request,Event.all(), template_name="mobile-bioOverview.html", extra_context={'countries':countryList})
#memcache.add("biosHtml", data)
return data
def show_races_event(request, event):
event = Event.all().filter("eventString =", event).fetch(1)
return UA_object_list(request,Race.all().filter("event =",event[0]).order("raceNumber"))
def show_events(request):
return UA_object_list(request,Event.all().order("eventString"), template_name="2event_list.html")
def race_upload(request):
errmsg = []
if request.method == 'POST':
errmsg += ['beginning import']
import re
import os
from bios.models import Country, Athlete, Crew
file = request.FILES['csv']
uploadfile=file.name;
file_contents = request.FILES['csv'].read().strip()
p = re.compile('\r', re.IGNORECASE)
file_contents = p.sub('\n',file_contents)
#file_contents = self.request.get('lif').strip()
import csv
imported = []
importReader = csv.reader(file_contents.split('\n'))
for row in importReader:
imported += [row]
#validate data structure
ci = 0
selectedEvent = None
selectedRace = None
errmsg += ['in the loop']
for r in imported:
try:
if selectedEvent is not None and selectedEvent.eventString != r[0] or selectedEvent is None:
#does this event already exist?
evtest = Event.all().filter("eventString =",r[0]).fetch(1)
#print evtest
if len(evtest) > 0:
selectedEvent = evtest[0]
#print "re-using event"
else:
#print "making new event"
eventInfo = [x.strip() for x in r[0].split('-')]
event = Event()
event.eventClass=eventInfo[0]
event.gender=eventInfo[1]
event.distance=eventInfo[2]
event.eventString=r[0]
event.put()
selectedEvent = event
if selectedRace is not None and (selectedRace.event != selectedEvent or selectedRace.heatNumber != r[1]) or selectedRace is None:
#print "making new race"
#check and re-use old races.
ractest = Race.all().filter("event =",selectedEvent).filter("heatNumber =",r[1]).fetch(1)
if len(ractest) > 0:
selectedRace = ractest[0]
else:
race = Race()
race.event = selectedEvent
race.heatNumber = r[1]
race.hasResults = False
race.put()
selectedRace = race
#athelte or crew?
athcrew = None
if len(r) > 6 and r[6] != '':
if len(r) >8 and r[7] != '':
"""
it's a 4 man crew
"""
fourteam = Athlete.all().filter("bibNum IN",[int(r[5]),int(r[6]),int(r[7]),int(r[8])]).fetch(4)
crew = Crew()
crew.athletes = fourteam
crew.put()
athcrew = crew
else:
"""
it's a crew@@
"""
#crew = Crew()
twoteam = Athlete.all().filter("bibNum IN",[int(r[5]),int(r[6])]).fetch(2)
crew = Crew()
crew.athletes = twoteam
crew.put()
athcrew = crew
else:
selath = Athlete.all().filter("bibNum =", int(r[5])).fetch(1)
athcrew = selath[0] if len(selath)>0 else None
result = Results()
#print athcrew.__class__.__name__
if athcrew.__class__.__name__ is "Crew":
#print "its crew"
result.crew = athcrew
elif athcrew.__class__.__name__ is "Athlete":
#print "its athlete"
result.athlete = athcrew
#result.athlete = selath[0] if len(selath)>0 else None
result.laneNumber = r[2]
selc = Country.all().filter("code =", r[3]).fetch(1)
result.country = selc[0] if len(selc)>0 else None
result.race = selectedRace
result.put()
ci = ci + 1
#if ci > 100:
# return UA_direct(request, 'results/race-upload.html')
#print result
#print r
except:
errmsg += ["Error on Line :%s of CSV, line looks like: %s" % (ci,r)]
errmsg += ["%s rows imported<br/>" % ci]
return render_to_response(request, 'results/race-upload.html', extra_context={"errmsg":errmsg})
def populate_races(request):
errmsg = []
if request.method == 'POST':
errmsg += ['beginning import']
import re
import os
from bios.models import Country, Athlete, Crew
file_contents = request.FILES['evt'].read().strip()
#file_contents = self.request.get('lif').strip()
import csv
imported = []
importReader = csv.reader(file_contents.split('\n'))
for row in importReader:
imported += [row]
selectedEvent = None
selectedRace = None
for row in imported:
if len(row) == 4:
fields = row[3].strip().split(" ")
evtStr = "%s-%s-%s" % (fields[2],fields[3],fields[4].strip("m"))
selectedEvent = Event.all().filter("eventString =", evtStr).fetch(1)[0]
selectedRace = Race.all().filter("raceNumber =", int(row[0])).fetch(1)[0]
print selectedRace.raceNumber
print selectedEvent
else:
#print row[1]
"""
is it an athlete or a crew for the result? check class?
if it's an athlete, search bibNumber set Result with lane number and athlete
if it's a crew, search for the bibNum participating in the event and insert
that crew into a new result containing the lane number
"""
newResult = Results()
newResult.race = selectedRace
chkRace = Race.all().filter("event =", selectedEvent).fetch(1)[0]
if len(chkRace.results_race) > 0 and chkRace.results_race[0].crew is not None:
#find and assign crew
chkAthlete = Athlete.all().filter("bibNum =",int(row[1])).fetch(1)
#print chkAthlete
for crew in chkAthlete[0].crew_athlete:
for result in crew.result_crew:
if result.race.event == selectedEvent:
newResult.crew = crew
else:
newResult.athlete = Athlete.all().filter("bibNum =", int(row[1])).fetch(1)[0]
newResult.laneNumber = row[2]
selc = Country.all().filter("code =", row[5]).fetch(1)[0]
newResult.country = selc
newResult.put()
errmsg += [newResult]
return render_to_response(request, 'results/populate.html', {'errmsg':errmsg})
def purge_event(request):
list = Event.all().fetch(250)
db.delete(list)
return UA_direct(request,'race-upload.html')
