DevForce Community Forum : How tp cleanup after running Unit Tests http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : How tp cleanup after running Unit Tests Sat, 11 Apr 2026 11:09:16 -700 Thu, 12 Jul 2007 16:41:23 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=229 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ How tp cleanup after running Unit Tests : DevForce does not support your... http://www.ideablade.com/forum/forum_posts.asp?TID=229&PID=508#508 Author: IdeaBlade
Subject: 229
Posted: 12-Jul-2007 at 4:41pm

DevForce does not support your transactional approach.  We do transactional saves as part of the SaveChanges method, but we do not support the ability to start a transaction, do a whole bunch of database operations, and then rollback the entire set of database operations.  According to our CTO, supporting long running transactions of this type is a bad idea.  Instead he believes that you should start and complete transactions as quickly as possible. 

I agree with you that CheckPointing is not the ultimate answer.  While Checkpointing may be a great solution the vast majority of the time, a big problem is that if the application crashes, there is no way to undo the database changes.

Our current strategy is to develop a “Cleanup” test that restores the database by programmatically applying fixes to the database.  For example, we may delete all employees with an ID greater than 1000 after first deleting all of their orders and order details.

 At some point in the future, we may develop a more robust solution by using database restore.

 

]]> Thu, 12 Jul 2007 16:41:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=229&PID=508#508 How tp cleanup after running Unit Tests : I'm starting to learn the... http://www.ideablade.com/forum/forum_posts.asp?TID=229&PID=507#507 Author: Customer
Subject: 229
Posted: 12-Jul-2007 at 4:40pm

I'm starting to learn the IdeaBlade ORM.   I'm trying to get some existing NUnit tests running.  In our current application we begin a transaction during SetUp, and then roll back the transaction during a TearDown method.  This ensures that the unit test database's contents do not ever get modified.

I'm having difficulty figuring out how to do this with IdeaBlade.  CheckPoints do not seem to be the answer.  Any insights you could provide will be greatly appreciated.]]> Thu, 12 Jul 2007 16:40:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=229&PID=507#507