`pakk_logg`: Make it work on the mobile
[sunny256-utils.git] / hvor
blob5d970166b4163c8133962f7dc152fbe3165257c2
1 #!/usr/bin/env bash
3 #=======================================================================
4 # hvor
5 # File ID: 450313a6-22cf-11e2-866b-fefdb24f8e10
7 # Query the GPS database for the location at a specific point in time.
9 # Author: Øyvind A. Holm <sunny@sunbase.org>
10 # License: GNU General Public License version 2 or later.
11 #=======================================================================
13 progname=hvor
14 VERSION=0.3.1
16 ARGS="$(getopt -o "\
20 " -l "\
21 help,\
22 quiet,\
23 verbose,\
24 version,\
25 " -n "$progname" -- "$@")"
26 test "$?" = "0" || exit 1
27 eval set -- "$ARGS"
29 opt_help=0
30 opt_quiet=0
31 opt_verbose=0
32 while :; do
33 case "$1" in
34 -h|--help) opt_help=1; shift ;;
35 -q|--quiet) opt_quiet=$(($opt_quiet + 1)); shift ;;
36 -v|--verbose) opt_verbose=$(($opt_verbose + 1)); shift ;;
37 --version) echo $progname $VERSION; exit 0 ;;
38 --) shift; break ;;
39 *) echo $progname: Internal error >&2; exit 1 ;;
40 esac
41 done
42 opt_verbose=$(($opt_verbose - $opt_quiet))
44 if test "$opt_help" = "1"; then
45 test $opt_verbose -gt 0 && { echo; echo $progname $VERSION; }
46 cat <<END
48 Query the GPS database for the location at a specific point in time.
50 Usage: $progname [options] TIMESTAMP_IN_UTC
52 Options:
54 -h, --help
55 Show this help.
56 -q, --quiet
57 Be more quiet. Can be repeated to increase silence.
58 -v, --verbose
59 Increase level of verbosity. Can be repeated.
60 --version
61 Print version information.
63 END
64 exit 0
67 psql -X gps -c "COPY (SELECT findpos('$*')) TO STDOUT;"
68 psql -X gps -c "COPY (SELECT wherepos('$*')) TO STDOUT;"