#!/bin/sh
# File	: afsp-db_functions.sh
# By	: Maarten.deBoer@Atos.net, 150904
# Subject	: Script with functions for AFSP-DB
#(0.2)	: Mod if [ "${DB_FILE}" != "" ]; then
#(0.3),160721	: Added DFM_
#(0.4),160726	: Added COMMENTS
#(0.5),170828	: Added some new VAR's
#(0.5),171228	: Added NetApp (NA_) VAR's
PGM="`basename $0|cut -d\. -f1`"
FUNCVER="0.6"

# Functions

echo "Reading functions v${FUNCVER} ${PGM} ..."

export DB_FUNC_VER
function DB_FUNC_VER
{
  echo "${PGM} v${FUNCVER}"
}

# read DB_FILE in
function DB_READ 
{
  DB_FILE=${1}
  if [ -f ${DB_FILE} ]; then
    DB_SERIAL_NUMBER="`grep ^SERIAL_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_CONTROLER_NAME="`grep ^CONTROLER_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_MODEL_NAME="`grep ^MODEL_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_OS_VERSION="`grep ^OS_VERSION ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_PARTNER_HOSTNAME="`grep ^PARTNER_HOSTNAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SNMP_CONTACT="`grep ^SNMP_CONTACT ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SNMP_LOCATION="`grep ^SNMP_LOCATION ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_ASUP_GENERATED_ON="`grep ^ASUP_GENERATED_ON ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SYSTEM_ID="`grep ^SYSTEM_ID ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_DFM_SERVERNAME="`grep ^DFM_SERVERNAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_DFM_UPDATE_DATE="`grep ^DFM_UPDATE_DATE ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_REMARKS="`grep ^REMARKS ${DB_FILE}|awk -F\= '{print $2}'`"
# New since 2017-08-28
    DB_CONTRACT_NAME="`grep ^CONTRACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SITE_NAME="`grep ^SITE_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_CONTACT_NAME="`grep ^CONTACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
# New since 2017-12-28
	DB_NA_SERIAL_NUMBER="`grep ^NA_SERIAL_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_SYSTEM_NAME="`grep ^NA_SYSTEM_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PLATFORM="`grep ^NA_PLATFORM ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_OS_VERSION="`grep ^NA_OS_VERSION ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_EOS_DATE="`grep ^NA_EOS_DATE ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_LAST_ASUP="`grep ^NA_LAST_ASUP ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_NAME="`grep ^NA_PRIM_CONTACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_NUMBER="`grep ^NA_PRIM_CONTACT_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_MAIL="`grep ^NA_PRIM_CONTACT_MAIL ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_GROUP_NAME="`grep ^GROUP_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_INSTALLED_AT="`grep ^NA_INSTALLED_AT ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_CONTRACT="`grep ^NA_CONTRACT ${DB_FILE}|awk -F\= '{print $2}'`"

    if [ "${DB_MODEL_NAME}" = "" ]; then
      DB_MODEL_NAME=""
    fi
  else
    echo "`date` No DB_FILE (${DB_FILE}) found "
  fi  # if -f
}

function DB_WRITE 
{
  DB_FILE=${1}
  if [ "${DB_FILE}" != "" ]; then
    echo "  Writing ${PGM} ${DB_FILE} ..."
    echo "SERIAL_NUMBER=${DB_SERIAL_NUMBER}" > ${DB_FILE}
    echo "CONTROLER_NAME=${DB_CONTROLER_NAME}" >> ${DB_FILE}
    echo "MODEL_NAME=${DB_MODEL_NAME}" >> ${DB_FILE}
    echo "OS_VERSION=${DB_OS_VERSION}" >> ${DB_FILE}
    echo "PARTNER_HOSTNAME=${DB_PARTNER_HOSTNAME}" >> ${DB_FILE}
    echo "SNMP_CONTACT=${DB_SNMP_CONTACT}" >> ${DB_FILE}
    echo "SNMP_LOCATION=${DB_SNMP_LOCATION}" >> ${DB_FILE}
    echo "ASUP_GENERATED_ON=${DB_ASUP_GENERATED_ON}" >> ${DB_FILE}
    echo "SYSTEM_ID=${DB_SYSTEM_ID}" >> ${DB_FILE}
    echo "DFM_SERVERNAME=${DB_DFM_SERVERNAME}" >> ${DB_FILE}
    echo "DFM_UPDATE_DATE=${DB_DFM_UPDATE_DATE}" >> ${DB_FILE}
    echo "REMARKS=${DB_REMARKS}" >> ${DB_FILE}
# New since 2017-08-28
    echo "CONTRACT_NAME=${DB_CONTRACT_NAME}" >> ${DB_FILE}
    echo "SITE_NAME=${DB_SITE_NAME}" >> ${DB_FILE}
    echo "CONTACT_NAME=${DB_CONTACT_NAME}" >> ${DB_FILE}
# New since 2017-12-28
    echo "NA_SERIAL_NUMBER=${DB_NA_SERIAL_NUMBER}" >> ${DB_FILE}
    echo "NA_SYSTEM_NAME=${DB_NA_SYSTEM_NAME}" >> ${DB_FILE}
    echo "NA_PLATFORM=${DB_NA_PLATFORM}" >> ${DB_FILE}
    echo "NA_OS_VERSION=${DB_NA_OS_VERSION}" >> ${DB_FILE}
    echo "NA_EOS_DATE=${DB_NA_EOS_DATE}" >> ${DB_FILE}
    echo "NA_LAST_ASUP=${DB_NA_LAST_ASUP}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_NAME=${DB_NA_PRIM_CONTACT_NAME}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_NUMBER=${DB_NA_PRIM_CONTACT_NUMBER}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_MAIL=${DB_NA_PRIM_CONTACT_MAIL}" >> ${DB_FILE}
    echo "NA_GROUP_NAME=${DB_NA_GROUP_NAME}" >> ${DB_FILE}
    echo "NA_INSTALLED_AT=${DB_NA_INSTALLED_AT}" >> ${DB_FILE}
    echo "NA_CONTRACT=${DB_NA_CONTRACT}" >> ${DB_FILE}

    echo "LAST_DB_UPDATE_BY=${PGM} v${VER} at `date`" >> ${DB_FILE}
  else
    echo "`date` No DB_FILE (${DB_FILE}) defined "
  fi
}