#!/bin/bash
#
# mysql_delete_old_loggings
#
# Alle Loggingdatensaetze loeschen, die nach den Eintraegen in den section, server,
# teststep-Tabellen geloescht werden koennen
#
###############################################################################
#
PATH=/usr/local/bin:/usr/bin:$PATH
export PATH
#
if [[ -f /etc/ulsserver.conf ]]
 then
  . /etc/ulsserver.conf
fi
if [[ -z "$ULSNAME" ]]
 then
  ULSNAME=`hostname`
fi
#
WD=`dirname $0`
if [[ -f $WD/../database.conf ]]
 then
  . $WD/../database.conf
fi
#
MYSQL="mysql -h ${LOGGINGADMINHOST:-localhost} -u loggingadmin -p$LOGGINGADMINPWD logging"
MYSQLO="mysql -B -N -h ${LOGGINGADMINHOST:-localhost} -u loggingadmin -p$LOGGINGADMINPWD logging"
#
SYSVARNAME=lastdeletejob
if [[ "$1" != "-f" ]]
 then
  if [[ `$MYSQLO -e "select wert >= curdate() from systemvars where name='$SYSVARNAME'"` = 1 ]]
   then
    echo "Der letzte Loeschjob ist am `$MYSQLO -e "select wert from systemvars where name='$SYSVARNAME'"` gelaufen!"
    exit 1
  fi
fi
#
$MYSQL -e "update systemvars set wert=curdate() where name='$SYSVARNAME'"
#
echo "calling jobmonitor2uls -u m -f -h $ULSNAME -s ULS -t Jobs:DelOldLoggings `dirname $0`/delete_old_loggings"
jobmonitor2uls -u m -f -h $ULSNAME -s ULS -t Jobs:DelOldLoggings `dirname $0`/delete_old_loggings
