Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function checkKey($key)
- {
- return isset($_POST[$key]) && '' !== $_POST[$key];
- }
- $Host = checkKey('Host') ? $_POST['Host'] : '127.0.0.1';
- $Keyspace = checkKey('Keyspace') ? $_POST['Keyspace'] : null;
- $Family = checkKey('Family') ? $_POST['Family'] : '';
- $SuperColumn = checkKey('SuperColumn') ? $_POST['SuperColumn'] : null;
- $KeyName = checkKey('KeyName') ? $_POST['KeyName'] : '';
- $ColumnsNames = checkKey('ColumnsNames') ? $_POST['ColumnsNames'] : '';
- $ColumnsValues = checkKey('ColumnsValues') ? $_POST['ColumnsValues'] : '';
- $insert = checkKey('insert') ? $_POST['insert'] : null;
- $GLOBALS['THRIFT_ROOT'] = '/usr/share/php/Thrift';
- require_once $GLOBALS['THRIFT_ROOT'].'/packages/cassandra/Cassandra.php';
- require_once $GLOBALS['THRIFT_ROOT'].'/packages/cassandra/cassandra_types.php';
- require_once $GLOBALS['THRIFT_ROOT'].'/transport/TSocket.php';
- require_once $GLOBALS['THRIFT_ROOT'].'/protocol/TBinaryProtocol.php';
- require_once $GLOBALS['THRIFT_ROOT'].'/transport/TFramedTransport.php';
- require_once $GLOBALS['THRIFT_ROOT'].'/transport/TBufferedTransport.php';
- try {
- // Make a connection to the Thrift interface to Cassandra
- $socket = new TSocket($Host, 9160);
- $transport = new TBufferedTransport($socket, 1024, 1024);
- $protocol = new TBinaryProtocolAccelerated($transport);
- $client = new CassandraClient($protocol);
- $transport->open();
- // We want the consistency level to be ONE which means to only wait for 1 node
- $consistency_level = cassandra_ConsistencyLevel::ONE;
- if(!is_null($insert)
- && !empty($ColumnsValues)
- && !empty($ColumnsNames) ){
- if(count($ColumnsNames) > 1 && $ColumnsNames[1] != ''){
- // build columns to insert
- $ptr = 0;
- // build super column containing the columns
- $super_column = new cassandra_SuperColumn();
- $super_column->name = $SuperColumn;
- $cols = array();
- foreach($ColumnsNames as $ColumnName){
- if($ColumnName == '')
- continue;
- $cols[$ptr] = new cassandra_Column();
- $cols[$ptr]->name = $ColumnName;
- $cols[$ptr]->value = $ColumnsValues[$ptr];
- $cols[$ptr]->timestamp = time();
- $ptr++;
- }
- $super_column->columns = $cols;
- // create columnorsupercolumn holder class that batch_insert uses
- $c_or_sc = new cassandra_ColumnOrSuperColumn();
- $c_or_sc->super_column = $super_column;
- // create the mutation (a map of ColumnFamily names to lists ColumnsOrSuperColumns objects
- $mutation[$Family] = array($c_or_sc);
- //var_dump($Keyspace, $KeyName, $mutation, $consistency_level);
- $batch = $client->batch_insert($Keyspace, $KeyName, $mutation, $consistency_level);
- if($batch)
- echo 'Batch Insert Success! <br />';
- }else{
- // Constructing the column path that we are adding information into.
- $columnPath = new cassandra_ColumnPath();
- $columnPath->column_family = $Family;
- $columnPath->super_column = $SuperColumn;
- $columnPath->column = $ColumnsNames[0];
- // Timestamp for update
- $timestamp = time();
- $single = $client->insert($Keyspace, $KeyName, $columnPath,
- $ColumnsValues[0], $timestamp, $consistency_level);
- if($single)
- echo 'Single Insert Success! <br />';
- }
- }
- // Specify what Column Family to query against.
- $columnParent = new cassandra_ColumnParent();
- $columnParent->column_family = $Family;
- $columnParent->super_column = $SuperColumn;
- $sliceRange = new cassandra_SliceRange();
- $sliceRange->start = "";
- $sliceRange->finish = "";
- $predicate = new cassandra_SlicePredicate();
- list() = $predicate->column_names;
- $predicate->slice_range = $sliceRange;
- $result = $client->get_slice($Keyspace, $KeyName, $columnParent, $predicate, $consistency_level);
- $transport->close();
- } catch (TException $tx) {
- print 'TException: '.$tx->why. ' Error: '.$tx->getMessage() . "\n";
- }
- ?>
- <style>
- #main{ margin:10px auto; width:650px; text-align:left; }
- #form {}
- #form label { float:left; width:400px; margin-top:15px; }
- #form input { border:solid 1px #ccc;float:right; width:180px; padding:2px 4px;}
- .cols input { border:solid 1px #ccc;float:left; width:180px; padding:2px 4px; margin:0px 10px; }
- .cols span { float:left; width:400px; }
- #form p { width:100%;float:left; margin-top:30px;}
- #form .submit { float:left; margin-left:200px; }
- #result { float:left; width:600px; }
- </style>
- <div id="main">
- <form id="form" method="post">
- <label>Host<input name="Host" value="<?php echo $Host ?>" /></label>
- <label>Keyspace<input name="Keyspace" value="<?php echo $Keyspace ?>" /></label>
- <label>Family<input name="Family" value="<?php echo $Family ?>" /></label>
- <label>SuperColumn<input name="SuperColumn" value="<?php echo $SuperColumn ?>" /></label>
- <label>KeyName<input name="KeyName" value="<?php echo $KeyName ?>" /></label>
- <div class="cols">
- <span>Column </span>
- <span>
- Name<input name="ColumnsNames[]" value="<?php echo $ColumnsNames[0] ?>" />
- </span>
- <span>
- Value<input name="ColumnsValues[]" value="<?php echo $ColumnsValues[0] ?>" />
- </span>
- <span>Column </span>
- <span>
- Name<input name="ColumnsNames[]" value="<?php echo $ColumnsNames[1] ?>" />
- </span>
- <span>
- Value<input name="ColumnsValues[]" value="<?php echo $ColumnsValues[1] ?>" />
- </span>
- <span>Column</span>
- <span>
- Name<input name="ColumnsNames[]" value="<?php echo $ColumnsNames[2] ?>" />
- </span>
- <span>
- value<input name="ColumnsValues[]" value="<?php echo $ColumnsValues[2] ?>" />
- </span>
- <span>Column</span>
- <span>
- Name<input name="ColumnsNames[]" value="<?php echo $ColumnsNames[3] ?>" />
- </span>
- <span>
- Value<input name="ColumnsValues[]" value="<?php echo $ColumnsValues[3] ?>" />
- </span>
- </div>
- <label>Save<input type="checkbox" name="insert" value="1" <?php echo $insert?'checked':'' ?> /></label>
- <p><input type="submit" /></p>
- </form>
- <fieldset id="result">
- <pre>
- <?php print_r($result) ?>
- </pre>
- </fieldset>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment