Cassandra的PHP客户端的另一个选择---SimpleCassie
秦信瑞
接上例：http://blog.csdn.net/kunshan_shenbin/article/details/7193289
官方主页：http://code.google.com/p/simpletools-php/
API介绍：http://code.google.com/p/simpletools-php/wiki/SimpleCassie
和上例一样，依然尝试将SimpleCassie继承到CodeIgniter中运行。
1. 下载源码：http://code.google.com/p/simpletools-php/downloads/list，解压后把SimpleCassie.php拷贝至application/libraries下。
2. 修改autoload.php如下：
$autoload['libraries'] = array('SimpleCassie', 'smarty');
注意，如果和上例是同一个工程，则不用让SimpleCassie和上例中的db同时自动加载，因为他们都是cassandra的client类库，很多的class同名的。
3. 为了能够被加载进codeigniter，SimpleCassie的构造函数需要修改一下：
public function __construct() {}
// public function __construct($host,$port=9160,$timeout=null)
// {
// $this->__nodes[$host] = array($port,$timeout);
// }4. 在controller里可以直接使用SimpleCassie类库了：
$cassie = $this->simplecassie;
$cassie->addNode("192.168.11.124", 9160);
$cassie->addNode("192.168.11.185", 9160);
if(!$cassie->isConnected())
throw new Exception('Couldn\'t connect to server');
$activeNode = $cassie->getActiveNode();
$cassie->keyspace('LiftDNA_DB');
$cassie->keyspace('MyApp')->cf('LiftDNA_Table')->key('shenyi')->column('age')->set('27');
$cassie->cf('LiftDNA_Table')->key('yangye')->column('age')->set('28');
//$cassie->cf('LiftDNA_Table')->key('yangye')->column('name')->batch('28');
//$cassie->cf('LiftDNA_Table')->key('yangye')->column('age')->batch('29');
//$cassie->batchCommit();
$age = $cassie->cf('LiftDNA_Table')->key('shenyi')->column('age')->value();
$this->load->view('cassandra', $age);更多代码参考：
<?php
require_once('SimpleCassie.php');
$cassie = new SimpleCassie(HOST, PORT, TIMEOUT_MS);
//failover support added since SimpleCassie 0.7.1.2 by:
$cassie->addNode(HOST2, PORT2, TIMEOUT_MS);
$cassie->addNode(HOST3, PORT3, TIMEOUT_MS);
if(!$cassie->isConnected())
throw new Exception('Couldn\'t connect to server');
//checking active node - since SimpleCassie 0.7.1.2
$activeNode = $cassie->getActiveNode();
/*
* setting working keyspace
* @return - (false) on failure true on success
* working keyspace can be change at any point by running ->keyspace() method
*/
$cassie->keyspace('Keyspace1');
/*
* setting new column (and key if not exist)
* @return - (false) on failure
*/
$cassie->keyspace('MyApp')->cf('Users')->key('user1')->column('name')->set('Marcin');
$cassie->cf('Users')->key('user1')->column('surname')->set('Rosinski');
/*
* setting in batches
* @return - number of batches or false on failure
*/
$cassie->cf('Users')->key('user1')->column('name')->batch('Marcin');
$cassie->cf('Users')->key('user1')->column('surname')->batch('Rosinski');
//batching deletion
$cassie->cf('Users')->key('user1')->column('columntodrop')->batch();
//commiting all above batches
$cassie->batchCommit();
/*
* delete column or row/key
* @return - (false) on failure
*/
//deleting column
$cassie->cf('Users')->key('user1')->column('name')->remove();
//deleting row
$cassie->cf('Users')->key('user1')->remove();
/*
* count number of columns in row/key
* @return - (int) on succes, false on failure
*/
$count = $cassie->cf('Users')->key('user2')->count();
/*
* count number of columns with predicate: from column to column
* @return - (int) on succes, false on failure
*/
$count = $cassie->cf('Users')->key('user2')->column('fromColumn','toColumn')->count();
/*
* count number of columns with predicate: from column to column for multiple keys
* @return - (int) on succes, false on failure
*/
$count = $cassie->cf('Users')->key('user2','user3')->column('fromColumn','toColumn')->count();
/*
* getting single column
* @return - object on succes, null on failure
*/
$name = $cassie->keyspace('Keyspace1')->cf('Standard1')->key('user1')->column('name')->get();
/*
* getting multiple columns
* @return - array of objects on success, null on failure
*/
$user = $cassie->cf('Standard1')->key('user1')->column('name','surname')->get();
/*
* getting multiple column values
* @return - array of objects on success, null on failure
*/
$user = $cassie->cf('Standard1')->key('user1')->column('name','surname')->value();
/*
* getting single column from multiple rows/keys
* @return - array of objects on succes, null on failure
*/
$users = $cassie->cf('Standard1')->key('user1','user2')->column('name')->get();
/*
* getting multiple columns from multiple rows/keys
* @return - array of objects on succes, null on failure
*/
$users = $cassie->cf('Standard1')->key('user1','user2')->column('name','username')->get();
/*
* getting slice of columns from single row/key
* @return - array of objects on succes, null on failure
*/
$limit = 10;
$reversed = false;
$from_name = 'Puma';
$to_name = 'Tiger';
$friends = $cassie->cf('Standard1')->key('user1friends')->column($from_name,$to_name)->slice($limit,$reversed);
/*
* getting slice of columns from single supercolumn row
* @return - array of objects on succes, null on failure
*/
$limit = 10;
$reversed = false;
$friends = $cassie->cf('Standard1')->key('user1')->supercolumn('friends')->column($from_name,$to_name)->slice($limit,$reversed);
//resetting supercolumn for future use - deprecated since SimpleCassie 0.7.1.3 - this process has been automated
$cassie->key('user1')->supercolumn(null);
/*
* getting slice of columns from multiple rows/keys
* @return - array of objects on succes, null on failure
*/
$limit = 10;
$reversed = true;
$friends = $cassie->cf('Standard1')->key('user1friends','user2friends')->column($from_name,$to_name)->slice($limit,$reversed);
/*
* increment column value
* @return - (int) new value on succes, false on failure
*/
$new_value = $cassie->cf('Standard1')->key('user1')->column('friends')->increment();
/*
* decrement column value
* @return - (int) new value on succes, false on failure
*/
$new_value = $cassie->cf('Standard1')->key('user1')->column('friends')->decrement();
/*
* Getting active keyspace
*/
echo $cassie->keyspace();
/*
* Range support - since SimpleCassie 0.7.1.2
*/
$range = $cassie->cf('MyColumnFamily')->key('fromKey','toKey')->column('fromColumn','toColumn')->range($keyCount,$columnCount);
?>UUID Usage Examples：
<?php
//setting new uuid column
$cassie->keyspace('MyApp')->cf('BlogPosts')->key('post')->column($cassie->uuid())->set('I like raw food.');
//getting latest added post (assuming TimeUUIDType)
$post = $cassie->cf('BlogPosts')->key('post')->slice(1);
//getting post column uuid name in canonical form
$uuid = $cassie->uuid($post->column->name);
$string_form = (string) $uuid; //canonical form
$binary_form = $uuid->uuid;
?>
类似资料：