@AnalyzeSql

The AnalyzeSql annotation builds an analysis report of the SQL executed during the test method execution.

Displayed information is:

• Number of total JDBC executions,
• Longest execution time of all JDBC executions,
• Number of queries for each type (CRUD). Please note that PLSQL like statements will not be counted.
• Alerts and or hints regarding queries syntax (usage of wildcards in select statements, N + 1 one issue etc ... See the global annotations.
• Sql queries.

This annotation accepts a Writer class (must implement WriterFactory interface) to allow writing to the desired output. See example below for file export.

   // Helper class used to return a Writer class
   public static class FileWriterBuilder implements WriterFactory {
 
      @Override
      public Writer buildWriter() throws IOException {
          return new FileWriter(desired-path-to-exported-file);
      }
   }
 
   // annotated test method
   @AnalyzeSql(writerFactory = FileWriterBuilder.class)
   public void select() {
           ...
       };
   }