public async Task BasicFlow()
{
//Assume
const string insertCql = @"insert into Test.BasicFlow (id,value) values (?,?);";
const string retrieveCql = @"select * from Test.BasicFlow;";
const int insertCount = 1000;
//Act
using (var connection = new CqlConnection(ConnectionString))
{
await connection.OpenAsync();
var executions = new Task<ICqlQueryResult>[insertCount];
var options = new ParallelOptions() { MaxDegreeOfParallelism = 1 };
Parallel.For(0, insertCount, options, (i) =>
{
var cmd = new CqlCommand(connection, insertCql, CqlConsistency.One);
cmd.Prepare();
var b = new BasicFlowData { Id = i, Data = "Hallo " + i };
cmd.PartitionKey.Set(b);
cmd.Parameters.Set(b);
executions[i] = cmd.ExecuteNonQueryAsync();
});
await Task.WhenAll(executions);
var presence = new bool[insertCount];
var selectCmd = new CqlCommand(connection, retrieveCql, CqlConsistency.One) { EnableTracing = true };
CqlDataReader<BasicFlowData> reader = await selectCmd.ExecuteReaderAsync<BasicFlowData>();
while (await reader.ReadAsync())
{
BasicFlowData row = reader.Current;
Assert.AreEqual(row.Data, "Hallo " + row.Id);
presence[row.Id] = true;
}
Assert.IsTrue(presence.All(p => p));
var tracer = new QueryTraceCommand(connection, reader.TracingId.Value);
TracingSession session = await tracer.GetTraceSessionAsync();
Assert.IsNotNull(session);
}
}
public async Task BasicPrepareInsertSelect()
{
//Assume
const string insertCql = @"insert into Test.BasicFlow (id,value) values (?,?);";
const string retrieveCql = @"select * from Test.BasicFlow;";
//Act
using(var connection = new CqlConnection(ConnectionString))
{
await connection.OpenAsync();
//insert data
var cmd = new CqlCommand(connection, insertCql, CqlConsistency.One);
await cmd.PrepareAsync();
var b = new BasicFlowData {Id = 123, Data = "Hallo", Ignored = "none"};
cmd.PartitionKey.Set(b);
cmd.Parameters.Set(b);
await cmd.ExecuteNonQueryAsync();
//select data
var selectCmd = new CqlCommand(connection, retrieveCql, CqlConsistency.One) {EnableTracing = true};
await selectCmd.PrepareAsync();
CqlDataReader<BasicFlowData> reader = await selectCmd.ExecuteReaderAsync<BasicFlowData>();
Assert.AreEqual(1, reader.Count);
if(await reader.ReadAsync())
{
BasicFlowData row = reader.Current;
Assert.AreEqual(123, row.Id);
Assert.AreEqual("Hallo", row.Data);
Assert.IsNull(row.Ignored);
}
else
Assert.Fail("Read should have succeeded");
}
}
