def update_brewery_positions(conn_str=None): db = Database(conn_str) countries = {'154': 'NO'} matches = [] for rb_id, iso_code in countries.iteritems(): matches += map_breweries_for_country(db, rb_id, iso_code) db.run_upserts(SQL, matches) ids = [m['osm_id'] for m in matches] delete_sql = ''' DELETE FROM rb_brewery_position where osm_id NOT IN %s; ''' db.execute_sql(delete_sql, tuple(ids)) db.add_log('osm')