* If you're using Linux, verify that 'php5-cli' or a similar package has
* been installed.
*
*/
require_once __DIR__ . '/../lib/autoload.php';
use phpcassa\Connection\ConnectionPool;
use phpcassa\ColumnFamily;
use phpcassa\ColumnSlice;
use phpcassa\SystemManager;
use phpcassa\Schema\StrategyClass;
// Create a new keyspace and column family
$sys = new SystemManager('127.0.0.1');
$sys->create_keyspace('Keyspace1', array("strategy_class" => StrategyClass::SIMPLE_STRATEGY, "strategy_options" => array('replication_factor' => '1')));
$sys->create_column_family('Keyspace1', 'Letters', array("column_type" => "Standard", "comparator_type" => "LongType", "key_validation_class" => "UTF8Type", "default_validation_class" => "UTF8Type"));
// Start a connection pool, create our ColumnFamily instance
$pool = new ConnectionPool('Keyspace1', array('127.0.0.1'));
$letters = new ColumnFamily($pool, 'Letters');
// Insert a few records
$columns = array(1 => "a", 2 => "b", 3 => "c", 4 => "d", 5 => "e");
$letters->insert('key', $columns);
function print_slice($columns)
{
echo "(";
foreach ($columns as $number => $letter) {
echo "{$number} => {$letter}, ";
}
echo ")\n";
}
// Fetch everything >= 2
$slice = new ColumnSlice(2);
print_slice($letters->get('key', $slice));
!/usr/local/bin/php
<?
require_once(__DIR__.'/../lib/autoload.php');
use phpcassa\Connection\ConnectionPool;
if ($argc < 2){
echo "Usage {$argv[0]} keyspace cql\n";
exit;
}
$space = $argv[1];
$cql = $argv[2];
$pool = new ConnectionPool($space, array("127.0.0.1"));
$raw = $pool->get();
$rows = $raw->client->execute_cql_query($cql, 2);
$pool->return_connection($raw);
unset($raw);
$pool->close();
print_r($rows);
//print_r($rows["rows"]); // result data only