gpslist

   1 #!/bin/bash
   2
   3 #=======================================================================
   4 # gpslist
   5 # File ID: 9cf16956-fafa-11dd-9073-000475e441b9
   6 # Read GPS data from stdin or file names at the command line and send a
   7 # PostgreSQL table to stdout. Needs a database called "tmpgps" with the
   8 # usual tables.
   9 # License: GNU General Public License version 3 or later.
  10 #=======================================================================
  11
  12 cat "$@" | gpst -o pgtab | \
  13     psql -c "TRUNCATE logg; COPY logg (date, coor, ele, name, dist, description) FROM stdin;" tmpgps
  14 cd ~/bin/src/gpstools/postgres
  15 psql -f "$HOME/bin/src/gpstools/postgres/allupdate.sql" tmpgps >/dev/null 2>&1
  16 psql -f "$HOME/bin/src/gpstools/postgres/distupdate.sql" tmpgps >/dev/null 2>&1
  17 psql -c "SELECT date as date, coor, name, dist FROM logg ORDER BY date;" tmpgps