#!/bin/sh
#@(C) iX, Verlag Heinz Heise, Hannover, Germany 
# JS/ck, 25.1.99
SQLCONF=SQLCONF

if [ $# != 2 ]; then
 echo "usage: $0 number_of_rows dbmsentry"
 exit 1
fi

# ===================================================================
# DO NOT EDIT THIS FILE
# change parameters in $SQLCONF instead        
# getting the parameters
MX=$1
DBMSENTRY=$2
#
SQLDELIM=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $2}'`
STRDELIM=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $3}'`
SERIAL=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $4}'`
NUMBER=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $5}'`
CHARSTR=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $6}'`
DBMS=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $7}'`
MAXINSERTS=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $8}'`
FGEXTENSION=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $9}'`
COMMENT=`grep $DBMSENTRY $SQLCONF | awk -F"|" '{print $10}'`
#====================================================================

# to the environment
export DBMS SQLDELIM NUMBER SERIAL CHARSTR STRDELIM MAXINSERTS MX FGEXTENSION
##echo $DBMS $SQLDELIM $NUMBER $SERIAL $CHARSTR $STRDELIM $MAXINSERTS $MX $FGEXTENSION
##exit

LOG=L`date "+%y%m%d%H%M"`.txt

LIST1="kseq k100k k40k k10k k1k k100 k25 k10 k5 k4 k2"
LIST2="k100k k40k k10k k1k k100 k25 k10 k5 k4 k2"
LIST3="k2,k100 k4,k25 k10,k25"
LIST4="k100k k40k k10k k1k k100"
LIST5="k40k k10k k1k k100"

C1="k2 = 1"
C2="k100 > 80"
C3="k10k between 2000 and 3000"
C4="k5 = 3"
C5="k25 in (11, 19)"
C6="k4 = 3"
C7="k100 < 41"
C8="k1k between 850 and 950"
C9="k10 = 7"
CA="k25 in (3,4)"

export LIST1 LIST2 LIST3 LIST4 LIST5 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA
#
# the real work
cat <<END | $DBMS
drop table bench
$SQLDELIM
END

echo "Starting firstgen.${FGEXTENSION}"
date
echo "$COMMENT" > $LOG
(echo -n "Start of inserting $1 rows:       " ; date ) >> $LOG
if [ $MAXINSERTS -eq 0 ];then
 ./firstgen.${FGEXTENSION} 1 $MX $DBMSENTRY| $DBMS
else
START=1
while [ $MX -gt 0 ];do
 MX=`expr $MX - $MAXINSERTS`
 ./firstgen.${FGEXTENSION} $START $MAXINSERTS $DBMSENTRY | $DBMS
 echo "$MAXINSERTS rows inserted"
 START=`expr $START + $MAXINSERTS`
done
fi
echo "Starting make_idx"
date
(echo -n "Start of indexing $1 rows:        " ; date ) >> $LOG
./make_idx
echo "Starting make_queries"
date
(echo -n "Start of SetQuery single user:    " ; date ) >> $LOG
./make_sqs
date
#(echo -n "Start of SetQuery multi user:     " ; date ) >> $LOG
#./make_sqm
(echo -n "Start of NewQuery single user:    " ; date ) >> $LOG
./make_nqs
#(echo -n "Start of New+SetQuery multi user: " ; date ) >> $LOG
#./make_sqm &
#./make_nqm
#wait
(echo -n "End of iX SQLBench 2.1:      " ; date ) >> $LOG
