Mercurial > gemma
comparison schema/update-db.sh @ 3995:074cf9349c71
Fixed schema update-script to ignore text files.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Wed, 17 Jul 2019 16:40:29 +0200 |
parents | 2fa052a44300 |
children | 79adff625ed8 |
comparison
equal
deleted
inserted
replaced
3994:0eb6b5fbeea3 | 3995:074cf9349c71 |
---|---|
98 | 98 |
99 current_ver=$( get_version ) | 99 current_ver=$( get_version ) |
100 | 100 |
101 for d in $BASEDIR/updates/* ; do | 101 for d in $BASEDIR/updates/* ; do |
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" ] && [ "$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);" | 107 sql+="INSERT INTO gemma_schema_version(version) VALUES ($new_ver);" |
108 | 108 |