VCG not analysing files with extension ".sql"

akkinitsch commented 8 years ago

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

maddin200 commented 7 years ago

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

abhi06991 commented 10 months ago

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.

nccgroup / VCG

VCG not analysing files with extension ".sql" #6