Data Management Challenge - Ivan Karaman using SQL and JavaScript

Summary

Ivan Karaman solves the Data Management Challenge from Test.bash(); 2022 using SQL and JavaScript.

There are lots of tools out there that we can use to create or fake test data. That’s why in this challenge we want to see demonstrations of tools that allow us to set up test data for testing purposes. We’d like to see how far you got with solving the challenge, what you liked about the tooling you used, and what you disliked.

Instructions

Using a tool of your choice that you think the community would be interested in, show us how you would mitigate the following problem:

Creating test data manually is taking too long and slowing the team down

If you had to rapidly create test data in an environment, how would you do it? Would you use an existing tool or build your own?

Example:

One example of mitigating this risk might be to find:

1. Find the seed.sql files in the github.com/mwinteringham/restful-booker-platform project
2. Duplicate the INSERT SQL statement multiple times and then build the application to get it running with lots of new test data

Tip: You’ll find more opportunities to manage test data if you have restful-booker-platform running locally on your machine.

Also, check out the Postman collection for Restful-Booker-Platform to get started with its APIs Postman

Follow

Ivan Karaman

Principal Quality Assistance Engineer

Principal QAE during the day, content creator at night. Old, have been doing testing since 2006. Opinions are my own and not always correct ;) If you want to learn more about "how I think", check out my YouTube channel "Ivan and code"!