Sample Jenkins script to dynamically create a database and then pass it to Grails

jenkins_create.sh

# Exports
export GRAILS_HOME=/path/to/grails
export PATH=$PATH:${GRAILS_HOME}/bin

export PSQL_HOME=/Library/PostgreSQL/9.3
export PATH=$PATH:${PSQL_HOME}/bin

export PGPASSWORD=yourPass # Ideally this should live in the .pgpass file

# Create the database
createdb test_db${BUILD_NUMBER} --owner=yourOwner --username=yourUser

# Run the tests
grails clean
grails test-app -integration -Dtest.suffix=${BUILD_NUMBER}