validate_distribution_examples.sh

#!/bin/sh

mvn clean install

if [ "$?" -ne "0" ]; then
  echo "Hmm. Build failed."
  exit 99
fi

TMPDIR=$(mktemp -d -t dbdeploy)

unzip dbdeploy-dist/target/dbdeploy-dist-*-distribution.zip -d $TMPDIR

cd $TMPDIR/dbdeploy-*/example/

ant default

# for some reason, the sql task doesn't display the output
# if it's run in the same session as the updates.
ant dump-tables

mvn dbdeploy:change-script -Ddbdeploy.script.name=add_column_to_test_table

mvn dbdeploy:db-scripts

echo "Created apply.sql file..."
cat apply.sql

echo "Created undo.sql file..."
cat undo.sql

mvn dbdeploy:update

ant dump-tables

mvn dbdeploy:update -Ddbdeploy.lastChange=1

ant dump-tables