.travis.yml

language: java

sudo: required # So we can use docker and a beefier machine
dist: trusty

git:
  depth: 1 # an optimization since we won't be committing anything
  quiet: true

services:
- mysql
- postgresql
- docker # In order to run DBMS such as DB2, MSSQL and Oracle

stages:
- compile
- test
- deploy

# Attempt to reduce the time to pull the OracleDB Container
cache:
  timeout: 1000
  directories:
    - $HOME/.m2/repository
    - $CACHE_DIR

# Attempt to reduce the time to pull the OracleDB Container
env:
  global:
  - CACHE_DIR=$HOME/.cache/docker
  - CACHE_FILE_ORACLE=$CACHE_DIR/oracle.tar.gz

jobs:
  include:
  - stage: compile

    before_install:
    - source .travisci/setup.sh
    script: mvn test -Dtest=!MySQLMigrationSpec,!org.javalite.db_migrator.* -DfailIfNoTests=false -V

  - stage: test
    # ----------------------- mysql -----------------------
    env: DB=mysql_travis-ci
    before_install:
    - source .travisci/setup.sh
    before_script:
    - mysql -e 'CREATE DATABASE IF NOT EXISTS test;'
    script:
    - echo "Starting MySQL build"
    - sh .travisci/run_tests.sh

  - # --------------------- postgresql ---------------------
    env: DB=postgresql_travis-ci
    before_install:
    - source .travisci/setup.sh
    before_script:
    - psql -c 'create database test;' -U postgres
    script:
    - echo "Starting PostgreSQL build"
    - sh .travisci/run_tests.sh

  - # ----------------------- db2 -----------------------
    env: DB=db2_travis-ci
    before_install:
    - source .travisci/setup.sh
    - docker run -d -p 50000:50000 --name db2 -e DB2INST1_PASSWORD=dzqAbmZwnN8c -e LICENSE=accept ibmcom/db2express-c:latest db2start
    - docker ps # db2 takes a sec to start before we can issue the db creation
    - docker exec -u db2inst1 -it db2 /bin/bash -c ". /home/db2inst1/sqllib/db2profile && db2 create db db2 && exit"
    script:
    - echo "Starting DB2 build"
    - sh .travisci/run_tests.sh

  - # ----------------------- oracle -----------------------
    env: DB=oracle_travis-ci
    before_install:
    # Load cached docker images
    - if [ -f ${CACHE_FILE_ORACLE} ]; then gunzip -c ${CACHE_FILE_ORACLE} | docker load; fi
    - docker run -d -p 8080:8080 -p 1521:1521 --name oracle_active-jdbc sath89/oracle-12c
    - docker ps
    - source .travisci/setup.sh
    before_script:
    - docker cp $TRAVIS_BUILD_DIR/.travisci/oracle/init.sql oracle_active-jdbc:/tmp/init.sql
    - docker exec -u oracle -it oracle_active-jdbc /bin/bash -c "echo 'Waiting for DB to boot...' && while [ ! -f /u01/app/oracle/cfgtoollogs/dbca/xe/xe.log ]; do sleep 10; done;"
    - docker exec -u oracle -it oracle_active-jdbc /bin/bash -c "cat /u01/app/oracle/cfgtoollogs/dbca/xe/xe.log"
    - docker exec -u oracle -it oracle_active-jdbc /bin/bash -c "\$ORACLE_HOME/bin/sqlplus -S system/oracle @/tmp/init.sql"
    script:
    - echo "Starting Oracle build"
    - sh .travisci/run_tests.sh
    before_cache:
    # Save tagged docker images
    - mkdir -p $CACHE_DIR
    - if [ ! -f ${CACHE_FILE_ORACLE} ]; then docker save sath89/oracle-12c:latest | gzip > ${CACHE_FILE_ORACLE}; fi

  - # ----------------------- mssql -----------------------
    env: DB=mssql_travis-ci
    before_install:
    - source .travisci/setup.sh
    - docker run -e ACCEPT_EULA=Y -e SA_PASSWORD=CVXQj6sC9D3s3PzE! -e MSSQL_PID=Express -p 1433:1433 --name mssql_active-jdbc -d microsoft/mssql-server-linux:latest
    - docker ps
    script:
    - echo "Starting MS SQLServer build"
    - sh .travisci/run_tests.sh

  - # ----------------------- sqlite -----------------------
    env: DB=sqlite_travis-ci
    before_install:
    - source .travisci/setup.sh
    script:
    - echo "Starting SQLite build"
    - sh .travisci/run_tests.sh

    # ->->->->->->->->->->->->->->->->->->->->->->->->->->->->->->
    #                      Deploy Stage
    # ->->->->->->->->->->->->->->->->->->->->->->->->->->->->->->
  - stage: deploy
    # require the branch name to be master (note for PRs this is the base branch name)
    if: |
      repo = javalite/activejdbc AND \
      branch = master

    before_install:
    - source .travisci/setup.sh
    script: sh $TRAVIS_BUILD_DIR/.travisci/deploy.sh