sqlite database locked

sqlite-pragma-integrity_check.sh

#!/usr/bin/env bash

# https://stackoverflow.com/questions/2740806/python-sqlite-database-is-locked

function sqlite3() {
    executable="$(which sqlite3)" || exit
    out="$("$executable" "$@" 2>&1)" && echo "$out" && return || {
        [[ "$out" == *"locked"* ]] && exit; echo "$out" 1>&2 && exit 1
    }
}
integrity_check="$(sqlite3 "$db" "pragma integrity_check;" 2> /dev/null)" || exit
[[ "$integrity_check" != "ok" ]] && echo "SKIP: integrity_check $integrity_check" && exit