#!/usr/bin/bash


PG_VERSION_16=160000

fixup_roles() {
    local ADMIN_ROLE=vstoradmin
    local -a DB_USERS=(
        cinder
        glance
        neutron
        nova
        nova_api
        heat
        gnocchi
        octavia
        barbican
        placement
        magnum
        freezer
        watcher
        manila
        vporter
    )

    local roles present name
    roles=$(IFS=,; echo "${DB_USERS[*]}")
    # -c does not expand psql variables, so the query is passed on stdin
    present=$(runuser -u postgres -- psql -p "${PREV_PORT}" -v ON_ERROR_STOP=1 -v "roles=${roles}" -tA <<'SQL'
SELECT rolname FROM pg_roles WHERE rolname = ANY(string_to_array(:'roles', ',')) ORDER BY rolname;
SQL
    ) || return

    while IFS= read -r name
    do
        [ -n "${name}" ] || continue
        runuser -u postgres -- psql -p "${CURR_PORT}" \
            -v ON_ERROR_STOP=1 -v "role=${name}" -v "admin=${ADMIN_ROLE}" <<'SQL' || return
GRANT :"role" TO :"admin" WITH ADMIN TRUE, INHERIT FALSE, SET FALSE;
SQL
    done <<< "${present}"
}

is_int() {
    local x=$1
    [ "$x" == "$((x))" ]
}

server_version_num() {
    local port=$1
    local ver

    ver=$(runuser -u postgres -- psql -p "${port}" -tAc "SHOW server_version_num") || return
    is_int "${ver}" || return
    echo "${ver}"
}

PREV_PORT=$1
CURR_PORT=$2

is_int "${PREV_PORT}" && is_int "${CURR_PORT}" || {
    echo >&2 "Usage: $0 PREV_PORT CURR_PORT"
    exit 64
}

PREV_VERSION=$(server_version_num "${PREV_PORT}") || exit
CURR_VERSION=$(server_version_num "${CURR_PORT}") || exit

if ((PREV_VERSION < PG_VERSION_16 && CURR_VERSION >= PG_VERSION_16))
then
    fixup_roles || exit
fi
