#!/bin/sh

# etc2psql
# Fri Aug 24 06:28:09 MDT 2007 
# jorgericarte@asuni.com.mx
# Pasa archivo FIC a postgres
# Debe de tener permisos para leer/escribir en /home/fic
# Ultimo cambio: Mon 18 Jan 2010 11:25:13 AM MST


/usr/bin/logger "Start $0"

# echo "*********** Inicio *************"; date

SCRIPTAWK="/var/www/ficnx/psql/etc2psql.awk"
FACPATH="/home/fic/etc/"
DBVIEWPATH="/usr/bin/dbview -D "
FACFILES="*"

AWKPATH="/usr/bin/awk"
RMPATH="/bin/rm -f"
MVPATH="/bin/mv"

CATPATH="/bin/cat"
FACSQL="/var/lib/postgresql/etc2psql.sql"
DBSQL="/usr/bin/psql -d ficnx -o /var/lib/postgresql/etc2psql.out -f "

for f in $FACPATH$FACFILES
  do
    /usr/bin/logger "Process $f"
    KES=`echo $f | cut -f1 --delimiter='.'`
    NEWFILE=$KES".TXT"
    $DBVIEWPATH $f >$NEWFILE

    $RMPATH $f
##    $MVPATH $NEWFILE $f
    NEWSQL=$KES".SQL"
    $AWKPATH  -f $SCRIPTAWK $NEWFILE >$NEWSQL
    $RMPATH $NEWFILE

    $CATPATH $NEWSQL >>$FACSQL
    $RMPATH $NEWSQL
done   

# if [ -f $FACSQL ]; then
#   PSQL=$DBSQL$FACSQL 
#   /usr/bin/logger "$PSQL"
#   $PSQL 
#   $RMPATH $FACSQL
# fi

/usr/bin/logger "End $0"

# echo "*********** Final *************"; date