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()