killbill-memoizeit

Merge pull request #384 from david-xie/db-helper Add -H

8/24/2015 12:51:55 PM

Changes

bin/db-helper 15(+9 -6)

Details

bin/db-helper 15(+9 -6)

diff --git a/bin/db-helper b/bin/db-helper
index 929c59a..95761e6 100755
--- a/bin/db-helper
+++ b/bin/db-helper
@@ -19,7 +19,7 @@
 #                                                                                 #
 ###################################################################################
 
-#set -x
+# set -x
 
 HERE=`cd \`dirname $0\`; pwd`
 TOP=$HERE/..
@@ -27,6 +27,7 @@ TOP=$HERE/..
 POM="$TOP/pom.xml"
 
 ACTION=
+HOST="localhost"
 DATABASE="killbill"
 USER="root"
 PWD="root"
@@ -42,6 +43,7 @@ SKIP="(server)"
 function usage() {
     echo -n "./db_helper "
     echo -n " -a <create|clean|dump>"
+    echo -n " -H MySQL host (default = localhost)"
     echo -n " -d database_name (default = killbill)"
     echo -n " -u user_name (default = root)"
     echo -n " -p password (default = root)"
@@ -106,7 +108,7 @@ function create_ddl_file() {
 
     local tmp="/tmp/ddl-$DATABASE.$$"
     touch $tmp
-    echo "/*! use $DATABASE; */" >> $tmp
+    echo "use $DATABASE;" >> $tmp
     echo "" >> $tmp
     for d in $ddls; do
         cat $d >> $tmp
@@ -120,10 +122,11 @@ function cleanup() {
 }
 
 
-while getopts ":a:d:u:p:f:t" options; do
+while getopts ":a:d:H:u:p:f:t" options; do
   case $options in
     a ) ACTION=$OPTARG;;
 	d ) DATABASE=$OPTARG;;
+	H ) HOST=$OPTARG;;
 	u ) USER=$OPTARG;;
 	p ) PWD=$OPTARG;;
 	t ) TEST_ALSO=1;;
@@ -152,15 +155,15 @@ fi
 
 if [ $ACTION == "create" ]; then
     DDL_FILE=`create_ddl_file`
-    echo "Applying new schema $tmp to database $DATABASE"
-    mysql -u $USER --password=$PWD < $DDL_FILE
+    echo "Applying new schema to database $DATABASE"
+    mysql -h $HOST -u $USER --password=$PWD < $DDL_FILE
 fi
 
 if [ $ACTION == "clean" ]; then
     DDL_FILE=`create_ddl_file`
     CLEAN_FILE=`create_clean_file $DDL_FILE`
     echo "Cleaning db tables on database $DATABASE"
-    mysql -u $USER --password=$PWD < $DDL_FILE
+    mysql -h $HOST -u $USER --password=$PWD < $DDL_FILE
 fi
 
 cleanup