.travis.yml

## SETUP file for Travis
## Make sure to rename the database name in the CREATE DATABASE script below to the SAME name as used for your local tests
---

dist: bionic

language: java

cache:
  directories:  
    - $HOME/.m2

script:
  - mvn test
  - mvn -Dremote.user=$REMOTE_USER -Dremote.password=$REMOTE_PW tomcat7:undeploy tomcat7:deploy

services:
   - mysql

before_script:

# TODO Add variable to make it simple to be reusable for all semester projects
#- export DEBIAN_FRONTEND="noninteractive";
#- PW="ax2"
#- USER_NAME="dev"

#- sudo apt-get clean
#- sudo rm -r /var/lib/apt/lists/*

- sudo apt-get update || true
- sudo apt-get install -y debconf-utils
- sudo debconf-set-selections <<< 'mysql-apt-config mysql-apt-config/select-server select mysql-8.0'
- wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
- sudo -E dpkg -i mysql-apt-config_0.8.13-1_all.deb
- sudo apt-get update || true

- echo "Installing MySQL 8..."
- sudo -E apt-get -y install mysql-server

- sudo mysql -u root -e "CREATE User 'dev'@'localhost' IDENTIFIED BY 'ax2'; GRANT ALL PRIVILEGES ON *.* TO 'dev'@'localhost' WITH GRANT OPTION;"
# - sudo mysql -u root -e "CREATE DATABASE startcodev2-test;"
- sudo mysql -u dev -pax2 -e "CREATE DATABASE CA1_test;"

- echo "Change  port to 3307, to mirror the local development setup"
- sudo systemctl stop mysql
- sudo sh -c 'echo "port=3307" >> /etc/mysql/mysql.conf.d/mysqld.cnf'
- echo "Restarting MySQL..."
- sudo systemctl start mysql
- mysql --version
- echo "before_script Complete"