Data for Testing

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

DataTable Generator¶

Faker¶

Faker is a Python package that generates fake data for you.

hypothesis¶

Hypothesis is a powerful, flexible, and easy to use library for property-based testing.

SQL Data Generator¶

GenerateData¶

Data Generator¶

This discussion on StackOverflow suggests that Databene Benerator is good choice.

Question: Does any tool support generating data sets that gurantees that joining returns results? And best if the returned results conver different corner cases.

Good Tools¶

1. http://www.softwaretestinghelp.com/tools/40-best-database-testing-tools/

2. http://filldb.info/

3. DataGenerator

   • handles dependencies

   • for Java

4. Databene Benerator

   • handles dependencies

   • poor documentation

5. mocker-data-generator

   • JS based

Others¶

3. Online Generate CSV Test Data

   • doesn’t handle dependencies

   • simple and easy to use

4. GenerateData

   • doesn’t handle dependencies

   • simple and easy to use

   • able to share it with people

5. Mockaroo

   • doesn’t handle dependencies

   • simple and easy to use

Commerical Tools¶

1. SQL Data Generator

   • handles dependencis

2. ApexSQL SQL test data generator

More¶

1. https://jethro.io/blog/how-to-generate-mock-data-for-testing

2. http://www.bigsynapse.com/sampling-large-datasets-using-spark

3. http://www.bizdatax.com/wp-content/uploads/2015/10/blog-how-to-mask-subset-and-generate-test-data-Img2.png

4. https://github.com/18F/rdbms-subsetter

5. https://docops.ca.com/ca-test-data-manager/3-5/en

6. http://finraos.github.io/DataGenerator/

7. http://sqlblog.com/blogs/jamie_thomson/archive/2009/09/08/deriving-a-list-of-tables-in-dependency-order.aspx