Skip to content

FEA47 Iteration 1 Test Report - Sprint 3
Iteration 01
Date 20.06.2023
Feature FEA-47-answers-database

Test Objectives

Testing types: API testing, integration testing, acceptance testing.

The objective of this test is to verify and validate the functionality of Answers database developed for Skill Collector application. The functionality of this feature is detailed in FEA-47-answers-database documentation.

Test Execution Details

Test Cases

Test Case Description Status Notes
TC-47-001 Database structure Pass 100% step success rate
TC-47-003 Database Pass 95% step success rate

Summary

  • Total Test Cases: 2
  • Passed: 2
  • Failed: 0
  • Pending: 0
  • Success Rate: 100%

Overall, the database API functions as expected. Most of the notes are related to the routes not actively used in the Skill Collector application, and do not break the database.

Observations and Notes

Step 1: GET /api/users/1 returns 500 Internal Server Error.

{
    "error": "Error fetching user"
}

Step 5: Attempting to create a duplicate user returns status 201 Created.

Step 16: The payloads with additional information went through.

Step 17: Attempting to register a new user with data types other than a string in payload didn't return an error and had to be manually cancelled.

Step 18: An attempt to register a new user with a login or password that is a string of blank spaces succeeded. It is also possible to add a new hash that is a string of blank spaces.

Recommendations

  1. Fix the implementation of GET /api/users/:id endpoint to ensure it is functioning correctly and returning the expected results.

  2. Improve the string sanitization mechanism for POST requests to enhance the security and robustness of the API.

Next Steps

Test engineer will have a discussion with a backend developer to determine if the behavior observed in steps 5, 16, 17, and 18 is acceptable. Testing steps related to these API calls will be repeated after the bugs are fixed.