for member in gf_archive.getmembers(): if not member.name.endswith('.poly'): continue extract_path = member.name[:-5] + '.osm.pbf' extract_href = urljoin(gf_base_href, extract_path) try: content_length, last_modified = size_and_date(extract_href) print extract_href except IOError: print 'Failed', extract_href continue lines = list(gf_archive.extractfile(member)) shape = parse_poly(lines) extracts.append((extract_href, content_length, last_modified, shape)) db = connect(database='tiledrawer', user='******').cursor() db.execute('BEGIN') db.execute('DELETE FROM extracts') for (href, size, date, shape) in extracts: db.execute("""INSERT INTO extracts (href, size, date, geom) VALUES (%s, %s, %s, SetSRID(Multi(GeomFromText(%s)), 4326))""", (href, size, date, str(shape)))
for member in gf_archive.getmembers(): if not member.name.endswith('.poly'): continue extract_path = member.name[:-5] + '.osm.pbf' extract_href = urljoin(gf_base_href, extract_path) try: content_length, last_modified = size_and_date(extract_href) print extract_href except IOError: print 'Failed', extract_href continue lines = list(gf_archive.extractfile(member)) shape = parse_poly(lines) extracts.append((extract_href, content_length, last_modified, shape)) db = connect(database='tiledrawer', user='******').cursor() db.execute('BEGIN') db.execute('DELETE FROM extracts') for (href, size, date, shape) in extracts: db.execute( """INSERT INTO extracts (href, size, date, geom) VALUES (%s, %s, %s, SetSRID(Multi(GeomFromText(%s)), 4326))""", (href, size, date, str(shape)))