Advanced Scripting for Testers: Local Data, Spreadsheets, and Reporting

Course details

Your program might be passing all the tests, but what more can you glean from your results? Your test results can hold—and sometimes, even hide—valuable insights that you could be extracting and sharing with larger teams. In this course, instructor Dave Westerveld offers an overview of advanced scripting skills for testers, including local data processing, spreadsheets, and test reporting. Explore the essentials of processing local data generated from testing, working with the Google Charts and Sheets APIs, and creating and managing reports with HTML, PDFs, email, Slack, Excel, and Python. By the end of this course, you’ll be prepared to wield your new skills to find and distribute your testing results more effectively.

Concepts

Introduction

Smarter testing through scripting
What you should know

Working with Local Data

Running command line programs
Capturing stdout and stderr
Running a program from Python
Interacting with files
Running a web server locally
Parsing a log file
Challenge - Find the error in the logs
Solution - Find the error in the logs

Working with Spreadsheets

Scripting Excel
Reading data from Excel
Writing data to Excel
Challenge - Create a test report in Excel
Solution - Create a test report in Excel
Setting up a Google service account
Interacting with Google Sheets
Reading data from Google Sheets
Writing data to Google Sheets
Challenge - Consolidate multiple data sources
Solution - Consolidate multiple data sources

Scripting Test Reports

Using HTML templates
Creating charts
Challenge - Creating an HTML report
Solution - Creating an HTML report
Working with PDFs
Challenge - Creating a PDF report
Solution - Creating a PDF report

Sending Test Reports

Sending emails
Emailing a test report
Integrating with Slack
Posting a report to Slack
Challenge - Build and send a report
Solution - Build and send a report

Conclusion

From course to action