#!/bin/bash

#########################################
# Name: raw2db.sh
#
# Summary: make DB table from raw csv
#
# Description:
# wrapper for mktable.sh
#
# Author: k. headley
#
# Copyright 2018 MBARI
#
#########################################

#########################################
# Script configuration defaults
# casual users should not need to change
# anything below this section
#########################################
description="Make DB table from CSV data"

#################################
# Script variable initialization
#################################
VERBOSE="N"
unset DO_HELP
unset ARG_HEADER
unset ARG_ID
unset ARG_GNUDATE
MT_CDATE=""

#################################
# Function Definitions
#################################

#################################
# name: printUsage
# description: print use message
# args: none
#################################
printUsage(){
    echo
    echo " Description: $description"
    echo
    echo " use: `basename $0` [options] file [file...]"
    echo "  Options:"
	echo "   -H s    : header string"
	echo "   -I n    : ID (<0 for empty)"
#	echo "   -g      : GNU date (use for Cygwin)"
    echo "   -v      : verbose output    [$VERBOSE]"
    echo "   -h      : print use message"
    echo ""
    echo
}

########################################
# name: vout
# description: print verbose message to stderr
# args:
#     msg: message
########################################
vout(){
    if [ "${VERBOSE}" == "Y" ] || [ "${VERBOSE}" == "TRUE" ]
    then
    	echo "$1" >&2
    fi
}

########################################
# name: imsg
# description: echos with indent
# args:
#     msg: message
#  indent: indent level
########################################
imsg(){
    OIFS=$IFS
    IFS=""
    msg_pad="                                        "
    let "msg_indent=${1}"
    shift
    all="${@}"
    printf "%s%s\n" ${msg_pad:0:${msg_indent}} ${all}
    IFS=$OIFS
}

########################################
# name: msg
# description: echos with default indent
# args:
#     msg: message
########################################
msg(){
	imsg $MSG_INDENT "${*}"
}

########################################
# name: exitError
# description: print use message to stderr
# args:
#     msg:        error message
#     returnCode: exit status to return
########################################
exitError(){
    echo >&2
    echo "`basename $0`: error - $1" >&2
    echo >&2
    exit $2
}

########################################
# name: convertDate
# description: convert date format
# args:
#     $1:        date  [note 1]
#     $2:        fromFormat
#     $3:        toFormat
# returns value in MT_CDATE
# [1] prefix w/ '@' if epoch sec, e.g. @1533106800
########################################
convertDate(){

	local date_in=$1
	local fromFormat=$2
	local toFormat=$3
	MT_CDATE=""

	echo "converting $date_in from $fromFormat to $toFormat"
	nmatch_len=`expr "${date_in}" : '[0-9]*'`
	if [ $ARG_GNUDATE ]
	then
		if [ ${fromFormat} == "%s" ]
		then
			date_in="@${date_in}"
		fi
		MT_CDATE=$(date --date ${date_in} ${toFormat})
	else
		MT_CDATE=$(date -jf ${fromFormat} ${date_in} ${toFormat})
	fi
}

########################################
# name: processCmdLine
# description: do command line processsing
# args:
#     args:       positional paramters
#     returnCode: none
########################################
processCmdLine(){
    OPTIND=1
    vout "`basename $0` all args[$*]"

	while getopts ghH:I:v Option
    do
        vout "processing $Option[$OPTARG]"
        case $Option in
            g) ARG_GNUDATE=$OPTARG
            ;;
            H ) ARG_HEADER=$OPTARG
            ;;
            I ) ARG_ID=$OPTARG
            ;;
            v ) VERBOSE="Y"
            ;;
            h) DO_HELP="Y"
            ;;
            *) exit 0 # getopts outputs error message
            ;;
        esac
    done
}


##########################
# Script main entry point
##########################

# Argument processing
# Accepts arguments from command line
# or pipe/file redirect

# process command line args
#if [ "$#" -eq 0 ]
#then
#    printUsage
#    #	exit -1
#else
    # this ensures that quoted whitespace is preserved by getopts
    # note use of $@, in quotes

    # originally was processCmdLine $*
    processCmdLine "$@"
    let "i=$OPTIND-1"
    while [ "${i}" -gt 0  ]
    do
        shift
        let "i-=1"
    done
#fi

###########################
# generate time window boundaries
# normalized to epoch milliseconds

# GNU utils date conversion
# (does not have BSD -j option)
# $ date --date="2018-08-01T00:00:00" +%s
# 1533106800
#
# $ date --date="@1533106800" +%Y-%m-%dT%H:%M:%S
# 2018-08-01T00:00:00

#NOW_ISO=$(date  +%Y-%m-%dT%H:%M:%S)
#convertDate ${NOW_ISO} '%Y-%m-%dT%H:%M:%S' '+%s'
#let "NOW_EPS=${MT_CDATE}"
#vout "NOW_EPS=${NOW_EPS}"
#
#convertDate ${NOW_EPS} '%s' '+%Y-%m-%dT%H:%M:%S'
#NOW_ISO=${MT_CDATE}
#vout "NOW_ISO=${NOW_ISO}"


###########################
# debug output
vout "VERBOSE     : [$VERBOSE]"

###########################
# Run

# output help and exit
if [ ${DO_HELP} ] && [ ${DO_HELP} == "Y" ]
then
    printUsage
    exit 0
fi

fileList=""
declare -a srcFiles
MKTABLE="./mktable.sh"

>&2 echo -n " Enter source directory         : "
read sourceDir
>&2 echo -n " Enter file(s) or expression(s) : "
read -a srcFiles
>&2 echo -n " Enter destination file         : "
read dest
>&2 echo -n " Enter header                   : "
IFS= read header
>&2 echo -n " Enter ID                       : "
read id

destDir=$(dirname $dest)
destFile=$(basename $dest)

if [ -f ${header} ]
then
	header=$(cat ${header})
fi

vout ""
vout "source dir   : [${sourceDir}]"
vout "dest         : [${dest}]"
vout "source files : [${srcFiles[@]}]"
vout "header       : [${header}]"
vout "ID           : [${id}]"

if [ ${dest} != "" ] && [ ! -d ${destDir} ]
then
	mkdir -p ${destDir}
	status=$?
	if [ ${status} -ne 0 ]
	then
		exitError "mkdir failed [$status]" 1
	fi
fi

for file in $(echo ${srcFiles[@]})
do
vout "$(ls -1 ${sourceDir}/${file})"
fileList+=" ${sourceDir}/$file"
done
unset OPT_HEADER
unset OPT_ID

if [ "${header}" != "" ]
then
OPT_HEADER="-H ${header}"
fi

if [ "${id}" != "" ]
then
OPT_ID="-I ${id}"
fi
vout "OPT_HEADER    : [${OPT_HEADER}]"
vout "OPT_ID        : [${OPT_ID}]"

if [ ${destFile} != "" ]
then
sort -k 1,24 $fileList | $MKTABLE ${OPT_HEADER} ${OPT_ID} > ${dest}
else
sort -k 1,24 $fileList | $MKTABLE ${OPT_HEADER} ${OPT_ID}
fi

#/////////// End Script
exit 0

if [ ${ARG_HEADER} ]
then
echo ${ARG_HEADER}
fi


if [ ${ARG_ID} ]
then
let "id=${ARG_ID}"
else
let "id=0"
fi

while IFS= read line
do
    if [ ${#line} -gt 24 ]
    then
        if [ ${ARG_ID} ]
        then
            if [ ${ARG_ID} -ge 0 ]
            then
                fid="${id},"
            else
                fid=","
            fi
        else
            fid=""
        fi

        echo "${fid}${line}"

        # update counters
        let "id+=1"
    fi
done