# push a local WP database to an existing staging site
# uses current directory as theme path and ssh alias
pushstage() {
    START=$(date +%s)
    # make a backup of the current local database
    # get current directory name, used for database and URL
    current=${PWD##*/}
    cd ~/Sites/$current || return

    # rsync the local database to staging site
    wp db export $current.sql
    rsync $current.sql $current-s:~/

    # make a backup of the staging database
    wp @stage db export backup.sql
    # reset the staging database
    wp @stage db reset --yes

     # import our rsynced local database and update URLs
    wp @stage db import $current.sql
    wp @stage search-replace "$current.localhost" "$current.dmctest.com.au" --all-tables

    # deactivate plugins that aren't needed
    wp @stage plugin deactivate debug-bar query-monitor acf-theme-code-pro wordpress-seo
    # Discourage search engines from indexing this site
    wp @stage option update blog_public 0

    cd ~/Sites/$current/wp-content/themes/$current
    END=$(date +%s)
    DIFF=$(( $END - $START ))
    echo -e "\n$current.localhost database now in use on $push_staging_url site.\nIt took $DIFF seconds, enjoy!\n"
}