def metro_data():
metro_obj = db.get_metros()
for m in metro_obj:
try:
m_data = b.getMetroData(m.msa, m.state_id, m.best_places_url)
except:
print "ERROR could not get data for {}".format(m.msa)
continue
for d in m_data:
db.set_metros(
state_id = d['state_id'],
cities = d['cities'],
population = d['population'],
unemployment = d['unemployment'],
avg_commute = d['avg_commute'],
median_age = d['median_age'],
household_size = d['household_size'],
median_home_price = d['median_home_price'],
msa = d['msa'],
zipcodes = d['zipcodes']
)
print "imported {}".format(m.msa)
return
def metros():
ids = state_ids()
for state in ids:
state_data = b.getMetros(state)
for m in state_data:
db.set_metros(
state_id = m['state_id'],
state_name = m['state_name'],
msa = m['msa'],
best_places_url = m['bp_url']
)
print "imported {}".format(state)
return
