public async Task DataStream_Postgres_ExecSQL_Test()
{
var stream = GetValidStream();
var connector = new PostgresqlConnector(_logger);
AssertSuccessful(await connector.InitAsync(stream));
var deviceId = "DEV001";
for (var idx = 0; idx < 20; ++idx)
{
AssertSuccessful(await AddRecord(connector, stream, deviceId, idx + 300, idx + 200));
}
var filteredItems = new List <SQLParameter>()
{
new SQLParameter()
{
Name = "@start", Value = "2021-04-12"
}
};
var query = "select timeStamp, int1 from information where timeStamp > TO_TIMESTAMP(@start, 'yyyy-mm-dd')";
var result = await connector.ExecSQLAsync(query, filteredItems);
Assert.IsTrue(result.Successful);
}
