#!/bin/zsh.exe 
nm=LPLoad

path=$1
query=$2
day=$3
msk=$4
fidelity=$5
rep=$6
dFlag=$7

if  [  $# -eq 7  ]
then
  started=`$DATE +"%s"`   ;  started=${started%[^0-9]}     
  stopped=0               
  printf "..%s  for '%s' is here\n" $nm  $query        >>$rep
  $LS  $path/$msk   >$THIS/.$nm.ls
  if [   -s $THIS/.$nm.ls   ] ; then
    $GREP  -v \# $path/$msk   >$THIS/.$nm.grep
    if [   -s $THIS/.$nm.grep   ] ; then
      if [  $dFlag -ge 0   ] ; then
        printf "..%s: >%s %s %s %s %s<\n" $nm  $PARSER $PARSER_SEP -i:$PARSER_PAR \
                       -o:CSV file:$query\?from=$path/$msk+dt=$day+int=$fidelity
      fi
      $RM -rf $THIS/.$nm.csv
      $PARSER $PARSER_SEP -stats:OFF -e:0 -i:$PARSER_PAR -o:CSV -headers:OFF \
                      file:$query\?from=$path/$msk+dt=$day+int=$fidelity >$THIS/.$nm.csv
      RC=$?
      printf "..%s:  parser RC is %s\n" $nm    $RC           >>$rep
      if [ $dFlag -eq 0   ] ; then
        if [    $RC -ne 0  ] ; then
          printf "%s"  $RC  >$THIS/.rcg.save
          if [ -f  $THIS/.rcg.save  ] ; then
            printf "..%s: there was error: %s"  $nm $RC  >>$rep
          fi
          RC=0
        fi
      fi
      if [ -s  $THIS/.$nm.csv -a $RC -eq  0  ] ; then
        printf "input into ar.udua from '%s' format ASCII delimited by ','(ip,dt,prj,fl,isDld,isLv,c2s,s2c,src,drt,nt);"\
                                                    $THIS/.$nm.csv  >$THIS/.$nm.sql
        printf " commit; "  $THIS/.$nm.csv  >>$THIS/.$nm.sql
        $ISQL -c "$DB_CNCT" $THIS/.$nm.sql
        RC=$?
        printf "..%s:  db load RC is %s\n" $nm   $RC         >>$rep
      fi
    else
      RC=0
      printf "..%s:  log is empty. query/msk: '%s'/'%s'\n" $nm     $query $msk        >>$rep
    fi
  else
    RC=0
    printf "..%s: no  log files \n" $nm            >>$rep
  fi
  if [   $dFlag -eq 0   ] ; then
    $RM -rf $THIS/.\*.
  fi

  stopped=`$DATE +"%s"`        ; stopped=${stopped%[^0-9]}
  let "stopped = $stopped -  $started"     

  ls=`$GREP -c .  $THIS/.$nm.csv`  ;   ls=${ls%[^0-9]}
  printf "..%s  for '%s' is finished. lines/secs: %s/%s\n" $nm $query $ls $stopped    >>$rep
  printf "\n %s is finished. RC is %s\n"  $nm $RC

else
  printf "\n $nm: wrong number of params: $#\n\n"
  exit 3
fi

exit $RC