#!/bin/bash

SCRIPT_VER="1.0"

APP="Test - DB 002"
APP_CATEGORY="__Fixes"
APP_SCOPE="system"
APP_ENABLED="no"
SUPPORTED_ON="CentOS7,CentOS8,Debian9,Debian10,Ubuntu16.04,Ubuntu18.04,Ubuntu20.04"
LIBRARY="functions4.sh"

if [ "${SUPPORT-}" = '' ]; then
    SUPPORT="https://installers.rapidseedbox.com/scripts/whmcs_client_installers/support"
fi

LOGFILE="/var/log/whmcs_client_installers/${0}.log"
[ ! -d "/var/log/whmcs_client_installers" ] && mkdir -p "/var/log/whmcs_client_installers"

wget -4 -nc -q --no-check-certificate --timeout=20 --tries=5 ${SUPPORT}/${LIBRARY} >> "${LOGFILE}" 2>&1
if [ ! -f "./${LIBRARY}" ] ; then
    echo "55"
    echo "Error downloading \"${SUPPORT}/${LIBRARY}\"" >> "${LOGFILE}"
    exit 55
fi

# shellcheck source=support/functions4.sh
. "./${LIBRARY}"
SCRIPTENTRY

# -- Functions

function _init_db () {
    local db_ver, pfx, python_ver, s, ss
    local cat_id, cat_name, app_name, app_sname, app_supp, app_status
    local oAPP, oAPP_DIRECTORY, oDELUGE_VER, oRT_S_VER
    local in, tmp_file
    if [ -f "${APP_DB}" ] ; then
        db_ver=$( ${SQL_CMD} "${APP_DB}" "SELECT id FROM version" )
        if [ "${db_ver}" != "${APP_DB_VER}" ] ; then
            RM_FILES "${APP_DB}" || return 3
        else
            return 0
        fi
    fi
    INFO "Initializing DB: [${APP_DB}]"
    s=$(
     cat <<-EOF
	CREATE TABLE version ( id TEXT );
	INSERT INTO version ( id ) VALUES ( '${APP_DB_VER}' );
	CREATE TABLE category    (
	    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
	    name TEXT
	  );
	CREATE TABLE application (
	    id     INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
	    cat_id INTEGER,
	    name   TEXT,
	    sname  TEXT,
	    status INTEGER
	  );
	EOF
       )
    ${SQL_CMD} "${APP_DB}" "${s}"
    if [ $? -ne 0 ] ; then
        ERROR "Error initializing DB !"
        return 3
    fi
    WGET "${SUPPORT}/installers.db" || return 3
    INSTALLERS_DB="${TMP_DIR}/installers.db"
    oAPP="${APP}"
    oAPP_DIRECTORY="${APP_DIRECTORY}"
    oDELUGE_VER="${DELUGE_VER}"
    oRT_S_VER="${RT_S__VER}"
    ${SQL_CMD} "${INSTALLERS_DB}" "SELECT id FROM application;" | \
        while read app_id ; do
            tmp_file="${TMP_DIR}/_init_db_tmp.app-${app_id}.$$"
            # Check "supported" status:
            app_supp=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT supported_on FROM application WHERE id=${app_id};" )
            RUN_LOG "echo '${app_supp}' | grep -E '^${LSB_VER}$|^${LSB_VER},|,${LSB_VER}$|,${LSB_VER},' 2>&1"
            [ $? -ne 0 ] && continue
            [ -e "${tmp_file}" ] && RM_FILES "${tmp_file}"
            app_name=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT name FROM application WHERE id=${app_id};" )
            APP="${app_name}"
            app_sname=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT sname FROM application WHERE id=${app_id};" )
            i_cat_id=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT cat_id FROM application WHERE id=${app_id};" )
            cat_name=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT name FROM category WHERE id=${i_cat_id};" )
            cat_id=$( ${SQL_CMD} "${APP_DB}" "SELECT id FROM category WHERE name='${cat_name}'" )
            if [ -z "${cat_id}" ] ; then
                ${SQL_CMD} "${APP_DB}" "INSERT INTO category ( name ) VALUES ( '${cat_name}' );"
                cat_id=$( ${SQL_CMD} "${APP_DB}" "SELECT id FROM category WHERE name='${cat_name}'" )
            fi
            extra_vars=$( ${SQL_CMD} "${INSTALLERS_DB}" \
                "SELECT extra_vars FROM application WHERE id=${app_id};" )
#            DEBUG "Extra vars: ${extra_vars}"
            if [ ! -z "${extra_vars}" ] ; then
#                DEBUG "Extra vars is not blank!"
                oIFS=${IFS}
                IFS='|'
                in=${extra_vars}
                for s in ${in} ; do
#                    DEBUG "s: [${s}]"
                    [ ! -z "${s}" ] && echo "${s}" >> "${tmp_file}"
                done
                IFS=${oIFS}
                [ -e "${tmp_file}" ] && . "${tmp_file}"
            fi
            app_status=0
            ${CHECK_APP} "${app_name}" "install"
            if [ $? -eq 111 ] ; then
                if [ ! -z "${DELUGE_VER}" ] ; then
                    for pfx in "/usr/local" "/usr" ; do
                        for python_ver in "2.6" "2.7" ; do
                            if [ -d "${pfx}/lib/python${python_ver}/site-packages/deluge-${DELUGE_VER}-py${python_ver}.egg" -o \
                                 -d "${pfx}/lib/python${python_ver}/site-packages/deluge-${DELUGE_VER}-py${python_ver}.egg" ] ; then
                                app_status=1
                                break 2
                            fi
                        done
                    done
                elif [ ! -z  "${RT_S_VER}" ] ; then
                    [ -d "/usr/local/rt${RT_S_VER}" ] && app_status=1
                else
                    app_status=1
                fi
            fi
            ${SQL_CMD} "${APP_DB}" \
               "INSERT INTO application ( cat_id, name, sname, status ) VALUES ( ${cat_id}, '${app_name}', '${app_sname}', ${app_status} );"
            APP=""
            APP_DIRECTORY=""
            DELUGE_VER=""
            RT_S_VER=""
        done

    APP="${oAPP}"
    APP_DIRECTORY="${oAPP_DIRECTORY}"
    DELUGE_VER="${oDELUGE_VER}"
    RT_S_VER="${oRT_S_VER}"
    return 0
}


# -- Main test section

_init_db


#SCRIPTEXIT