Open-ILS/src/sql/Pg/build-db.sh

   1 #!/bin/sh
   2
   3 # ---------------------------------------------------------------------------
   4 # Store command line args for later use
   5 # args: {db-host} {db-port} {db-name} {db-user} {db-password}
   6 # ---------------------------------------------------------------------------
   7 PGHOST=$1
   8 PGPORT=$2
   9 PGDATABASE=$3
  10 PGUSER=$4
  11 PGPASSWORD=$5
  12 export PGHOST PGPORT PGDATABASE PGUSER PGPASSWORD
  13
  14 # ---------------------------------------------------------------------------
  15 # Lookup the database version from the PostgreSQL server.
  16 # ---------------------------------------------------------------------------
  17 DB_VERSION=`psql -qtc 'show server_version;' | xargs | cut -c1,3`
  18 if [ -z "$DB_VERSION" ] || [ `echo $DB_VERSION | grep -c '[^0-9]'` != 0 ]; then
  19   cat <<EOM
  20 ********************************************************************************
  21 * Could not determine the version of PostgreSQL you have installed.  Our best  *
  22 * guess was:                                                                   *
  23 * $DB_VERSION
  24 * which didn't make any sense.  For assistance, please email                   *
  25 * open-ils-general@list.georgialibraries.org or join #OpenILS-Evergreen on the *
  26 * freenode IRC network.                                                        *
  27 ********************************************************************************
  28 EOM
  29   exit 1
  30 fi
  31
  32 # ---------------------------------------------------------------------------
  33 # Validate fts-config file is available for specified DB_VERSION.
  34 # ---------------------------------------------------------------------------
  35 if [ -e "000.english.pg$DB_VERSION.fts-config.sql" ]; then
  36   fts_config_file="000.english.pg$DB_VERSION.fts-config.sql"
  37 else
  38   # -------------------------------------------------------------------------
  39   # Attempt to auto-detect the latest available config file.
  40   # -------------------------------------------------------------------------
  41   last_ver=""
  42   for i in $(seq 80 99 | sort -rn); do
  43     if [ -e "000.english.pg$i.fts-config.sql" ]; then
  44       last_ver=$i
  45       break
  46     fi
  47   done
  48   if [ -z "$last_ver" ]; then
  49     cat <<EOM
  50 ********************************************************************************
  51 * Cannot locate any configuration files for  full text search config.  This    *
  52 * may indicate a problem with your copy of the source files.  We attempted to  *
  53 * find files like 000.english.pg83.fts-config.sql in this directory:           *
  54 * `pwd`
  55 * but were unsuccessful.  Aborting.                                            *
  56 ********************************************************************************
  57 EOM
  58     exit 1
  59   fi
  60
  61   a=$DB_VERSION  # preserves the text alignment below, in a cheap fashion
  62   b=$last_ver    # assuming of course two character DB_VERSION and last_ver
  63 cat <<EOM
  64 ********************************************************************************
  65 * There is no configuration for full text search config, for the database      *
  66 * version you have installed ($a).  If you're not really sure why, you should  *
  67 * proabably press 'Control-C' now, and abort.  To continue using the latest    *
  68 * available version ($b), press enter. For assistance, please email            *
  69 * open-ils-general@list.georgialibraries.org or join #OpenILS-Evergreen on the *
  70 * freenode IRC network.                                                        *
  71 ********************************************************************************
  72 EOM
  73   read unused
  74   fts_config_file="000.english.pg$last_ver.fts-config.sql"
  75 fi
  76
  77 # ---------------------------------------------------------------------------
  78 # This describes the order in which the SQL files will be eval'd by psql.
  79 # ---------------------------------------------------------------------------
  80 ordered_file_list="
  81   $fts_config_file
  82
  83   001.schema.offline.sql
  84
  85   002.schema.config.sql
  86   002.functions.aggregate.sql
  87   002.functions.config.sql
  88
  89   005.schema.actors.sql
  90   006.schema.permissions.sql
  91   010.schema.biblio.sql
  92   011.schema.authority.sql
  93   012.schema.vandelay.sql
  94   020.schema.functions.sql
  95   030.schema.metabib.sql
  96   040.schema.asset.sql
  97   070.schema.container.sql
  98   080.schema.money.sql
  99   090.schema.action.sql
 100
 101   100.circ_matrix.sql
 102   110.hold_matrix.sql
 103
 104   300.schema.staged_search.sql
 105
 106   500.view.cross-schema.sql
 107
 108   800.fkeys.sql
 109
 110   900.audit-functions.sql
 111   901.audit-tables.sql
 112   950.data.seed-values.sql
 113   951.data.MODS-xsl.sql
 114   952.data.MODS3-xsl.sql
 115   953.data.MODS32-xsl.sql
 116
 117   reporter-schema.sql
 118   extend-reporter.sql
 119 "
 120
 121 # ---------------------------------------------------------------------------
 122 # Import files via psql, warn user on error, suggest abort.
 123 # ---------------------------------------------------------------------------
 124 for sql_file in $ordered_file_list; do
 125   # It would be wise to turn this on only if confidence is high that errors in
 126   # scripts will result in terminal failures.  Currently, there are a couple
 127   # that seem benign.  --asjoyner
 128   # export ON_ERROR_STOP=1
 129
 130   export PGHOST PGPORT PGDATABASE PGUSER PGPASSWORD
 131   psql -f $sql_file
 132   if [ $? != 0 ]; then
 133     cat <<EOM
 134 ********************************************************************************
 135 * There was an error with a database configuration file:                       *
 136 * $sql_file
 137 * It is very likely that your installation will be unsuccessful because of     *
 138 * this error.  Press Control-C to abort, or press enter to charge ahead.       *
 139 ********************************************************************************
 140 EOM
 141     read unused
 142   fi
 143 done
 144