Database development

Predavanja so razvrščena po abecednem vrstnem redu naslova predavanj.

Patrick Barel

Increase your programming confidence by using Unit Tests

Patrick Barel

When we create our programs, just getting it to compile is not enough. We want to test if our code does what it is supposed to do. But testing over and over again is a time-consuming and mostly boring process. You don’t want to run the same tests over and over again. It worked before, so it will work now, or won’t it?

This should be an automated process which you can start whenever you want, even when you’re not present. There are multiple unit testing frameworks and tools available to do this job for you.

This session will show a couple of them and will show an in depth analysis of utPLSQL and SQL Developer. Although very different in approach then can both be useful in your development process. We’ll discuss the structure of unit testing: - Setup - Run - Validate - Teardown Then we’ll demonstrate the two products. On the one hand, we will see how easy it is to setup utPLSQL and start using it, but also the technical, programmatic, approach that suits developers. On the other hand, there is SQL Developer with a more declarative approach to describe and run your tests. We will also see how this can be integrated into a Continuous Delivery method with automated testing. When you are using a unit testing framework then you can be confident you are done programming and your program is working correctly.

Informacije o predavanju

Jezik / Language: ENG

O Avtorju

Patrick Barel is a PL/SQL Developer for Qualogy in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins for PL/SQL Developer. He publishes articles on his own blog. In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he has been promoted to ACE Director.
  • # Oracle
  • # PLSQL
  • # Testing

Vsebina iskanje