public void NullUtils_GetBoolean_NotNull_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(true));
reader.Read();
Assert.IsTrue(NullUtils.GetBoolean(reader, "unit_test"), "GetBoolean(true) should have returned true");
}
public void NullUtils_GetDateTimeOrNull_Null_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value));
reader.Read();
Assert.IsNull(NullUtils.GetDateTimeOrNull(reader, "unit_test"),
"GetDateTime(null) should have returned null");
}
public void NullUtils_GetDateTime_Null_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value));
reader.Read();
Assert.AreEqual(default(DateTime), NullUtils.GetDateTime(reader, "unit_test"),
"GetDateTime(null) should not have returned a default DateTime");
}
public void NullUtils_GetDateTime_Value_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(new DateTime(2004, 12, 13)));
reader.Read();
Assert.AreEqual(new DateTime(2004, 12, 13), NullUtils.GetDateTime(reader, "unit_test"),
"GetDateTime(value) should have returned a value");
}
public void NullUtils_GetString_Null_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value));
reader.Read();
Assert.AreEqual(String.Empty, NullUtils.GetString(reader, "unit_test"),
"GetString(null) should have returned an empty string");
}
public void NullUtils_GetStringOrNull_Value_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow("123"));
reader.Read();
Assert.AreEqual("123", NullUtils.GetStringOrNull(reader, "unit_test"),
"GetStringOrNull(value) did not return the expected value");
}
public void NullUtils_GetInt64_Value_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(5L));
reader.Read();
Assert.AreEqual(5L, NullUtils.GetInt64(reader, "unit_test"),
"GetInt64(value) did not return the expected value");
}
public void NullUtils_GetInt64_Null_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value));
reader.Read();
Assert.AreEqual(default(long), NullUtils.GetInt64(reader, "unit_test"),
"GetInt64(null) should have returned the default long value");
}
public void NullUtils_GetInt16OrNull_Value_Success()
{
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow((short)17));
reader.Read();
Assert.AreEqual((short)17, NullUtils.GetInt16OrNull(reader, "unit_test").Value,
"GetInt16OrNull(value) did not return the expected value");
}
public void StubDataReader_GetName_GetDataTypeName_Success()
{
using (var reader = new StubDataReader(new StubResultSet("unit", "test")))
{
Assert.AreEqual("test", reader.GetName(1));
Assert.AreEqual("unit", reader.GetDataTypeName(0));
}
}
public void StubDataReader_GetFieldType_Success()
{
using (var reader = new StubDataReader(new StubResultSet("more", "fun").AddRow(8, "yowza")))
{
reader.Read();
Assert.AreEqual(typeof(int), reader.GetFieldType(0));
Assert.AreEqual(typeof(string), reader.GetFieldType(1));
}
}
public void NullUtils_GetGuidOrNull_Value_Success()
{
var guid = Guid.NewGuid();
var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(guid));
reader.Read();
Assert.AreEqual(guid, NullUtils.GetGuidOrNull(reader, "unit_test").Value,
"GetGuidOrNull(value) did not return the expected value");
}
public void StubDataReader_IndexAccessors_Read_Success()
{
using (var reader = new StubDataReader(new StubResultSet("abc", "def").AddRow(3, "nice")))
{
Assert.IsTrue(reader.Read(), "First call to Read() should have had data");
Assert.AreEqual(3, reader[0], "The first column (by index) was not correct");
Assert.AreEqual("nice", reader["def"], "The second column (by name) was not correct");
Assert.IsFalse(reader.Read(), "Second call to Read() should not have had data");
}
}
public void StubDataReader_IndexAccessors_BOF_Failure()
{
using (var reader = new StubDataReader(new StubResultSet()))
{
try
{
var column = reader[0];
Assert.Fail("Index accessor should have thrown an exception (BOF)");
}
catch (InvalidOperationException) { }
}
}
/// <summary>
/// Construct the database service
/// </summary>
/// <param name="data">
/// The <see cref="StubDataReader"/> with data to use for query executions
/// </param>
/// <param name="providers">
/// Providers of type <see cref="IDatabaseQueryProvider"/> or <see cref="IQueryFragmentProvider"/>
/// </param>
public MockDatabaseService(StubDataReader data, params Type[] providers)
{
Data = data;
Queries = new Dictionary <string, DatabaseQuery>();
ExecutedQueries = new List <ExecutedQuery>();
DatabaseService.FillQueryLibrary(Queries, providers);
if (!Queries.ContainsKey("database.sequence.generic"))
{
DatabaseService.FillQueryLibrary(Queries, typeof(DatabaseQueryProvider));
}
}
public void StubDataReader_FieldCount_Success()
{
var result1 = new StubResultSet("col6", "col7", "col8");
var result2 = new StubResultSet("col9", "col0");
using (var reader = new StubDataReader(result1, result2))
{
Assert.IsNotNull(reader, "The StubDataReader object should not have been null");
Assert.AreEqual(3, reader.FieldCount, "The field count for the first result set was incorrect");
reader.NextResult();
Assert.AreEqual(2, reader.FieldCount, "The field count for the second result was incorrect");
}
}
public void StubDataReader_IndexAccessors_EOF_Failure()
{
using (var reader = new StubDataReader(new StubResultSet()))
{
Assert.IsFalse(reader.Read(), "Read() should not have had data");
try
{
var column = reader[0];
Assert.Fail("Index accessor should have thrown an exception (EOF)");
}
catch (InvalidOperationException) { }
}
}
public void IsDBNull_NotNull_Test()
{
StubResultSetCollection stubResultSets = new StubResultSetCollection();
stubResultSets.Add(CreateIsDBNullResultSet());
StubDataReader target = new StubDataReader(stubResultSets);
target.Read();
int i = 2;
bool expected = false;
bool actual;
actual = target.IsDBNull(i);
Assert.AreEqual(expected, actual);
}
public void CollectionSortHandler_CollectionSortHandler_PassNullWriterInConstructor_ThrowArgumentNullException()
{
using (ShimsContext.Create())
{
//
// Arrange.
//
var parser = new StubIDataParser <double>();
var reader = new StubDataReader(new StubIValidator());
ShimDataWriter <double> writer = null;
//
// Assert.
//
Assert.ThrowsException <ArgumentNullException>(() => new CollectionSortHandler <double>(reader, writer, parser));
}
}
public void StubDataReader_CurrentResultSet_NextResult_Failure()
{
using (var reader = new StubDataReader())
{
Assert.IsNotNull(reader, "The StubDataReader object should not have been null");
Assert.IsFalse(reader.NextResult(), "NextResult() should not have had data");
try
{
var results = reader.CurrentResultSet;
Assert.Fail("Call to CurrentResultSet should have thrown an exception");
}
catch (InvalidOperationException exception)
{
Assert.AreEqual("Current ResultSet is at EOF", exception.Message,
"Unexpected EOF exception message");
}
}
}
public void StubDataReader_CurrentResultSet_NextResult_Success()
{
var result1 = new StubResultSet("col1", "col2", "col3");
var result2 = new StubResultSet("col4", "col5");
using (var reader = new StubDataReader(result1, result2))
{
Assert.IsNotNull(reader, "The StubDataReader object should not have been null");
var currentSet = reader.CurrentResultSet;
Assert.IsNotNull(currentSet, "First call to CurrentResultSet should not have returned null");
Assert.AreEqual(result1, currentSet, "First call to CurrentResultSet did not return the first set");
Assert.IsTrue(reader.NextResult(), "First call to NextResult() should have had data");
currentSet = reader.CurrentResultSet;
Assert.IsNotNull(currentSet, "Second call to CurrentResultSet should not have returned null");
Assert.AreEqual(result2, currentSet, "Second call to CurrentResultSet did not return the second set");
}
}
