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.
|
|
hi there,
how does dbfit compare to dbunit ?
thank you,
BR,
~A
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.
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
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)