Difference between revisions of "Coding standards"

From TempusServa wiki
Jump to navigation Jump to search
Line 1: Line 1:
=== Naming standards ===
== Naming standards ==
 
=== Code naming standards ===
 
==== Package / naming placement ====
==== Package / naming placement ====
* Package name all lowercase
* Package name all lowercase
Line 29: Line 32:
* Shared ressources include "Helper"
* Shared ressources include "Helper"


==== DB Table naming ====
=== Database naming standards ===
 
==== Table naming ====


System tables should follow this syntax
System tables should follow this syntax
Line 39: Line 44:
* _data_ (deleted tables)
* _data_ (deleted tables)


==== DB Attribute naming ====
==== Table attribute naming ====
General rules
General rules
* Starts uppercase
* Starts uppercase

Revision as of 08:10, 24 July 2024

Naming standards

Code naming standards

Package / naming placement

  • Package name all lowercase
  • General platform entities
    • Servlets: com.tsnocode.server.servlet
    • Filters: com.tsnocode.server.filter
    • Core: com.tsnocode.ui
    • Fields: com.tsnocode.ui.field.<group>
    • Views: com.tsnocode.ui.views.<type> (item,list,statistics,)
    • Codeunit: com.tsnocode.codeunit.common
  • Solution specific code
    • TS customer app:
      • com.tsnocode.solution.app
      • com.tsnocode.solution.customer
      • com.tsnocode.solution.customer.app
    • Vendor app:
      • com.vendor.tsnocode.app
      • com.vendor.solution.app

Class naming

Naming convention follows Java standard

  • Starting with uppercase
  • No special characters
  • Seperate words with uppercase

In addition the following are recommended

  • CodeunitPage post fix name "Page"
  • CodeunitService post fix name "Service"
  • Shared ressources include "Helper"

Database naming standards

Table naming

System tables should follow this syntax

  • lowercase
  • no special characters

Reserved prefixes include

  • data_
  • _data_ (deleted tables)

Table attribute naming

General rules

  • Starts uppercase
  • Foreign keys ends with ID (uppercase)

Changelog attributes fixed names

  • CreatedAt
  • CreatedBy
  • ModifiedAt
  • ModifiedBy

Safety standards

  • Input sanitization used in SQL, using either
    • Escape all string parameters using DbConnection.EscapeSQL
    • Prepared statements
  • All Page codeunits should contain some user group restrictions, and set to be default off

Review standards

The following changes requires a formal code review

  • Changes to the API
  • Changes to common objects
    • Command
    • Security
    • Controller
    • DbConnection
  • Creation of OR changes to
    • Servlets
    • CodeunitPagePublic
    • Code containing SQL