{"id":7383,"date":"2017-02-06T02:34:35","date_gmt":"2017-02-06T01:34:35","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=7383"},"modified":"2023-11-07T23:12:28","modified_gmt":"2023-11-07T22:12:28","slug":"plsql-cop-for-trivadis-plsql-sql-coding-guidelines-version-3-2","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2017\/02\/06\/plsql-cop-for-trivadis-plsql-sql-coding-guidelines-version-3-2\/","title":{"rendered":"PL\/SQL Cop for Trivadis Coding Guidelines Version 3.2"},"content":{"rendered":"\n

The PL\/SQL Cop tool suite supports the new Trivadis PL\/SQL & SQL Coding Guidelines 3.2<\/a>. Download<\/a> the new versions from the Download<\/a> section. So, what’s new?<\/p>\n\n\n\n

Numbering and Categorisation Scheme<\/h2>\n\n\n\n

The guidelines have been renumbered, extended, categorised by severity (blocker, critical, major, minor and info) and assigned to one or more SQALE characteristics (changeability, efficiency, maintainability, portability, reliability, reusability, security and testability).<\/p>\n\n\n\n

This new categorisation allows to sort issues by severity. The most important issues will be listed first, even if you do not disable less important guidelines.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Severity and characteristics may now be used beside guideline numbers in check and skip lists (include and exclude lists).<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Validator Plugins<\/h2>\n\n\n\n

Would you like to create\u00a0your own guidelines? Or extend the existing guidelines? Then validators\u00a0are\u00a0your friends. A validator is a Java class implementing the\u00a0PLSQLCopValidator interface.\u00a0Validators may be used in the command-line utility, in SonarQube and the SQL Developer extension.<\/p>\n\n\n\n

A complete example is provided with source code as a Maven project. This example\u00a0extends the default validator by 15 additional guidelines\u00a0to check naming conventions according to\u00a0chapter 2.2 of the\u00a0Trivadis PL\/SQL & SQL Coding Guidelines 3.2<\/a>. The following screenshot shows the violation of a custom guideline\u00a0(G-9013: Exceptions should start with ‘e’) within SonarQube.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

PL\/SQL Editor for Eclipse<\/h2>\n\n\n\n

The editor is mainly provided to understand the PL\/SQL model better. The full model is available\u00a0as a PLSQL.ecore<\/em> file, which may be explored best within the\u00a0Eclipse IDE. Understanding the PL\/SQL model is important if you plan to develop your own validators.<\/p>\n\n\n\n

Use the\u00a0plsqleditor.zip<\/em>\u00a0file in the Eclipse folder to install the PL\/SQL editor in Eclipse. The editor supports an outline view, syntax\u00a0colouring, bracket matching, code formatting and error integration into the Eclipse workbench.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Changelogs<\/h2>\n\n\n\n