从shell运行MySQL存储过程

#/bin/bash -ex

# General settings
PWD=`pwd`
#DATE=`date +%Y-%m-%d:%H:%M:%S`
DATE=`date +%Y-%m-%d_%H%M%S`

# Log file
logfile="${PWD}/${DATE}.log"

echo "Program started" > ${logfile} 2>&1

# DB connection info
mysql=`which mysql`
#dbhost=
#dbuser=
#dbpw=
#db=crm
dbhost=
dbuser=
dbpw=
dbport=3306
db=jpcrm
sp=jobId4AssignmnetTask

# fees
feename="EDITOR_ASSIGNMENT_FEE"
feesjp_source="http://s2dev.edanzgroup.com/s2test/custom/modules/edanz_Service_fees/javascript/edanzfees.Japan.js"

# debug parameters
testsql="use ${db}; show tables;"

# ---------- End parameters declaration

# get the fees file for Japan
wget -O feesjp.js ${feesjp_source}

${mysql} -h ${dbhost} -P ${dbport} -u ${dbuser} -p${dbpw} -e "${testsql}"

echo "Program exited with $?" >> ${logfile} 2>&1