vvv-init.sh

#!/bin/bash
# Just a human readable description of this site
SITE_NAME="site-name"
# The name (to be) used by MySQL for the DB
DB_NAME="site-name"
# Values for searching and replacing
SEARCHDOMAIN="site-name.wpengine.com"
REPLACEDOMAIN="local.site-name"
# Site URL
SITE_URL="http://local.site-name"
# Wordpress multisite network (true/false)
MULTISITE=false
# Append additional config to wp-config.php
EXTRA_CONFIG="
// No extra config, but if there was it would go here.
"
RED='\033[0;31m'
GREEN='\033[0;32m'
NC='\033[0m' # No Color

# ----------------------------------------------------------------
# You should not need to edit below this point. Famous last words.

echo "---------------------------"
echo "Commencing $SITE_NAME setup"

# Add GitHub and GitLab to known_hosts, so we don't get prompted
# to verify the server fingerprint.
# The fingerprints in [this repo]/ssh/known_hosts are generated as follows:
#
# As the starting point for the ssh-keyscan tool, create an ASCII file
# containing all the hosts from which you will create the known hosts
# file, e.g. sshhosts.
# Each line of this file states the name of a host (alias name or TCP/IP
# address) and must be terminated with a carriage return line feed
# (Shift + Enter), e.g.
#
# bitbucket.org
# github.com
# gitlab.com
#
# Execute ssh-keyscan with the following parameters to generate the file:
#
# ssh-keyscan -t rsa,dsa -f ssh_hosts >ssh/known_hosts
# The parameter -t rsa,dsa defines the host’s key type as either rsa
# or dsa.
# The parameter -f /home/user/ssh_hosts states the path of the source
# file ssh_hosts, from which the host names are read.
# The parameter >ssh/known_hosts states the output path of the
# known_host file to be created.
#
# From "Create Known Hosts Files" at:
# http://tmx0009603586.com/help/en/entpradmin/Howto_KHCreate.html
mkdir -p ~/.ssh
touch ~/.ssh/known_hosts
IFS=$'\n'
for KNOWN_HOST in $(cat "ssh/known_hosts"); do
	if ! grep -Fxq "$KNOWN_HOST" ~/.ssh/known_hosts; then
	    echo "Adding host to SSH known_hosts for user 'root': $(echo $KNOWN_HOST |cut -d '|' -f1)"
	    echo $KNOWN_HOST >> ~/.ssh/known_hosts
	fi
done


# Run Composer
echo "Running Composer to download dependencies"
composer install --prefer-dist

#Multi site configuration
if $MULTISITE; then
	MULTISITE_CONFIG="
	define('WP_ALLOW_MULTISITE', true);
	//define('MULTISITE', true);
	//define('SUBDOMAIN', true);
	//define('DOMAIN_CURRENT_SITE', '$SITE_URL');
	//define('PATH_CURRENT_SITE', '/');
	//define('SITE_ID_CURRENT_SITE', 1);
	//define('BLOG_ID_CURRENT_SITE', 1);
"
	echo "WP Multisite settings saved"
else
	MULTISITE_CONFIG=""
	echo "$SITE_NAME is not a WP multisite..."
fi

# Let's get some config in the house
if [ ! -f public_html/wp-config.php ]; then
	echo "Creating wp-config.php and moving it up into public_html because we like it there"
	wp core config --allow-root --dbname="$DB_NAME" --dbuser=wp --dbpass=wp --dbhost="localhost" --extra-php <<PHP
define( 'WP_HOME', "http://local.$SITE_NAME" );
define( 'WP_SITEURL', "http://local.$SITE_NAME/wp" );
define( 'WP_CONTENT_DIR', dirname( __FILE__ ) . '/wp-content' );
define( 'WP_CONTENT_URL', "http://local.$SITE_NAME/wp-content" );
define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define('WP_DEBUG_DISPLAY', false);
define('SAVEQUERIES', true);
$EXTRA_CONFIG
$MULTISITE_CONFIG
PHP
	mv public_html/wp/wp-config.php public_html/wp-config.php
else
	echo "wp-config.php already exists"
fi
# Move index.php and change path to blog-header so that we can run WordPress in a sub-directory
if [ ! -f public_html/index.php ]; then

	echo "Copying index.php and moving it up into public_html because we like it there"

	cp public_html/wp/index.php public_html/index.php
	sed -i -e "s/wp-blog-header.php/wp\/wp-blog-header.php/g" public_html/index.php
else
	echo "index.php already exists"
fi
# Load the composer stuff
./wrapper-composer.sh update

# DATA_IN_DB=`mysql -u root --password=root --skip-column-names -e "SHOW TABLES FROM $DB_NAME;"`
# if [ "" == "$DATA_IN_DB" ]; then
# 	if [ ! -f initial-data.sql ]
# 	then
# 		echo "DATABASE NOT INSTALLED, add initial-data.sql file and run Vagrant provisioning again"
# 	else
# 		echo "Loading the database with lovely data"
# 		mysql -u root --password=root $DB_NAME < initial-data.sql
# 	fi
# 	wp user create dev_admin dev_admin@example.com --role=administrator --user_pass=password
# else
# 	echo "index.php already exists"
# fi

# Make a database, if we don't already have one
DATA_IN_DB=`mysql -u root --password=root --skip-column-names -e "SHOW TABLES FROM $DB_NAME;"`
if [ "" == "$DATA_IN_DB" ]; then
	echo "Creating database (if it's not already there)"
	mysql -u root --password=root -e "CREATE DATABASE IF NOT EXISTS $DB_NAME"
	mysql -u root --password=root -e "GRANT ALL PRIVILEGES ON $DB_NAME.* TO wp@localhost IDENTIFIED BY 'wp';"

	if [ -f $DB_NAME.sql ]; then
		echo "Importing DB content from dump file"

		wp db import --allow-root $DB_NAME.sql
		wp search-replace --allow-root "$SEARCHDOMAIN" "$REPLACEDOMAIN"
	elif ! $(wp core is-installed ); then
		echo "Installing initial WordPress DB tables"
		wp core install --allow-root --title=$SITE_NAME --admin_user=admin --admin_password=password --admin_email=admin@no.reply
		wp option update --allow-root siteurl "$SITE_URL\/wp"

	fi
else
	echo "database $DB_NAME already exists and has data"
fi


# The Vagrant site setup script will restart Nginx for us

echo "$SITE_NAME init is complete";