check

This command runs a static code analysis using a configuration that is defined in the Web GUI. This feature is only available with an Essential or Professional Subscription.

Syntax

dblinter [<options>] check [<args>]

Options

See Options. Mandatory options are tenantName, userName, accessToken and configName.

Argument Syntax

in Command Line

--<argument>=<value>

in Property File

<argument>=<value>

Arguments

It is not possible to set arguments using environment variables. Beside that, in dbLinter, both arguments and options are treated in the same way. Therefore, they can be used in any order. For example, they can be used before or after the command name. We use options when the semantics are identical for each applicable command. Arguments are used when the semantics change for a command.

• outputFormats
  A comma-separated list of the output formats to be produced. All formats are considered by default. The following formats are supported:
  

  • vscode: dbLinter Check Report as Markdown for VS Code. This report will open automatically when the analysis is run via the VS Code extension.
  • sonarqube: SonarQube Generic formatted issue report to import issues in any SonarQube edition without any plugin.
  • sarif: Static Analysis Results Interchange Format (SARIF) to visualise issues in various tools. See also Viewers.
  • checkstyle: Checkstyle XML report.
  • github: Workflow commands for GitHub Actions. These commands (annotations) are interpreted when printed to stdout.
  • gitlab: GitLab quality report.
  
  

• outputName
  This is the relative path from the working directory to the base name of the output files. Missing target directories will be created. For example, if you use the name check for an outputName, a file called check.vscode.md will be created in the working directory. The default is dblinter.

• parallel
  The number of files analysed in parallel. The default is 1. To achieve better performance with higher values, you need enough free system resources. Also consider increasing the maximum heap space using the JAVA_OPTS environment variable. For example, export JAVA_OPTS=-Xmx=32G to set the maximum heap size to 32GB. The default maximum heap size for a system with 64 GB of RAM is 16 GB (one quarter), which is sensible for desktop systems. In CI/CD environments, however, higher values can improve performance, especially when processing large files.

Example

dbLinter check \
    --tenantName=Demo \
    --userName=philipp.salvisberg+42@gmail.com \
    --accessToken=*** \
    --configName=Default \
    --outputFormats=vscode,github \
    --outputName=check \
    --parallel=2

The console output for the dbLinter-Demo project on GitHub looks like this:

