public async Task CanQueryAllSupportedTypes() { var client = CreateClient(); Response<LogsQueryResult> results = await client.QueryAsync(TestEnvironment.WorkspaceId, $"datatable (DateTime: datetime, Bool:bool, Guid: guid, Int: int, Long:long, Double: double, String: string, Timespan: timespan, Decimal: decimal, NullBool: bool, Dynamic: dynamic)" + "[" + "datetime(2015-12-31 23:59:59.9)," + "false," + "guid(74be27de-1e4e-49d9-b579-fe0b331d3642)," + "12345," + "1234567890123," + "12345.6789," + "\"string value\"," + "10s," + "decimal(0.10101)," + "bool(null)," + "dynamic({\"a\":123, \"b\":\"hello\", \"c\":[1,2,3], \"d\":{}})" + "]", _logsTestData.DataTimeRange); LogsTableRow row = results.Value.Table.Rows[0]; var expectedDate = DateTimeOffset.Parse("2015-12-31 23:59:59.9+00:00"); Assert.AreEqual(expectedDate, row.GetDateTimeOffset("DateTime")); Assert.AreEqual(expectedDate, row.GetDateTimeOffset(0)); Assert.AreEqual(expectedDate, row.GetObject("DateTime")); Assert.AreEqual(false, row.GetBoolean("Bool")); Assert.AreEqual(false, row.GetBoolean(1)); Assert.AreEqual(false, row.GetObject("Bool")); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), row.GetGuid("Guid")); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), row.GetGuid(2)); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), row.GetObject("Guid")); Assert.AreEqual(12345, row.GetInt32("Int")); Assert.AreEqual(12345, row.GetInt32(3)); Assert.AreEqual(12345, row.GetObject("Int")); Assert.AreEqual(1234567890123, row.GetInt64("Long")); Assert.AreEqual(1234567890123, row.GetInt64(4)); Assert.AreEqual(1234567890123, row.GetObject("Long")); Assert.AreEqual(12345.6789d, row.GetDouble("Double")); Assert.AreEqual(12345.6789d, row.GetDouble(5)); Assert.AreEqual(12345.6789d, row.GetObject("Double")); Assert.AreEqual("string value", row.GetString("String")); Assert.AreEqual("string value", row.GetString(6)); Assert.AreEqual("string value", row.GetObject("String")); Assert.AreEqual(TimeSpan.FromSeconds(10), row.GetTimeSpan("Timespan")); Assert.AreEqual(TimeSpan.FromSeconds(10), row.GetTimeSpan(7)); Assert.AreEqual(TimeSpan.FromSeconds(10), row.GetObject("Timespan")); Assert.AreEqual(0.10101m, row.GetDecimal("Decimal")); Assert.AreEqual(0.10101m, row.GetDecimal(8)); Assert.AreEqual(0.10101m, row.GetObject("Decimal")); Assert.Null(row.GetBoolean("NullBool")); Assert.Null(row.GetBoolean(9)); Assert.IsNull(row.GetObject("NullBool")); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", row.GetDynamic(10).ToString()); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", row.GetDynamic("Dynamic").ToString()); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", row.GetObject("Dynamic").ToString()); }
public void ValidateMonitorModelFactoryTableCreation() { LogsTableColumn logsTableColumn0 = MonitorQueryModelFactory.LogsTableColumn("column0", LogsColumnType.Datetime); LogsTableColumn logsTableColumn1 = MonitorQueryModelFactory.LogsTableColumn("column1", LogsColumnType.Guid); LogsTableColumn logsTableColumn2 = MonitorQueryModelFactory.LogsTableColumn("column2", LogsColumnType.Int); LogsTableColumn logsTableColumn3 = MonitorQueryModelFactory.LogsTableColumn("column3", LogsColumnType.Long); LogsTableColumn logsTableColumn4 = MonitorQueryModelFactory.LogsTableColumn("column4", LogsColumnType.Real); LogsTableColumn logsTableColumn5 = MonitorQueryModelFactory.LogsTableColumn("column5", LogsColumnType.String); LogsTableColumn logsTableColumn6 = MonitorQueryModelFactory.LogsTableColumn("column6", LogsColumnType.Timespan); LogsTableColumn logsTableColumn7 = MonitorQueryModelFactory.LogsTableColumn("column7", LogsColumnType.Decimal); LogsTableColumn logsTableColumn8 = MonitorQueryModelFactory.LogsTableColumn("column8", LogsColumnType.Bool); LogsTableColumn logsTableColumn9 = MonitorQueryModelFactory.LogsTableColumn("column9", LogsColumnType.Dynamic); LogsTableColumn[] logsTableColumns = new LogsTableColumn[] { logsTableColumn0, logsTableColumn1, logsTableColumn2, logsTableColumn3, logsTableColumn4, logsTableColumn5, logsTableColumn6, logsTableColumn7, logsTableColumn8, logsTableColumn9 }; Object[] rowValues = new Object[] { "2015-12-31T23:59:59.9Z", "74be27de-1e4e-49d9-b579-fe0b331d3642", 12345, 1234567890123, 12345.6789, "string value", "00:00:10", "0.10101", false, "{\u0022a\u0022:123,\u0022b\u0022:\u0022hello\u0022,\u0022c\u0022:[1,2,3],\u0022d\u0022:{}}" }; LogsTableRow logsTableRow = MonitorQueryModelFactory.LogsTableRow(logsTableColumns, rowValues); LogsTableRow[] rowArray = new LogsTableRow[] { logsTableRow }; LogsTable logsTable = MonitorQueryModelFactory.LogsTable("tester", logsTableColumns.AsEnumerable(), rowArray.AsEnumerable()); Assert.AreEqual("tester", logsTable.Name); Assert.AreEqual(1, logsTable.Rows.Count); Assert.AreEqual(10, logsTable.Columns.Count); Assert.AreEqual("column0", logsTable.Columns[0].Name); Assert.AreEqual("datetime", logsTable.Columns[0].Type.ToString()); Assert.AreEqual("column1", logsTable.Columns[1].Name); Assert.AreEqual("guid", logsTable.Columns[1].Type.ToString()); Assert.AreEqual("column2", logsTable.Columns[2].Name); Assert.AreEqual("int", logsTable.Columns[2].Type.ToString()); Assert.AreEqual("column3", logsTable.Columns[3].Name); Assert.AreEqual("long", logsTable.Columns[3].Type.ToString()); Assert.AreEqual("column4", logsTable.Columns[4].Name); Assert.AreEqual("real", logsTable.Columns[4].Type.ToString()); Assert.AreEqual("column5", logsTable.Columns[5].Name); Assert.AreEqual("string", logsTable.Columns[5].Type.ToString()); Assert.AreEqual("column6", logsTable.Columns[6].Name); Assert.AreEqual("timespan", logsTable.Columns[6].Type.ToString()); Assert.AreEqual("column7", logsTable.Columns[7].Name); Assert.AreEqual("decimal", logsTable.Columns[7].Type.ToString()); Assert.AreEqual("column8", logsTable.Columns[8].Name); Assert.AreEqual("bool", logsTable.Columns[8].Type.ToString()); Assert.AreEqual("column9", logsTable.Columns[9].Name); Assert.AreEqual("dynamic", logsTable.Columns[9].Type.ToString()); var expectedDate = DateTimeOffset.Parse("2015-12-31 23:59:59.9+00:00"); Assert.AreEqual(expectedDate, logsTable.Rows[0].GetDateTimeOffset(0)); Assert.AreEqual(expectedDate, logsTable.Rows[0].GetObject("column0")); Assert.AreEqual(false, logsTable.Rows[0].GetBoolean("column8")); Assert.AreEqual(false, logsTable.Rows[0].GetBoolean(8)); Assert.AreEqual(false, logsTable.Rows[0].GetObject("column8")); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), logsTable.Rows[0].GetGuid("column1")); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), logsTable.Rows[0].GetGuid(1)); Assert.AreEqual(Guid.Parse("74be27de-1e4e-49d9-b579-fe0b331d3642"), logsTable.Rows[0].GetObject("column1")); Assert.AreEqual(12345, logsTable.Rows[0].GetInt32("column2")); Assert.AreEqual(12345, logsTable.Rows[0].GetInt32(2)); Assert.AreEqual(12345, logsTable.Rows[0].GetObject("column2")); Assert.AreEqual(1234567890123, logsTable.Rows[0].GetInt64("column3")); Assert.AreEqual(1234567890123, logsTable.Rows[0].GetInt64(3)); Assert.AreEqual(1234567890123, logsTable.Rows[0].GetObject("column3")); Assert.AreEqual(12345.6789d, logsTable.Rows[0].GetDouble("column4")); Assert.AreEqual(12345.6789d, logsTable.Rows[0].GetDouble(4)); Assert.AreEqual(12345.6789d, logsTable.Rows[0].GetObject("column4")); Assert.AreEqual("string value", logsTable.Rows[0].GetString("column5")); Assert.AreEqual("string value", logsTable.Rows[0].GetString(5)); Assert.AreEqual("string value", logsTable.Rows[0].GetObject("column5")); Assert.AreEqual(TimeSpan.FromSeconds(10), logsTable.Rows[0].GetTimeSpan("column6")); Assert.AreEqual(TimeSpan.FromSeconds(10), logsTable.Rows[0].GetTimeSpan(6)); Assert.AreEqual(TimeSpan.FromSeconds(10), logsTable.Rows[0].GetObject("column6")); Assert.AreEqual(0.10101m, logsTable.Rows[0].GetDecimal("column7")); Assert.AreEqual(0.10101m, logsTable.Rows[0].GetDecimal(7)); Assert.AreEqual(0.10101m, logsTable.Rows[0].GetObject("column7")); Assert.IsFalse(logsTable.Rows[0].GetBoolean("column8")); Assert.IsFalse(logsTable.Rows[0].GetBoolean(8)); Assert.AreEqual(false, logsTable.Rows[0].GetObject("column8")); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", logsTable.Rows[0].GetDynamic(9).ToString()); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", logsTable.Rows[0].GetDynamic("column9").ToString()); Assert.AreEqual("{\"a\":123,\"b\":\"hello\",\"c\":[1,2,3],\"d\":{}}", logsTable.Rows[0].GetObject("column9").ToString()); }