public void Should_be_possible_to_transform_a_sqlQueryResult_with_empty_field_into_a_list_of_ovalRecordType() { var fakeSqlQueryResult = new SqlQueryResult(); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "id", "name" }, new object[] { null, null })); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "id", "name" }, new object[] { 1, null })); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "id", "name" }, new object[] { null, "John" })); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "id", "name" }, new object[] { 2, "Michael" })); var ovalRecords = fakeSqlQueryResult.ToOvalRecordTypeList(); Assert.IsNotNull(ovalRecords); Assert.AreEqual(4, ovalRecords.Count()); var firstRecord = ovalRecords.ElementAt(0); AssertField(firstRecord.field.First(), "id", null); AssertField(firstRecord.field.Last(), "name", null); var secondRecord = ovalRecords.ElementAt(1); AssertField(secondRecord.field.First(), "id", "1"); AssertField(secondRecord.field.Last(), "name", null); var thirdRecord = ovalRecords.ElementAt(2); AssertField(thirdRecord.field.First(), "id", null); AssertField(thirdRecord.field.Last(), "name", "John"); var fourthRecord = ovalRecords.ElementAt(3); AssertField(fourthRecord.field.First(), "id", "2"); AssertField(fourthRecord.field.Last(), "name", "Michael"); }
private SqlQueryResult CreateFakeQueryResult() { var fakeColumnNames = new string[] { "name", "id", "enabled" }; var fakeQueryResult = new SqlQueryResult(); fakeQueryResult.AddRecord(CreateFakeRecord(fakeColumnNames, new object[] { "John", 1, true })); fakeQueryResult.AddRecord(CreateFakeRecord(fakeColumnNames, new object[] { "David", 2, false })); return(fakeQueryResult); }
public void Should_be_possible_to_transform_a_sqlQueryResult_with_empty_field_into_a_list_of_ovalSimpleAnyType() { var fakeSqlQueryResult = new SqlQueryResult(); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "name" }, new object[] { "John" })); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "name" }, new object[] { null })); fakeSqlQueryResult.AddRecord(CreateFakeRecord(new string[] { "name" }, new object[] { "Mark" })); var ovalSimpleTypes = fakeSqlQueryResult.ToOvalSimpleTypeList(); Assert.IsNotNull(ovalSimpleTypes); Assert.AreEqual(3, ovalSimpleTypes.Count()); Assert.AreEqual("John", ovalSimpleTypes.ElementAt(0).Value); Assert.AreEqual("Mark", ovalSimpleTypes.ElementAt(2).Value); var nullField = ovalSimpleTypes.ElementAt(1); Assert.IsNull(nullField.Value); Assert.AreEqual(StatusEnumeration.doesnotexist, nullField.status); }