In most of your software program testing actions, you want information. Generally you possibly can depend on a small pattern, however if you wish to carry out some load testing or if you wish to take a look at a characteristic that should produce a multipage bill, you then begin to want extra than simply two or three occurrences. Check information mills are instruments that may enable you to on this job with the automated era of tons of or 1000’s of consumers, merchandise or accounts objects with totally different attributes for his or her id, e mail, identify, and so forth.
Check information mills can work in numerous mode: from the random strategy to a extra targeted or clever means. Their purpose is to make use of a predefined information construction to supply the information want for take a look at in a particular format that might vary from a spreadsheet file to SQL insert directions. For extra details about take a look at information era, you possibly can go to the Wikipedia discussing this subject on https://en.wikipedia.org/wiki/Test_data_generation
This text presents some open supply take a look at information mills. Don’t hesitate to contact us to incorporate any device that that isn’t but listed on this article. The merchandise at present included on this article are: Benerator, DataFactory, Knowledge Manufacturing facility, DataGenerator, generatedata, MockNeat, MySQL Random Knowledge Generator, pydbgen, Spawner, SQLfuzz, Synth, test-data-generator
Updates
July 21 2022 :
renamed Databene Benerator to Benerator
added MockNeat, MySQL Random Knowledge Generator, pydbgen
October 19 2021:
added generatedata, SQLfuzz, Synth
Benerator
Benerator is a framework launched beneath each open supply and industrial licenses that can be utilized to generate high-volume take a look at information. This take a look at information era device works on Home windows and Unix programs. It helps many database programs (Oracle, IBM DB2, MS SQL Server, MySQL, PostgreSQL, …), XML, XML Schema, CSV, Flat Recordsdata and Excel. Benerator has additionally a plugin system that permits as an example to make use of it with Eclipe or Maven.
Determine: How Databene Benerator works.
Web sites: https://github.com/rapiddweller/rapiddweller-benerator-ce and https://sourceforge.web/initiatives/benerator/
DataFactory
DataFactory is an open supply take a look at information generator device that lets you simply generate take a look at information. It was primarily written for populating database for improvement or take a look at environments by offering values for names, addresses, e mail addresses, cellphone numbers, textual content, and dates. DataFactory will be built-in with Maven.
Web site: https://github.com/andygibson/datafactory
Knowledge Manufacturing facility
Knowledge Manufacturing facility is an open supply Java API that can be utilized to generate random information. It’s helpful when growing functions that require quite a lot of pattern information.
Web site: https://sourceforge.web/initiatives/data-factory/
DataGenerator
DataGenerator is an open supply Java library that may produce massive volumes of knowledge to satisfy the challenges of the Huge Knowledge area. DataGenerator frames information manufacturing as a modeling drawback, with a consumer offering a mannequin of dependencies amongst variables and the library traversing the mannequin to supply related information units. DataGenerator can be utilized with IDE like Eclipse, IntelliJ IDEA or NetBeans.
Web site: http://finraos.github.io/DataGenerator/
generatedata
generatedata is an open supply script that’s primarily an engine to generate any form of random information in any format. It at present comes with 30 or so Knowledge Sorts (varieties of information it generates), 8 Export Sorts (codecs for the information), plus round 30 information units for particular nations (metropolis names, areas,and so forth). However extra importantly, it may be prolonged in any means you need. If you’ll want to generate random information programmatically reasonably than manually through the UI, you should utilize the REST API.
Web site: https://github.com/benkeen/generatedata
MockNeat
Mockneat is an arbitrary data-generator open-source library written in Java. It supplies a easy however highly effective (fluent) API that permits builders to create json, xml, csv and sql information programatically. It could possibly additionally act as a robust Random substitute or a mocking library.
Mockneat random information era instance
Web sites: https://github.com/nomemory/mockneat, https://www.mockneat.com/
MySQL Random Knowledge Generator
MySQL Random Knowledge Generator is the best MySQL random take a look at information generator device. Load the process and execute to auto detect column sorts and cargo information.
Web site: https://github.com/kedarvj/mysql-random-data-generator
pydbgen
pydbgen is an open supply python package deal that permits random dataframe and database desk era. This Python package deal generates a random database TABLE (or a Pandas dataframe, or an Excel file) based mostly on consumer’s alternative of knowledge sorts (database fields). Person can specify the variety of samples wanted. One may designate a “PRIMARY KEY” for the database desk. Lastly, the TABLE is inserted into a brand new or current database file of consumer’s alternative.
Web site: https://github.com/tirthajyoti/pydbgen
Spawner
Spawner is a generator of pattern and take a look at information for databases. It may be configured to output delimited textual content or SQL insert statements. It could possibly additionally insert instantly right into a MySQL database. Consists of many subject sorts, most of that are configurable. Spawner works on Linux and Home windows programs.
Determine. Spawner era display screen. Supply: http://spawner.sourceforge.web/
Web site: http://spawner.sourceforge.web/
SQLfuzz
SQLfuzz is an open supply device for software program testing that masses random information into SQL tables for testing functions. The device can get the format of the SQL desk and fill it up with random information.
Web site: https://github.com/PumpkinSeed/sqlfuzz
Synth
Synth is an open supply device for producing lifelike information utilizing a declarative information mannequin. Synth is database agnostic and might scale to tens of millions of rows of knowledge. Synth supplies a sturdy, declarative framework for specifying constraint based mostly information era. Synth supplies a versatile declarative information mannequin which you’ll model management in git, peer overview, and automate.
Web site: https://github.com/getsynth/synth
test-data-generator
test-data-generator is an easy open supply Java device to generate information that can be utilized with Maven. It helps many information values like emails, nation or identify. You possibly can produce output in numerous codecs like csv, tsv or sql. You may also instantly inject the generated take a look at information in a database utilizing a jdbc connection.
Web site: https://github.com/presidentio/test-data-generator
