public async Task CreatePullQuery_FromPlainStringQuery()
{
//Arrange
string sensorId = "sensor-1";
string ksql = $"SELECT * FROM {SensorsPullQueryProvider.MaterializedViewName} WHERE SensorId = '{sensorId}';";
//Act
var result = await context.ExecutePullQuery <IoTSensorStats>(ksql);
//Assert
result.Should().NotBeNull();
result.SensorId.Should().Be(sensorId);
}
private static async Task PullSensor(KSqlDBContext context)
{
string windowStart = "2019-10-03T21:31:16";
string windowEnd = "2025-10-03T21:31:16";
var result = await context.CreatePullQuery <IoTSensorStats>(MaterializedViewName)
.Where(c => c.SensorId == "sensor-1")
//.Where(c => Bounds.WindowStart > windowStart && Bounds.WindowEnd <= windowEnd)
.GetAsync();
Console.WriteLine($"Id: {result?.SensorId} - Avg Value: {result?.AvgValue} - Window Start {result?.WindowStart}");
string ksql = "SELECT * FROM avg_sensor_values WHERE SensorId = 'sensor-1';";
result = await context.ExecutePullQuery <IoTSensorStats>(ksql);
}
private static async Task PullSensor(KSqlDBContext context)
{
string windowStart = "2019-10-03T21:31:16";
string windowEnd = "2025-10-03T21:31:16";
var pullQuery = context.CreatePullQuery <IoTSensorStats>(MaterializedViewName)
.Where(c => c.SensorId == "sensor-1")
.Where(c => Bounds.WindowStart > windowStart && Bounds.WindowEnd <= windowEnd)
.Take(5);
var sql = pullQuery.ToQueryString();
await foreach (var item in pullQuery.GetManyAsync().OrderBy(c => c.SensorId).ConfigureAwait(false))
{
Console.WriteLine($"Pull query - GetMany result => Id: {item?.SensorId} - Avg Value: {item?.AvgValue} - Window Start {item?.WindowStart}");
}
var list = await pullQuery.GetManyAsync().OrderBy(c => c.SensorId).ToListAsync();
string ksql = "SELECT * FROM avg_sensor_values WHERE SensorId = 'sensor-1';";
var result2 = await context.ExecutePullQuery <IoTSensorStats>(ksql);
}
