ZoneMinder Forums

Code: Select all

#!/bin/bash
# zm_archive_old_events
# Script to clean up the database/events directory on a regular basis by
# removing "old events" - an event older than ${age_in_days}
# event data is copied to an archive directory for safe keeping/later
# archival/deletion
#
#
# Author: Nugget, aka Stuart Carmichael  20/06/2004
#
 
# Define some vars used later:
age_in_days=14  # keep events online for 2 weeks, then archive
archive_dir="/usr/local/archive/zm/`date +%b%Y`"
db_name="zm"
 
archive_date="`date --date=\"${age_in_days} days ago\" +%Y-%m-%d`"
# Now get a list of all "old" events
 
mysql -D "${db_name}" << EOF > /tmp/old_event.$$
  select e.Id,m.Name,e.StartTime,e.EndTime
  from Events e
  left join Monitors m on e.MonitorId = m.Id
  where e.StartTime <="${archive_date}"
  order by m.Name,e.Id;
EOF
 
if [ `cat /tmp/old_event.$$|wc -l` -eq 0 ]; then
  echo "No matching records found, exiting..."
  exit 0
fi
 
# Using the temporary file created above, move the video files to
# the archive directory and remove the event record from the database.
# The archive directory chosen will be for the month/year for which the
# event occurred.
# An alternate method if you don't want to archive the video files is
# to simply remove the record from the Event table, and allow the
# cleanup daemon to remove the video files (requires the option
# ZM_OPT_FAST_DELETE to be turned on).
 
 
cat /tmp/old_event.$$ | grep -v "^Id" | while read event; do
  id="`echo $event|awk '{ print $1 }'`"
  zone="`echo $event|awk '{ print $2 }'`"
  event_date="`echo $event|awk '{ print $3 }'`"
  outdir="/usr/local/archive/zm/`date --date=${event_date} +%b%Y`/archived_event/$zone"
 
  if [ ! -d "$outdir" ]; then
    mkdir --parents $outdir
  fi
  
  # find the event directory, and move it to the archive location
 
  mv /var/www/html/zm/events/$zone/$id ${outdir}/
 
  # remove the record from the database
mysql -D "${db_name}" << EOF
  delete from Events where Id=${id};
EOF
 
done
 
# now copy the event listing file to the archive directory for safe keeping
outfile="$archive_dir/archived_event/archived_events.`date +%d%m%y_%H%M`"
mv /tmp/old_event.$$ $outfile
 
num_events="`cat $outfile|wc -l`"-1
echo "${num_events} archived events found and processed."
echo "Output report can be found in the following location:"
echo "$outfile"
 
# at this point the db and the events directory are cleaned up. You can either
# burn these files to CD for safe keeping, or remove them later.

Code: Select all

cat /tmp/old_event.$$ | grep -v "^Id" | while read event; do
  id="`echo $event|awk '{ print $1 }'`"
  zone="`echo $event|awk '{ print $2 }'`"
  event_date="`echo $event|awk '{ print $3 }'`"
  outdir="/usr/local/archive/zm/`date --date=${event_date} +%b%Y`/archived_event/$zone" 

Code: Select all

outdir="/usr/local/archive/zm/`date --date=${event_date} 

Code: Select all

outdir="$(archive_dir)/`date --date=${event_date}