databene

 
  • Increase font size
  • Default font size
  • Decrease font size

dbsanity4ben

dbsanity4ben is a Benerator plugin which enables Benerator to perform database sanity checks using DB Sanity.

Installation

To use dbsanity4ben, just copy the jar files from the lib folder into your Benerator installation's lib folder.

If you want to distribute a data generation project which uses dbsanity4ben to run on a plain Benerator installation, put the jars mentioned above into a 'lib' folder inside your project folder. 


Usage

You can call Databene DB Sanity for checking preconditions before starting data generation and for verifying properness of the generated data in the end. For detailed information about DB Sanity, check its project homepage: http://databene.org/dbsanity. To use its functionality in Benerator, download and install dbsanity4ben from http://databene.org/dbsanity4ben.

For calling DB Sanity in a Benerator descriptor file, you define the checks and put them into a single XML file or distribute them over several ones and put them into a sub directory of your Benerator project, typically called 'dbsanity'.

Import the plugin functionality to your Benerator project using

<import platform="dbsanity" … />

 

Then you can call DB Sanity providing a reference to a database you have declared before:

<database id="db" … />
<dbsanity database="db" />

 

Alternatively, you can specify the environment and use a new database connection to perform data verification:

<dbsanity environment="mytestdb" />



You have the following configuration options:

Option

Description

Default Value

environment

The environment name with the configuration of the database to verify (see the 'database' chapter about environment definition).

-

database

The database to verify

-

in

The directory from which to read the

dbsanity

out

The directory in which to put the report

dbsanity-report

appVersion

An application version for which to perform the checks

*

tables

Comma-separated list of tables on which to restrict the checks

-

tags

Comma-separated list of tags on which to restrict the checks

-

skin

The DB sanity skin to use for reports

online

locale

The locale in which to render values

default locale

mode

DB Sanity's execution mode

default

onError

Configures how to react to a requirements violation

See the chapter 'Error Handling'

 

Requirements

- Java 1.6+
- Benerator 0.7.6+