Changeset 34919 for branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh

Timestamp:

Jan 12, 2013, 2:24:56 PM (14 years ago)

Author:

eugene

Message:

add buffered inserts with multiple rows per insert

File:

• branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh (modified) (1 diff)

branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh

@@ -47 +47 @@
 endif
 
+if ("$1" == "delete") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+
+  mysql -h $dbhost -u $dbuser -p <<EOF > /dev/null
+   USE $dbname;
+   describe dvoDetection;
+EOF
+
+  if ($status) then
+    echo "database does not contain dvoDetections, not deleting"
+    exit 1;
+  endif
+
+  echo "database is valid, deleting"
+  mysql -h $dbhost -u $dbuser -p <<EOF
+   drop database $dbname;
+EOF
+
+   exit 0;
+endif
+
 usage:
   echo "USAGE: dbadmin.sh (options)"