DbFit 1.0 With Enhanced Querying Capabilities and User Docs

| by Mike Bria Follow 0 Followers on Mar 17, 2008. Estimated reading time: 1 minute |
Gojko Adzic has recently announced the version 1.0 release of DbFit, his popular FIT/FitNesse extension used for practicing TDD on database code.  Gojko summarizes what's new and fresh with DbFit 1.0 as follows:
Major updates
  1. Support for in/out parameters in stored procedures.
  2. Support for querying stored results
  3. Support for SQL Server 2000 in .NET. Not as complete as Sql Server 2005, but should work in most cases.
  4. Support for testing blank-padded fixed length CHAR types.
  5. .NET version now compiled with FitNesse.NET 1.5
  6. Proper documentation — finally. The documentation is available as PDF and FitNesse (included in the dbfit-complete package) and also online at FitNesse.Info.
Minor updates
  1. Oracle date used as Timestamp to allow V8 compatibility switch to work
  2. Stored procedure params no longer have to be listed in the same order as in db
  3. GUID handler now just redirecting to standard GUID handler in .NET
  4. OrderedQuery and StoreParameter fixtures for standalone mode
  5. bugfix for transactions not getting rolled back in Java after tests in flow mode
  6. bugfix for ntext and text field sizes in sql server
  7. bugfix for fail[null] NullPointerException in Java
  8. workaround for fail[null] bug in 1.5
  9. Acceptance tests now reorganised better.
Not long ago, Gojko had written in an article about what drove him to create DbFit, in which he comes to the following conclusion:
  • Agile practices make as much sense for the database as for anything else, they are just (a bit) harder to implement
  • To change the way people work, you need to get them enthusiastic, not compliant.
  • In order to get developers enthusiastic, focus on reducing dull work
  • DbFit solves two major problems with TDD of DB code: object-relational mismatch and DB specialists not being to write tests efficiently.
Check out the fully re-engineered documentation for more information on what DbFit is all about and how to make the most of the tool to help unit test your database code.

See Scott Ambler's popular Agile Data series for more expert advice on agile and tdd at the database layer, and also InfoQ's agile community for the very freshest on agile tools, techniques, debates, and ideas.

Rate this Article

Adoption Stage

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

db-code, i know it's name now. by ding jack

I've heard that some people writen db-code still nowadays.I hope they will jump out the well in let's guess 10 years.

Re: db-code, i know it's name now. by Mike Bria

Hi Jack --

Might you be able to clarify just a bit what you're note means.


Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

2 Discuss

Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you