script to update DB object comments
authorGalen Charlton <gmc@esilibrary.com>
Mon, 18 Apr 2011 15:58:02 +0000 (11:58 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Mon, 18 Apr 2011 15:58:02 +0000 (11:58 -0400)
commit04e875ae4b266338feaf5fc24fae7b83f349273b
tree1240bfd5259cbc29bcfb322cdf198e0e3416adc6
parent8259db73d01e8e097edd0173d345a99517b2b7e8
script to update DB object comments

New script, update-db-comments.sh, to be run as part of upgrades
to refresh comments on database schema objects.  Usage is:

  update-db-comments.sh db-host db-port db-name db-user db-pass

The helper script grab-db-comment.pl is what actually parses out
the comment statements.

To avoid repetition, the list of default SQL scripts to use when
initializing an Evergreen database has been moved to a new file
called sql_file_manifest.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/build-db.sh
Open-ILS/src/sql/Pg/grab-db-comments.pl [new file with mode: 0755]
Open-ILS/src/sql/Pg/sql_file_manifest [new file with mode: 0644]
Open-ILS/src/sql/Pg/update-db-comments.sh [new file with mode: 0755]