#!/bin/sh

#Script d'insertion en base des éléments d'alarme

#Usage : sql_alarm.sh IP_IDU new|cleared|changed|event severity type ressource cause probem alarmManagedObjectInstance

#NB : alarmManagedObjectInstance argument utile uniquement dans le cas d'un retour SNMP

#--------------------
DBNAME=test
ALARMTABLE=ALARM
USER=root
PASSWORD=azerty
HOST=localhost

XMLFILEPATH=/home/userir/

XML_ROOT=ALARMS
XML_ROOT_INF=ALARM
XML_ID=ID
XML_IP=IP
XML_DATE=DATE
XML_STATE=STATE
XML_SEVERITY=SEVERITY
XML_TYPE=TYPE
XML_DESC=DESCRIPTION
#--------------------





if [ $# -gt 0 ]; then

	xml="<$XML_ROOT>\n"

	while [ $# -gt 0 ]; do

	#Vérification de la présence de l'information dans la mine
	count=$(echo "use $DBNAME; SELECT COUNT(*)  AS '' FROM $ALARMTABLE WHERE ID='$1';" | mysql --user=$USER --password=$PASSWORD --host=$HOST)

	if [ $count -gt 0 ]; then

		#Extraction du minerai
		#date=`echo "use $DBNAME; SELECT DATE AS '' FROM $ALARMTABLE WHERE ID='$1';" | mysql --user=$USER --password=$PASSWORD --host=$HOST`
		fields=`echo "use $DBNAME; SELECT CONCAT_WS('#',IP,DATE,STATE,SEVERITY,TYPE,RESSOURCE,CAUSE,PROBLEM) AS '' FROM $ALARMTABLE WHERE ID='$1';" | mysql --user=$USER --password=$PASSWORD --host=$HOST`

		ip=`echo $fields | cut -d"#" -f1`
		date=`echo $fields | cut -d"#" -f2`
		state=`echo $fields | cut -d"#" -f3`
		severity=`echo $fields | cut -d"#" -f4`
		type=`echo $fields | cut -d"#" -f5`

		ressource=`echo $fields | cut -d"#" -f6`
		cause=`echo $fields | cut -d"#" -f7`
		problem=`echo $fields | cut -d"#" -f8`

		desc="Ressource:$ressource\tCause:$cause\tProblem:$problem"

		xml="$xml\t<$XML_ROOT_INF>\n"
		xml="$xml\t\t<$XML_ID>$1</$XML_ID>\n"
		xml="$xml\t\t<$XML_IP>$ip</$XML_IP>\n"
		xml="$xml\t\t<$XML_DATE>$date</$XML_DATE>\n"
		xml="$xml\t\t<$XML_STATE>$state</$XML_STATE>\n"
		xml="$xml\t\t<$XML_SEVERITY>$severity</$XML_SEVERITY>\n"
		xml="$xml\t\t<$XML_TYPE>$type</$XML_TYPE>\n"
		xml="$xml\t\t<$XML_DESC>$desc</$XML_DESC>\n"
		xml="$xml\t</$XML_ROOT_INF>\n"

		#MAJ Base
		echo "use $DBNAME; UPDATE $ALARMTABLE SET SENT='1' WHERE ID='$1';" | mysql --user=$USER --password=$PASSWORD --host=$HOST
	fi

	shift;done
	xml="$xml</$XML_ROOT>"
fi


name=___.xml
path="$XMLFILEPATH$name"



echo $xml > ___.xml