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