From dc1d6b8d2bab00179d273cd9be2172dc97acb883 Mon Sep 17 00:00:00 2001 From: Deepak Srivastava Date: Fri, 19 Apr 2013 19:25:27 +0530 Subject: [PATCH] scripts for managing demo sites and their pristines --- tools/scripts/demo/demo.conf.txt | 18 ++++++ tools/scripts/demo/load-pristine-joomla | 17 ++++++ tools/scripts/demo/load-pristine-wordpress | 17 ++++++ tools/scripts/demo/save-pristine-joomla | 17 ++++++ tools/scripts/demo/save-pristine-wordpress | 17 ++++++ tools/scripts/demo/update-demo-all | 64 ++++++++++++++++++++++ 6 files changed, 150 insertions(+) create mode 100644 tools/scripts/demo/demo.conf.txt create mode 100755 tools/scripts/demo/load-pristine-joomla create mode 100755 tools/scripts/demo/load-pristine-wordpress create mode 100755 tools/scripts/demo/save-pristine-joomla create mode 100755 tools/scripts/demo/save-pristine-wordpress create mode 100755 tools/scripts/demo/update-demo-all diff --git a/tools/scripts/demo/demo.conf.txt b/tools/scripts/demo/demo.conf.txt new file mode 100644 index 0000000000..28beeff38f --- /dev/null +++ b/tools/scripts/demo/demo.conf.txt @@ -0,0 +1,18 @@ +# tmp dump file +TMP_DUMP_FILE= + +# Define the path for civicrm demo svn source directory here +CIVI_DEMO_DIR= + +# Define drupal-db-name and pristine path along with file-name +DRUPAL_DEMO_DBNAME= +DRUPAL_DEMO_PRISTINE= + +# Define wordpress-db-name and pristine path along with file-name +WORDPRESS_DEMO_DBNAME= +WORDPRESS_DEMO_PRISTINE= + +# Define wordpress-db-name and pristine path along with file-name +JOOMLA_DEMO_DBNAME= +JOOMLA_DEMO_PRISTINE= + diff --git a/tools/scripts/demo/load-pristine-joomla b/tools/scripts/demo/load-pristine-joomla new file mode 100755 index 0000000000..6259c5ff4d --- /dev/null +++ b/tools/scripts/demo/load-pristine-joomla @@ -0,0 +1,17 @@ +#!/usr/bin/env /bin/bash + +source `dirname $0`/demo.conf + +pushd . + +# load fromm joomla pristine +if [ $JOOMLA_DEMO_DBNAME ]; then + if [ -f $JOOMLA_DEMO_PRISTINE ]; then + mysqladmin -f drop $JOOMLA_DEMO_DBNAME + mysqladmin create $JOOMLA_DEMO_DBNAME + echo "Reloading civicrm-joomla-demo from pristine.." + mysql $JOOMLA_DEMO_DBNAME < $JOOMLA_DEMO_PRISTINE + fi +fi + +popd diff --git a/tools/scripts/demo/load-pristine-wordpress b/tools/scripts/demo/load-pristine-wordpress new file mode 100755 index 0000000000..858d40edb3 --- /dev/null +++ b/tools/scripts/demo/load-pristine-wordpress @@ -0,0 +1,17 @@ +#!/usr/bin/env /bin/bash + +source `dirname $0`/demo.conf + +pushd . + +if [ $WORDPRESS_DEMO_DBNAME ]; then + # wordpress pristine + if [ -f $WORDPRESS_DEMO_PRISTINE ]; then + mysqladmin -f drop $WORDPRESS_DEMO_DBNAME + echo "Reloading civicrm-wordpress-demo db from pristine.." + mysqladmin create $WORDPRESS_DEMO_DBNAME + mysql $WORDPRESS_DEMO_DBNAME < $WORDPRESS_DEMO_PRISTINE + fi +fi + +popd diff --git a/tools/scripts/demo/save-pristine-joomla b/tools/scripts/demo/save-pristine-joomla new file mode 100755 index 0000000000..2484b14429 --- /dev/null +++ b/tools/scripts/demo/save-pristine-joomla @@ -0,0 +1,17 @@ +#!/usr/bin/env /bin/bash + +source `dirname $0`/demo.conf + +pushd . + +# create joomla pristine +if [ $JOOMLA_DEMO_DBNAME ]; then + echo "Taking civicrm-joomla-demo db dump.." + mysqldump $JOOMLA_DEMO_DBNAME > $TMP_DUMP_FILE + if [ -f $JOOMLA_DEMO_PRISTINE ]; then + echo "Creating civicrm-joomla-demo pristine from dump.." + cp $TMP_DUMP_FILE $JOOMLA_DEMO_PRISTINE + fi +fi + +popd diff --git a/tools/scripts/demo/save-pristine-wordpress b/tools/scripts/demo/save-pristine-wordpress new file mode 100755 index 0000000000..05f84aad84 --- /dev/null +++ b/tools/scripts/demo/save-pristine-wordpress @@ -0,0 +1,17 @@ +#!/usr/bin/env /bin/bash + +source `dirname $0`/demo.conf + +pushd . + +# creating wordpress pristine +if [ $WORDPRESS_DEMO_DBNAME ]; then + if [ -f $WORDPRESS_DEMO_PRISTINE ]; then + echo "Taking civicrm-wordpress-demo db dump.." + mysqldump $WORDPRESS_DEMO_DBNAME > $TMP_DUMP_FILE + echo "Creating civicrm-wordpress-demo pristine from dump.." + cp $TMP_DUMP_FILE $WORDPRESS_DEMO_PRISTINE + fi +fi + +popd diff --git a/tools/scripts/demo/update-demo-all b/tools/scripts/demo/update-demo-all new file mode 100755 index 0000000000..b7c8c643c4 --- /dev/null +++ b/tools/scripts/demo/update-demo-all @@ -0,0 +1,64 @@ +#!/usr/bin/env /bin/bash + +source `dirname $0`/demo.conf + +pushd . + +# run regen.sh +echo "Running $CIVI_DEMO_DIR/bin/regen.sh.." +cd $CIVI_DEMO_DIR/bin +./regen.sh + +echo "cd $CIVI_DEMO_DIR/sql" +cd $CIVI_DEMO_DIR/sql + +if [ $DRUPAL_DEMO_DBNAME ]; then + # drupal pristine + echo "Reloading civicrm-drupal-demo db from generated.mysql .." + mysqladmin -f drop $DRUPAL_DEMO_DBNAME + mysqladmin create $DRUPAL_DEMO_DBNAME + mysql $DRUPAL_DEMO_DBNAME < civicrm.mysql + mysql $DRUPAL_DEMO_DBNAME < civicrm_generated.mysql + echo "Taking civicrm-drupal-demo dump.." + mysqldump $DRUPAL_DEMO_DBNAME > $TMP_DUMP_FILE + if [ -f $DRUPAL_DEMO_PRISTINE ]; then + echo "Creating civicrm-drupal-demo pristine.." + cp $TMP_DUMP_FILE $DRUPAL_DEMO_PRISTINE + fi +fi + +if [ ! -f $TMP_DUMP_FILE ]; then + exit 1 +fi + +if [ $WORDPRESS_DEMO_DBNAME ]; then + # wordpress pristine + if [ -f $WORDPRESS_DEMO_PRISTINE ]; then + echo "Creating civicrm-wordpress-demo pristine.." + cp $TMP_DUMP_FILE $WORDPRESS_DEMO_PRISTINE + fi + mysqladmin -f drop $WORDPRESS_DEMO_DBNAME + echo "Reloading civicrm-wordpress-demo from pristine.." + mysqladmin create $WORDPRESS_DEMO_DBNAME + mysql $WORDPRESS_DEMO_DBNAME < $TMP_DUMP_FILE +fi + +if [ $JOOMLA_DEMO_DBNAME ]; then + # joomla pristine + if [ -f $JOOMLA_DEMO_PRISTINE ]; then + echo "Taking civicrm-joomla-demo pristine backup.." + cp $JOOMLA_DEMO_PRISTINE $JOOMLA_DEMO_PRISTINE.bak + fi + echo "Dropping civicrm_* tables from civicrm-joomla-demo db.." + mysql $JOOMLA_DEMO_DBNAME < civicrm_drop.mysql + echo "Reloading civicrm-joomla-demo with fresh civicrm_* tables.." + mysql $JOOMLA_DEMO_DBNAME < $TMP_DUMP_FILE + echo "Taking civicrm-joomla-demo db dump.." + mysqldump $JOOMLA_DEMO_DBNAME > $TMP_DUMP_FILE + if [ -f $JOOMLA_DEMO_PRISTINE ]; then + echo "Creating civicrm-joomla-demo pristine from dump.." + cp $TMP_DUMP_FILE $JOOMLA_DEMO_PRISTINE + fi +fi + +popd -- 2.25.1