#!/bin/sh

# cli2psql
# Fri Aug 24 06:28:09 MDT 2007 
# jorgericarte@asuni.com.mx
# Pasa archivo de clientes (FIC) a postgres
# Debe de tener permisos para leer/escribir en /home/fic

SCRIPTAWK="/var/www/ficnx/psql/cli2psql.awk"
FACPATH="/home/fic/clicon/"
DBVIEWPATH="/usr/bin/dbview"
FACENV="*.DBF"
D2UPATH="/usr/bin/dos2unix -u"
RECOPATH="/usr/bin/recode msdos..utf-8"


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

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

for f in $FACPATH$FACENV 
  do
    KES=`echo $f | cut -f1 --delimiter='.'`
    NEWFILE=$KES".TXT"
    $DBVIEWPATH $f >$NEWFILE

    $D2UPATH $NEWFILE
    $RECOPATH $NEWFILE

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

#    $RMPATH $f
    $CATPATH $NEWSQL >>$FACSQL
#    $RMPATH $NEWSQL
done   

# if [ -f $FACSQL ]; then
#   PSQL=$DBSQL$FACSQL 
#   $PSQL 
#   $RMPATH $FACSQL
# fi