SOPs
Runbooks for safe releases
Standard operating procedures for releases, smoke tests, and on-call diagnostics. Authored in MDX so they stay versioned with the code.
API Testing Using Postman (v1.0)
Import Swagger/OpenAPI spec and create environments (BASE_URL, TOKEN) · Add pre-request scripts for auth token generation · Write pm.expect tests for status, schema, payload · Add iteration tests for datasets and integrate Newman in CI · Export CLI/HTML reports
API Automation Using Pytest (v1.0)
Structure tests/api and shared utils/fixtures · Use fixtures for base URL and auth tokens · Apply jsonschema for payload validation · Parametrize datasets; run pytest -n auto · Publish Allure reports in CI
UI Automation Using Pytest + Playwright (v1.0)
Install pytest-playwright and launch Chromium headless · Adopt Page Object Model with auto-wait selectors · Capture screenshots on failure · Integrate with CI and Docker for reproducible runs
ETL Testing Using Pandas + SQL (v1.0)
Read source/target data (MySQL/Postgres/CSV/Parquet) · Perform column-level and row/aggregation comparisons · Validate transformation rules with audit logging · Dockerize the ETL test runner for CI
Dockerization SOP (v1.0)
Create Dockerfile with multi-stage build and .dockerignore · Build/test image locally; tag & push to registry · Deploy via Cloud Run with health checks