export MAVEN_OPTS="-Xms521M -Xmx1024M"

if [[ "$1" == "" ]] ; then

echo "Missing argument: correct usage <./run-sql.sh database>"

DATABASE=$1

echo "Database type: $DATABASE"

cd flowable-sql-7.0.1

if [[ "$DATABASE" == "oracle" ]] ; then

mvn -PupdateDb -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT clean install

else

mvn -PupdateDb -Ddatabase=$DATABASE clean install

fi

cd ..

cd flowable-sql-7.1.0

if [[ "$DATABASE" == "oracle" ]] ; then

mvn -PgenerateSql -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT -DoldVersion=7.0.1 -DnewVersion=7.1.0 clean install

mvn -PgenerateCreateSql -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT clean install

mvn -PcombineUpgradeSql -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT -DoldVersion=7.0.1 -DnewVersion=7.1.0 clean install

mvn -PcombineCreateSql -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT clean install

mvn -PdropAll -Ddatabasewithschema=$DATABASE -Duser.timezone=GMT clean install

else

mvn -PgenerateSql -Ddatabase=$DATABASE -DoldVersion=7.0.1 -DnewVersion=7.1.0 clean install

mvn -PgenerateCreateSql -Ddatabase=$DATABASE clean install

mvn -PcombineUpgradeSql -Ddatabase=$DATABASE -DoldVersion=7.0.1 -DnewVersion=7.1.0 clean install

mvn -PcombineCreateSql -Ddatabase=$DATABASE clean install

mvn -PdropAll -Ddatabase=$DATABASE clean install

fi

cd ..