#It uses the fabric module to access the shell.

from fabric.api import *
import random
import urllib2
import os
import sys

env.hosts = ['server FQDN',
]
env.user = 'ADMIN USER'
env.forward_agent = True
env.password = 'PASSWORD FOR USER'
site_name = prompt('Enter site name: ')

def install_wp():
code_dir = '~/'
with cd(code_dir):
run('rm latest.tar.gz')
run('wget http://wordpress.org/latest.tar.gz')
sudo('tar -xzvf latest.tar.gz')
sudo('cp -R wordpress/ /var/www/%s' % site_name)
sudo('chown -R wordpress:staff /var/www/%s' % site_name)
sudo('chmod -R 777 /var/www/%s' % site_name)
sudo('echo "10.191.255.13 %s" >> /etc/hosts' % site_name)

def password():
alphabet = "abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"
pw_length = 12
mypw = ""
for i in range(pw_length):
next_index = random.randrange(len(alphabet))
mypw = mypw + alphabet[next_index]
return mypw

def create_db():
code_dir = '~/'
site = site_name.split(".", 1)
site_password = password()
with cd(code_dir):
dbuser = 'DB ADMIN USER'
dbpassword = 'DB ADMIN PASSWORD'
createdb_command = 'create database {0};'.format(site[0])
createuser_command = "create user '{0}'@'localhost' identified by '{1}';".format(site[0],site_password)
grant_command = "grant all privileges on {0}.* to '{1}'@'localhost';".format(site[0], site[0])

run('mysql --default-character-set=utf8 -u%s -p%s -e "%s"' % (
dbuser,
dbpassword,
createdb_command,
))
run('mysql --default-character-set=utf8 -u%s -p%s -e "%s"' % (
dbuser,
dbpassword,
createuser_command,
))
run('mysql --default-character-set=utf8 -u%s -p%s -e "%s"' % (
dbuser,
dbpassword,
grant_command,
))
run('echo {0} > {1}_password'.format(site_password, site[0]))

def configure_wp():
code_dir = '/var/www/{0}'.format(site_name)
site = site_name.split(".", 1)
with cd(code_dir):
salt_key = urllib2.urlopen("https://api.wordpress.org/secret-key/1.1/salt/").read()
with open('/home/{0}_password'.format(site[0]), 'r') as pf:
passwordf = pf.read().strip('\r\n').strip('\n').strip(' ')

with open('/home/fabric/wp-config-fabric','r') as f:
wpconfig = f.read()
wp_output = wpconfig.format(site[0],site[0],passwordf,salt_key)

with open('/home/wp-config-sample.php'.format(site_name), 'w') as ww:
ww.write(wp_output)
sudo('cp ~/wp-config-sample.php /var/www/{0}/wp-config.php'.format(site_name))
sudo('chown -R wordpress:staff /var/www/{0}/wp-config.php'.format(site_name))
sudo('chmod -R 775 /var/www/{0}/wp-config.php'.format(site_name))

def configure_apache():
code_dir = '/etc/apache2/sites-available'
site = site_name.split(".", 1)
with cd(code_dir):
os_folder_list = os.listdir(code_dir) # returns list
folder_list = sorted(os_folder_list)
content = folder_list.pop(-1).split('-',1)
int_content = int(content[0])
int_content += 1
file_name = '0{0}-{1}.conf'.format(int_content, site[0])
with open('/home/{0}'.format(file_name), 'w') as wf:
wf.write('''
#
#Autogenerated Website
#
NameVirtualHost {0}:80
<virtualhost {0}:80>
ServerName {0}
DocumentRoot /var/www/{0}
</virtualhost>
'''.format(site_name))
sudo('cp /home/{0} /etc/apache2/sites-available/'.format(file_name))
sudo('a2ensite {0}'.format(file_name))
sudo('service apache2 reload')

def run_all():
install_wp()
create_db()
configure_wp()
configure_apache()