World Wide Workshop Wednesday 2025

Frontend + DB + API - Automating integration tests for a web app
2025-10-01 , WS6

Hands-on automation of integration tests for a common setup - web frontend with REST API and a database in the backend. The workshop covers creating the project structure, tests and keywords in Python / Robot Framework - with tips and tricks from real projects.
The tool stack includes Browser Library / Playwright, OpenAPI Python Client Generator and Database Library.


Workshop Description

The workshop includes walking through:
- Creating a basic project structure
- Generating the OpenAPI client in Python
- Creating keywords in Python and Robot Framework for connecting / controlling the API, DB and web frontend
- Implement some basic test cases

After accomplishing the mentioned steps with trainer guidance and support, the workshop continues with more advanced exercises.

Knowledge Level

Intermediate. Participants are expected to have at least basic knowledge of Robot Framework and Python. Basic experience with SQL, REST API and Docker is nice to have.

Technical requirements

The comprehensive list of technical requirements will be provided later on.
Roughly, participants would need a computer with following software and libraries installed:
- Editor / IDE, e.g. VS Code
- Python
- RF
- Browser Library
- Database Library
- Docker - an image with SUT installed will be provided later on

Probably, an alternative workspace in a web based IDE like GitPod might be provided.


Start Time (UTC):

7:00

Categorize / Tags:

RobotFramework, Python, Browser, Playwright, Database, REST, OpenAPI

Intended Audience Description:

Testers with basic experience in Robot Framework familiar with Python, SQL / Databases and REST API

Test automation architect, consultant and trainer.
Current maintainer of the Database Library and developer of the Eggplant Library and the LibToc tool.

More details on www.mochinin.com.