nccgroup/VCG

VCG not analysing files with extension ".sql"

akkinitsch opened this issue · 2 comments

Hi everybody,

i'm trying to automate the analysis of SQL-script-files via command line (and later on Jenkins) and VCG is not picking these files up.
For test-reasons i duplicated one of my files and changed the extension from "sql" to "pls" and VCG analysed it correctly, the same file with extension "sql" was ignored,
although "sql" is mentioned as default extension for PL/SQL analysis in readme file.

I ran the following command:

 VisualCodeGrepper.exe --console --language PL/SQL --export C:\somepath\vcg_result_sql.xml --target C:\somecodepath

BTW: ".sql" is not listed as default file extension in the GUI of VCG either.

Thanks for your help

Best regards

Akki

Proposed change:
Public PLSQLSuffixes As String = ".pls|.pkb|.pks|.sql"
AppSettings.vb

When I build the application using visual studio 2022 with the above proposed code change, and run it in console mode, I immediately get a prompt and this gets printed-

PS C:\Users\xxx\Downloads\VCG-master\VCG-master\VisualCodeGrepper\bin\Release>
[+] ==============================================
[+] ==            Visual Code Grepper           ==
[+] ==              CONSOLE MODE                ==
[+] ==============================================
[+]
[+] ##############################################
[+] Please let VCG finish before using the console
[+] ##############################################

[+] Running scans...
[+]
[+] Finished scanning...
[+] Closing VCG.
[+] ##############################################
[+]    Press <Enter> to get your prompt back
[+] ##############################################

P.S - In the GUI mode, the sql is detected after the code change, but the scan doesn't happen in the console mode.

Any help regarding this will be appreciated.