René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Missing line break after suite annotation in generator skeleton template","articleBody":"This is the PL/SQL package to test:\r\n\r\n```sql\r\ncreate or replace package etl is\r\n   procedure refresh_deptsal;\r\nend etl;\r\n/\r\n```\r\n\r\nWhen generating a utPLSQL test via context menu or via oddgen the generated code looks like this:\r\n\r\n```sql\r\ncreate or replace package test_etl is\r\n\r\n   --%suite(test_etl)\r\n   --%test\r\n   procedure refresh_deptsal;\r\n\r\nend test_etl;\r\n/\r\n\r\ncreate or replace package body test_etl is\r\n\r\n   procedure refresh_deptsal is\r\n      l_actual   integer := 0;\r\n      l_expected integer := 1;\r\n   begin\r\n      ut.expect(l_actual).to_equal(l_expected);\r\n   end refresh_deptsal;\r\n\r\nend test_etl;\r\n/\r\n```\r\n\r\nGenerator settings look like this:\r\n\r\n![image](https://user-images.githubusercontent.com/3883171/180603192-3bb156a4-3fef-400d-80ba-bb058f4e7aa3.png)\r\n\r\nSince there is no empty line between `--%suite(test_etl)` and `--%test` the test is not found by the utPLSQL framework. \r\n\r\nThis run:\r\n\r\n```sql\r\nset serveroutput on size unlimited\r\nexecute ut.run;\r\n```\r\n\r\nproduced this result: \r\n\r\n```\r\nFinished in 0 seconds\r\n0 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)\r\n \r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n```\r\n\r\nMaybe this is related to #156.\r\n\r\n","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2022-07-23T11:38:32.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/157/utPLSQL-SQLDeveloper/issues/157"}