fgextract.awk

BEGIN {
  OFS=","
  print "log_time", "circulation", "fine_interval", "recurring_fine", "max_fine", "stop_fines", "stop_fines_time"
}

/generate_fines/ {
  time = $3
  circ = $10
  if (time ~ /^0[6-8]/) {
    next
  }
  else {
    CMD = "psql -U evergreen -h 10.250.60.60 -A -t -F, -P footer -c 'select fine_interval, recurring_fine, max_fine, stop_fines, stop_fines_time from action.circulation where id = " circ "'"
    CMD | getline data
    close(CMD)
    print time, circ, data
  }
}