Open-ILS/src/sql/Pg/update-db-comments.sh

   1 #!/bin/sh
   2
   3 if [ $# = 0 ]; then
   4     echo Update database schema comments for an Evegreen database
   5     echo
   6     echo usage: $0 db-host db-port db-name db-user db-password
   7     exit 0;
   8 fi
   9
  10 # ---------------------------------------------------------------------------
  11 # Store command line args for later use
  12 # args: {db-host} {db-port} {db-name} {db-user} {db-password}
  13 # ---------------------------------------------------------------------------
  14 PGHOST=$1
  15 PGPORT=$2
  16 PGDATABASE=$3
  17 PGUSER=$4
  18 PGPASSWORD=$5
  19 export PGHOST PGPORT PGDATABASE PGUSER PGPASSWORD
  20
  21 cd `dirname $0`
  22 export PATH=.:$PATH
  23
  24 grab-db-comments.pl sql_file_manifest | psql