Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

An Example of Test-Driven Development Expand / Collapse
Author
Message
Posted Friday, October 29, 2010 11:34 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:44 PM
Points: 4,359, Visits: 6,197
Andy Leonard (10/29/2010)
LOL Guru!

I think Alex is trying to tell me the same thing, although he's being much nicer about it than you!

:{>


LOVE your tweet btw! Great minds think alike!


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1013242
Posted Friday, October 29, 2010 2:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, May 24, 2014 7:58 PM
Points: 219, Visits: 824
del
Post #1013323
Posted Friday, November 5, 2010 8:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 17, 2012 10:22 PM
Points: 7, Visits: 6
Hi Andy,
I really enjoyed this series and I'm always thrilled to see others combining SQL Server and TDD! I was wondering if you've tried using any of the frameworks out there that help with this?

One of the problems I frequently ran into while TDDing databases is that as the database changes, the tests can become fragile. In other words, adding constraints or renaming columns, or changing data in the database breaks fail pretty quickly. This is okay if the test if very closely related to the change I'm making - in fact I want tests to fail I broke something. But I don't want tests to fail if I changed something irrelevant.

Anyway, I helped write an open source framework, tSQLt (www.tsqlt.org) which helps alleviate these problems of dependencies by allowing you to fake tables and spy procedures (similar to mocking frameworks in Java). It also allows you to group tests into schemas and has some other neat features. It might be something you want to check out if you like DB TDD!

Cheers and good luck with the testing!
-Dennis
Post #1016572
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse