Database Setup and Teardown for Automated Testing of PL/SQL Code

Following up on our popular session in November 2019 that focused on real-world testing of PL/SQL code, two of our speakers return to focus on one of the most challenge aspects of that testing: how to set up and tear down database state for automated testing.

Deepti Bandari is a senior software engineer at Fidelity Investments since 2013. Her focus areas include database design and development, test automation and promoting engineering excellence. She will share her experience with data setup and teardown for testing pl/sql, some challenges and techniques to overcome the challenges.

Jasmin Fluri is an independent consultant at Schaltstelle GmbH and lectures on software engineering and code review at the University of Applied Sciences North-western Switzerland. Her focus as a database developer and DevOps engineer lies on continuous integration and delivery pipelines, automation of recurring tasks, PL/SQL development, data engineering, and data warehousing.

01:04 Steven sets the context
04:30 Dee Bandari on automated testing
05:47 F.I.R.S.T principles of unit testing
08:07 Challenges with data setup and teardown
11:15 Overcoming the challenges
19:59 Example: testing the smart home application
33:15 Jasmin Fluri on the architecture of unit tests
36:40 Development and test lifecycle - stages of testing
38:16 Management of test data
41:00 Requirements of test data and test code example
46:50 Summary by Jasmin
48:45 Q&A: testing the test code, testing private subprograms and more

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.

https://asktom.oracle.com/

Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit