def handle_noargs(self, **options):
def clean_int(value):
if value.strip()=='':
value=None
else:
value=int(value.replace('$', '').replace(',', ''))
return value
for year in range(2001, 2015):
data = HeadStartEnrollment.objects.filter(year=year)
count = data.count()
if count > 0:
print str(year) + ': skipping. ' + str(count) + ' records already loaded'
else:
source_file = '%s/health/head_start_enrollment/head_start_enrollment_%s.csv' % (settings.LOCAL_DATA_ROOT, year)
try:
data_reader = csv.reader(open(source_file))
insert_count = 0
for i, row in enumerate(data_reader):
if i == 0:
header_row = row
elif i > 0:
if row[0].strip() <> '':
record = HeadStartEnrollment()
record.year = year
record.state = row[0]
record.funding = clean_int(row[1])
record.enrollment = clean_int(row[2])
record.save()
insert_count = insert_count + 1
print str(year) + ': ' + str(insert_count) + ' records inserted'
except:
print 'data file not found for year ' + str(year)
def handle_noargs(self, **options):
def clean_int(value):
if value.strip()=='':
value=None
else:
value=int(value.replace('$', '').replace(',', ''))
return value
for year in range(2001, 2008):
source_file = '%s/health/head_start_enrollment/head_start_enrollment_%s.csv' % (settings.LOCAL_DATA_ROOT, year)
data_reader = csv.reader(open(source_file))
for i, row in enumerate(data_reader):
if i == 0:
header_row = row
elif i > 0:
if row[0].strip() <> '':
record = HeadStartEnrollment()
record.year = year
record.state = row[0]
record.funding = clean_int(row[1])
record.enrollment = clean_int(row[2])
record.save()
