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