def fill_db_ru():
cities = json.loads(open('data/cities.json', 'r').read())
for c in cities:
id = city_id(c['lat'], c['lon'])
city = {'id': id, 'latitude': c['lat'], 'longitude': c['lon'], 'xy': xy(c['lat'], c['lon']), 'name': c['name_ru'], 'name_en': c['name_en'], 'country': 'ru'}
save(city)
psql.commit()
def fill_db():
with open('scrape/cities.txt', 'rU') as f:
for row in f:
row = row.split(",")
(country, _unused, name, _code, pop, lat, lng) = row
lat = float(lat)
lng = float(lng)
pop = int(pop)
if pop < 50000:
continue
id = city_id(lat, lng)
city = {'id': id, 'latitude': lat, 'longitude': lng, 'xy': xy(lat, lng), 'name': name, 'name_en': name, 'country': country}
save(city)
psql.commit()
def install_schema():
logger.info("Installing database schema")
cur = psql.cursor()
cur.execute(open("scrape/worldcities.sql", 'r').read())
psql.commit()
