/// <summary>
/// Using a time series schema, it inserts a few records and then retrieves some of them
/// </summary>
public static void TimeSeriesExample()
{
Console.WriteLine("--------------------");
Console.WriteLine("Executing time series sample");
var repository = new TemperatureRepository(_session);
//Insert some data
var weatherStation = "station1";
//Trying to simulate the insertion of several rows
//with temperature measures
for (var i = 0; i < 1000; i++ )
{
repository.AddTemperature(weatherStation, i / 16M);
}
//Now lets retrieve the temperatures for a given date
var rs = repository.GetTemperatureRecords(weatherStation, DateTime.Today);
//lets print a few of them
Console.WriteLine("Printing the first temperature records (only 20)");
var counter = 0;
foreach (var row in rs)
{
Console.Write(row.GetValue<string>("weatherstation_id"));
Console.Write("\t");
Console.Write(row.GetValue<DateTime>("event_time").ToString("HH:mm:ss.fff"));
Console.Write("\t");
Console.WriteLine(row.GetValue<decimal>("temperature"));
//It is just an example, 20 is enough
if (counter++ == 20)
{
break;
}
}
}
/// <summary>
/// Using a time series schema, it async inserts a few records and then retrieves some of them
/// </summary>
public static void TimeSeriesExampleAsync()
{
Console.WriteLine("--------------------");
Console.WriteLine("Executing time series async sample");
var repository = new TemperatureRepository(_session);
//Insert some data
var weatherStation = "station2";
//Trying to simulate the insertion of several rows
//with temperature measures
//We will not wait for the insertion to try to insert the next
//We will create a task list
var insertTaskList = new List <Task>();
for (var i = 0; i < 1000; i++)
{
//It returns a task that is going to be completed when the Cassandra ring acknowledge the insert
var task = repository.AddTemperatureAsync(weatherStation, i / 16M);
//Maintain the task for later use.
insertTaskList.Add(task);
}
//Now lets wait until any of the insert succeeds.
Task.WaitAny(insertTaskList.ToArray());
//Now lets retrieve the temperatures for a given date
var rs = repository.GetTemperatureRecords(weatherStation, DateTime.Today);
//lets print a few of them
Console.WriteLine("Printing the first temperature records (only 20, if available)");
var counter = 0;
foreach (var row in rs)
{
Console.Write(row.GetValue <string>("weatherstation_id"));
Console.Write("\t");
Console.Write(row.GetValue <DateTime>("event_time").ToString("HH:mm:ss.fff"));
Console.Write("\t");
Console.WriteLine(row.GetValue <decimal>("temperature"));
//It is just an example, 20 is enough
if (counter++ == 20)
{
Console.WriteLine();
break;
}
}
}
/// <summary>
/// Using a time series schema, it inserts a few records and then retrieves some of them
/// </summary>
public static void TimeSeriesExample()
{
Console.WriteLine("--------------------");
Console.WriteLine("Executing time series sample");
var repository = new TemperatureRepository(_session);
//Insert some data
var weatherStation = "station1";
//Trying to simulate the insertion of several rows
//with temperature measures
for (var i = 0; i < 1000; i++)
{
repository.AddTemperature(weatherStation, i / 16M);
}
//Now lets retrieve the temperatures for a given date
var rs = repository.GetTemperatureRecords(weatherStation, DateTime.Today);
//lets print a few of them
Console.WriteLine("Printing the first temperature records (only 20)");
var counter = 0;
foreach (var row in rs)
{
Console.Write(row.GetValue <string>("weatherstation_id"));
Console.Write("\t");
Console.Write(row.GetValue <DateTime>("event_time").ToString("HH:mm:ss.fff"));
Console.Write("\t");
Console.WriteLine(row.GetValue <decimal>("temperature"));
//It is just an example, 20 is enough
if (counter++ == 20)
{
break;
}
}
}
/// <summary>
/// Using a time series schema, it async inserts a few records and then retrieves some of them
/// </summary>
public static void TimeSeriesExampleAsync()
{
Console.WriteLine("--------------------");
Console.WriteLine("Executing time series async sample");
var repository = new TemperatureRepository(_session);
//Insert some data
var weatherStation = "station2";
//Trying to simulate the insertion of several rows
//with temperature measures
//We will not wait for the insertion to try to insert the next
//We will create a task list
var insertTaskList = new List<Task>();
for (var i = 0; i < 1000; i++)
{
//It returns a task that is going to be completed when the Cassandra ring acknowledge the insert
var task = repository.AddTemperatureAsync(weatherStation, i / 16M);
//Maintain the task for later use.
insertTaskList.Add(task);
}
//Now lets wait until any of the insert succeeds.
Task.WaitAny(insertTaskList.ToArray());
//Now lets retrieve the temperatures for a given date
var rs = repository.GetTemperatureRecords(weatherStation, DateTime.Today);
//lets print a few of them
Console.WriteLine("Printing the first temperature records (only 20, if available)");
var counter = 0;
foreach (var row in rs)
{
Console.Write(row.GetValue<string>("weatherstation_id"));
Console.Write("\t");
Console.Write(row.GetValue<DateTime>("event_time").ToString("HH:mm:ss.fff"));
Console.Write("\t");
Console.WriteLine(row.GetValue<decimal>("temperature"));
//It is just an example, 20 is enough
if (counter++ == 20)
{
Console.WriteLine();
break;
}
}
}
