svn commit: r1345387 - in /incubator/ambari/branches/ambari-186: CHANGES.txt hmc/ShellScripts/cleanupHMCDB.sh

[vi...@apache.org]

Author: vikram
Date: Fri Jun  1 23:02:43 2012
New Revision: 1345387

URL: http://svn.apache.org/viewvc?rev=1345387&view=rev
Log:
AMBARI-313. Provide a DB cleanup script. Missed file Vikram. (Contributed by Hitesh)

Added:
    incubator/ambari/branches/ambari-186/hmc/ShellScripts/cleanupHMCDB.sh
Modified:
    incubator/ambari/branches/ambari-186/CHANGES.txt

Modified: incubator/ambari/branches/ambari-186/CHANGES.txt
URL: http://svn.apache.org/viewvc/incubator/ambari/branches/ambari-186/CHANGES.txt?rev=1345387&r1=1345386&r2=1345387&view=diff
==============================================================================
--- incubator/ambari/branches/ambari-186/CHANGES.txt (original)
+++ incubator/ambari/branches/ambari-186/CHANGES.txt Fri Jun  1 23:02:43 2012
@@ -6,6 +6,8 @@ characters wide.
 
 Release 0.1.x - unreleased
 
+  AMBARI-313. Provide a DB cleanup script. Missed script (Hitesh via Vikram)
+
   AMBARI-313. Provide a DB cleanup script. (Hitesh via Vikram)
 
   AMBARI-312. Uninstall's wipe flag should be correctly passed to puppet. (Hitesh via Vikram)

Added: incubator/ambari/branches/ambari-186/hmc/ShellScripts/cleanupHMCDB.sh
URL: http://svn.apache.org/viewvc/incubator/ambari/branches/ambari-186/hmc/ShellScripts/cleanupHMCDB.sh?rev=1345387&view=auto
==============================================================================
--- incubator/ambari/branches/ambari-186/hmc/ShellScripts/cleanupHMCDB.sh (added)
+++ incubator/ambari/branches/ambari-186/hmc/ShellScripts/cleanupHMCDB.sh Fri Jun  1 23:02:43 2012
@@ -0,0 +1,36 @@
+#!/bin/sh
+
+dbFile="/var/db/hmc/data/data.db"
+
+if [[ "x" != "x$1" ]]; then
+  dbFile=$1
+fi
+
+if [[ ! -f ${dbFile} ]]; then
+  echo "DB file ${dbFile} does not exist";
+  exit 1
+fi
+
+while true; do
+  read -p "Are you really sure you want to wipe out the DB at ${dbFile}? (y/n)" yn  
+  case $yn in
+    [Yy]* ) break;;
+    [Nn]* ) echo "User aborted script. Exiting without cleaning up DB"; exit 0;;
+    * ) echo "Please answer y or n.";;
+  esac
+done
+
+echo "Deleting data from DB ${dbFile}, restoring to clean state"
+
+sqlite3 ${dbFile} "Delete FROM Clusters;"
+sqlite3 ${dbFile} "DELETE FROM ServiceInfo;"
+sqlite3 ${dbFile} "DELETE FROM ServiceComponentInfo;"
+sqlite3 ${dbFile} "DELETE FROM ServiceConfig;"
+sqlite3 ${dbFile} "DELETE FROM Hosts;"
+sqlite3 ${dbFile} "DELETE FROM HostRoles;"
+sqlite3 ${dbFile} "DELETE FROM HostRoleConfig;"
+sqlite3 ${dbFile} "DELETE FROM ConfigHistory;"
+sqlite3 ${dbFile} "DELETE FROM TransactionStatus;"
+sqlite3 ${dbFile} "DELETE FROM SubTransactionStatus;"
+
+exit 0;
\ No newline at end of file