#!/bin/bash
DBNAME="ubuk"

### обработать командную строку
i=$#;  # число параметров в командной строке
while [ $i -ge "0" ]; do
    is="no"
    case $1 in
    -date) # имя БД
        is="yes"; DT=$2 ;;
    esac
    if [ $is == "yes" ]; then
        shift
        i=`expr $i - 1`
    fi
    shift
    i=`expr $i - 1`
done

if [ -z "$DT" ]; then
    MSG="Не указана дата -date YYYY-MM-DD"
    echo $MSG
    exit 1
fi

for f in `psql $DBNAME -qAt -U db_report -h localhost -c "SELECT id_shop||':'||num FROM sj_shifts WHERE time_beg::date<'$DT'::date ORDER BY id_shop, num"`; do 
  SHOP=`echo $f | awk -F':' '{print $1}'`
  SHIFT=`echo $f | awk -F':' '{print $2}'`
  echo "Удаление idshop=$SHOP shift=$SHIFT"
  time psql $DBNAME -qAt -U db_report -h localhost -c "DELETE FROM utranz.sj_shifts WHERE id_shop=$SHOP AND shift=$SHIFT"
  time psql $DBNAME -qAt -U db_report -h localhost -c "DELETE FROM public.sj_shifts WHERE id_shop=$SHOP AND num=$SHIFT"
done
