projects / civicrm-core.git / blame
| Commit | Line | Data |
|---|---|---|
| 6a488035 | 1 | #!/usr/bin/env bash |
| ebf2b57b EM |
2 | |
| 3 | # define your database name here, will be overriden by | |
| 6a488035 TO |
4 | # FIRST command line argument if given |
| 5 | DBNAME= | |
| ebf2b57b | 6 | # define your database usernamename here, will be overriden by |
| 6a488035 TO |
7 | # SECOND command line argument if given |
| 8 | DBUSER= | |
| ebf2b57b | 9 | # define your database password here, will be overriden by |
| 6a488035 TO |
10 | # THIRD command line argument if given |
| 11 | DBPASS= | |
| 12 | # set your PHP5 bin dir path here, if it's not in PATH | |
| 13 | # The path should be terminated with dir separator! | |
| 14 | PHP5PATH= | |
| 15 | ||
| 16 | # ========================================================== | |
| 17 | # No changes below, please. | |
| 18 | # ========================================================== | |
| 19 | ||
| 20 | CALLEDPATH=`dirname $0` | |
| 21 | ||
| 22 | if [ "$1" == '-h' ] || [ "$1" == '--help' ]; then | |
| 23 | echo; echo Usage: setup.sh [database name] [database user] [database password]; echo | |
| 24 | exit 0 | |
| 25 | fi | |
| 26 | ||
| 27 | ||
| 28 | # fetch command line arguments if available | |
| 29 | if [ ! -z $1 ] ; then DBNAME=$1; fi | |
| 30 | if [ ! -z $2 ] ; then DBUSER=$2; fi | |
| 31 | if [ ! -z $3 ] ; then DBPASS=$3; 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 | |
| 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 $DBNAME database | |
| 64 | mysqladmin -f -u $DBUSER $PASSWDSECTION drop $DBNAME | |
| 65 | echo; echo Creating $DBNAME database | |
| 66 | mysqladmin -f -u $DBUSER $PASSWDSECTION create $DBNAME | |
| 67 | echo; echo Creating database structure | |
| 68 | mysql -u $DBUSER $PASSWDSECTION $DBNAME < civicrm.mysql | |
| 69 | ||
| 70 | mysql -u $DBUSER $PASSWDSECTION $DBNAME < civicrm_data.mysql | |
| 71 | ||
| 72 | mysql -u $DBUSER $PASSWDSECTION $DBNAME < zipcodes.mysql | |
| 73 | cd ../test/RSTest/ | |
| 74 | php Run.php | |
| 75 | ||
| 76 | echo; echo "DONE!" | |
| 77 | ||
| 78 | # to generate a new data file do the foll: | |
| 79 | # mysqladmin -f -uYourDBUser -pYourDBPassword drop YourDBName | |
| 80 | # mysqladmin -f -uYourDBUser -pYourDBPassword create YourDBName | |
| 81 | # mysql -uYourDBUser -pYourDBPassword YourDBName < civicrm.mysql | |
| 82 | # mysql -uYourDBUser -pYourDBPassword YourDBName < civicrm_data.mysql | |
| 83 | # mysql -uYourDBUser -pYourDBPassword YourDBName < zipcodes.mysql | |
| 84 | # php GenerateContactData.php | |
| 85 | # echo "drop table zipcodes" | mysql -uYourDBUser -pYourDBPassword YourDBName | |
| 86 | # mysqldump -t -n -uYourDBUser -pYourDBPassword YourDBName > GeneratedData.sql |