connection.execute(wrregioncache.delete())
# Query all combinations of sledruns and regions
- sel = select([wrregion.c.id.label('wrregion_id'), wrregion.c.border.label('border'), wrsledruncache.c.page_id, wrsledruncache.c.position_longitude, wrsledruncache.c.position_latitude], geofunc.gcontains(wrregion.c.border, sqlfunc.point(wrsledruncache.c.position_longitude, wrsledruncache.c.position_latitude)))
+ sel = select([wrregion.c.id.label('region_id'), wrregion.c.border.label('border'), wrsledruncache.c.page_id, wrsledruncache.c.position_longitude, wrsledruncache.c.position_latitude], geofunc.gcontains(wrregion.c.border, sqlfunc.point(wrsledruncache.c.position_longitude, wrsledruncache.c.position_latitude)))
ins = wrregioncache.insert()
# Refill wrregioncache
for row in result:
point.SetPoint(0, row.position_longitude, row.position_latitude)
if point.Within(ogr.CreateGeometryFromWkb(row.border.geom_wkb)):
- connection.execute(ins.values(wrregion_id=row.wrregion_id, page_id=row.page_id))
+ connection.execute(ins.values(region_id=row.region_id, page_id=row.page_id))
# commit
transaction.commit()
"""
return Table("wrregioncache", metadata,
Column("id", types.Integer, primary_key=True),
- Column("wrregion_id", types.Integer, schema.ForeignKey('wrregin.id')),
+ Column("region_id", types.Integer, schema.ForeignKey('wrregin.id')),
Column("page_id", types.Integer)
)