Advertisement
rherrick

Initialize XNAT database

Jun 4th, 2013
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.16 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. # Set defaults.
  4. NUKE=0
  5. PROJECT=xnat
  6.  
  7. while true;
  8. do
  9.     if [ -n "$1" ]; then
  10.         if [[ "$1" == "-n" || "$1" == "--nuke" ]]; then
  11.             NUKE=1
  12.         else
  13.             PROJECT=$1
  14.         fi
  15.         shift;
  16.     else
  17.         break;
  18.     fi
  19. done
  20.  
  21. if [ $NUKE == 1 ]; then
  22.     echo Completing full build WITH NUKE with database deployments using project ${PROJECT}...
  23. else
  24.     echo Completing full build with database deployments using project ${PROJECT}...
  25. fi
  26.  
  27. PATH=`pwd`/bin:${PATH}
  28. PGPASSWORD=${PROJECT}
  29.  
  30. if [ $NUKE == 1 ]; then
  31.     echo Preparing to nuke database ${PROJECT}. Hit enter to proceed, Ctrl-C to abort.
  32.     read test
  33.     dropdb -h xnatdev -U ${PROJECT} ${PROJECT}
  34.     createdb -h xnatdev -O ${PROJECT} -U ${PROJECT} ${PROJECT}
  35. fi
  36.  
  37. pushd deployments/${PROJECT}
  38.  
  39. echo Deploying database schema
  40. psql -h xnatdev -d ${PROJECT} -f sql/${PROJECT}.sql -U ${PROJECT}
  41. echo Calling StoreXML on security
  42. StoreXML -project ${PROJECT} -l security/security.xml -allowDataDeletion true
  43. echo Calling StoreXML on field_groups
  44. StoreXML -dir ./work/field_groups -u admin -p admin -allowDataDeletion true
  45.  
  46. popd
  47.  
  48. echo Finished...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement