René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Update code templates using AAA","articleBody":"The current code template for the PL/SQL package body looks like this (`test_` is the default prefix):\r\n\r\n```sql\r\nCREATE OR REPLACE PACKAGE BODY test_[package_name] IS\r\n\r\n   --\r\n   -- test\r\n   --\r\n   PROCEDURE [procedure_name] IS\r\n      l_actual   INTEGER := 0;\r\n      l_expected INTEGER := 1;\r\n   BEGIN\r\n      -- populate actual\r\n      -- ...\r\n   \r\n      -- populate expected\r\n      -- ...\r\n   \r\n      -- assert\r\n      ut.expect(l_actual).to_equal(l_expected);\r\n   END [procedure_name];\r\n\r\nEND test_[package_name];\r\n/\r\n```\r\n\r\nThe body is grouped into three steps. Firstly, populate actual. Secondly, populate expected. Thirdly, assert. \r\n\r\nInstead of these three steps the [Arrange-Act-Assert pattern](https://java-design-patterns.com/patterns/arrange-act-assert/) should be used. It's popular in Unit testing.\r\n\r\nThe new template should look like this:\r\n\r\n```sql\r\ncreate or replace package body test_[package_name] is\r\n\r\n   --\r\n   -- test\r\n   --\r\n   procedure [procedure_name] is\r\n      l_actual   integer := 0;\r\n      l_expected integer := 1;\r\n   begin\r\n      -- arrange\r\n      -- ...\r\n      \r\n      -- act\r\n      -- ...\r\n   \r\n      -- assert\r\n      ut.expect(l_actual).to_equal(l_expected);\r\n   end [procedure_name];\r\n\r\nend test_[package_name];\r\n/\r\n```\r\n\r\nThe other template should be changed accordingly.","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2022-02-25T07:27:27.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/145/utPLSQL-SQLDeveloper/issues/145"}