# set oracle URL in form of JDBC URL connection string - old SID or new SERVICE variant - do not enter "jdbc:oracle:thin:" part!!!
# SERVICE: //<host>:<port>/<service>
# SID:     <host>:<port>:<sid>
export ORACLE_CONN_FLYWAY="//localhost:1521/orcl.localdomain"
export ORACLE_USER_FLYWAY="sys AS SYSDBA"
export ORACLE_PASSWORD_FLYWAY="sys"
export ORACLE_SCHEMA_FLYWAY="schema"
export ORACLE_SQL_ROOT="/installer/sql-scripts"

# set FlywayDB home dir
export FLYWAY_HOME="/tools/flyway-3.2.1"

# set FlywayDB JDBC driver - native, use only when no SQL logging needed
# export FLYWAY_DRIVER="oracle.jdbc.OracleDriver"
# export FLYWAY_URL="jdbc:oracle:thin:@"${ORACLE_CONN_FLYWAY}

# set FlywayDB JDBC driver - wrapped with SQL logging - preferred variant
export FLYWAY_DRIVER="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"
export FLYWAY_URL="jdbc:log4jdbc:oracle:thin:@"${ORACLE_CONN_FLYWAY}

echo Updating Oracle schema ...

# update DB schema
${FLYWAY_HOME}/flyway "-driver=${FLYWAY_DRIVER}" "-url=${FLYWAY_URL}" "-user=${ORACLE_USER_FLYWAY}" "-password=${ORACLE_PASSWORD_FLYWAY}" "-schemas=${ORACLE_SCHEMA_FLYWAY}" "-table=FLYWAY_SCHEMA_VERSION" "-baselineOnMigrate=true" "-validateOnMigrate=false" "-locations=filesystem:${ORACLE_SQL_ROOT}" "migrate" 2>&1
_exit_status=$?
if [[ $_exit_status -ne 0 ]]; then
    echo ERROR: Updating Oracle schema finished with errors!
    exit $_exit_status
fi