Data Management Challenge - Ivan Karaman using SQL and JavaScript

  • Locked
Ivan Karaman's profile
Ivan Karaman

Principal Quality Assistance Engineer

Data Management Challenge - Ivan Karaman using SQL and JavaScript image
Summary

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

Challenge Description

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

Ivan Karaman's profile'

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"!
Suggested Content
With a combination of SAST, SCA, and QA, we help developers identify vulnerabilities in applications and remediate them rapidly. Get your free trial today!
Explore MoT
TestBash Brighton 2024
Thu, 12 Sep 2024, 9:00 AM
We’re shaking things up and bringing TestBash back to Brighton on September 12th and 13th, 2024.
MoT Foundation Certificate in Test Automation
Unlock the essential skills to transition into Test Automation through interactive, community-driven learning, backed by industry expertise