#!/bin/sh

# k6h2psql
# Mon Oct 15 16:42:34 MDT 2007
# jorgericarte@asuni.com.mx
# Pasa archivo de kardes seis meses (FIC) a postgres
# el khmmaa mm=mes aa=anio debe estar en K6PATH
# Ultimo cambio: Tue 01 Dec 2009 05:14:51 PM MST

SCRIPTAWK="/var/www/ficnx/psql/k6h2psql.awk"
# K6PATH="/var/www/ficnx/fc_his/"
K6PATH="/home/fic/fc_his/"
DBVIEWPATH="/usr/bin/dbview -t -b" 
D2UPATH="/usr/bin/dos2unix -u"
RECOPATH="/usr/bin/recode msdos..utf-8"

K6ENV="*.DBF"

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

CLIENV="*.cli"
CATPATH="/bin/cat"
DBSQL="/usr/bin/psql -o /tmp/k6.out -d ficnx -f "
DBUSER=" -U ficnx"

NEWFILE="/tmp/$2.TXT"
$DBVIEWPATH $1 >$NEWFILE
$D2UPATH $NEWFILE
$RECOPATH $NEWFILE

NEWSQL="/tmp/$2.SQL"
$AWKPATH -v K6M=$2 -f $SCRIPTAWK $NEWFILE >$NEWSQL

if [ -f $NEWSQL ]; then
  PSQL=$DBSQL$NEWSQL$DBUSER
  $PSQL 
fi