Open Source Software Testing Tools

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies. Platform-independent, it can retrieve data from both the IMDb's web server and a local copy of the whole db.

dbUnit is a JUnit extension targeted for database-driven projects that, among other things, puts your database into a known state between test runs.

Testcontainers is an open source library for providing throwaway, lightweight instances of databases, message brokers, web browsers, or just about anything that can run in a Docker container. No more need for mocks or complicated environment configurations. Define your test dependencies as code, then simply run your tests and containers will be created and then deleted. With support for many languages and testing frameworks, all you need is Docker. Use a containerized instance of your database to test your data access layer code for complete compatibility, without requiring a complex setup on developer machines. Trust that your tests will always start with a known state. Use containerized web browsers, compatible with Selenium, to run automated UI tests. Each test gets a fresh, clean instance of the browser, without having to worry about variations in plugins or required updates.

Firebird 2.5 is required at least Monitor and trace Firebird activity on Windows and Linux. Let DBA to get the traces and send them to you when you can't access to production server. Watch query duration and plan.

dbMonster is a tool which generates random test data and puts it into SQL database. It helps to test how an application can deal with large database.

csvdiff is a Perl script to diff/compare two csv files with the possibility to select the separator. Differences will be shown like: "Column XYZ in record 999" is different. After this, the actual and the expected result for this column will be shown.

Our objective: to provide a unit testing framework for PL/SQL developers modeled on the Junit and Xunit frameworks. Based on the Extreme Programming methodology, utPLSQL makes it easy for developers to set up and execute unit tests of packages. Active development of this project is now on GitHub

When testing using a database with rollback after each test, failing tests are very hard to resolve. Data Storm is a simple DB viewer directly launchable from within your test code to enable you to inspect the current state of the database.

Ingres Dynamic Playback is a tool to play back prerecorded SQL statements to do functional and stress testing on the Ingres Database. More information here: http://community.ingres.com/wiki/Dynamic_Playback

This project is a java web application developer toolbox. It is among other, a simple and powerful framework which does not require dealing with XML files. It also provides a lot of other features, such as a DB abstraction layer, a nice javadoc doclet, a

JdbcProxy is a JDBC 2.0 driver that can help debug or test applications. The driver can wrap another JDBC driver to debug the JDBC calls done by the application. The driver can also emulate another JDBC driver to test the application without a database.

Orate is a source-level tracing facility for Oracle PL/SQL. Programmers insert calls to Orate in the code and Orate captures and writes run time information to a table. These data are suitable for debugging, testing and profiling the application.

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

Please note the project has moved to GitHub, see http://benilovj.github.com/dbfit DbFit is a set of fixtures which enables FIT/FitNesse tests to execute directly against a database, enabling developers to manipulate database objects in a relational form, making database TDD much easier then with xUnit-style tools.

DB Sanity performs checks on a database for verifying data consistency and correctness of aplication deployments. It is invoked by command line and creates an HTML report with aggregated diagnostic summaries and listings of faulty database entries.

DBFeeder is a great tool to generate synthetic testdata for Oracle Databases and it is ideal for companies who wants to outsource development. Thanks to his original approach, data can be highly customizable and it even fits primary and foreign keys constraints of tables.

Eclipse Documentum DQL/API plug-in with the main functionality of content proposals and colour coding. As a secondary result testing things the plug-in is starting to resemble a fast hard client. A feature we lost when a certain hard client was replaced.

Fill your database with test data, move in and be happy. DataRoller is a small program that will insert rows into your database based on a file describing your tables and columns. Script files describe how each table relates to other tables, how DataRoller should geneate foreign keys, and how each column should look. DataRoller executes your script file, generating insert statements and filling your database with data.

DB Initiator is a tool to quickly populate a database with nonsense data quickly and easily. This can aid in testing the scalability of your database driven website, or easily design the UI with plenty of data loaded.

FormatCheck screens flat files looking for violations in the format of the data. It uses a set of XML files that define the rules for each file format. The Swing front-end allows the user to run the verification, view and print the errors.

Need sample data for your database? Genedator is a tool that helps you to generate data for your database. Set of dynamically loaded generators allows you generating any combination of data regarding columns type and purpose.

This software provides PL/SQL packages for defining and measuring business tasks utilizing Oracle's extended SQL tracing mechanism.

A small database stress tool written in Java. Emulates a given number of concurrent users querying the engine. Reports timing information for each test. Currently supports MySQL engine only.

The Unofficial Home to JSR 272 Mobile TV API Tests and Evaluation --- PROVIDED AS IS, FOR EVALUATION PURPOSE ONLY. NO CLAIM OF CONFORMANCE OR ENDORSEMENT FROM JSR 272 GROUP. --- JSR 272 IS LICENSED BY NOKIA AND MOTOROLA. PLEASE CHECK TERMS AND CONDIT