Mercurial > public > ssdt-docker
view scripts/clearlocks.sh @ 418:abe2edacbcb5 release/2.16.0
INV-475: Merging changes onto release branch.
author | Jason Klinger <klinger@nwoca.org> |
---|---|
date | Tue, 09 May 2023 18:34:22 +0100 |
parents | fea886ba7279 |
children |
line wrap: on
line source
#!/bin/bash source "${SSDT_SCRIPTS:-$(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;"