.travis.yml

os: linux
dist: xenial
language: python
matrix:
  include:
    - python: 3.6
      env: TOXENV=flake8

    - python: 3.6
      env: TOXENV=mysql
      services:
        - mysql
      before_script:
        - mysql -u root -e "DROP DATABASE IF EXISTS app; CREATE DATABASE app DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"
        - mysql -u root -e "CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY 'mysqluserpassword';"
        - mysql -u root -e "GRANT ALL ON app.* TO 'mysqluser'@'localhost';"

    - python: 3.6
      env: TOXENV=mssql
      services:
        - docker
      before_install:
        - docker pull mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
        - docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password_123" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
        - docker ps
        - sleep 60
        - docker logs -t mssql
      after_failure:
        - docker logs -t mssql
    - python: 3.7
      env: TOXENV=postgres
      services:
        - postgresql
      before_script:
        - psql -U postgres -c "CREATE DATABASE app;"
        - psql -U postgres -c "CREATE USER pguser WITH PASSWORD 'pguserpassword';"

    - python: 3.6
      env: TOXENV=mongodb
      services:
        - mongodb
install:
  - pip install tox
  - pip install codecov
script:
  - tox
after_success:
  - codecov