def city_basic_populate():
Base.metadata.create_all(engine)
with open('../scrapers/cities.json', 'r') as f:
city_data = json.load(f)
for city in city_data:
session = Session()
city_db = City(city["city_id"], city["city_name"])
city_db.add_basic_city_data(
city["image_description"], city["city_image"], city["county_id"], city["county_name"])
city_db.add_city_stat(city["unemployment_in_county"], city["motor_vehicle_crash_deaths_in_county"],
city["high_school_graduation_rate_in_county"], city["violent_crime_in_county"], city["population_in_county"],
city["primary_care_physicians_in_county"], city["median_household_income_in_county"],
city["people_with_college_education_in_county"], city["survey_year_in_county"])
print("Added " + city["city_name"])
session.add(city_db)
session.commit()
session.close()
