public async Task Should_Write_All_Field_Types_To_Database()
{
var row = new VariationRow
{
Timestamp = new DateTime(2013, 1, 1, 1, 1, 1, DateTimeKind.Utc),
Count = 1337,
Floaty = 13.36f,
Shorty = 23005,
SbytyMcByteFace = 42,
Indicator = true,
Message = "Hello, there\nWhat's up? ==",
Percent = 0.37,
Type = "tag, =Value",
Category = TestEnum1.Value2,
CategoryTag = TestEnum2.Value3,
OtherTimestamp = new DateTime(2011, 4, 23, 1, 23, 54, DateTimeKind.Utc),
};
await _client.WriteAsync(InfluxClientFixture.DatabaseName, "variation", new[] { row });
var resultSet = await _client.ReadAsync <VariationRow>(InfluxClientFixture.DatabaseName, "SELECT * FROM variation");
Assert.Equal(1, resultSet.Results.Count);
var result = resultSet.Results[0];
Assert.Equal(1, result.Series.Count);
var series = result.Series[0];
Assert.Equal(1, series.Rows.Count);
Assert.Equal(row, series.Rows[0]);
}
public async Task Should_Write_All_Field_Types_To_Database()
{
var row = new VariationRow
{
Timestamp = new DateTime(2013, 1, 1, 1, 1, 1, DateTimeKind.Utc),
Count = 1337,
Floaty = 13.36f,
Shorty = 23005,
SbytyMcByteFace = 42,
Indicator = true,
Message = "Hello, \\athere\nWhat's up? ==",
Percent = 0.37,
Type = "tag, =Value",
Category = TestEnum1.Value2,
CategoryTag = TestEnum2.Value3,
CategoryNullable = TestEnum1.Value2,
DoubleTag = 1.123,
IntType = 42,
OtherTimestamp = new DateTime(2011, 4, 23, 1, 23, 54, DateTimeKind.Utc),
Decimal1 = 23.53m,
Decimal2 = 13.97m,
Dto1 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto2 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
Decimal3 = 23.53m,
Decimal4 = 13.97m,
Dto3 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto4 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
};
await _client.WriteAsync(InfluxClientFixture.DatabaseName, "variation", new[] { row });
var resultSet = await _client.ReadAsync <VariationRow>(
InfluxClientFixture.DatabaseName,
"SELECT * FROM variation WHERE indicator = $indicator AND categoryTag = $categoryTag AND category = $category",
new { indicator = true, categoryTag = TestEnum2.Value3, category = TestEnum1.Value2 });
Assert.Equal(1, resultSet.Results.Count);
var result = resultSet.Results[0];
Assert.Equal(1, result.Series.Count);
var series = result.Series[0];
Assert.Equal(1, series.Rows.Count);
Assert.Equal(row, series.Rows[0]);
}
public async Task Should_Write_All_Field_Types_To_Database()
{
var innerList = new List <KeyValuePair <string, string> >();
innerList.Add(KeyValuePair.Create("description", "Configuration Changed"));
var innerJson = JsonConvert.SerializeObject(innerList, Formatting.None);
var outerList = new List <KeyValuePair <string, string> >();
outerList.Add(KeyValuePair.Create("EventList", innerJson));
var outerJson = JsonConvert.SerializeObject(outerList, Formatting.None);
var row1 = new VariationRow
{
Timestamp = new DateTime(2013, 1, 1, 1, 1, 1, DateTimeKind.Utc),
Count = 1337,
Floaty = 13.36f,
Shorty = 23005,
SbytyMcByteFace = 42,
BodyProperties_PointLint_Tag = outerJson,
BodyProperties_PointLint_Field = outerJson,
Indicator = true,
Message = null, //"Hello, \\athere\nWhat's up? ==",
SomeValue = "",
Percent = 0.37,
Type = "tag, =Value",
Category = TestEnum1.Value2,
CategoryTag = TestEnum2.Value3,
CategoryNullable = TestEnum1.Value2,
DoubleTag = 1.123,
IntType = 42,
OtherTimestamp = new DateTime(2011, 4, 23, 1, 23, 54, DateTimeKind.Utc),
Decimal1 = 23.53m,
Decimal2 = 13.97m,
Dto1 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto2 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
Decimal3 = 23.53m,
Decimal4 = 13.97m,
Dto3 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto4 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
};
var row2 = new VariationRow
{
Timestamp = new DateTime(2013, 1, 1, 2, 1, 1, DateTimeKind.Utc),
Count = 1337,
Floaty = 13.36f,
Shorty = 23005,
SbytyMcByteFace = 42,
Indicator = true,
Message = "Hello, \\athere\nWhat's up? ==",
Percent = 0.37,
Type = "tag, =Value",
Category = TestEnum1.Value2,
CategoryTag = TestEnum2.Value3,
CategoryNullable = TestEnum1.Value2,
DoubleTag = 1.123,
IntType = 42,
OtherTimestamp = new DateTime(2011, 4, 23, 1, 23, 54, DateTimeKind.Utc),
Decimal1 = 23.53m,
Decimal2 = 13.97m,
Dto1 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto2 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
Decimal3 = 23.53m,
Decimal4 = 13.97m,
Dto3 = new DateTimeOffset(2011, 1, 1, 20, 32, 10, 53, TimeSpan.FromHours(3)),
Dto4 = new DateTimeOffset(2010, 1, 1, 20, 32, 10, 0, TimeSpan.FromHours(-3)),
};
await _client.WriteAsync(InfluxClientFixture.DatabaseName, "variation", new[] { row1, row2 });
var resultSet = await _client.ReadAsync <VariationRow>(
InfluxClientFixture.DatabaseName,
"SELECT * FROM variation WHERE indicator = $indicator AND categoryTag = $categoryTag AND category = $category",
new { indicator = true, categoryTag = TestEnum2.Value3, category = TestEnum1.Value2 });
Assert.Equal(1, resultSet.Results.Count);
var result = resultSet.Results[0];
Assert.Equal(1, result.Series.Count);
var series = result.Series[0];
Assert.Equal(2, series.Rows.Count);
Assert.Equal(row1, series.Rows[0]);
Assert.Equal(row2, series.Rows[1]);
}
