Mercurial > gemma

comparison schema/update-db.sh @ 3984:2fa052a44300

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Set schema version in update-db.sh, not in extra scripts. Also fixed handling of empty gemma_schema_version table.
author Sascha Wilde <wilde@intevation.de>
date Wed, 17 Jul 2019 13:54:01 +0200
parents 5396581cf203
children 074cf9349c71
comparison
equal deleted inserted replaced
3983:42af5ec25a7c 3984:2fa052a44300
86 { 86 {
87 local ver 87 local ver
88 if ver=$( psql -qtA -p "$port" -d "$db" \ 88 if ver=$( psql -qtA -p "$port" -d "$db" \
89 -c 'SELECT get_schema_version()' 2>/dev/null ) 89 -c 'SELECT get_schema_version()' 2>/dev/null )
90 then 90 then
91 echo $ver 91 echo ${ver:--1}
92 else 92 else
93 echo '-1' 93 echo '-1'
94 fi 94 fi
95 } 95 }
96 96
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 sql+="INSERT INTO gemma_schema_version(version) VALUES ($new_ver);"
108
107 psql -1 -q -p "$port" -d "$db" -c "$sql" 109 psql -1 -q -p "$port" -d "$db" -c "$sql"
108 fi 110 fi
109 done 111 done