def get_city_id(city, state):
cityID = 0
city_query = City.query.filter(City.state == state).filter(
City.city == city).all()
if (len(city_query) > 0):
cityID = city_query[0].id
else:
newCity = City()
newCity.city = city
newCity.state = state
db.session.add(newCity)
db.session.commit()
cityID = newCity.id
return cityID
