#!/bin/bash

function get_history
{
  rm -f /tmp/e3g_dpkg.log
  for logfile in  `ls -1tr /var/log/dpkg*`
  do
    if echo $logfile | grep -q ".gz"
    then
      zcat $logfile >> /tmp/e3g_dpkg.log
    else
      cat $logfile >> /tmp/e3g_dpkg.log
    fi
  done
  cat /tmp/e3g_dpkg.log | grep euro3g  | grep " installed "
  rm -f /tmp/e3g_dpkg.log
}



case $1 in
  -h|help) 	echo 'help | all (default) | history | db | last'; exit 1 ;;
  history)	get_history ;;
  db)		echo -n 'db version: ';  echo 'select version from db_version' | mysql -peuro3g -ueuro3g eurotest | tail -1 ;;
  last)         get_history | tail -1 ;;
  *|all)	get_history | tail -1 ; $0 db ;;
esac
