Several posts have been made lately concerning testing NHibernate Mappings. I thought I would share what I have done for the past few months.<\/p>\n
I create a test fixture for each class mapped in NHibernate. The tests in the fixture test loading, updating, saving, and deleting through NHibernate.<\/p>\n
Initially, I only tested loading, but later found out that when we started saving objects with NHibernate, it broke. Likewise, with deletes, I found some cascading deletes conflicted with triggers in the database (that I had no conrtol over). Had I tested the deletion, I would have known. So I find it a good practice to test all of the above for your mappings.<\/p>\n
Here are some sample tests<\/p>\n
<\/p>\n
[ TestMethod<\/span> ]<\/p>\n public<\/span> void<\/span> Loading_a_VirtualColumn_will_populate_all_its_properties()<\/p>\n {<\/p>\n VirtualColumn<\/span> expectedColumn = Anonymous<\/span>.VirtualColumn();<\/p>\n \n \/\/ Insert column into Db.<\/span><\/p>\n _context.AddVirtualColumn( expectedColumn );<\/p>\n _context.Persist( _session );<\/p>\n \n \/\/ Load from Db.<\/span><\/p>\n VirtualColumn<\/span> actualColumn = _session.Get<VirtualColumn<\/span>>( expectedColumn.Id );<\/p>\n \n \/\/ Ensure all properties match.<\/span><\/p>\n TestAssertions<\/span>.VirtualColumnEquals( expectedColumn, actualColumn );<\/p>\n }<\/p>\n \n \n [ TestMethod<\/span> ]<\/p>\n public<\/span> void<\/span> Updating_a_VirtualColumns_CriteriaExpression_and_saving_should_persist_the_change()<\/p>\n {<\/p>\n VirtualColumn<\/span> column = Anonymous<\/span>.VirtualColumn_WithVersionCriteria();<\/p>\n \n \/\/ Insert column with its criteria expression into Db.<\/span><\/p>\n _context.AddVirtualColumn( column );<\/p>\n _context.Persist( _session );<\/p>\n \n \/\/ Get column to update from db.<\/span><\/p>\n VirtualColumn<\/span> persistedColumn = _session.Get<VirtualColumn<\/span>>( column.Id );<\/p>\n Assert<\/span>.IsInstanceOfType( persistedColumn.CriteriaExpression,<\/p>\n typeof<\/span> ( VersionExpression<\/span> ) );<\/p>\n \n \/\/ Update column and persist.<\/span><\/p>\n persistedColumn.CriteriaExpression = Anonymous<\/span>.BudgetYearExpression();<\/p>\n _session.SaveOrUpdate( persistedColumn );<\/p>\n _session.Flush();<\/p>\n \n \/\/ Get the updated column.<\/span><\/p>\n VirtualColumn<\/span> actualColumn = _session.Get<VirtualColumn<\/span>>( column.Id );<\/p>\n \n \/\/ Ensure the change was persisted.<\/span><\/p>\n Assert<\/span>.IsInstanceOfType( actualColumn.CriteriaExpression,<\/p>\n typeof<\/span> ( BudgetYearExpression<\/span> ) );<\/p>\n }<\/p>\n \n \n [ TestMethod<\/span> ]<\/p>\n public<\/span> void<\/span> Deleting_a_Virtual_Column_should_remove_it_from_the_db()<\/p>\n {<\/p>\n VirtualColumn<\/span> column = Anonymous<\/span>.VirtualColumn();<\/p>\n \n \/\/ Insert column into Db.<\/span><\/p>\n _context.AddVirtualColumn( column );<\/p>\n _context.Persist( _session );<\/p>\n \n \/\/ Get column to delete from db.<\/span><\/p>\n VirtualColumn<\/span> persistedColumn = _session.Get<VirtualColumn<\/span>>( column.Id );<\/p>\n \n \/\/ Delete the column.<\/span><\/p>\n _session.Delete( persistedColumn );<\/p>\n _session.Flush();<\/p>\n \n \/\/ Ensure it was removed from db.<\/span><\/p>\n TestDataAssertions<\/span>.VirtualColumnDoesNotExist( column, _session );<\/p>\n }<\/p>\n \n \n [ TestMethod<\/span> ]<\/p>\n public<\/span> void<\/span> Deleting_a_Virtual_Column_should_also_remove_its_Criteria_Expression_from_the_db()<\/p>\n {<\/p>\n VirtualColumn<\/span> column = Anonymous<\/span>.VirtualColumn_ForAmountInPeriod( January );<\/p>\n \n \/\/ Insert column into Db.<\/span><\/p>\n _context.AddVirtualColumn( column );<\/p>\n _context.Persist( _session );<\/p>\n \n \/\/ Get column to delete from db.<\/span><\/p>\n VirtualColumn<\/span> persistedColumn = _session.Get<VirtualColumn<\/span>>( column.Id );<\/p>\n \n \/\/ Delete the column.<\/span><\/p>\n _session.Delete( persistedColumn );<\/p>\n _session.Flush();<\/p>\n \n \/\/ Ensure it was removed from db.<\/span><\/p>\n TestDataAssertions<\/span>.ExpressionDoesNotExist( column.CriteriaExpression, _session );<\/p>\n }<\/p>\n<\/div>\n The code may require some explanation, because much of the nuts and bolts functionality is hidden behind classes that make the tests much more readable. Let me explain what these do:<\/p>\n The _context<\/strong> object is a DynamicConext class that I created for unit testing that allows me to easily create test object graphs, and it also provides the ability to insert the data from those objects into a database. It uses the NHibernate _session object to do so, but doesn\u00e2\u20ac\u2122t use the NHibernate mappings.<\/p>\n The Anonymous<\/strong> object is an object mother I created to create anonymous test objects. It simply returns a valid object with random data.<\/p>\n The TestAssertions<\/strong> and TestDataAssertions<\/strong> classes are custom assertions I wrote to increase readability of the tests. The TestAssertions assert against objects whereas the TestDataAssertions assert against a database. This is so that I can test the database state independently from NHibernate. (It\u00e2\u20ac\u2122s not a good idea to use NHibernate to test NHibernate).<\/p>\n Note that the tests do not use any custom repositories from my domain. They just use the NHibernate session directly. This is because I am not testing my repositories. I only want to test my NHibernate mappings. If I had a custom repository for the \u00e2\u20ac\u0153CalculatedField\u00e2\u20ac\u009d class, I would test it separately.<\/p>\n In upcoming posts I will explain my implementation of the DynamicContext, Anonymous, and custom TestAssertion classes.<\/p>\n -=CE=-<\/p>\n","protected":false},"excerpt":{"rendered":" Several posts have been made lately concerning testing NHibernate Mappings. I thought I would share what I have done for the past few months. I create a test fixture for each class mapped in NHibernate. The tests in the fixture test loading, updating, saving, and deleting through NHibernate. Initially, I only tested loading, but later […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3,8],"tags":[15,36,71],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-agile","category-test-driven-development","category-testing","tag-integration-testing","tag-tdd","tag-testing"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":2,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/posts\/24\/revisions"}],"predecessor-version":[{"id":162,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/posts\/24\/revisions\/162"}],"wp:attachment":[{"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/media?parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/categories?post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/architester.com\/blog\/wp-json\/wp\/v2\/tags?post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}