Mercurial > gemma
comparison schema/update-db.sh @ 3979:5396581cf203 v4-preview20190717
Put updates in a single transaction.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Wed, 17 Jul 2019 12:13:08 +0200 |
parents | 7b7c324b318f |
children | 2fa052a44300 |
comparison
equal
deleted
inserted
replaced
3978:7b7c324b318f | 3979:5396581cf203 |
---|---|
102 new_ver=$( basename $d ) | 102 new_ver=$( basename $d ) |
103 if [ -d "$d" -a "$new_ver" -gt $current_ver ] ; then | 103 if [ -d "$d" -a "$new_ver" -gt $current_ver ] ; then |
104 echo "Running updates for $new_ver ..." | 104 echo "Running updates for $new_ver ..." |
105 | 105 |
106 sql=$( cat `echo "$d/"* | sort -n` ) | 106 sql=$( cat `echo "$d/"* | sort -n` ) |
107 psql -q -p "$port" -d "$db" -c "$sql" | 107 psql -1 -q -p "$port" -d "$db" -c "$sql" |
108 fi | 108 fi |
109 done | 109 done |