Mercurial > gemma

changeset 436:8feb64128c34

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed install db script to cope with user roles containing whitespace.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 20 Aug 2018 17:58:56 +0200
parents 7d2afdc263b5
children b8366b24dc55
files schema/install-db.sh
diffstat 1 files changed, 3 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/schema/install-db.sh	Mon Aug 20 16:58:55 2018 +0200
+++ b/schema/install-db.sh	Mon Aug 20 17:58:56 2018 +0200
@@ -128,12 +128,9 @@
   read a
   if [[ $a == "yes" ]] ; then
     dropdb -p "$port" "$db"
-    for r in `psql -p $port -t -c '\du' | awk -F '|' \
-          '$1 "." $3 ~ /waterway_user|waterway_admin|sys_admin|pw_reset/ \
-           {print $1}'`
-    do
-      dropuser -p "$port" "$r"
-    done
+    psql -p $port -A -t -c '\du' | awk -F '|' -v port=$port \
+        '$1 "." $3 ~ /waterway_user|waterway_admin|sys_admin|pw_reset/ \
+	    { system("dropuser -p " port " \"" $1 "\"") }'
   else
     echo "No harm done."
   fi