[epgd, epg2vdr] VDR-EPG mittels eventsview.sql "bearbeiten"

#!/bin/bash

fUsage() {
  action="$1"
  case "$action" in
  5) $ECHO "$VERSION"
     exit 0
     ;;
  esac
  $ECHO
  case "$action" in
  4) $ECHO "wrong parameter!";;
  3) $ECHO "mutual exclusive parameters!";;
  2) $ECHO "missing parameter!";;
  1) $ECHO "unknown parameter!";;
  esac
  $ECHO "\tusage:\t$my_name [ -a][ -d [ -D]][ -h] -p <pass> -s <string>[ -V]"
  $ECHO
  $ECHO "\t\t-a          search in all tables"
  $ECHO "\t\t              Default:"
  $ECHO "\t\t                searchtimers, timers, timersdone, useevents"
  $ECHO "\t\t-d          delete found timers and timersdone entries"
  $ECHO "\t\t-D          delete found searchtimer entries"
  $ECHO "\t\t              only in conjunction with -d"
  $ECHO "\t\t-h          displays this help message"
  $ECHO "\t\t-s <string> search for <string>"
  $ECHO "\t\t-p <pass>   password for epg2vdr database"
  $ECHO "\t\t-V          displays version number and date"
  $ECHO
  exit $action

}

VERSION="version 0.01 / 30.01.2023"
ECHO="/bin/echo -e"
ECHON="/bin/echo -e -n"
DBPRG="/usr/bin/mariadb"
[ -x "$DBPRG" ] || DBPRG="/usr/bin/mysql"

VDR="vdr"
DB="epg2vdr"
DBUSER="epg2vdr"

A=0
D=0
while getopts adDhp:s:V OPTION
do
  case "$OPTION" in
  a) A=1;;
  d) D=1;;
  D) D=2;;
  h) fUsage 0;;
  p) P=$OPTARG;;
  s) S=$OPTARG;;
  V) fUsage 5;;
  *) fUsage 4;;
  esac
done
shift `expr "$OPTIND" - 1`

[ -z "$P" ] && fUsage 2
[ -z "$S" ] && fUsage 2

case "$A" in
1)
  TABLES=$( "$DBPRG" --host="${VDR}" --database="${DB}" \
                     --user="${DBUSER}" --password="$P" --batch \
                     --execute "SHOW tables;" \
            | grep -vP "^(Tables_in|movie_media|series_media)" \
          )
  ;;
*)
  TABLES="searchtimers timers timersdone useevents"
  ;;
esac
for _table in $TABLES # {
do
  FIELDS=$( "$DBPRG" --host="${VDR}" --database="${DB}" \
                     --user="${DBUSER}" --password="$P" --batch \
                     --execute "SELECT COLUMN_NAME \
                                FROM information_schema.columns \
                                WHERE TABLE_NAME = '${_table}' \
                                AND TABLE_SCHEMA = '${DB}';" \
            | grep -viP "^(COLUMN_NAME)$" \
          )
  _where=""
  _or=""
  _mfields=""
  _c=""
  _l="------------------------------------------------------------------------"
  for _field in $FIELDS # {
  do
    _where="${_where}${_or}${_field} RLIKE '${S}'"
    _or=" OR "
    _mfields="${_mfields}${_c}( CASE WHEN ${_field} RLIKE '${S}' \
             THEN CONCAT( '\n', '${_field}:\n  [', ${_field}, ']' ) END )"
    _c=","
  done # }

  RESULT=$( "$DBPRG" --host="$VDR" --database="$DB" \
              --user="$DBUSER" --password="$P" \
              --execute \
              "SELECT CONCAT_WS( '\n', ${_mfields} ) AS MatchingFields \
               FROM $_table WHERE ${_where} \G;" \
         )
  test -z "$RESULT" && continue
  $ECHO "${_table}:\n"
  $ECHO "$RESULT"
  $ECHO "$_l"

  if ( ( test "$_table" = "timers" || test "$_table" = "timersdone" ) \
       && ( test $D -eq 1 || test $D -eq 2 ) ) \
     || ( test "$_table" = "searchtimer" && test $D -eq 2 )
  then
    $ECHO
    $ECHON "deleting found record from table [${_table}] - OK? [yn] "
    read yn
    case "$yn" in
    j|J|y|Y)
      # $ECHO \
      "$DBPRG" --host="$VDR" --database="$DB" \
               --user="$DBUSER" --password="$P" \
               --execute \
               "DELETE FROM $_table WHERE ${_where};"
      ;;
    esac
  fi

done # }