Back to Projects

Automated Testing for Clean Water Monitoring

Automation Tester

Comprehensive automated testing suite for the Clean Water Monitoring project. Covers API testing (6 modules), Admin UI testing, and E2E flows using Playwright. Includes custom scripts for test pipeline, result export, and Google Sheets integration.

Automated Testing for Clean Water Monitoring 1
Click to Expand
Automated Testing for Clean Water Monitoring 2
Click to Expand
Automated Testing for Clean Water Monitoring 3
Click to Expand
Thumbnail 1
Thumbnail 2
Thumbnail 3

Key Features

  • 01API Testing - 6 modules: Auth, Devices, Issues, Locations, Logs, Users
  • 02Admin UI Testing - Dashboard, Locations, Issues, User Management
  • 03E2E Testing - Full user flows with Page Object Model
  • 04Multi-environment support (dev, staging, production)
  • 05Custom pipeline script with health check before tests
  • 06Auto export results to CSV and JSON formats
  • 07Google Sheets integration for test result reporting
  • 08GitHub Actions CI/CD workflow

Highlights

  • 6 API test suites + Admin UI + E2E tests
  • Custom Node.js pipeline & export scripts
  • Multi-environment configs (.env.production, .env.staging)
  • Google Sheets auto-upload for test results

Technologies

PlaywrightTypeScriptNode.jsGitHub ActionsGoogle Sheets APIdotenv

Responsibilities

  • Design test architecture with Page Object Model pattern
  • Implement API tests for all 6 backend route modules
  • Create Admin UI test suites (Dashboard, Locations, Issues, Users)
  • Build custom pipeline.js for orchestrating test execution
  • Develop export-results.js for CSV/JSON report generation
  • Integrate Google Sheets API with upload-to-sheets.js
  • Configure Playwright for multi-browser & multi-environment
  • Setup GitHub Actions CI/CD workflow with secrets management

Project Links