def handle_noargs(self, **options):
data_reader = csv.reader(open(SOURCE_FILE))
for i, row in enumerate(data_reader):
if i == 0:
year_row = row;
else:
for j,col in enumerate(row):
if j == 0:
state = col
elif j > 0:
year = year_row[j]
value = col
print "%s %s" % (year, value)
record = AverageTeacherSalary(state=state, year=year, value=value)
record.save()
def handle_noargs(self, **options):
data_reader = csv.reader(open(SOURCE_FILE))
insert_count = 0
update_count = 0
for i, row in enumerate(data_reader):
if i == 0:
year_row = row;
else:
for j,col in enumerate(row):
if j == 0:
state = col
else:
if len(state):
year = year_row[j]
try:
record = AverageTeacherSalary.objects.get(year=year,state=state)
update_count = update_count + 1
except MultipleObjectsReturned:
print 'error: multiple records found for year %s and state %s. value not inserted' % (year,state)
continue
except:
record = AverageTeacherSalary()
record.year = year
record.state = state
insert_count = insert_count + 1
record.value = col
record.save()
db.reset_queries()
print 'Import complete: %s records updated, %s records inserted' % (update_count, insert_count)
