API tests for a building-permit service need known rows in the test…

Question

API tests for a building-permit service need known rows in the test DynamoDB table before each run. How should that data be prepared?

Accepted Answer

Run a repeatable seeding script that loads anonymized fixture permits into the test table before the API tests execute. — Set the chessboard the same way before every match. A seeding script with anonymized fixtures makes API tests repeatable. Cloning prod PII or typing rows by hand is messy and unsafe.

Answer

Copy the entire production table into test before every suite, including personal citizen data.

Answer

Leave the test table empty and assert only that HTTP 500 responses are interesting.

Answer

Ask QA to type fixture permits into the console whenever a test fails.

API tests for a building-permit service need known rows in the test DynamoDB table before each run. How should that data be prepared?

Short Explanation

Full Explanation