Update code templates using AAA

[PhilippSalvisberg]

The current code template for the PL/SQL package body looks like this (test_ is the default prefix):

CREATE OR REPLACE PACKAGE BODY test_[package_name] IS

 --
 -- test
 --
 PROCEDURE [procedure_name] IS
 l_actual INTEGER := 0;
 l_expected INTEGER := 1;
 BEGIN
 -- populate actual
 -- ...
 
 -- populate expected
 -- ...
 
 -- assert
 ut.expect(l_actual).to_equal(l_expected);
 END [procedure_name];

END test_[package_name];
/

The body is grouped into three steps. Firstly, populate actual. Secondly, populate expected. Thirdly, assert.

Instead of these three steps the Arrange-Act-Assert pattern should be used. It's popular in Unit testing.

The new template should look like this:

create or replace package body test_[package_name] is

 --
 -- test
 --
 procedure [procedure_name] is
 l_actual integer := 0;
 l_expected integer := 1;
 begin
 -- arrange
 -- ...
 
 -- act
 -- ...
 
 -- assert
 ut.expect(l_actual).to_equal(l_expected);
 end [procedure_name];

end test_[package_name];
/

The other template should be changed accordingly.