Travis cassandra service setup

.travis.yml

sudo: required
services:
- cassandra
before_script:
- bash travis/setup_cassandra.sh
script:
- ... run test

setup_cassandra.sh

#!/bin/bash
function cassandra_ready() {
    count=0
    while ! cqlsh -e "describe cluster;" 2>&1 ; do
        echo "waiting for cassandra"
        if [ $count -gt 30 ]
        then
            exit
        fi
        (( count += 1 ))
        sleep 1
    done
    echo "cassandra is ready"
}

cassandra_ready
cqlsh -e "create keyspace dev with replication = {'class': 'SimpleStrategy', 'replication_factor': 1}; USE dev; create table play(code int primary key, title varchar); insert into play (code, title) values (1, 'hello!');"

test_cassandra.yml

---
- provider: play_cassandra
  type: execute
  connection:
    contact_points:
      - 127.0.0.1
    port: 9042
    auth_provider:
      username: cassandra
      password: cassandra
  keyspace: dev
  query: SELECT title from play WHERE code = 1;
  variable: title
  variable_expression: results[0].title
assertion: "'$title' == 'hello!'"