Exemplo n.º 1
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, 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]);
        }
Exemplo n.º 2
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]);
        }
Exemplo n.º 3
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]);
        }