#!/bin/bash

. /etc/init.d/cr-env

# solr
dbuser=`grep -m 1 user-name /var/lib/jboss/server/web/deploy/CR_${crEnv}-ds.xml | sed -e 's/^[ \t]*//' -e 's/<user-name>//' -e 's/<\/user-name>//'`
dbpass=`grep -m 1 password /var/lib/jboss/server/web/deploy/CR_${crEnv}-ds.xml | sed -e 's/^[ \t]*//' -e 's/<password>//' -e 's/<\/password>//'`
dbhost=`grep -m 1 'connection-url' /var/lib/jboss/server/web/deploy/CR_${crEnv}-ds.xml | sed -e 's/^[ \t]*//' -e 's|<connection-url>jdbc\:mysql\://||' -e 's|\:.*$||'`
dbport=`grep -m 1 'connection-url' /var/lib/jboss/server/web/deploy/CR_${crEnv}-ds.xml | sed -e 's/^[ \t]*//' -e 's|<connection-url>jdbc\:mysql\://||' -e 's|^.*\:||' -e 's|/.*$||'`
dbname=`grep -m 1 'connection-url' /var/lib/jboss/server/web/deploy/CR_${crEnv}-ds.xml | sed -e 's/^[ \t]*//' -e 's|<connection-url>jdbc\:mysql\://||' -e 's|^.*[0-9][0-9][0-9][0-9]/||' -e 's|<.*$||'`
echo "lf"

cmd="mtest -u $dbuser -p $dbpass -h ${dbhost} -P ${dbport} ${dbname}"
# -se "select max(CustomerID) from tbl_Customer"
echo "command: $cmd"
#maxcust=`$cmd | grep -v CustomerID`
echo "dbuser: $dbuser"
echo "dbpass: $dbpass"
echo "dbhost: $dbhost"
echo "dbport: $dbport"
echo "dbname: $dbname"
echo "db cmd: mysql -u${dbuser} -p${dbpass} -h ${dbhost} -P ${dbport} ${dbname} -se \"select max(CustomerID) from tbl_Customer\" | grep -v CustomerID"
echo "maxcust: $maxcust"