← All recipes
Moderne licensed

Find SQL usage

Recipe IDio.moderne.prethink.calm.FindSqlUsageArtifactio.moderne.recipe:rewrite-prethink

Locate SQL statements in code and resources, and attribute the physical tables and columns each touches to the class and method that issues it. Emits one row per statement per table, joining sql-anti-patterns.csv on source path and line number, and method-quality-metrics.csv and test-gaps.csv on class name and method signature.

Single recipeProprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe io.moderne.prethink.calm.FindSqlUsage

If the recipe isn’t available locally, install it with:

mod config recipes jar install io.moderne.recipe:rewrite-prethink:RELEASE

Data tables

Structured output this recipe can produce.

  • SQL usagePhysical tables and columns each SQL statement touches, attributed to the class and method that issues it.io.moderne.prethink.table.SqlUsage
  • Source files that had resultsSource files that were modified by the recipe run.org.openrewrite.table.SourcesFileResults
  • Source files that had search resultsSearch results that were found during the recipe run.org.openrewrite.table.SearchResults
  • Source files that errored on a recipeThe details of all errors produced by a recipe run.org.openrewrite.table.SourcesFileErrors
  • Recipe performanceStatistics used in analyzing the performance of recipes.org.openrewrite.table.RecipeRunStats