#!/bin/sh
# File	: import_data_into_db.sh
# By	: Maarten.deBoer@atos.net,170828
# Subject	: Script to import data into AFSP-DB
#set -x
#(0.2),170829	: Added check DB-file 1st
#(0.3),180528	: Other CSV-layout
PGM="`basename $0|cut -d\. -f1`" 
VER="0.3"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"
INCSV="../data/${PGM}.csv"
COUNTRY=""

MAILTO="maarten.deboer@atos.net"

if [ "${1}" != "" ];  then
  COUNTRY="${1}"
fi  # $1
if [ "${2}" != "" ];  then
  INCSV="${2}"
fi  # $2

AFSPDATADIR="/appl/mdr/mdrglob/afsp/${COUNTRY}/data/database"

echo "PGM=${PGM}"
echo "AFSPDATADIR=${AFSPDATADIR}"
echo "BASEDIR=${BASEDIR}"
echo "COUNTRY=${COUNTRY}"
echo "INCSV=${INCSV}"
sleep 2

echo "`date` ${PGM} v${VER} Started."|tee -a ${LOG}
if [ "${COUNTRY}" = "" ]; then
  echo "  NO country (${COUNTRY}) given. Exiting ..."|tee -a ${LOG}
  echo "Usage: ${PGM} <country> [<input CSV-file>]"
  exit 3
fi  # COUNTRY

# Check if INFILE exists
if [ ! -f ${INCSV} ]; then
  echo "  Import CSV-file (${INCSV}) NOT found. Exiting ..."|tee -a ${LOG}
  exit 4
fi

# Check if DB-DIR exists
if [ ! -d ${AFSPDATADIR} ]; then
  echo "  AFSP-DataBase-DIR (${AFSPDATADIR}) NOT found. Exiting ..."|tee -a ${LOG}
  exit 5
fi

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

DB_FUNC_VER

touch ${TMP}

#Host Name;Model;Ser.Nr;
cat ${INCSV}|grep -v '#'|while read LINE
do
  DB_SERIAL_NUMBER="`echo ${LINE}|awk -F\; '{print $1}'`"

  if [ -f ${AFSPDATADIR}/${DB_SERIAL_NUMBER}.asc ];  then
    echo "  DB-file ${AFSPDATADIR}/${DB_SERIAL_NUMBER}.asc exists. Read DB 1st"|tee -a ${LOG}
    DB_READ "${AFSPDATADIR}/${DB_SERIAL_NUMBER}.asc"
  fi

#  DB_CONTRACT_NAME="`echo ${LINE}|awk -F\; '{print $1}'`"
  DB_CONTRACT_NAME=""

  DB_CONTROLER_NAME=""
#  DB_CONTROLER_NAME="`echo ${LINE}|awk -F\; '{print $1}'`"

  DB_SITE_NAME=""
#  DB_SITE_NAME="`echo ${LINE}|awk -F\; '{print $3}'`"

  DB_MODEL_NAME=""
  DB_MODEL_NAME="`echo ${LINE}|awk -F\; '{print $7}'`"

  DB_OS_VERSION=""
#  DB_OS_VERSION="`echo ${LINE}|awk -F\; '{print $4}'`"

  DB_CONTACT_NAME=""
  DB_CONTACT_NAME="`echo ${LINE}|awk -F\; '{print $10}'`"

  DB_REMARKS="Imported at `date`"

  echo "${DB_CONTRACT_NAME}|${DB_CONTROLER_NAME}|${DB_SITE_NAME}|${DB_SERIAL_NUMBER}|${DB_MODEL_NAME}|${DB_OS_VERSION}|${DB_CONTACT_NAME}"

  DB_WRITE "${AFSPDATADIR}/${DB_SERIAL_NUMBER}.asc"

done  #  cat ${INCSV}


echo "`date` ${PGM} v${VER} finished."|tee -a ${LOG}
exit 0