bin/setup.sh

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