appveyor.yml

build: off

platform:
  - x64

environment:
  PGUSER: "postgres"
  PGPASSWORD: "Password12!"
  IBIS_POSTGRES_USER: "%PGUSER%"
  IBIS_POSTGRES_PASS: "%PGPASSWORD%"
  DATA_DIR: "%USERPROFILE%\\ibis-testing-data"
  DATA_URL: "https://storage.googleapis.com/ibis-ci-data"
  IBIS_TEST_POSTGRES_DB: "ibis_testing"
  IBIS_TEST_SQLITE_DB_PATH: "%USERPROFILE%\\ibis_testing.db"
  CONDA: "C:\\Miniconda36-x64\\Scripts\\conda"
  ACTIVATE: "C:\\Miniconda36-x64\\Scripts\\activate"

  matrix:
    - PYTHON_VERSION: "2.7"
    - PYTHON_VERSION: "3.4"
    - PYTHON_VERSION: "3.5"
    - PYTHON_VERSION: "3.6"

services:
  - postgresql93

test_script:
  - "%CONDA% config --set always_yes true"
  - "%CONDA% create --name \"ibis_%PYTHON_VERSION%\" python=%PYTHON_VERSION% --channel conda-forge"
  - "%ACTIVATE% \"ibis_%PYTHON_VERSION%\""
  - "pip install -e .\"[sqlite, postgres, visualization, pandas]\""
  - "pip install flake8 mock pytest click \"pbs==0.110\""
  - "flake8"
  - "python ci\\datamgr.py download --directory \"%USERPROFILE%\""
  - "python ci\\datamgr.py sqlite --database \"%IBIS_TEST_SQLITE_DB_PATH%\" --data-directory \"%DATA_DIR%\" --script ci\\sqlite_load.sql functional_alltypes batting awards_players diamonds"
  - "python ci\\datamgr.py postgres --database \"%IBIS_TEST_POSTGRES_DB%\" --data-directory \"%DATA_DIR%\" --script ci\\postgresql_load.sql functional_alltypes batting awards_players diamonds"
  - "pytest --tb=short -m \"not impala and not hdfs\" ibis"