def add_county(**lookup): #Sometimes, CFFR records come through with old county codes #that aren't in the official ANSI county list. Rather than skip #these records, add the missing county record. #get the county name from the CFFR raw record cffr_county = CffrRaw.objects.filter(state_code = lookup['state'].state_ansi,county_code = lookup['county_ansi']) if cffr_county.count() > 0: county_name = cffr_county[0].county_name else: county_name = 'Unknown' record = County(state_id=lookup['state'].id, county_ansi=lookup['county_ansi'], county_name=county_name) record.save() return record
def handle_noargs(self, **options): abbr = '' for c in AnsiCountyState.objects.order_by('state'): if c.state != abbr: state_ref_current = State.objects.get(state_abbr=c.state) abbr = c.state #for each state, add 1) a county-level record to be used for #tracking CFFR state undistributed funds 2) an "unknown" county #record county_ref_row = County(state=state_ref_current, county_ansi='999', county_name='State Undistributed') county_ref_row.save() county_ref_row = County(state=state_ref_current, county_ansi='000', county_name='Unknown County') county_ref_row.save() db.reset_queries() county_ref_row = County(state=state_ref_current, county_ansi=c.code, county_name=c.county) county_ref_row.save() db.reset_queries() #add county row to correspond to US Undistributed state record state_ref_current = State.objects.get(state_ansi='99') county_ref_row = County(state=state_ref_current, county_ansi='999', county_name='U.S. Undistributed') county_ref_row.save() db.reset_queries()