.travis.yml

language: c

cache: 
  ccache: true
  # directories:
  #   - $HOME/Library/Caches/Homebrew
  # not work
# env:
#   jobs:
#     # - CHANNEL=stable
#     - CHANNEL=devel
matrix:
  include:
    - name: linux with mysql8
      env: DB=MYSQL8 DOCKER=true CHANNEL=devel 
      # USE_SHA2=true
      dist: xenial
      services:
        - docker
      before_install:
        - docker pull mysql:8.0
        - docker run -d -p 127.0.0.1:3306:3306 
          -v $(pwd)/.travis/docker-entrypoint-initdb:/docker-entrypoint-initdb.d 
          --name  mysqld  
          -e MYSQL_DATABASE=test 
          -e MYSQL_USER=test_user 
          -e MYSQL_PASSWORD=12345678 
          -e MYSQL_ROOT_PASSWORD='' 
          -e MYSQL_ALLOW_EMPTY_PASSWORD=yes
          mysql:8.0 --innodb_log_file_size=256MB  --innodb_buffer_pool_size=512MB --max_allowed_packet=16MB --local-infile=1 --default-authentication-plugin=mysql_native_password

    # Build and test against the master (stable) and devel branches of Nim
    - os: linux
      name: linux with mysql(5.7.30)
      env: CHANNEL=devel 
      compiler: gcc
      services:
        mysql # mysql  Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using  EditLine wrapper

    - os: linux
      name: linux with mariadb(10.4)
      env: CHANNEL=devel 
      compiler: gcc
      addons:
        mariadb: '10.4'

    # On OSX we only test against clang (gcc is mapped to clang by default)
    # - os: osx
    #   name: osx with mysql(8.0.21)
    #   env: CHANNEL=devel
    #   compiler: clang
    #   # env: USE_SHA2=true
    #   before_install:
    #     - brew install ccache
    #     - export PATH="/usr/local/opt/ccache/libexec:$PATH"
    #     - brew install mysql # mysql-8.0.21
    #     - mysql.server start
    # - os: osx
    #   name: osx with mariadb(10.5.5)
    #   compiler: clang
    #   # mariadb-10.5.5.high_sierra.bottle.tar.gz
    #   env: CHANNEL=devel TRAVIS_MARIADB_VERSION=10.5.5
    #   before_install:
    #     - brew install ccache
    #     - rm -f /etc/my.cnf
    #     - brew install mariadb
    #     - brew services start mariadb

  allow_failures:
    # Ignore failures when building against the devel Nim branch
    # Also ignore OSX, due to very long build queue
    - os: osx
    - env: CHANNEL=devel USE_SHA2=true
    # -  name: osx with mysql
  fast_finish: true

before_script:

  # env(DB) = MYSQL8
  # - |
  #   if [ -z "$TRAVIS_MARIADB_VERSION" ] 
  #   then
  #     sudo systemctl stop mysql
  #     sudo mysqld_safe --skip-grant-tables --skip-networking &
  #     # mariadb 10.4 and later replace to mysql.global_priv https://mariadb.com/kb/en/mysqluser-table/
  #     # sudo mysql -u root -e "use mysql;UPDATE user SET authentication_string = PASSWORD('123456') WHERE User = 'root' AND Host = '127.0.0.1';UPDATE user SET password = PASSWORD('123456') WHERE User = 'root' AND Host = '127.0.0.1';FLUSH PRIVILEGES;"
  #     sudo mysql -u root -e "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;"

  #     sudo systemctl start mysql;
  #   fi

  - |
    if [ -z "$DOCKER" ]
    then
      sudo mysql -u root -e "create database if not exists test;"
      if [ -z "$TRAVIS_MARIADB_VERSION" ] 
      then
        sudo mysql -u root  -e "create user 'test_user'@'127.0.0.1' identified WITH mysql_native_password BY '12345678';"
        
        if [ "$USE_SHA2" == "true" ]
        then
          sudo mysql -u root  -e "CREATE USER 'sha2user'@'127.0.0.1' IDENTIFIED WITH caching_sha2_password BY 'password';"
          sudo mysql -u root  -e "grant all on *.* to 'sha2user'@'127.0.0.1';"
        fi
      else
        sudo mysql -u root  -e "create user 'test_user'@'127.0.0.1' identified VIA mysql_native_password USING PASSWORD('12345678');"
        # mariadb not well support https://mariadb.com/kb/en/authentication-plugin-sha-256/#client-authentication-plugins
        # sudo mysql -u root  -e "CREATE USER 'sha2user'@'127.0.0.1' IDENTIFIED VIA caching_sha2_password USING PASSWORD('12345678');"
      fi
      sudo mysql -u root  -e "grant all on *.* to 'test_user'@'127.0.0.1';"
      sudo mysql -u root -e "grant FILE on *.* to 'test_user'@'127.0.0.1';"
    fi


install:
  - export CHOOSENIM_NO_ANALYTICS=1
  # - export CHOOSENIM_CHOOSE_VERSION=1.3.1
  - curl https://nim-lang.org/choosenim/init.sh -sSf > init.sh
  - sh init.sh -y
  - export PATH=~/.nimble/bin:$PATH
  - echo "export PATH=~/.nimble/bin:$PATH" >> ~/.profile
  - choosenim $CHANNEL
  - nimble install https://github.com/bung87/zstd
  - nimble install -d -y

script:
  - nimble test --silent
  - nimble test -d:ChronosAsync --silent
  # - nimble install scorper
  # - nim c -d:useServer -r experiments/test_concurrent.nim