def test_meta_files(self): acs_meta = ACSMeta() self.failUnlessEqual(acs_meta.csv_column_for_matrix('B07401_001'), 6) census_meta = CensusMeta('SF1') self.failUnlessEqual(census_meta.csv_column_for_matrix('P001001'), 5) census_meta = CensusMeta('SF3') self.failUnlessEqual(census_meta.csv_column_for_matrix('P021001'), 171) census_2010_sf1_meta = Census2010Meta('sf1') self.failUnlessEqual(census_2010_sf1_meta.csv_column_for_matrix('P0040002'), 14)
def get_value(self, table, geo_dicts): if not isinstance(geo_dicts, list): geo_dicts = [geo_dicts] census_info = CensusMeta(self.summary_file) fileid = 'u%s' % self.summary_file col = census_info.csv_column_for_matrix(table) raw_vals = Row.objects.filter( fileid=fileid, cifsn=census_info._file_name_for_matrix(table), stusab__in=map(lambda g: g['STUSAB'].upper(), geo_dicts), logrecno__in=map(lambda g: g['LOGRECNO'], geo_dicts) ).values_list("col%s" % str(col - 4), flat=True) return map(lambda v: Value(self._type_value(v)), raw_vals)
def get_value(self, table, geo_dicts, **kwargs): if not isinstance(geo_dicts, list): geo_dicts = [geo_dicts] census_info = CensusMeta(self.summary_file) fileid = 'u%s' % self.summary_file col = census_info.csv_column_for_matrix(table) raw_vals = Row.objects.filter( fileid=fileid, cifsn=census_info._file_name_for_matrix(table), stusab__in=map(lambda g: g['STUSAB'].upper(), geo_dicts), logrecno__in=map(lambda g: g['LOGRECNO'], geo_dicts)).values_list("col%s" % str(col - 4), flat=True) return map(lambda v: Value(self._type_value(v)), raw_vals)
def test_meta_files(self): acs_meta = ACSMeta() self.failUnlessEqual(acs_meta.csv_column_for_matrix('B07401_001'), 6) census_meta = CensusMeta('SF1') self.failUnlessEqual(census_meta.csv_column_for_matrix('P001001'), 5) census_meta = CensusMeta('SF3') self.failUnlessEqual(census_meta.csv_column_for_matrix('P021001'), 171) census_2010_sf1_meta = Census2010Meta('sf1') self.failUnlessEqual( census_2010_sf1_meta.csv_column_for_matrix('P0040002'), 14)