bin/setup.sh

   1 #!/usr/bin/env bash
   2 set -e
   3
   4 CALLEDPATH=`dirname $0`
   5
   6 # Convert to an absolute path if necessary
   7 case "$CALLEDPATH" in
   8   .*)
   9     CALLEDPATH="$PWD/$CALLEDPATH"
  10     ;;
  11 esac
  12
  13 if [ ! -f "$CALLEDPATH/setup.conf" ]; then
  14   echo
  15   echo "Missing configuration file. Please copy $CALLEDPATH/setup.conf.txt to $CALLEDPATH/setup.conf and edit it."
  16   exit 1
  17 fi
  18
  19 source "$CALLEDPATH/setup.conf"
  20 source "$CALLEDPATH/setup.lib.sh"
  21
  22 if [ "$1" = '-h' ] || [ "$1" = '--help' ]; then
  23   echo
  24   echo "Usage: setup.sh [options] [schema file] [database data file] [database name] [database user] [database password] [database host] [database port] [additional args]"
  25   echo "[options] is a mix of zero or more of following:"
  26   echo "  -a     (All)       Implies -Dgsdf (default)"
  27   echo "  -D     (Download)  Download depdencies"
  28   echo "  -g     (GenCode)   Generate DAO files, SQL files, etc"
  29   echo "  -s     (Schema)    Load new schema in DB"
  30   echo "  -d     (Data)      Load default data in DB"
  31   echo "  -f     (Flush)     Flush caches and settings"
  32   echo
  33   echo "Example: Perform a full setup"
  34   echo "   setup.sh -a"
  35   echo
  36   echo "Example: Setup all the code but leave the DB alone"
  37   echo "   setup.sh -Dg"
  38   echo
  39   echo "Example: Keep the existing code but reset the DB"
  40   echo "   setup.sh -sdf"
  41   exit 0
  42 fi
  43
  44 ###############################################################################
  45 ## Parse command line options
  46
  47 FOUND_ACTION=
  48 DO_DOWNLOAD=
  49 DO_GENCODE=
  50 DO_SCHEMA=
  51 DO_DATA=
  52 DO_FLUSH=
  53
  54 while getopts "aDgsdf" opt; do
  55   case $opt in
  56     a)
  57       DO_DOWNLOAD=1
  58       DO_GENCODE=1
  59       DO_SCHEMA=1
  60       DO_DATA=1
  61       DO_FLUSH=1
  62       FOUND_ACTION=1
  63       ;;
  64     D)
  65       DO_DOWNLOAD=1
  66       FOUND_ACTION=1
  67       ;;
  68     g)
  69       DO_GENCODE=1
  70       FOUND_ACTION=1
  71       ;;
  72     s)
  73       DO_SCHEMA=1
  74       FOUND_ACTION=1
  75       ;;
  76     d)
  77       DO_DATA=1
  78       FOUND_ACTION=1
  79       ;;
  80     f)
  81       DO_FLUSH=1
  82       FOUND_ACTION=1
  83       ;;
  84     \?)
  85       echo "Invalid option: -$OPTARG" >&2
  86       exit 1
  87       ;;
  88     :)
  89       echo "Option -$OPTARG requires an argument." >&2
  90       exit 1
  91       ;;
  92   esac
  93 done
  94 if [ -z "$FOUND_ACTION" ]; then
  95   DO_DOWNLOAD=1
  96   DO_GENCODE=1
  97   DO_SCHEMA=1
  98   DO_DATA=1
  99   DO_FLUSH=1
 100 fi
 101
 102 shift $((OPTIND-1))
 103
 104 # fetch command line arguments if available
 105 if [ ! -z "$1" ] ; then SCHEMA="$1"; fi
 106 if [ ! -z "$2" ] ; then DBLOAD="$2"; fi
 107 if [ ! -z "$3" ] ; then DBNAME="$3"; fi
 108 if [ ! -z "$4" ] ; then DBUSER="$4"; fi
 109 if [ ! -z "$5" ] ; then DBPASS="$5"; fi
 110 if [ ! -z "$6" ] ; then DBHOST="$6"; fi
 111 if [ ! -z "$7" ] ; then DBPORT="$7"; fi
 112
 113 # verify if we have at least DBNAME given
 114 if [ -z $DBNAME ] ; then
 115   echo "No database name defined!"
 116   exit 1
 117 fi
 118 if [ -z $DBUSER ] ; then
 119   echo "No database username defined!"
 120   exit 1
 121 fi
 122 if [ -z $DBPASS ] ; then
 123   read -p "Database password:"
 124   DBPASS=$REPLY
 125 fi
 126
 127 MYSQLCMD=$(mysql_cmd)
 128 ###############################################################################
 129 ## Execute tasks
 130 set -x
 131
 132 if [ -n "$DO_DOWNLOAD" ]; then
 133   pushd "$CALLEDPATH/.."
 134     composer install
 135     # Install npm and bower modules
 136     npm install
 137   popd
 138 fi
 139
 140 # run code generator if it's there - which means it's
 141 # checkout, not packaged code
 142 if [ -n "$DO_GENCODE" -a -d "$CALLEDPATH/../xml" ]; then
 143   pushd "$CALLEDPATH/../xml"
 144     if [ -z "$DBPORT" ]; then
 145       PHP_MYSQL_HOSTPORT="$DBHOST"
 146     else
 147       PHP_MYSQL_HOSTPORT="$DBHOST:$DBPORT"
 148     fi
 149     "$PHP5PATH"php -d mysql.default_host="$PHP_MYSQL_HOSTPORT" -d mysql.default_user=$DBUSER -d mysql.default_password=$DBPASS GenCode.php $SCHEMA '' ${GENCODE_CMS}
 150   popd
 151 fi
 152
 153 if [ -n "$DO_SCHEMA" ]; then
 154   pushd "$CALLEDPATH/../sql"
 155     echo; echo "Dropping civicrm_* tables from database $DBNAME"
 156     echo "SELECT table_name FROM information_schema.TABLES  WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \
 157       | $MYSQLCMD \
 158       | grep '^\(civicrm_\|log_civicrm_\)' \
 159       | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \
 160       | $MYSQLCMD
 161     echo "SELECT table_name FROM information_schema.TABLES  WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \
 162       | $MYSQLCMD \
 163       | grep '^\(civicrm_\|log_civicrm_\)' \
 164       | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \
 165       | $MYSQLCMD
 166
 167     echo; echo Creating database structure
 168     $MYSQLCMD < civicrm.mysql
 169   popd
 170 fi
 171
 172 if [ -n "$DO_DATA" ]; then
 173   pushd "$CALLEDPATH/../sql"
 174     # load civicrm_generated.mysql sample data unless special DBLOAD is passed
 175     if [ -z $DBLOAD ]; then
 176         echo; echo Populating database with example data - civicrm_generated.mysql
 177         $MYSQLCMD < civicrm_generated.mysql
 178     else
 179         echo; echo Populating database with required data - civicrm_data.mysql
 180         $MYSQLCMD < civicrm_data.mysql
 181         echo; echo Populating database with $DBLOAD data
 182         $MYSQLCMD < $DBLOAD
 183     fi
 184
 185     # load additional script if DBADD defined
 186     if [ ! -z $DBADD ]; then
 187         echo; echo Loading $DBADD
 188         $MYSQLCMD < $DBADD
 189     fi
 190   popd
 191 fi
 192
 193 if [ -n "$DO_FLUSH" ]; then
 194   pushd "$CALLEDPATH/.."
 195     # run the cli script to build the menu and the triggers
 196     "$PHP5PATH"php bin/cli.php -e System -a flush --triggers 1 --session 1
 197
 198     # reset config_backend and userFrameworkResourceURL which gets set
 199     # when config object is initialized
 200     $MYSQLCMD -e "UPDATE civicrm_domain SET config_backend = NULL; UPDATE civicrm_setting SET value = NULL WHERE name = 'userFrameworkResourceURL';"
 201   popd
 202 fi
 203
 204 echo; echo "NOTE: Logout from your CMS to avoid session conflicts."
 205