public void SimpleScenario()
{
TTransport transport = new TSocket("localhost", 9160);
TProtocol protocol = new TBinaryProtocol(transport);
var client = new Cassandra.Client(protocol);
Console.WriteLine("Opening Connection");
transport.Open();
//At this point we're using the standard configuration file
var nameColumnPath = new ColumnPath("Standard1", null, "name");
Console.WriteLine("Inserting a column");
client.insert("Keyspace1",
"1",
nameColumnPath,
"Josh Blogs".UTF(),
Util.UnixTimestamp,
ConsistencyLevel.ONE
);
client.insert("Keyspace1",
"2",
nameColumnPath,
"Something else".UTF(),
Util.UnixTimestamp,
ConsistencyLevel.ONE);
//Let's get something back out (this is our select statement)
ColumnOrSuperColumn returnedColumn = client.get(
"Keyspace1", //The database
"1", //The actual key we want
nameColumnPath, //Where that key sits
ConsistencyLevel.ONE //HAZY
);
Console.WriteLine("We got Name: {0}, value {1}",
returnedColumn.Column.Name.UTFDecode(),
returnedColumn.Column.Value.UTFDecode());
Console.WriteLine("Now let's try getting a range");
//This is telling us the offest to get. This is where paging would occur.
var predicate = new SlicePredicate(new SliceRange(false, 10));
var parent = new ColumnParent("Standard1");
var keyedResults =
client.multiget_slice("Keyspace1",
new List<string> { "1", "2" },
parent,
predicate,
ConsistencyLevel.ONE);
foreach (var keyedResult in keyedResults)
{
Console.WriteLine("Key: {0}", keyedResult.Key);
foreach (ColumnOrSuperColumn result in keyedResult.Value)
{
Column column = result.Column;
Console.WriteLine("Name: {0}, value: {1}",
column.Name.UTFDecode(),
column.Value.UTFDecode());
}
}
Console.WriteLine("closing connection");
transport.Close();
}
/// <summary>
/// 取得Baha單日資料
/// </summary>
/// <param name="key">日期</param>
/// <param name="columnFamily">CF name (BahamutOnline,BahamutAll)</param>
/// <returns></returns>
public IOrderedEnumerable <RankList> BahaGetOneDay(string key, string columnFamily)
{
var rank = new List <RankList>();
var lb = new List <byte[]> {
ThriftTool.ToByte(key)
};
Dictionary <byte[], List <ColumnOrSuperColumn> > results = Client.multiget_slice(lb, ThriftTool.GetParent(columnFamily), ThriftTool.GetPredicate(100), ConsistencyLevel.ONE);
if (results.Count > 0) //if have result
{
foreach (var result in results)
{
foreach (var scol in result.Value)
{
if (scol.GetType() == typeof(ColumnOrSuperColumn))
{
var rl = new RankList();
foreach (var col in scol.Super_column.Columns)
{
string name = ThriftTool.ToString(col.Name);
if (name == "Title")
{
rl.Title = ThriftTool.ToString(col.Value);
}
if (name == "Rank")
{
rl.Rank = int.Parse(ThriftTool.ToString(col.Value));
}
if (name == "Article")
{
rl.Article = ThriftTool.ToString(col.Value);
}
if (name == "Link")
{
rl.Link = ThriftTool.ToString(col.Value);
}
if (name == "Popular")
{
rl.Popular = ThriftTool.ToString(col.Value);
}
if (name == "Date")
{
rl.Date = DateTime.Parse(ThriftTool.ToString(col.Value));
}
if (name == "Change")
{
rl.Change = ThriftTool.ToString(col.Value);
}
}
rank.Add(rl);
}
}
}
}
ThriftTool.TransportClose();
var ranks = from n in rank orderby n.Rank select n;
return(ranks);
}
static void Main(string[] args)
{
TTransport transport = new TSocket("localhost", 9160);
TProtocol protocol = new TBinaryProtocol(transport);
Cassandra.Client client = new Cassandra.Client(protocol);
Console.WriteLine("Opening connection");
transport.Open();
System.Text.Encoding utf8Encoding = System.Text.Encoding.UTF8;
long timeStamp = DateTime.Now.Millisecond;
ColumnPath nameColumnPath = new ColumnPath()
{
Column_family = "Standard1",
Column = utf8Encoding.GetBytes("name")
};
Console.WriteLine("Inserting name columns");
//Insert the data into the column 'name'
client.insert("Keyspace1",
"1",
nameColumnPath,
utf8Encoding.GetBytes("Joe Bloggs"),
timeStamp,
ConsistencyLevel.ONE);
client.insert("Keyspace1",
"2",
nameColumnPath,
utf8Encoding.GetBytes("Joe Soap"),
timeStamp,
ConsistencyLevel.ONE);
//Simple single value get using the key to get column 'name'
ColumnOrSuperColumn returnedColumn = client.get("Keyspace1", "1", nameColumnPath, ConsistencyLevel.ONE);
Console.WriteLine("Column Data in Keyspace1/Standard1: name: {0}, value: {1}",
utf8Encoding.GetString(returnedColumn.Column.Name),
utf8Encoding.GetString(returnedColumn.Column.Value));
Console.WriteLine("Getting splice range");
//Read an entire row
SlicePredicate predicate = new SlicePredicate()
{
Slice_range = new SliceRange()
{
//Start and Finish cannot be null
Start = new byte[0],
Finish = new byte[0],
Count = 10,
Reversed = false
}
};
ColumnParent parent = new ColumnParent()
{
Column_family = "Standard1"
};
Dictionary <string, List <ColumnOrSuperColumn> > results = client.multiget_slice("Keyspace1",
new List <string>()
{
"1", "2"
},
parent,
predicate,
ConsistencyLevel.ONE);
foreach (KeyValuePair <string, List <ColumnOrSuperColumn> > resultPair in results)
{
Console.WriteLine("Key: {0}", resultPair.Key);
foreach (ColumnOrSuperColumn resultColumn in resultPair.Value)
{
Column column = resultColumn.Column;
Console.WriteLine("name: {0}, value: {1}", utf8Encoding.GetString(column.Name), utf8Encoding.GetString(column.Value));
}
}
Console.WriteLine("Closing connection");
transport.Close();
}
