#!/bin/sh
usage(){
	echo "Usage gen_db_dao DBNAME SOURCE_FOLDER"
	echo "DBNAME could be PGSQL, MSSQL, ORACLE"
	echo "ex: sh gen_db_dao ORACLE /home/ctu/dev/tm-6.1/src/com/ctu/tm/data"
	exit
}

if [ $# -lt 2 ]
then
	usage
fi

DB=$1
DIR=$2
if [ $DB = "MSSQL" ]
then
	ID="MQ"
elif [ $DB = "ORACLE" ]
then
	ID="OQ"
else
	echo "We can do nothing here"
	exit
fi

DB=`echo $DB | tr [A-Z] [a-z]`

DAOS=`ls $DIR/*.dao | grep -v oracle | grep -v mssql`
for dao in $DAOS
do
	basename=`basename $dao .dao`
	echo "basename $basename"
	newDaoFile="${basename}_${DB}.dao"
	echo "$newDaoFile"
	DaoName=`grep 'DAO.*data' $dao | cut -f 2 -d " "`
	newDaoName=`echo "$DaoName" | sed "s/Dao/${ID}Dao/g"`
	echo "#" >> $newDaoFile
	echo "# This is the $DB version of DAO file: $basename" >> $newDaoFile
	echo "#" >> $newDaoFile
	echo "#-----------------------------------------------------------------------------------" >> $newDaoFile
	echo "#" >> $newDaoFile
	echo "#" >> $newDaoFile
	echo "DAO $newDaoName com.ctu.tm.data $DaoName" >> $newDaoFile
	echo "[" >> $newDaoFile
	echo "]" >> $newDaoFile
	echo "{" >> $newDaoFile
	echo "}" >> $newDaoFile
done
