Drupal Local Update Script

site_reset.sh

sitereset () {
  source $HOME/sql_slurp.sh

  if [[ $# < 2 ]]; then
    echo "You must specify at least an alias and a multisite directory name."
    return
  fi
  read -p "Would you like to run updates (y/n)? " updb
  alias=$1
  site=$2
  local_dir="$(drush drupal-directory $site)"
  echo "cd $local_dir"
  cd $local_dir
  #echo "drush sql-sync -y --no-cache $alias $site"
  echo "SQL Slurping $alias $site ..."
  _sql-slurp $alias $site
  echo "drush vset --yes preprocess_css 0"
  drush vset --yes preprocess_css 0
  echo "drush vset --yes preprocess_js 0"
  drush vset --yes preprocess_js 0
  #echo "drush vset --yes admin_menu_cache_client 0"
  #drush vset --yes admin_menu_cache_client 0
  echo "drush en -y stage_file_proxy devel ${@:3}"
  drush en -y stage_file_proxy devel dblog ${@:3}
  if [ "$updb" == "y" ]; then
    echo "drush updb -y"
    drush updb -y
  fi
  echo "drush cc all"
  drush cc all
}

sitereset "$@"

sql_slurp.sh

sql-slurp () {
        derp="^@\w+\.\w+"
        if [[ ! $1 =~ $derp ]]; then
                printf "Derp, that's not an alias!\n"
                return 1
        fi
        printf "This will overwrite the $2 database with the $1 database.\n"
        printf "\n\t\t*** $1 -> $2 ***\n\n"
        sleep 3s
        read -p "Are you sure [Y/n]? " -n 1 -r
        if [[ $REPLY  =~ ^[Yy]$ ]]; then
                drush $2 sql-drop -y
                printf "\n"
                drush $1 sql-dump | pv -br | drush $2 sql-cli -A
        fi
        printf "\n"
}

sql-slurp "@"