#!/bin/bash

PREFIX=jos_
PASSWD=asdzxc
DBUSER=joomla
DBPASS=joomla
DBNAME=joomla_16 # Database for test site
UNITDB=joomla_ut # Database for unit tests
SYSTDB=joomla_st # Database for system tests

### No need to edit below this line ###

PASSWORD=$(echo -n "$PASSWD" | md5sum | awk '{print $1}')
echo Clearing cache
rm -rf cache/*
echo Clearing tmp
rm -rf tmp/*
echo Reverting trunk
svn revert -R .
echo Updating SVN
svn up --username anonymous
echo Recreating database
mysql -e "DROP DATABASE $DBNAME"
mysql -e "CREATE DATABASE $DBNAME"
mysql -e "GRANT ALL PRIVILEGES ON ${DBNAME}.* to '${DBUSER}'@'localhost' IDENTIFIED BY '${DBPASS}'"
sed -e "s/#__/$PREFIX/g" installation/sql/mysql/joomla.sql > clean_joomla.sql
sed -e "s/#__/$PREFIX/g" installation/sql/mysql/sample_data.sql > clean_sample_data.sql
echo Adding structure
mysql $DBNAME < clean_joomla.sql
echo Adding sample data
mysql $DBNAME < clean_sample_data.sql
rm -f clean_*.sql
echo Adding admin account
mysql $DBNAME -e "REPLACE INTO ${PREFIX}users SET id = 42, name = 'Super User', username = 'admin', email = 'admin@test.com', password = '$PASSWORD', usertype = 'deprecated', block = 0, sendEmail = 1, registerDate = '2010-07-01 17:45:34', lastvisitDate = '0000-00-00 00:00:00', activation = '', params = ''"
mysql $DBNAME -e "REPLACE INTO ${PREFIX}user_usergroup_map SET user_id = 42, group_id = 8"
echo All Done!