zpa
zpa copied to clipboard
felipebz
Parser and static code analysis tool for PL/SQL and Oracle SQL.
Inspired by #92, it should be possible to create rules targeting the test annotations provided by utPLSQL 3.x. Example: * Every test case (annotated with "-- %test") should have a...
is it possible to add support for pldoc? Pldoc documents a plsql object like javadoc does. I would like to have checks like: - does this object have a pldoc...
Hi! Is it possible to analyse more than one file with a custom rule? Background: We have separated our PL/SQL files. There is one file for the package specification and...
Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6 (originally reported on #8)
Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6 (originally reported on #8)
Hi Filepe, I am testing anew custom rule to check for CRETAE VIEW statements if it is not using OR REPLACE FORCE and report it as an issue with an...
Hi Filepe, Here is my code public class PreventPublicSynonymCheck extends PlSqlCheck { private static final Logger LOGGER = Logger.getLogger(PreventPublicSynonymCheck.class.getName()); @Override public void init() { subscribeTo(DdlGrammar.CREATE_SYNONYM); LOGGER.info("Subscribed to CREATE_SYNONYM nodes for...
Hi felipe, I am trying to find a way to validate schema names (supplied list) using SQL operations like private static final List SQL_OPERATIONS = Arrays.asList( "CREATE TABLE", "ALTER TABLE",...
Good afternoon. Please help me. How to add a rule for scripts in a specific directory? For example, I want to prohibit the use of ddl operations in the "repo/data"...
I am trying to write a custom rule to implement TableName check, But I am facing compilation errors. Please suggest how to achieve this. ERROR: C:\myfiles\zpa-Latest>gradlew build -p plsql-custom-rules Picked...