.drone-local.yml

workspace:
  base: /drone
  path: src/gopkg.in/reform.v1

pipeline:
  # use volume to download dependencies, share them between steps to reduce build time
  download_deps:
    image: ${GO}
    pull: true
    environment:
      - GOPATH=/go:/drone
      - PATH=/go/bin:/drone/bin:/usr/local/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    volumes:
      - drone_cache:/go/src
    commands:
      - make download_deps
    when:
      matrix:
        DOWNLOAD_DEPS: 1

  build:
    image: ${GO}
    pull: true
    environment:
      - GOPATH=/go:/drone
      - PATH=/go/bin:/drone/bin:/usr/local/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
      - TZ=Europe/Moscow
    volumes:
      - drone_cache:/go/src:ro
    commands:
      - echo ${GO} ${DATABASE} ${VERSION} ${REFORM_DRIVER}
      - go version
      - make install_deps
      - make test
      - make test-db
      - make check

services:
  postgres:
    image: postgres:${VERSION}
    pull: true
    environment:
      - TZ=Europe/Moscow
    when:
      matrix:
        DATABASE: postgres

  mysql:
    image: mysql:${VERSION}
    pull: true
    environment:
      - TZ=Europe/Moscow
      - MYSQL_ALLOW_EMPTY_PASSWORD=1
    when:
      matrix:
        DATABASE: mysql

  mssql:
    image: microsoft/mssql-server-linux:${VERSION}
    pull: true
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=reform-password123
    when:
      matrix:
        DATABASE: mssql

matrix:
  include:
    - {
        GO: "golang:1.8", DATABASE: postgres, VERSION: 9.6, REFORM_DRIVER: postgres,
        REFORM_ROOT_SOURCE: "postgres://postgres@127.0.0.1/template1?sslmode=disable",
        REFORM_INIT_SOURCE: "postgres://postgres@127.0.0.1/reform-database?sslmode=disable&TimeZone=UTC",
        REFORM_TEST_SOURCE: "postgres://postgres@127.0.0.1/reform-database?sslmode=disable&TimeZone=America/New_York",
        DOWNLOAD_DEPS: 1
      }

    # ANSI mode
    - {
        GO: "golang:1.8", DATABASE: mysql, VERSION: 5.7, REFORM_DRIVER: mysql,
        REFORM_ROOT_SOURCE: "root@/mysql",
        REFORM_INIT_SOURCE: "root@/reform-database?parseTime=true&time_zone='UTC'&sql_mode='ANSI'&multiStatements=true",
        REFORM_TEST_SOURCE: "root@/reform-database?parseTime=true&time_zone='America%2FNew_York'&sql_mode='ANSI'"
      }

    # TRADITIONAL mode + interpolateParams=true
    - {
        GO: "golang:1.8", DATABASE: mysql, VERSION: 5.7, REFORM_DRIVER: mysql,
        REFORM_ROOT_SOURCE: "root@/mysql",
        REFORM_INIT_SOURCE: "root@/reform-database?parseTime=true&time_zone='UTC'&sql_mode='ANSI'&multiStatements=true",
        REFORM_TEST_SOURCE: "root@/reform-database?parseTime=true&time_zone='America%2FNew_York'&sql_mode='TRADITIONAL'&interpolateParams=true"
      }

    - {
        GO: "golang:1.8", DATABASE: sqlite3, VERSION: dummy, REFORM_DRIVER: sqlite3,
        REFORM_ROOT_SOURCE: "/tmp/reform-database.sqlite3",
        REFORM_INIT_SOURCE: "/tmp/reform-database.sqlite3",
        REFORM_TEST_SOURCE: "/tmp/reform-database.sqlite3"
      }

    - {
        GO: "golang:1.8", DATABASE: mssql, VERSION: latest, REFORM_DRIVER: mssql,
        REFORM_ROOT_SOURCE: "server=localhost;user id=sa;password=reform-password123",
        REFORM_INIT_SOURCE: "server=localhost;user id=sa;password=reform-password123;database=reform-database",
        REFORM_TEST_SOURCE: "server=localhost;user id=sa;password=reform-password123;database=reform-database"
      }

    - {
        GO: "golang:1.8", DATABASE: mssql, VERSION: latest, REFORM_DRIVER: sqlserver,
        REFORM_ROOT_SOURCE: "sqlserver://sa:reform-password123@localhost",
        REFORM_INIT_SOURCE: "sqlserver://sa:reform-password123@localhost?database=reform-database",
        REFORM_TEST_SOURCE: "sqlserver://sa:reform-password123@localhost?database=reform-database"
      }