protected override void InternalRun(ICluster cluster)
{
var cmd = cluster.CreatePropertyBagCommand();
const string cqlKeyspaces = "SELECT * from system.schema_columns";
var req = from t in cmd.Execute(cqlKeyspaces).AsFuture().Result
where "system" == (string) t["KeyspaceName"]
select t;
DisplayResult(req);
}
protected override void InternalRun(ICluster cluster)
{
var cmd = cluster.CreatePropertyBagCommand();
const string cqlKeyspaces = "SELECT * from system_schema.columns";
var req = from t in cmd.Execute(cqlKeyspaces).AsFuture().Result
where "system" == (string)t["KeyspaceName"]
select t;
DisplayResult(req);
}
public void TestNull()
{
CassandraSharpConfig cassandraSharpConfig = new CassandraSharpConfig();
ClusterManager.Configure(cassandraSharpConfig);
ClusterConfig clusterConfig = new ClusterConfig
{
Endpoints = new EndpointsConfig
{
Servers = new[] { CQLBinaryProtocol.DefaultKeyspaceTest.CassandraServerIp }
}
};
using (ICluster cluster = ClusterManager.GetCluster(clusterConfig))
{
var cmd = cluster.CreatePropertyBagCommand();
const string dropFoo = "drop keyspace Tests";
try
{
cmd.Execute(dropFoo).AsFuture().Wait();
}
catch
{
}
const string createFoo = "CREATE KEYSPACE Tests WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1}";
Console.WriteLine("============================================================");
Console.WriteLine(createFoo);
Console.WriteLine("============================================================");
cmd.Execute(createFoo).AsFuture().Wait();
Console.WriteLine();
Console.WriteLine();
const string createBar = @"CREATE TABLE Tests.AllTypes (a int, b int, primary key (a))";
Console.WriteLine("============================================================");
Console.WriteLine(createBar);
Console.WriteLine("============================================================");
cmd.Execute(createBar).AsFuture().Wait();
Console.WriteLine();
Console.WriteLine();
//const string useBar = @"use Tests";
//Console.WriteLine("============================================================");
//Console.WriteLine(useBar);
//Console.WriteLine("============================================================");
//cmd.Execute(useBar).AsFuture().Wait();
//Console.WriteLine();
//Console.WriteLine();
const string insertBatch = @"insert into Tests.AllTypes (a, b) values (?, ?)";
var prepared = cmd.Prepare(insertBatch);
PropertyBag insertBag = new PropertyBag();
insertBag["a"] = 1;
insertBag["b"] = null;
prepared.Execute(insertBag).AsFuture().Wait();
const string selectAll = "select * from Tests.AllTypes";
var res = cmd.Execute(selectAll).AsFuture();
Assert.IsTrue(1 == res.Result.Count);
PropertyBag selectBag = res.Result.Single();
Assert.IsTrue(selectBag.Keys.Contains("a"));
Assert.IsTrue(1 == (int)selectBag["a"]);
Assert.IsTrue(null == selectBag["b"]);
// to test case in-sensistive
Assert.IsTrue(1 == (int)selectBag["A"]);
Assert.IsTrue(null == selectBag["B"]);
}
}
