Changeset 39021 for trunk/ippToPsps/test/mkgpc1.sh

Timestamp:

Nov 2, 2015, 7:53:00 AM (11 years ago)

Author:

eugene

Message:

add mkcmf -forcedgalaxy; add forcedelete mode to mkgpc1

File:

• trunk/ippToPsps/test/mkgpc1.sh (modified) (1 diff)

trunk/ippToPsps/test/mkgpc1.sh

@@ -68 +68 @@
 endif
 
+if ("$1" == "forcedelete") then
+  if ($#argv < 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+  if ($#argv == 5) then
+    set dbpass = "-p$5"
+  else 
+    set dbpass = "-p"
+  endif
+
+  (mysql -B -h $dbhost -u $dbuser $dbpass -e "show databases" | grep ^$dbname\$) >& /dev/null
+  if ($status) then
+    echo "database $dbname does not yet exist"
+    exit 0
+  endif
+
+  mysql -h $dbhost -u $dbuser $dbpass $dbname -e "describe ippToPspsFake" >& /dev/null
+  if ($status) then
+    echo "database does not contain ippToPspsFake, not deleting"
+    exit 1;
+  endif
+
+  set ntable = `mysql -B -h $dbhost -u $dbuser $dbpass $dbname -e "show tables" | wc -l`
+  echo ntable: $ntable
+  if ($ntable != 28) then
+    echo "warning: expected 28 lines (27 tables), but got $ntable; still deleting"
+  else
+    echo "database is valid, deleting"
+  endif
+
+  mysql -h $dbhost -u $dbuser $dbpass -e "drop database $dbname"
+  exit 0;
+endif
+
 usage:
   echo "USAGE: mkgpc1.sh (options)"