public async Task WriteMeasurements()
{
_writeApi = Client.GetWriteApi();
var bucketName = _bucket.Name;
var time = DateTime.UtcNow.Add(-TimeSpan.FromSeconds(10));
var measurement1 = new H20Measurement
{
Location = "coyote_creek", Level = 2.927, Time = time.Add(-TimeSpan.FromSeconds(30))
};
var measurement2 = new H20Measurement
{
Location = "coyote_creek", Level = 1.927, Time = time
};
_writeApi.WriteMeasurements(bucketName, _organization.Id, WritePrecision.S, measurement1, measurement2);
_writeApi.Dispose();
var measurements = await _queryApi.QueryAsync <H20Measurement>(
$"from(bucket:\"{bucketName}\") |> range(start: 1970-01-01T00:00:00.000000001Z) |> rename(columns:{{_value: \"level\"}})",
_organization.Id);
Assert.AreEqual(2, measurements.Count);
Assert.AreEqual(2.927, measurements[0].Level);
Assert.AreEqual("coyote_creek", measurements[0].Location);
Assert.AreEqual(time.AddTicks(-(time.Ticks % TimeSpan.TicksPerSecond)).Add(-TimeSpan.FromSeconds(30)),
measurements[0].Time);
Assert.AreEqual(1.927, measurements[1].Level);
Assert.AreEqual("coyote_creek", measurements[1].Location);
Assert.AreEqual(time.AddTicks(-(time.Ticks % TimeSpan.TicksPerSecond)), measurements[1].Time);
}
public async Task WriteMeasurementsWithoutFields()
{
_writeApi = Client.GetWriteApi();
var listener = new WriteApiTest.EventListener(_writeApi);
var bucketName = _bucket.Name;
var time = DateTime.UtcNow;
var measurement1 = new H20Measurement
{
Location = "coyote_creek", Level = 2.927, Time = time.Add(-TimeSpan.FromSeconds(30))
};
var measurement2 = new H20Measurement
{
Location = "coyote_creek", Level = null, Time = time
};
_writeApi.WriteMeasurements(bucketName, _organization.Id, WritePrecision.S, measurement1, measurement2);
_writeApi.Flush();
listener.WaitToSuccess();
var measurements = await _queryApi.QueryAsync <H20Measurement>(
$"from(bucket:\"{bucketName}\") |> range(start: 0) |> rename(columns:{{_value: \"level\"}})",
_organization.Id);
Assert.AreEqual(1, measurements.Count);
Assert.AreEqual(2.927, measurements[0].Level);
Assert.AreEqual("coyote_creek", measurements[0].Location);
Assert.AreEqual(time.AddTicks(-(time.Ticks % TimeSpan.TicksPerSecond)).Add(-TimeSpan.FromSeconds(30)),
measurements[0].Time);
}
public async Task DefaultTagsMeasurement()
{
Client.Dispose();
Environment.SetEnvironmentVariable("measurement-datacenter", "LA");
ConfigurationManager.AppSettings["measurement-sensor.version"] = "1.23a";
var options = new InfluxDBClientOptions.Builder().Url(InfluxDbUrl)
.AuthenticateToken(_token.ToCharArray())
.AddDefaultTag("id", "132-987-655")
.AddDefaultTag("customer", "California Miner")
.AddDefaultTag("env-var", "${env.measurement-datacenter}")
.AddDefaultTag("sensor-version", "${measurement-sensor.version}")
.Build();
Client = InfluxDBClientFactory.Create(options);
var measurement1 = new H20Measurement
{
Location = "coyote_creek", Level = 2.927, Time = DateTime.UtcNow
};
_writeApi = Client.GetWriteApi();
var listener = new WriteApiTest.EventListener(_writeApi);
_writeApi.WriteMeasurement(_bucket.Name, _organization.Id, WritePrecision.Ms, measurement1);
_writeApi.Flush();
listener.WaitToSuccess();
_queryApi = Client.GetQueryApi();
var tables = await _queryApi.QueryAsync(
"from(bucket:\"" + _bucket.Name +
"\") |> range(start: 1970-01-01T00:00:00.000000001Z) |> pivot(rowKey:[\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")",
_organization.Id);
Assert.AreEqual(1, tables.Count);
Assert.AreEqual(1, tables[0].Records.Count);
Assert.AreEqual("h2o", tables[0].Records[0].GetMeasurement());
Assert.AreEqual(2.927, tables[0].Records[0].GetValueByKey("level"));
Assert.AreEqual("coyote_creek", tables[0].Records[0].GetValueByKey("location"));
Assert.AreEqual("132-987-655", tables[0].Records[0].GetValueByKey("id"));
Assert.AreEqual("California Miner", tables[0].Records[0].GetValueByKey("customer"));
Assert.AreEqual("1.23a", tables[0].Records[0].GetValueByKey("sensor-version"));
Assert.AreEqual("LA", tables[0].Records[0].GetValueByKey("env-var"));
}
public async Task DefaultTagsConfiguration()
{
Client.Dispose();
var options = new InfluxDBClientOptions.Builder()
.LoadConfig()
.Url(InfluxDbUrl)
.AuthenticateToken(_token)
.Build();
Client = InfluxDBClientFactory.Create(options);
var measurement1 = new H20Measurement
{
Location = "coyote_creek", Level = 2.927, Time = DateTime.UtcNow
};
_writeApi = Client.GetWriteApi();
var listener = new WriteApiTest.EventListener(_writeApi);
_writeApi.WriteMeasurement(_bucket.Name, _organization.Id, WritePrecision.Ms, measurement1);
_writeApi.Flush();
listener.WaitToSuccess();
_queryApi = Client.GetQueryApi();
var tables = await _queryApi.QueryAsync(
$"from(bucket:\"{_bucket.Name}\") |> range(start: 1970-01-01T00:00:00.000000001Z) |> pivot(rowKey:[\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")",
_organization.Id);
Assert.AreEqual(1, tables.Count);
Assert.AreEqual(1, tables[0].Records.Count);
Assert.AreEqual("h2o", tables[0].Records[0].GetMeasurement());
Assert.AreEqual(2.927, tables[0].Records[0].GetValueByKey("level"));
Assert.AreEqual("coyote_creek", tables[0].Records[0].GetValueByKey("location"));
Assert.AreEqual("132-987-655", tables[0].Records[0].GetValueByKey("id"));
Assert.AreEqual("California Miner", tables[0].Records[0].GetValueByKey("customer"));
Assert.AreEqual("v1.00", tables[0].Records[0].GetValueByKey("version"));
}
