#!/bin/bash
# File	: proc_dfm-model-versions_to_db.sh
# By	: Maarten.deBoer@atos.net, 160721
# Subject	: Script to process DFM-files to models&versions in DB
PGM="`basename $0|cut -d\. -f1`" 
VER="0.1"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"
INFILE="storage-systems-releases.csv"
DBDIR="${BASEDIR}/data/database"
COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`"

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 ${BASEDIR}

echo "${COUNTRY} ..."
echo "# Processed by ${PGM} v${VER} at `hostname`" > ${TMP}
cd /appl/mdr/mdrglob/afsp/${COUNTRY}/incomming/
LASTDIR="`ls -1d 20??-??-??|tail -1`"
cd ${LASTDIR}
ls -1d *|while read SERVER
do
  cd ${SERVER}
  echo "${LASTDIR}/${SERVER}"
  if [ -f ${INFILE} ]; then
    cat ${INFILE}|grep -v '"' | while read LINE
	do
	  TYPE="`echo ${LINE}|awk -F\, '{print $2}'`"
	  STORAGESYSTEM="`echo ${LINE}|awk -F\, '{print $4}'|cut -d\. -f1`"
	  MODEL="`echo ${LINE}|awk -F\, '{print $5}'`"
	  OSVERSION="`echo ${LINE}|awk -F\, '{print $6}'`"
#	  echo ${STORAGESYSTEM}

# Find the right DB-file
      DBFILENAME="`grep \"CONTROLER_NAME=${STORAGESYSTEM}\" ${DBDIR}/*|cut -d\: -f1`"
	  if [ "${DBFILENAME}" != "" ]; then
	    echo "DBFILE=${DBFILENAME}"
        DB_READ ${DBFILENAME}
		DB_DFM_SERVERNAME="${SERVER}"
		DB_DFM_UPDATE_DATE="${LASTDIR}"

        if [ "${MODEL_NAME}" != "" ] && [ "${MODEL_NAME}" != "${MODEL}" ]; then
		  echo "  ${STORAGESYSTEM} update with ${MODEL_NAME} => ${MODEL}"|tee -a ${LOG}
          DB_MODEL_NAME="${MODEL}"
		fi
        if [ "${OS_VERSION}" != "" ] && [ "${OS_VERSION}" != "${OSVERSION}" ]; then
		  echo "  ${STORAGESYSTEM} update with ${OS_VERSION} => ${OSVERSION}"|tee -a ${LOG}
          DB_OS_VERSION="${OSVERSION}"
		fi

        DB_WRITE ${DBFILENAME}
	  fi


	done  # read LINE
  fi  # -f INFILE

  cd ..
done


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