Travis

.travis.yml

before_script:
  - ./script/travis/setup_db.sh
  
script: bundle exec rspec spec/ --tag $TEST_TAG

env:
  matrix:
    - TEST_TAG=js DB_TEST=1
    - TEST_TAG=~js DB_TEST=2

    

setup_db.sh

#!/bin/sh

cp config/travis_database.yml config/database.yml

echo "checkpoint_segments='9'\ncheckpoint_timeout='30min'\nfsync='off'\nfull_page_writes='off'\nsynchronous_commit='off'" | sudo tee -a /etc/postgresql/9.3/main/postgresql.conf
psql -c 'create database my_test_1' -U postgres
psql -c "create extension hstore;" "my_test_1"
psql -U postgres -q -d my_test_1 -f db/structure.sql

echo "checkpoint_segments='9'\ncheckpoint_timeout='30min'\nfsync='off'\nfull_page_writes='off'\nsynchronous_commit='off'" | sudo tee -a /etc/postgresql/9.3/main/postgresql.conf
psql -c 'create database my_test_2' -U postgres
psql -c "create extension hstore;" "my_test_2"
psql -U postgres -q -d my_test_2 -f db/structure.sql

sudo /etc/init.d/postgresql restart

travis_database.yml

test:
  adapter: postgresql
  database: my_test_<%= ENV['DB_TEST'] %>
  username: postgres
  pool: 10