Using connection to jdbc:oracle:thin:@localhost:1521/freepdb1 with user DBL_READ
Processed examples/Core-G-1010.sql (1/186) in 0.106 sec. Found 4 issues.
Processed examples/Core-G-1030.sql (2/186) in 0.285 sec. Found 2 issues.
Processed examples/Core-G-1020.sql (3/186) in 0.432 sec. Found 8 issues.
Processed examples/Core-G-1050.sql (4/186) in 0.025 sec. Found 3 issues.
Processed examples/Core-G-1060.sql (5/186) in 0.012 sec. Found 2 issues.
Processed examples/Core-G-1070.sql (6/186) in 0.005 sec. Found 2 issues.
Processed examples/Core-G-1080.sql (7/186) in 0.036 sec. Found 1 issue.
Processed examples/Core-G-1110.sql (8/186) in 0.020 sec. Found 2 issues.
Processed examples/Core-G-1120.sql (9/186) in 0.002 sec.
Processed examples/Core-G-1130.sql (10/186) in 0.003 sec.
Processed examples/Core-G-1140.sql (11/186) in 0.001 sec.
Processed examples/Core-G-1150.sql (12/186) in 0.001 sec.
Processed examples/Core-G-1210.sql (13/186) in 0.026 sec.
Processed examples/Core-G-1040.sql (14/186) in 0.175 sec. Found 8 issues.
Processed examples/Core-G-1220.sql (15/186) in 0.049 sec.
Processed examples/Core-G-1230.sql (16/186) in 0.082 sec. Found 2 issues.
Processed examples/Core-G-1240.sql (17/186) in 0.037 sec. Found 2 issues.
Processed examples/Core-G-1260.sql (18/186) in 0.008 sec. Found 1 issue.
Processed examples/Core-G-1270.sql (19/186) in 0.009 sec. Found 1 issue.
Processed examples/Core-G-1250.sql (20/186) in 0.018 sec. Found 2 issues.
Processed examples/Core-G-1310.sql (21/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-1280.sql (22/186) in 0.008 sec. Found 1 issue.
Processed examples/Core-G-1920.sql (23/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-1910.sql (24/186) in 0.013 sec. Found 2 issues.
Processed examples/Core-G-2110.sql (25/186) in 0.016 sec. Found 1 issue.
Processed examples/Core-G-2130.sql (26/186) in 0.007 sec. Found 1 issue.
Processed examples/Core-G-2120.sql (27/186) in 0.016 sec. Found 1 issue.
Processed examples/Core-G-2140.sql (28/186) in 0.009 sec. Found 3 issues.
Processed examples/Core-G-2135.sql (29/186) in 0.042 sec. Found 1 issue.
Processed examples/Core-G-2150.sql (30/186) in 0.013 sec. Found 1 issue.
Processed examples/Core-G-2145.sql (31/186) in 0.047 sec. Found 1 issue.
Processed examples/Core-G-2160.sql (32/186) in 0.029 sec. Found 2 issues.
Processed examples/Core-G-2180.sql (33/186) in 0.011 sec. Found 10 issues.
Processed examples/Core-G-2170.sql (34/186) in 0.051 sec. Found 2 issues.
Processed examples/Core-G-2185.sql (35/186) in 0.013 sec. Found 5 issues.
Processed examples/Core-G-2210.sql (36/186) in 0.022 sec. Found 1 issue.
Processed examples/Core-G-2190.sql (37/186) in 0.030 sec. Found 1 issue.
Processed examples/Core-G-2230.sql (38/186) in 0.023 sec. Found 3 issues.
Processed examples/Core-G-2220.sql (39/186) in 0.029 sec. Found 3 issues.
Processed examples/Core-G-2320.sql (40/186) in 0.026 sec. Found 1 issue.
Processed examples/Core-G-2310.sql (41/186) in 0.027 sec. Found 1 issue.
Processed examples/Core-G-2330.sql (42/186) in 0.005 sec. Found 1 issue.
Processed examples/Core-G-2410.sql (43/186) in 0.006 sec. Found 1 issue.
Processed examples/Core-G-2340.sql (44/186) in 0.011 sec. Found 1 issue.
Processed examples/Core-G-2610.sql (45/186) in 0.014 sec. Found 2 issues.
Processed examples/Core-G-2510.sql (46/186) in 0.037 sec. Found 2 issues.
Processed examples/Core-G-3115.sql (47/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-3110.sql (48/186) in 0.031 sec. Found 1 issue.
Processed examples/Core-G-3120.sql (49/186) in 0.039 sec. Found 4 issues.
Processed examples/Core-G-3130.sql (50/186) in 0.035 sec. Found 1 issue.
Processed examples/Core-G-3140.sql (51/186) in 0.039 sec. Found 2 issues.
Processed examples/Core-G-3145.sql (52/186) in 0.040 sec. Found 1 issue.
Processed examples/Core-G-3160.sql (53/186) in 0.017 sec.
Processed examples/Core-G-3150.sql (54/186) in 0.048 sec. Found 1 issue.
Processed examples/Core-G-3170.sql (55/186) in 0.035 sec. Found 1 issue.
Processed examples/Core-G-3182.sql (56/186) in 0.021 sec. Found 1 issue.
Processed examples/Core-G-3180.sql (57/186) in 0.044 sec. Found 3 issues.
Processed examples/Core-G-3183.sql (58/186) in 0.018 sec. Found 1 issue.
Processed examples/Core-G-3185.sql (59/186) in 0.003 sec. Found 2 issues.
Processed examples/Core-G-3190.sql (60/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-3192.sql (61/186) in 0.008 sec. Found 2 issues.
Processed examples/Core-G-3195.sql (62/186) in 0.009 sec. Found 1 issue.
Processed examples/Core-G-3220.sql (63/186) in 0.044 sec. Found 1 issue.
Processed examples/Core-G-3210.sql (64/186) in 0.051 sec. Found 1 issue.
Processed examples/Core-G-3320.sql (65/186) in 0.034 sec. Found 3 issues.
Processed examples/Core-G-3330.sql (66/186) in 0.017 sec. Found 1 issue.
Processed examples/Core-G-3310.sql (67/186) in 0.059 sec. Found 2 issues.
Processed examples/Core-G-4120.sql (68/186) in 0.035 sec. Found 3 issues.
Processed examples/Core-G-4110.sql (69/186) in 0.053 sec. Found 3 issues.
Processed examples/Core-G-4130.sql (70/186) in 0.036 sec. Found 1 issue.
Processed examples/Core-G-4210.sql (71/186) in 0.017 sec. Found 1 issue.
Processed examples/Core-G-4140.sql (72/186) in 0.053 sec. Found 2 issues.
Processed examples/Core-G-4220.sql (73/186) in 0.031 sec. Found 1 issue.
Processed examples/Core-G-4230.sql (74/186) in 0.040 sec. Found 1 issue.
Processed examples/Core-G-4250.sql (75/186) in 0.022 sec. Found 1 issue.
Processed examples/Core-G-4240.sql (76/186) in 0.049 sec. Found 1 issue.
Processed examples/Core-G-4260.sql (77/186) in 0.018 sec. Found 1 issue.
Processed examples/Core-G-4270.sql (78/186) in 0.014 sec. Found 1 issue.
Processed examples/Core-G-4320.sql (79/186) in 0.022 sec. Found 12 issues.
Processed examples/Core-G-4325.sql (80/186) in 0.006 sec. Found 2 issues.
Processed examples/Core-G-4330.sql (81/186) in 0.009 sec. Found 2 issues.
Processed examples/Core-G-4310.sql (82/186) in 0.047 sec. Found 3 issues.
Processed examples/Core-G-4340.sql (83/186) in 0.056 sec. Found 3 issues.
Processed examples/Core-G-4350.sql (84/186) in 0.071 sec. Found 3 issues.
Processed examples/Core-G-4365.sql (85/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-4360.sql (86/186) in 0.034 sec. Found 3 issues.
Processed examples/Core-G-4375.sql (87/186) in 0.008 sec. Found 2 issues.
Processed examples/Core-G-4370.sql (88/186) in 0.019 sec. Found 4 issues.
Processed examples/Core-G-4385.sql (89/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-4387.sql (90/186) in 0.011 sec. Found 1 issue.
Processed examples/Core-G-4380.sql (91/186) in 0.022 sec. Found 3 issues.
Processed examples/Core-G-4395.sql (92/186) in 0.005 sec. Found 3 issues.
Processed examples/Core-G-5010.sql (93/186) in 0.010 sec. Found 2 issues.
Processed examples/Core-G-4390.sql (94/186) in 0.019 sec. Found 2 issues.
Processed examples/Core-G-5020.sql (95/186) in 0.007 sec. Found 1 issue.
Processed examples/Core-G-5040.sql (96/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-5050.sql (97/186) in 0.015 sec. Found 1 issue.
Processed examples/Core-G-5030.sql (98/186) in 0.032 sec. Found 4 issues.
Processed examples/Core-G-5070.sql (99/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-5060.sql (100/186) in 0.020 sec. Found 2 issues.
Processed examples/Core-G-6010.sql (101/186) in 0.011 sec. Found 1 issue.
Processed examples/Core-G-5080.sql (102/186) in 0.039 sec. Found 1 issue.
Processed examples/Core-G-7110.sql (103/186) in 0.015 sec. Found 2 issues.
Processed examples/Core-G-7120.sql (104/186) in 0.018 sec. Found 2 issues.
Processed examples/Core-G-7125.sql (105/186) in 0.006 sec. Found 1 issue.
Processed examples/Core-G-6020.sql (106/186) in 0.092 sec. Found 1 issue.
Processed examples/Core-G-7140.sql (107/186) in 0.006 sec. Found 1 issue.
Processed examples/Core-G-7150.sql (108/186) in 0.020 sec. Found 1 issue.
Processed examples/Core-G-7130.sql (109/186) in 0.059 sec. Found 4 issues.
Processed examples/Core-G-7160.sql (110/186) in 0.026 sec. Found 4 issues.
Processed examples/Core-G-7180.sql (111/186) in 0.009 sec. Found 6 issues.
Processed examples/Core-G-7170.sql (112/186) in 0.034 sec. Found 4 issues.
Processed examples/Core-G-7220.sql (113/186) in 0.061 sec. Found 4 issues.
Processed examples/Core-G-7230.sql (114/186) in 0.127 sec. Found 1 issue.
Processed examples/Core-G-7310.sql (115/186) in 0.007 sec. Found 1 issue.
Processed examples/Core-G-7320.sql (116/186) in 0.013 sec. Found 1 issue.
Processed examples/Core-G-7330.sql (117/186) in 0.007 sec. Found 3 issues.
Processed examples/Core-G-7410.sql (118/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-7420.sql (119/186) in 0.005 sec. Found 1 issue.
Processed examples/Core-G-7430.sql (120/186) in 0.005 sec. Found 2 issues.
Processed examples/Core-G-7250.sql (121/186) in 0.116 sec. Found 2 issues.
Processed examples/Core-G-7450.sql (122/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-7440.sql (123/186) in 0.013 sec. Found 1 issue.
Processed examples/Core-G-7460.sql (124/186) in 0.007 sec. Found 1 issue.
Processed examples/Core-G-7510.sql (125/186) in 0.010 sec. Found 3 issues.
Processed examples/Core-G-7520.sql (126/186) in 0.006 sec. Found 1 issue.
Processed examples/Core-G-7515.sql (127/186) in 0.027 sec. Found 3 issues.
Processed examples/Core-G-7720.sql (128/186) in 0.011 sec. Found 2 issues.
Processed examples/Core-G-7710.sql (129/186) in 0.029 sec. Found 1 issue.
Processed examples/Core-G-7730.sql (130/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-7740.sql (131/186) in 0.004 sec. Found 2 issues.
Processed examples/Core-G-7910.sql (132/186) in 0.010 sec. Found 3 issues.
Processed examples/Core-G-7810.sql (133/186) in 0.013 sec. Found 1 issue.
Processed examples/Core-G-8120.sql (134/186) in 0.018 sec. Found 3 issues.
Processed examples/Core-G-8110.sql (135/186) in 0.032 sec. Found 1 issue.
Processed examples/Core-G-8210.sql (136/186) in 0.014 sec. Found 1 issue.
Processed examples/Core-G-8410.sql (137/186) in 0.033 sec. Found 2 issues.
Processed examples/Core-G-8310.sql (138/186) in 0.036 sec. Found 3 issues.
Processed examples/Core-G-8510.sql (139/186) in 0.014 sec. Found 1 issue.
Processed examples/Core-G-9020.sql (140/186) in 0.015 sec. Found 1 issue.
Processed examples/Core-G-9010.sql (141/186) in 0.026 sec. Found 1 issue.
Processed examples/Core-G-9040.sql (142/186) in 0.009 sec. Found 1 issue.
Processed examples/Core-G-9101.sql (143/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9102.sql (144/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9103.sql (145/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9030.sql (146/186) in 0.025 sec. Found 1 issue.
Processed examples/Core-G-9105.sql (147/186) in 0.005 sec. Found 12 issues.
Processed examples/Core-G-9106.sql (148/186) in 0.028 sec. Found 4 issues.
Processed examples/Core-G-9104.sql (149/186) in 0.049 sec. Found 7 issues.
Processed examples/Core-G-9107.sql (150/186) in 0.006 sec. Found 2 issues.
Processed examples/Core-G-9108.sql (151/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9109.sql (152/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9110.sql (153/186) in 0.001 sec. Found 2 issues.
Processed examples/Core-G-9111.sql (154/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9112.sql (155/186) in 0.002 sec. Found 6 issues.
Processed examples/Core-G-9113.sql (156/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9114.sql (157/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9115.sql (158/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9116.sql (159/186) in 0.002 sec. Found 2 issues.
Processed examples/Core-G-9201.sql (160/186) in 0.001 sec. Found 1 issue.
Processed examples/Core-G-9202.sql (161/186) in 0.001 sec. Found 1 issue.
Processed examples/Core-G-9203.sql (162/186) in 0.001 sec.
Processed examples/Core-G-9205.sql (163/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-9204.sql (164/186) in 0.004 sec. Found 1 issue.
Processed examples/Core-G-9206.sql (165/186) in 0.009 sec. Found 2 issues.
Processed examples/Core-G-9207.sql (166/186) in 0.028 sec. Found 1 issue.
Processed examples/Core-G-9209.sql (167/186) in 0.008 sec. Found 1 issue.
Processed examples/Core-G-9208.sql (168/186) in 0.040 sec.
Processed examples/Core-G-9211.sql (169/186) in 0.001 sec.
Processed examples/Core-G-9212.sql (170/186) in 0.001 sec.
Processed examples/Core-G-9213.sql (171/186) in 0.002 sec. Found 1 issue.
Processed examples/Core-G-9214.sql (172/186) in 0.001 sec. Found 2 issues.
Processed examples/Core-G-9215.sql (173/186) in 0.002 sec. Found 3 issues.
Processed examples/Core-G-9216.sql (174/186) in 0.003 sec. Found 2 issues.
Processed examples/Core-G-9217.sql (175/186) in 0.001 sec. Found 1 issue.
Processed examples/Core-G-9210.sql (176/186) in 0.023 sec. Found 1 issue.
Processed examples/Core-G-9218.sql (177/186) in 0.001 sec. Found 1 issue.
Processed examples/Core-G-9219.sql (178/186) in 0.002 sec. Found 1 issue.
Processed examples/Core-G-9600.sql (179/186) in 0.009 sec. Found 1 issue.
Processed examples/Core-G-9601.sql (180/186) in 0.004 sec. Found 3 issues.
Processed examples/Core-G-9602.sql (181/186) in 0.004 sec. Found 3 issues.
Processed examples/Core-G-9603.sql (182/186) in 0.004 sec. Found 3 issues.
Processed examples/Core-G-9604.sql (183/186) in 0.003 sec. Found 1 issue.
Processed examples/Core-G-9605.sql (184/186) in 0.003 sec. Found 3 issues.
Processed examples/Core-G-9501.sql (185/186) in 0.029 sec. Found 7 issues.
Processed install.sql (186/186) in 0.094 sec.
Check Summary
- Duration:                   2.389 sec.
- Files:                      186
- Characters:                 86,092
- Lines:                      3,168
- Lines of code:              2,151
- Statements:                 424
- PL/SQL units:               61
- Functions:                  61
- Comment line density:       9.0%
- Cyclomatic complexity (CC): 123
- Max CC per unit:            20
- Avg CC per unit:            2
- Errors:                     70
- Warnings:                   296
- Infos:                      1