Recently, I have been working on my Castle ActiveRecord talk. I am writing some WCF services that will be consumed by a Silverlight client. Because I write my code using TDD, I needed to be able to write tests against the WCF services. I wanted to mock out the backing store for my objects, but with ActiveRecord and NHibernate, this is not so straight-forward. Instead, I came across a post about mocking the backing store for NHibernate tests.
The idea is that you use SQLite in "memory-mode" as your database. This makes it so the database vanishes as soon as your connection is destroyed. This is great for testing! No database server... no database file... pure database interfaces. It is not a mock in the traditional sense of the word, but it lets me write tests as if I had a mock framework.
So, I modified the code to work for ActiveRecord. Note that I am overriding the DriverConnectionProvider to keep the connection alive. This is because the in-memory database gets destroyed when the connection closes.
If you want to use this class, add the following class to your test project. You will need to download and add System.Data.SQLite as a project reference.
namespace ActiveRecordTestHelperBy using this class, you simply need to initialize ActiveRecord in your test StartUp method, and destroy the connection in the test TearDown Method. Here is an example of a test fixture that takes advantage of my class:
{
public class ActiveRecordMockConnectionProvider : NHibernate.Connection.DriverConnectionProvider
{
private static IDbConnection _connection;
public override IDbConnection GetConnection()
{
if (_connection == null)
_connection = base.GetConnection();
return _connection;
}
public override void CloseConnection(IDbConnection conn)
{
}
/// <summary>
/// Destroys the connection that is kept open in order to keep the in-memory database alive. Destroying
/// the connection will destroy all of the data stored in the mock database. Call this method when the
/// test is complete.
/// </summary>
public static void ExplicitlyDestroyConnection()
{
if (_connection != null)
{
_connection.Close();
_connection = null;
}
}
/// <summary>
/// Initializes ActiveRecord and the Database that ActiveRecord uses to store the data. Call this method
/// before the test executes.
/// </summary>
/// <param name="types">A list of ActiveRecord types that will be created in the database</param>
public static void InitializeActiveRecord(params Type[] types)
{
ActiveRecordStarter.ResetInitializationFlag();
ActiveRecordStarter.Initialize(GetMockConfiguration(), types);
ActiveRecordStarter.CreateSchema();
}
private static IConfigurationSource GetMockConfiguration()
{
var properties = new Hashtable{
{"hibernate.connection.driver_class", "NHibernate.Driver.SQLite20Driver"},
{"hibernate.dialect", "NHibernate.Dialect.SQLiteDialect"},
{"hibernate.connection.provider", ConnectionProviderLocator},
{"hibernate.connection.connection_string", "Data Source=:memory:;Version=3;New=True;"}};
var source = new InPlaceConfigurationSource();
source.Add(typeof(ActiveRecordBase), properties);
return source;
}
private static string ConnectionProviderLocator
{
get { return String.Format("{0}, {1}", TypeOfEnclosingClass.FullName, EnclosingAssemblyName.Split(',')[0]); }
}
private static Type TypeOfEnclosingClass
{
get { return MethodInfo.GetCurrentMethod().DeclaringType; }
}
private static string EnclosingAssemblyName
{
get { return Assembly.GetAssembly(TypeOfEnclosingClass).FullName; }
}
}
}
[TestFixture]
public class IngredientServiceTests
{
private IRecipeBoxService _recipeBoxService;
[SetUp]
public void SetUp()
{
ActiveRecordMockConnectionProvider.InitializeActiveRecord(typeof(Ingredient));
_recipeBoxService = new RecipeBoxService();
}
[TearDown]
public void TearDown()
{
ActiveRecordMockConnectionProvider.ExplicitlyDestroyConnection();
}
[Test]
public void Test_Get_Ingredients()
{
Ingredient mockIngredient = new Ingredient("ABCD", "DEF");
mockIngredient.Save();
IList<Ingredient> ingredients = new List<Ingredient>(_recipeBoxService.AllIngredients());
Assert.That(ingredients.Count, Is.EqualTo(1));
Assert.That(ingredients[0].Name, Is.EqualTo("ABCD"));
Assert.That(ingredients[0].Description, Is.EqualTo("DEF"));
}
}
