pkgs/development/libraries/postgis/pg_db_postgis_enable.sh


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

#!/bin/sh
sql_files=(@sql_srcs@)
sql_comments=@sql_comments@

do_help(){ echo "$0 [--comments] db_name1 [db_name2 ..]"; }

for arg in "$@"; do
  case "$arg" in
    -h|--help)
      do_help; exit 0
      ;;
    --comments)
      LOAD_COMMENTS=1
    ;;
    *)
      dbs=(${dbs[@]} "$arg")
    ;;
  esac
done

PSQL(){
  echo ">> loading $1"
  psql -d "$db" -f $1
}

for db in ${dbs[@]}; do
  createlang plpgsql "$db"

  # mandatory
  for sql in $sql_files; do
    PSQL $sql
  done

  # optionally load some comments
  if [ -n "$LOAD_COMMENTS" ]; then
    PSQL $sql_comments
  fi
done