BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Contribute
News Articles Presentations Podcasts Guides

Topics

Choose your language

QCon Plus May
QCon Plus May

Uncover emerging trends and practices from software leaders. Attend online on May 10-20, 2022.

 QCon San Francisco
InfoQ Live June

Learn how cloud architectures achieve cost savings, improve reliability & deliver value. Register Now.

 QCon San Francisco
QCon San Francisco

Understand the emerging software trends you should pay attention to. Attend in-person on Oct 24-28, 2022.

InfoQ Homepage News Test-Driven Database Development with DbFit

Streaming SQL on Apache Kafka for Real-Time Processing (Live Webinar May 26th, 2022) - Save Your Seat

Test-Driven Database Development with DbFit

Bookmarks

Mar 01, 2007 1 min read

Write for InfoQ

Join a community of experts. Increase your visibility.
Grow your career.Learn more
Gojko Adzic has released DbFit, an extension of the Fit testing framework enabling test-driven development against Oracle databases:
DbFit is an extension of the .NET 2.0 Fit test runner which enables Fit/FitNesse tests to execute directly against a database. Version 0.1 supports testing stored procedures and functions, executing queries and statements on Oracle. Support for SQL Server is currently in development (expect it soon).
But why use DbFit to test against the database? Can't the same thing be accomplished with ordinary unit testing frameworks? On reddit.com, Gojko elaborated on the rationale behind DbFit:
After introducing FitNesse into a big .NET project, I found that we were still lacking test-coverage for a lot of DB (legacy) code, and that DB developers have a long feedback loop, so they were not really benefiting from TDD. FitNesse was a good solution because it enabled DB developers to write functional tests much easier than in pl/sql based unit testing libraries, and without getting Java developers involved to write those as JUnit tests. Although FitNesse is typically used for acceptance tests, the combination of FitNesse+DbFit filled the testing gap for our DB code with excellent results, so I wanted to share the library with others.

Note that DbFit currently requires both Java and the .NET 2.0 runtime. Gojko has helpfully provided a DbFit tutorial [pdf] to help new users get up and running.

Inspired by this content? Write for InfoQ.

Becoming an editor for InfoQ was one of the best decisions of my career. It has challenged me and helped me grow in so many ways. We'd love to have more people join our team.

Thomas BettsLead Editor, Software Architecture and Design @InfoQ; Senior Principal Engineer
Write for InfoQ

Rate this Article

Adoption
Style

This content is in the Oracle topic

Related Topics:

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.

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

Community comments

  • FYI: Fitnesse Testing

    by Dan Barber,

    Your message is awaiting moderation. Thank you for participating in the discussion.

    Just wanted to mention Fitnesse Acceptance Test framework as well.
    fitnesse.org/

    Back to top
  • Re: FYI: Fitnesse Testing

    by Kurt Christensen,

    Your message is awaiting moderation. Thank you for participating in the discussion.

    Right on - thanks for adding that. Gojko has been helpful in this arena as well; he wrote a really great intro on getting Fit and Fitnesse working for .NET applications.

    Back to top

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

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

BT