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