Mercurial > public > ssdt-docker

view scripts/clearlocks.sh @ 526:cb688221b17b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add ESS scripts and update workflows to connect to employee self service.
author Marc Davis <marc.davis@mcoecn.org>
date Wed, 10 Apr 2024 11:04:39 -0400
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;"