#!/bin/sh

#Script de génération du XML


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

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 1 ]; then

	xml="<$XML_ROOT>\n"
	file=$1
	shift

	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  !!! A decommenter !!!
			#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>"

	#Creation du fichier
	echo $xml > $file

	#Calcul et ajout du checksum MD5
	crc=`md5sum $file | cut -d" " -f1`
	mv $file $file$crc".XML"

fi