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