public static IPropertyBagCommand CreatePropertyBagCommand(this ICluster @this)
{
var cmd = @this.CreateCommand().FromPropertyBag().ToPropertyBag().Build();
var pbCmd = new PropertyBagCommand(cmd);
return(pbCmd);
}
public void TestAllTypes()
{
CassandraSharpConfig cassandraSharpConfig = new CassandraSharpConfig();
ClusterManager.Configure(cassandraSharpConfig);
ClusterConfig clusterConfig = new ClusterConfig
{
Endpoints = new EndpointsConfig
{
Servers = new[] { "localhost" }
}
};
using (ICluster cluster = ClusterManager.GetCluster(clusterConfig))
{
ICqlCommand cmd = cluster.CreateCommand().FromOrdinal().ToPoco().Build();
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();
// http://www.datastax.com/docs/1.1/references/cql/cql_data_types
const string createBar = @"CREATE TABLE Tests.AllTypes (cAscii ascii,
cBigint bigint,
cBlob blob,
cBoolean boolean,
cDecimal decimal,
cDouble double,
cFloat float,
cInet inet,
cInt int,
cText text,
cTimestamp timestamp,
cTimeuuid timeuuid,
cUuid uuid,
cVarchar varchar,
cVarint varint,
cList list<int>,
cSet set<int>,
cMap map<text, int>,
PRIMARY KEY (cInt))";
Console.WriteLine("============================================================");
Console.WriteLine(createBar);
Console.WriteLine("============================================================");
cmd.Execute(createBar).AsFuture().Wait();
Console.WriteLine();
Console.WriteLine();
const string insertBatch = @"insert into Tests.AllTypes (cAscii, cBigint, cBlob, cBoolean, cDouble, cFloat,
cInet, cInt, cText, cTimestamp, cTimeuuid, cUuid, cVarchar, cList, cSet, cMap)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
var prepared = cmd.Prepare(insertBatch);
var allTypesInsert = new AllTypes
{
CAscii = new string('x', 8000),
CBigint = 0x0102030405060708,
CBlob = Enumerable.Repeat((byte)42, 7142).ToArray(),
CBoolean = true,
CDouble = 1234.5678,
CFloat = 234.567f,
CInet = new IPAddress(new byte[] { 0x01, 0x02, 0x03, 0x04 }),
CInt = 42,
CText = new string('x', 3000),
CTimestamp = new DateTime(2013, 1, 16, 14, 20, 0),
CTimeuuid = TimedUuid.GenerateTimeBasedGuid(DateTime.Now),
CUuid = Guid.NewGuid(),
CVarchar = new string('x', 5000),
CList = new List <int> {
1, 2, 3
},
CSet = new HashSet <int> {
1, 2, 3
},
CMap = new Dictionary <string, int> {
{ "one", 1 }, { "two", 2 }, { "three", 3 }
},
};
var param = new object[]
{
allTypesInsert.CAscii,
allTypesInsert.CBigint,
allTypesInsert.CBlob,
allTypesInsert.CBoolean,
allTypesInsert.CDouble,
allTypesInsert.CFloat,
allTypesInsert.CInet,
allTypesInsert.CInt,
allTypesInsert.CText,
allTypesInsert.CTimestamp,
allTypesInsert.CTimeuuid,
allTypesInsert.CUuid,
allTypesInsert.CVarchar,
allTypesInsert.CList,
allTypesInsert.CSet,
allTypesInsert.CMap,
};
prepared.Execute(param).AsFuture().Wait();
const string selectAll =
"select cAscii, cBigint, cBlob, cBoolean, cDouble, cFloat, cInet, cInt, cText, cTimestamp, cTimeuuid, cUuid, cVarchar, cList, cSet, cMap from Tests.AllTypes";
AllTypes allTypesSelect = cmd.Execute <AllTypes>(selectAll).AsFuture().Result.Single();
cmd.Execute(dropFoo).AsFuture().Wait();
Assert.AreEqual(allTypesInsert.CAscii, allTypesSelect.CAscii);
Assert.AreEqual(allTypesInsert.CBigint, allTypesSelect.CBigint);
Assert.AreEqual(allTypesInsert.CBlob, allTypesSelect.CBlob);
Assert.AreEqual(allTypesInsert.CBoolean, allTypesSelect.CBoolean);
Assert.AreEqual(allTypesInsert.CDouble, allTypesSelect.CDouble);
Assert.AreEqual(allTypesInsert.CFloat, allTypesSelect.CFloat);
Assert.AreEqual(allTypesInsert.CInet, allTypesSelect.CInet);
Assert.AreEqual(allTypesInsert.CInt, allTypesSelect.CInt);
Assert.AreEqual(allTypesInsert.CText, allTypesSelect.CText);
Assert.AreEqual(allTypesInsert.CTimestamp, allTypesSelect.CTimestamp);
Assert.AreEqual(allTypesInsert.CTimeuuid, allTypesSelect.CTimeuuid);
Assert.AreEqual(allTypesInsert.CUuid, allTypesSelect.CUuid);
Assert.AreEqual(allTypesInsert.CVarchar, allTypesSelect.CVarchar);
Assert.AreEqual(allTypesInsert.CList, allTypesSelect.CList);
Assert.AreEqual(allTypesInsert.CSet, allTypesSelect.CSet);
Assert.AreEqual(allTypesInsert.CMap, allTypesSelect.CMap);
}
ClusterManager.Shutdown();
}
public static ICqlCommand CreatePocoCommand(this ICluster @this)
{
return(@this.CreateCommand().FromPoco().ToPoco().Build());
}
public static ICqlCommand CreateOrdinalCommand(this ICluster @this)
{
return(@this.CreateCommand().FromOrdinal().ToOrdinal().Build());
}
