Mercurial > public > ssdt-docker
changeset 79:85957628f4c0
add script to clear liquibase lock on existing db container
| author | smith@nwoca.org |
|---|---|
| date | Wed, 06 Apr 2016 19:03:16 +0100 |
| parents | 3eaeb138e1ae |
| children | 5c093612ce89 |
| files | scripts/.functions.sh scripts/clearlocks.sh |
| diffstat | 2 files changed, 16 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/scripts/.functions.sh Sat Mar 26 15:53:37 2016 +0100 +++ b/scripts/.functions.sh Wed Apr 06 19:03:16 2016 +0100 @@ -20,3 +20,10 @@ container=$( docker-compose ps | cut -d " " -f 1 -s | grep _${service}_ ) echo $container } + +executeSQL() { + service=${1?Must supply db service to execute against} + container=$(composeGetContainer $service) + + echo "$2" | docker exec -i $container sh -c "gosu postgres psql \$DB_NAME" +} \ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/scripts/clearlocks.sh Wed Apr 06 19:03:16 2016 +0100 @@ -0,0 +1,9 @@ +#!/bin/bash +source "$( dirname "${BASH_SOURCE[0]}")/.functions.sh" +if [ -z "$1" ] +then + echo "Usage: `basename $0` {db service}" + echo " eg: clearlocks.sh usasdb" + exit $E_NOARGS +fi +executeSQL "$1" "update databasechangeloglock set locked = false, lockgranted = null, lockedby = null where locked = true;"