bin/regen.sh

   1 #!/usr/bin/env /bin/bash
   2
   3 source `dirname $0`/setup.conf
   4
   5 # someone might want to use empty password for development,
   6 # let's make it possible - we asked before.
   7 if [ -z $DBPASS ]; then # password still empty
   8   PASSWDSECTION=""
   9 else
  10   PASSWDSECTION="-p$DBPASS"
  11 fi
  12
  13 pushd .
  14 cd $CIVISOURCEDIR
  15 # svn up .
  16 cd $CIVISOURCEDIR/bin
  17 ./setup.sh
  18 cd $CIVISOURCEDIR/sql
  19
  20 echo; echo "Dropping civicrm_* tables from database $DBNAME"
  21 # mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
  22 MYSQLCMD="mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME"
  23 echo "SELECT table_name FROM information_schema.TABLES  WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \
  24   | $MYSQLCMD \
  25   | grep '^\(civicrm_\|log_civicrm_\)' \
  26   | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \
  27   | $MYSQLCMD
  28 echo "SELECT table_name FROM information_schema.TABLES  WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \
  29   | $MYSQLCMD \
  30   | grep '^\(civicrm_\|log_civicrm_\)' \
  31   | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \
  32   | $MYSQLCMD
  33
  34 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm.mysql
  35 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_data.mysql
  36 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_sample.mysql
  37 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < zipcodes.mysql
  38 php GenerateData.php
  39
  40 # run the cli script to build the menu and the triggers
  41 cd $CIVISOURCEDIR
  42 "$PHP5PATH"php bin/cli.php -e System -a flush --triggers 1 --session 1
  43
  44 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME -e "DROP TABLE zipcodes; UPDATE civicrm_domain SET config_backend = NULL; UPDATE civicrm_setting SET value = NULL WHERE name = 'userFrameworkResourceURL'  OR name = 'imageUploadURL';"
  45
  46 cd $CIVISOURCEDIR/sql
  47 mysqldump -cent --skip-triggers -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME > civicrm_generated.mysql
  48 #cat civicrm_sample_report.mysql >> civicrm_generated.mysql
  49 cat civicrm_sample_custom_data.mysql >> civicrm_generated.mysql
  50 #cat civicrm_devel_config.mysql >> civicrm_generated.mysql
  51 cat civicrm_dummy_processor.mysql >> civicrm_generated.mysql
  52 mysqladmin -f -u$DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
  53 mysqladmin -u$DBUSER $PASSWDSECTION $DBARGS create $DBNAME
  54 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm.mysql
  55 mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_generated.mysql
  56 popd