| 1 | #!/usr/bin/env bash |
| 2 | |
| 3 | CALLEDPATH=`dirname $0` |
| 4 | |
| 5 | # Convert to an absolute path if necessary |
| 6 | case "$CALLEDPATH" in |
| 7 | .*) |
| 8 | CALLEDPATH="$PWD/$CALLEDPATH" |
| 9 | ;; |
| 10 | esac |
| 11 | |
| 12 | if [ ! -f "$CALLEDPATH/setup.conf" ]; then |
| 13 | echo |
| 14 | echo "Missing configuration file. Please copy $CALLEDPATH/setup.conf.txt to $CALLEDPATH/setup.conf and edit it." |
| 15 | exit 1 |
| 16 | fi |
| 17 | |
| 18 | source "$CALLEDPATH/setup.conf" |
| 19 | |
| 20 | if [ "$1" = '-h' ] || [ "$1" = '--help' ]; then |
| 21 | echo; echo Usage: setup.sh [schema file] [database data file] [database name] [database user] [database password] [additional args]; echo |
| 22 | exit 0 |
| 23 | fi |
| 24 | |
| 25 | |
| 26 | # fetch command line arguments if available |
| 27 | if [ ! -z $1 ] ; then SCHEMA=$1; fi |
| 28 | if [ ! -z $2 ] ; then DBLOAD=$2; fi |
| 29 | if [ ! -z $3 ] ; then DBNAME=$3; fi |
| 30 | if [ ! -z $4 ] ; then DBUSER=$4; fi |
| 31 | if [ ! -z $5 ] ; then DBPASS=$5; fi |
| 32 | |
| 33 | # verify if we have at least DBNAME given |
| 34 | if [ -z $DBNAME ] ; then |
| 35 | echo "No database name defined!" |
| 36 | exit 1 |
| 37 | fi |
| 38 | if [ -z $DBUSER ] ; then |
| 39 | echo "No database username defined!" |
| 40 | exit 1 |
| 41 | fi |
| 42 | if [ -z $DBPASS ] ; then |
| 43 | read -p "Database password:" |
| 44 | DBPASS=$REPLY |
| 45 | fi |
| 46 | |
| 47 | # run code generator if it's there - which means it's |
| 48 | # checkout, not packaged code |
| 49 | if [ -d $CALLEDPATH/../xml ]; then |
| 50 | cd $CALLEDPATH/../xml |
| 51 | "$PHP5PATH"php GenCode.php $SCHEMA |
| 52 | fi |
| 53 | |
| 54 | # someone might want to use empty password for development, |
| 55 | # let's make it possible - we asked before. |
| 56 | if [ -z $DBPASS ]; then # password still empty |
| 57 | PASSWDSECTION="" |
| 58 | else |
| 59 | PASSWDSECTION="-p$DBPASS" |
| 60 | fi |
| 61 | |
| 62 | cd $CALLEDPATH/../sql |
| 63 | echo; echo "Dropping civicrm_* tables from database $DBNAME" |
| 64 | # mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME |
| 65 | MYSQLCMD="mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME" |
| 66 | echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \ |
| 67 | | $MYSQLCMD \ |
| 68 | | grep '^\(civicrm_\|log_civicrm_\)' \ |
| 69 | | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \ |
| 70 | | $MYSQLCMD |
| 71 | echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \ |
| 72 | | $MYSQLCMD \ |
| 73 | | grep '^\(civicrm_\|log_civicrm_\)' \ |
| 74 | | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \ |
| 75 | | $MYSQLCMD |
| 76 | |
| 77 | |
| 78 | echo; echo Creating database structure |
| 79 | mysql -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm.mysql |
| 80 | |
| 81 | # load civicrm_generated.mysql sample data unless special DBLOAD is passed |
| 82 | if [ -z $DBLOAD ]; then |
| 83 | echo; echo Populating database with example data - civicrm_generated.mysql |
| 84 | mysql -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_generated.mysql |
| 85 | else |
| 86 | echo; echo Populating database with required data - civicrm_data.mysql |
| 87 | mysql -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_data.mysql |
| 88 | echo; echo Populating database with $DBLOAD data |
| 89 | mysql -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME < $DBLOAD |
| 90 | fi |
| 91 | |
| 92 | # load additional script if DBADD defined |
| 93 | if [ ! -z $DBADD ]; then |
| 94 | echo; echo Loading $DBADD |
| 95 | mysql -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME < $DBADD |
| 96 | fi |
| 97 | |
| 98 | # run the cli script to build the menu and the triggers |
| 99 | cd $CALLEDPATH/.. |
| 100 | "$PHP5PATH"php bin/cli.php -e System -a flush --triggers 1 --session 1 |
| 101 | |
| 102 | # reset config_backend and userFrameworkResourceURL which gets set |
| 103 | # when config object is initialized |
| 104 | mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME -e "UPDATE civicrm_domain SET config_backend = NULL; UPDATE civicrm_setting SET value = NULL WHERE name = 'userFrameworkResourceURL';" |
| 105 | |
| 106 | echo; echo "Setup Complete. Logout from your CMS to avoid session conflicts." |
| 107 | |