Release Notes: This is a bugfix release. In CSV files, null values and empty strings are now recognized correctly. In HTML reports, relative paths are used.
Release Notes: This release adds several new checking features: multi-column validator support, multicolumn-validation against reference data sets (exact set/sub set/super set) in CSV or Excel(TM) files, trim checking, and verification of alternative foreign key paths between two tables. All known bugs have been fixed.
Release Notes: Tag clouds show at a glance which checks were executed and which where the most defective ones. A hierarchy provider interface allows for custom definition of hierarchical grouping mechanisms; one provided implementation uses checks to specify tree paths. DatabeneScript expressions can be used to employ a subset of the Java syntax for instantiating plugins. The InfoModule provides more extensive information, and all known bugs were fixed.
Release Notes: This release provides some minor bugfixes in report rendering and navigation. Copying reports with long nested structures is made less problematic by reducing the length of the report file paths. During check execution, the user gets feedback about the number of completed and pending checks.
Release Notes: The new version adds more predefined check types which can be used to verify database tables without SQL knowledge, custom Java validator classes which can be plugged in to perform more sophisticated client-side (or cross-system) checking. Existing functionality has been undergone additional testing, stabilization, and simplification.
Release Notes: The application version can now be automatically retrieved from a database by a SQL query or from a custom Java component. New features can reduce the disk space consumed by reports: The number of defect rows listed in the HTML defects page can be restricted (while keeping the summary numbers complete and correct, option -m or --maxrows). The report can be zipped using command line option -z (or --zip)
Release Notes: A report module has been added to provide a summary of check results as a CSV file.
Release Notes: This release provides bugfixes related to PostgreSQL and Windows OS.
Release Notes: An additional more abtract semantic allows you to define general requirements without having to battle with SQL: <foreignKey>, <unique>, <notNull>, <stringLength>, <numberSize>. A "Digest" Module creates a minimalistic overview of all checks with verdict indication and links to check results. Checks can be tagged with arbitrary words and the user can restrict check execution to a list of tags. The number of reported defects can be limited. All known bugs are fixed.
Release Notes: Each check can be assigned with a selection of version numbers/names, enabling the user to support all versions of the checked application with a single file. Each check can be assigned with a requirements id and DB Sanity can automatically open a browser window with the generated report. Explicit support of process exit codes makes it easier to integrate DB Sanity with complex deployment scripts.