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);
}
