Ben Chuanlong Du's Blog

It is never too late to learn.

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

  1. Online Generate CSV Test Data

    • doesn't handle dependencies
    • simple and easy to use
  2. GenerateData

    • doesn't handle dependencies
    • simple and easy to use
    • able to share it with people
  3. 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

Comments