Sep 04 2007

DbFit 0.9: Support for MySql, complete Oracle for Java support and more

Published by gojko at 5:08 pm under dbfit

A new binary release of DbFit is now on available. Grab it from SourceForge. This is a general catch-up and clean-up release, generally intended as a replacement for all the ad-hoc binary builds over the last few months.

New and noteworthy:

General:

  • support for embedding DbFit tables into Java/.Net tests as a quick and efficient way to prepare the stage or verifying db results
  • new fixtures: QueryStats and Clean for quick checking and cleaning up tables
  • support for testing individual error codes with stored procs

Java:

  • initial support for MySql 5
  • support for Oracle stored functions, float and timestamps

DotNet

  • support for BIT data type in SQLServer 2005
  • support for Oracle Float data type

dbfit-complete-20070904.zip package contains all binaries (.NET and Java), examples and acceptance tests. Download that package if you want to start using DbFit. For those of you that already have an older binary release in use, I prepared smaller packages with DotNet and Java binaries.


Add to Del.Icio.Us bookmarks

4 Responses to “DbFit 0.9: Support for MySql, complete Oracle for Java support and more”

  1. # Anjan Bacchuon 04 Sep 2007 at 6:40 pm

    hi there,

    how does dbfit compare to dbunit ?

    thank you,

    BR,
    ~A

  2. # gojkoon 05 Sep 2007 at 10:07 am

    Hi,

    DbUnit is an extension for JUnit (so it requires java knowledge), and works in an x-Unit style fashion. DbFit is an extension for FIT/FitNesse, so it works in a tabular/relational language, which comes much more natural for database objects. In addition to mixing with Java or .Net tests, it can be used by db specialists for TDD without writing java or .net code. Also, it has quite a few useful features to speed up test writing, like automatic transaction rollback on the end of the test.

  3. # Peter Con 10 Oct 2007 at 2:39 pm

    Hi,

    Excellent work. I read in DBFit-oracle.pdf that there is some support for ref cursors, but I can’t get them work. Could you please provide some working example of a test using function with such cursor.

    BR,

    Peter

  4. # gojkoon 10 Oct 2007 at 4:23 pm

    you can store a ref cursor into a symbol (i.e. use >>mycursor in the output cell) and then use that as an input for the query fixture. An example is in DotNet.AcceptanceTests.OracleAcceptanceTests.RefCursorOutput. Java version still does not support this, but it is not hard to add (nobody requested it yet, I will add it if you need it)

Trackback URI | Comments RSS

Leave a Reply