#!/bin/bash -e

DN_ETC=/usr/share/tomcat/default/conf/service.properties

function get_service_url() {
    awk -F "=" '/serviceUrl/ {print $2}' $1
}

function ensure_coreurl_in_db() {
    local url="$1"
    local t="agent_package_property"
    local cmd="update $t set value='${url}' where id in (select prop.id from $t prop join agent_package package on prop.package_id=package.id where package.name='Built in' and prop.key='CORE_SERVER_URL' and prop.value similar to 'https://[0-9]%');"
    eval "export "$(egrep '^db.password' /usr/share/tomcat/default/conf/intigua.properties | sed 's/^db\.password/PGPASSWORD/')
    echo "$cmd" | psql --user intigua --host localhost --db intiguadb

}

function main() {
    if [ -f "$DN_ETC" ]; then
        local serviceUrl=$(get_service_url $DN_ETC)
        ensure_coreurl_in_db "${serviceUrl}"
    fi
}

main
