# HG changeset patch
# User smith@nwoca.org
# Date 1459965796 -3600
# Node ID 85957628f4c0fd39c8d3b8316e4584da6d811ab4
# Parent  3eaeb138e1ae54d7a8ed9a4c85412b55ee0847f2
add script to clear liquibase lock on existing db container

diff -r 3eaeb138e1ae -r 85957628f4c0 scripts/.functions.sh
--- 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
diff -r 3eaeb138e1ae -r 85957628f4c0 scripts/clearlocks.sh
--- /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;"