def handle_csv(self, user, file):
reader = csv.reader(file, dialect=csv.excel)
for row in reader:
try:
run = Run()
run.user = user
date = datetime.strptime(row[0], "%b %d, %Y")
run.date = date
self.stdout.write("Date: " + str(date) + ', ')
minutes = int(row[1])
seconds = int(row[2])
d = run.set_duration(0,minutes,seconds)
self.stdout.write("Dur: " + str(d) + ', ')
distance = Decimal(float(row[3]))
run.distance = distance
self.stdout.write("Dist: " + str(distance) + ', ')
if (row[5]):
hr = int(row[5])
run.average_heart_rate = hr
self.stdout.write("HR: " + str(hr) + ', ')
if (row[6]):
calories = int(row[6])
run.calories = calories
self.stdout.write("Cal: " + str(calories) + ', ')
else:
run.set_calories()
self.stdout.write("Cal': " + str(run.calories) + ', ')
run.set_zone()
self.stdout.write("Zone: " + str(run.zone) + '\n')
run.save()
except ValueError:
self.stdout.write("Skipping: " + ', '.join(row) + '\n')
def obj_to_run(obj):
_date = u'date'
_duration = u'duration'
_average_heart_rate = u'average_heart_rate'
_calories = u'calories'
_distance = u'distance'
run = Run()
# try to parse date field
run.date = datetime.datetime.strptime(obj[_date], "%Y-%m-%d").date()
# try to parse the duration and distance fields
run.duration = hms_to_time(0,0,int(obj[_duration]))
run.distance = float(obj[_distance]) / 1609.344
# try to parse the HR and calories fields, which may be null
if obj[_average_heart_rate]:
run.average_heart_rate = int(obj[_average_heart_rate])
if obj[_calories]:
run.calories = int(obj[_calories])
return run
