Mercurial > gemma

comparison schema/update-db.sh @ 4661:c1fa4cf8a3f4 stree-experiment

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added an SQL script to be manually executed after the 1302 update.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 14 Oct 2019 15:49:38 +0200
parents 5c0a99b56b2a
children
comparison
equal deleted inserted replaced
4660:6eab3ac0e849 4661:c1fa4cf8a3f4
102 new_ver=$( basename $d ) 102 new_ver=$( basename $d )
103 if [ -d "$d" ] && [ "$new_ver" -gt $current_ver ] ; then 103 if [ -d "$d" ] && [ "$new_ver" -gt $current_ver ] ; then
104 echo "Running updates for $new_ver ..." 104 echo "Running updates for $new_ver ..."
105 105
106 file_args="" 106 file_args=""
107 for f in "$d"/* ; do 107 for f in "$d"/*.sql ; do
108 file_args+=" -f $f" 108 file_args+=" -f $f"
109 done 109 done
110 110
111 psql -1qv ON_ERROR_STOP= -p "$port" -d "$db" $file_args \ 111 psql -1qv ON_ERROR_STOP= -p "$port" -d "$db" $file_args \
112 -c "INSERT INTO gemma_schema_version(version) VALUES ($new_ver)" 112 -c "INSERT INTO gemma_schema_version(version) VALUES ($new_ver)"