#! /bin/sh
datab=${1:-geo}

#$GEOHOME/geo-ext/loadgeo-aux $datab

awk '
BEGIN	{
  #printf "remove rewrite rule col1_apoid \\g\n"
  #printf "remove instance rule col1_apoid \\g\n"
  printf "destroy col1 \\g\n"
  #printf "create col1 (geo_loc=point, name=char16, height=float4, geo_color=int2, apoid= oid) \\g\n"
  printf "create col1 (geo_loc=point, name=char16, height=float4, geo_color=int2) \\g\n"
  #printf "define rewrite rule col1_apoid is on append to col1 do replace new(apoid=GetMyOid()) \\g\n"
  for (i= 0; i < 16; i++) {
	printf "append col1 (geo_loc=\"(%f,%f)\"::point, name=\"p%d\"::char16, height=\"%f\"::float4, geo_color=%d) \\g\n", \
		5.0+(i%25)/6, 52.0+i/9, i, (23.7 * i) % 24.7, i+2
  }

  printf "delete geo_monitors where geo_monitors.geo_relation = \"col1\"::char16 \\g\n"

  printf "append geo_monitors (geo_relation= \"col1\", change_flags= 7) \\g\n"
  }' < /dev/null | monitor $datab