#!/bin/sh

###############
# database defs
###############
DBXML=cgdb.xml
DBNAME=cgdb
PAGESIZE=32768
ADMPORT=2000
DBPORT=2200
LOGPORT=3000
PIDFILE=./db/pid
ADMINUSER=cgadm
ADMINPWD=cgadm

###############
# tableset defs 
###############
TS=sysmt
TSROOT=./db
TSTICKET=./db/tsticket.xml
SYSSIZE=100
TMPSIZE=100
LOGFILESIZE=1000000
LOGFILENUM=3
APPFILE=./db/data01.dbf
APPSIZE=2000
DBUSER=sysmt
DBPWD=sysmt

### end of customizing ###

CEGO=cego # /lemkeit/bin/cego

rm -rf db
rm -rf $DBXML
mkdir db

/bin/echo -n "   + Creating initial xml ... "
cat > $DBXML <<EOF
<?xml version="1.0" ?>
<!DOCTYPE CEGO_DB_SPEC>
<DATABASE NAME="$DBNAME" PAGESIZE="$PAGESIZE" ADMINPORT="$ADMPORT" LOGPORT="$LOGPORT" DATAPORT="$DBPORT" PIDFILE="$PIDFILE" MAXFID="1" MAXTSID="1" NUMRECSEMA="281" NUMSYSPAGESEMA="53" NUMDATAPAGESEMA="281" NUMIDXPAGESEMA="281" NUMRBPAGESEMA="281" NUMDATAFILESEMA="53" NUMBUFFERPOOLSEMA="31" CSMODE="ON" QESCMODE="ON" DTFORMAT="%d.%m.%Y %H:%M:%S">
<MODULE NAME="ALL" LEVEL="NOTICE"></MODULE>
</DATABASE> 
EOF
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Creating admin user ... "
$CEGO --mode=adduser --dbxml=${DBXML} --user=${ADMINUSER}/${ADMINPWD} --role=admin 
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Defining tableset ... "
$CEGO --mode=define --tableset=${TS} -dbxml=${DBXML} --tsdef=tsroot:${TSROOT},tsticket:${TSTICKET},syssize:${SYSSIZE},tmpsize:${TMPSIZE},logfilesize:${LOGFILESIZE},logfilenum:${LOGFILENUM},appfile:${APPFILE},appsize:${APPSIZE} 
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Creating role ... "
${CEGO} --mode=addrole --role=ALL -dbxml=${DBXML}
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Creating role permission ... "
${CEGO} --mode=addperm --permid=${TS}_P --role=ALL --tableset=${TS} --filter="ALL" --perm="ALL" -dbxml=${DBXML}
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Creating database user ... "
$CEGO --mode=adduser --tableset=${TS} --dbxml=${DBXML} --user=${DBUSER}/${DBPWD} --role=ALL
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

/bin/echo -n "   + Creating tableset ... "
$CEGO --mode=create --dbxml=${DBXML} --tableset=${TS}
test $? -eq 0 && echo OK || { echo FAILED; exit 1; }

