#! /bin/sh

set -v

monitor -c 'remove view nearrot' geo

monitor -c 'define view nearrot (cities.name,geo_loc=cities.geo_loc,cities.population,dist=cities.geo_loc <=> rot.geo_loc,citoid=cities.oid) from rot in cities where rot.name = "Rotterdam" and (rot.geo_loc <=> cities.geo_loc) < 200.0' geo

monitor -c 'remove rewrite rule nearrotdel' geo

monitor -c 'define rewrite rule nearrotdel is on delete to nearrot do instead delete cities where cities.oid = current.citoid' geo

monitor -c 'remove rewrite rule nearrotrepl' geo

monitor -c 'define rewrite rule nearrotrepl is on replace to nearrot.name do instead replace cities (name=new.name) where cities.oid = current.citoid' geo


monitor -c 'delete geo_dyninfo where geo_dyninfo.relname = "nearrot"' geo

monitor -c 'append geo_dyninfo (relname="nearrot", relattr="geo_loc", dynfunc="make_icon_shape", dynfile="DynIconShape.o", the_oid="citoid")' geo