.travis.yml

language: python
sudo: required
python:
  - "2.7"
  - "3.4"
services:
  - postgres
#  - mysql
addons:
  mariadb: '10.1'
  apt:
    packages:
      - cmake
      - unixodbc
      - unixodbc-dev
      - odbcinst1debian2
      - odbcinst
      - freetds-dev
      - freetds-bin
      - tdsodbc
      - libc6
      - e2fsprogs
      - mysql-client
      - libproj-dev
      - libgeos-dev
      - libspatialite-dev
env:
  - DB=generic
  - DB=postgres POSTGIS_VERSION=1.5
  - DB=postgres POSTGIS_VERSION=2
  - DB=mysql

install:
  - echo "[mysqld]" > $HOME/.my.cnf
  - echo "default-storage-engine = MYISAM" >> $HOME/.my.cnf
  - sudo sudo service mysql restart
  # install GeoAlchemy in editable mode
  - pip install -e .

  # install nose and rednose for colorful output
  - pip install nose rednose

  # install individual dependencies
  - if [[ "$DB" == "postgres" ]]; then pip install psycopg2; fi
  - if [[ "$DB" == "mysql" ]]; then pip install MySQL-python; fi

  # install PostGIS 2.x
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" != "1.5" ]]; then sudo apt-add-repository -y ppa:sharpie/for-science; fi
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" != "1.5" ]]; then sudo apt-add-repository -y ppa:sharpie/postgis-nightly; fi
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" != "1.5" ]]; then sudo apt-get update; fi
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" != "1.5" ]]; then sudo apt-get update; fi
  # Install PostGIS 1.5
  - if [[ "$POSTGIS_VERSION" == "1.5" ]]; then sudo apt-get install -y --force-yes postgresql-9.1-postgis=1.5.3-2 postgis=1.5.3-2; fi

before_script:
  # activate verbose and rednose mode
  - export NOSE_REDNOSE=1
  - export NOSE_VERBOSE=2

  # create database user "gis"
  - if [[ "$DB" == "postgres" ]]; then psql -U postgres -c "CREATE ROLE gis PASSWORD 'gis' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;"; fi
  - if [[ "$DB" == "mysql" ]]; then mysql --user=root -e "CREATE USER 'gis'@'localhost' IDENTIFIED BY 'gis';"; fi
  - if [[ "$DB" == "mysql" ]]; then mysql --user=root -e "GRANT ALL ON *.* TO 'gis'@'localhost';"; fi

  # create database "gis"
  - if [[ "$DB" == "postgres" ]]; then psql -U postgres -c "CREATE DATABASE gis;"; fi
  - if [[ "$DB" == "mysql" ]]; then mysql --user=root -e "CREATE DATABASE gis;"; fi

  # add PostGIS extension to "gis" database
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" == "1.5" ]]; then psql -d gis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql; fi
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" == "1.5" ]]; then psql -d gis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql; fi
  - if [[ "$DB" == "postgres" ]] && [[ "$POSTGIS_VERSION" != "1.5" ]]; then psql -d gis -U postgres -c "CREATE EXTENSION postgis;"; fi

script:
  # run tests
  - if [[ "$DB" == "generic" ]]; then python geoalchemy/tests/test_dialect.py; fi
  - if [[ "$DB" == "generic" ]]; then python geoalchemy/tests/test_type.py; fi

  - if [[ "$DB" == "postgres" ]]; then python geoalchemy/tests/test_postgis.py; fi
  - if [[ "$DB" == "mysql" ]]; then python geoalchemy/tests/test_mysql.py; fi

notifications:
  email:
    on_failure: change