This project involves testing the Reqres API using ReadyAPI. Through a combination of various assertions, database CRUD operations, and data matching techniques, the project aims to ensure the API's functionality, performance, and data integrity. ReadyAPI's powerful assertion capabilities will be used to validate HTTP status codes, response SLAs, content inclusion/exclusion, and content matching. Additionally, the project will perform CRUD operations on the associated database using JDBC statements and verify the success and timing of these operations. The captured data will be compared against the API response, ensuring consistency.
- Valid/Invalid HTTP status codes
- Response SLA
- Contains/Not Contains
- Match Content
- Jdbc Status
- Jdbc timeout
- Datasink
testrun.mp4
-
Install and configure Readyapi
-
Import Rest api project available in Readyapi folder
-
Install and configure MySql Server
-
Import the self-contained file available in Db folder
-
Download JDBC driver/Connector platform independent from
https://dev.mysql.com/downloads/connector/j/-
Place the driver in C:\Program Files\SmartBear\ReadyAPI-3.20.1\bin\ext
-
Restart Ready api
-
Click On Databases and modify connection string according to your mysql server information, here is the template:
jdbc:mysql://<HOST:127.0.0.1>:<PORT:3306>/<DB>?user=<USER>&password=<PASSWORD>