Tuples

PHP Driver supports Cassandra tuples

Background

Given

a running Cassandra cluster

Using Cassandra tuples

Given

the following schema:

CREATE KEYSPACE simplex WITH replication = {
  'class': 'SimpleStrategy',
  'replication_factor': 1
};
USE simplex;
CREATE TABLE users (
  id uuid PRIMARY KEY,
  name text,
  address tuple<text, text, int>
);

And

the following example:

$cluster   = Dse::cluster()->build();
$session   = $cluster->connect("simplex");

$tupleType = Dse\Type::tuple(Dse\Type::text(), Dse\Type::text(), Dse\Type::int());

$users = array(
    array(
        new Dse\Uuid('56357d2b-4586-433c-ad24-afa9918bc415'),
        'Charles Wallace',
        $tupleType->create('Phoenix', '9042 Cassandra Lane', 85023)
    ),
    array(
        new Dse\Uuid('ce359590-8528-4682-a9f3-add53fc9aa09'),
        'Kevin Malone',
        $tupleType->create('New York', '1000 Database Road', 10025)
    ),
    array(
        new Dse\Uuid('7d64dca1-dd4d-4f3c-bec4-6a88fa082a13'),
        'Michael Scott',
        $tupleType->create('Santa Clara', '20000 Log Ave', 95054)
    )
);

foreach ($users as $user) {
    $options = array('arguments' => $user);
    $session->execute("INSERT INTO users (id, name, address) VALUES (?, ?, ?)", $options);
}

$result    = $session->execute("SELECT * FROM users");

foreach ($result as $row) {
    echo "ID: {$row['id']}" . PHP_EOL;
    echo "Name: {$row['name']}" . PHP_EOL;
    echo "Address:" . PHP_EOL;
    foreach ($row['address'] as $format) {
        echo "  {$format}" . PHP_EOL;
    }
}

When

it is executed

Then

its output should contain:

ID: 56357d2b-4586-433c-ad24-afa9918bc415
Name: Charles Wallace
Address:
  Phoenix
  9042 Cassandra Lane
  85023
ID: ce359590-8528-4682-a9f3-add53fc9aa09
Name: Kevin Malone
Address:
  New York
  1000 Database Road
  10025
ID: 7d64dca1-dd4d-4f3c-bec4-6a88fa082a13
Name: Michael Scott
Address:
  Santa Clara
  20000 Log Ave
  95054