cassandra test

gistfile1.scala

import com.datastax.driver.core._

val cluster = Cluster.builder.addContactPoint("127.0.0.1").build
val session = cluster.connect

// http://www.datastax.com/documentation/developer/java-driver/1.0/webhelp/index.html#java-driver/quick_start/qsSimpleClientAddSession_t.html
session.execute("CREATE KEYSPACE simplex WITH replication " + 
      "= {'class':'SimpleStrategy', 'replication_factor':3};");
      
session.execute(
      "CREATE TABLE simplex.songs (" +
            "id uuid PRIMARY KEY," + 
            "title text," + 
            "album text," + 
            "artist text," + 
            "tags set<text>," + 
            "data blob" + 
            ");");
session.execute(
      "CREATE TABLE simplex.playlists (" +
            "id uuid," +
            "title text," +
            "album text, " + 
            "artist text," +
            "song_id uuid," +
            "PRIMARY KEY (id, title, album, artist)" +
            ");");
            

session.execute(
      "INSERT INTO simplex.songs (id, title, album, artist, tags) " +
      "VALUES (" +
          "756716f7-2e54-4715-9f00-91dcbea6cf50," +
          "'La Petite Tonkinoise'," +
          "'Bye Bye Blackbird'," +
          "'Joséphine Baker'," +
          "{'jazz', '2013'})" +
          ";");
session.execute(
      "INSERT INTO simplex.playlists (id, song_id, title, album, artist) " +
      "VALUES (" +
          "2cc9ccb7-6221-4ccb-8387-f22b6a1b354d," +
          "756716f7-2e54-4715-9f00-91dcbea6cf50," +
          "'La Petite Tonkinoise'," +
          "'Bye Bye Blackbird'," +
          "'Joséphine Baker'" +
          ");");
          
          
val results = session.execute("SELECT * FROM simplex.playlists " +
        "WHERE id = 2cc9ccb7-6221-4ccb-8387-f22b6a1b354d;");