#!/bin/sh
# File	: export_db.sh
# By	: Maarten.deBoer@atos.net, 150924
# Subject	: Script to export AFSP-DB
#set -x
#(0.2),160718	: Added LAST_ASUS_STATUS
PGM="`basename $0|cut -d\. -f1`" 
VER="0.2"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"
CSV="afsp-db-export.csv"

MAILTO="maarten.deboer@atos.net"

echo "`date` ${PGM} v${VER} Started."|tee -a ${LOG}
touch ${TMP}

# Read Functions file
source ./afsp-db_functions.sh

DB_FUNC_VER

echo "# DB_CONTROLER_NAME;DB_SERIAL_NUMBER;DB_SYSTEM_ID;DB_MODEL_NAME;DB_OS_VERSION;DB_SNMP_LOCATION;DB_SNMP_CONTACT;DB_ASUP_GENERATED_ON;COUNTRY;" > ${TMP}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  echo "${COUNTRY} ..."
  # If database, then cd to database
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database
	ls -1 | while read DBFILE
	do
	  DB_READ ${DBFILE}
      echo "${DB_CONTROLER_NAME};${DB_SERIAL_NUMBER};${DB_SYSTEM_ID};${DB_MODEL_NAME};${DB_OS_VERSION};${DB_SNMP_LOCATION};${DB_SNMP_CONTACT};${DB_ASUP_GENERATED_ON};${COUNTRY}; " >> ${TMP}
	done  # FILE
  fi  # database

#
#  if [ -f /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/dfm-filer-name-loc-model-os-fw-sn-partner.csv ]; then
#    cat /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/dfm-filer-name-loc-model-os-fw-sn-partner.csv|grep -v ^#|while read LINE
#	do
#	  CONTROLERNAME="`echo ${LINE}|awk -F\; '{print $1}'`"
#	  LOCATION="`echo ${LINE}|awk -F\; '{print $2}'`"
#	  MODEL="`echo ${LINE}|awk -F\; '{print $3}'`"
#	  OSVERSION="`echo ${LINE}|awk -F\; '{print $4}'`"
#	  SERIALNUMBER="`echo ${LINE}|awk -F\; '{print $6}'`"
#	  CONTACT="`echo ${LINE}|awk -F\; '{print $7}'`"
#
#      echo "${CONTROLERNAME};${SERIALNUMBER};<sys-id>;${MODEL};${OSVERSION};${LOCATION};${CONTACT}${COUNTRY}; " >> ${TMP}
#	done  # cat
#  fi  # FILE


#  if [ -f /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv ]; then
#    cat /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv|grep -v ^#|while read LINE
#	do
#	  CONTROLERNAME="`echo ${LINE}|awk -F\; '{print $1}'`"
#	  LOCATION="`echo ${LINE}|awk -F\; '{print $2}'`"
#	  MODEL="`echo ${LINE}|awk -F\; '{print $3}'`"
#	  OSVERSION="`echo ${LINE}|awk -F\; '{print $4}'`"
#	  SERIALNUMBER="`echo ${LINE}|awk -F\; '{print $6}'`"
#	  CONTACT="`echo ${LINE}|awk -F\; '{print $7}'`"
#
#      echo "${CONTROLERNAME};${SERIALNUMBER};<sys-id>;${MODEL};${OSVERSION};${LOCATION};${CONTACT}${COUNTRY}; " >> ${TMP}
#	done  # cat
#  fi  # FILE



done  # ${COUNTRY}


cp ${TMP} /tmp/${CSV}
date | mailx -a /tmp/${CSV} -s "AFSP DB export [${PGM} v${VER}]" ${MAILTO}
echo "Mailed to ${MAILTO} ..."|tee -a ${LOG}

rm ${TMP} /tmp/${CSV}
echo "`date` ${PGM} Finished."|tee -a ${LOG}
exit 0