Skip to main content

Find SQL in code and resource files

org.openrewrite.sql.FindSql

Find SQL in code (e.g. in string literals) and in resources like those ending with .sql.

Recipe source​

This recipe is only available to users of Moderne.

This recipe is available under the Moderne Proprietary License.

Example​

Before​
class Test {
    void test() {
        String sql = "select * from table where id = 1";
    }
}
After​
class Test {
    void test() {
        String sql = /*~~>*/"select * from table where id = 1";
    }
}

Usage​

This recipe has no required configuration options. Users of Moderne can run it via the Moderne CLI:

You will need to have configured the Moderne CLI on your machine before you can run the following command.

shell
mod run . --recipe FindSql

If the recipe is not available locally, then you can install it using:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.3.0

See how this recipe works across multiple open-source repositories​

Run this recipe on OSS repos at scale with the Moderne SaaS.

The community edition of the Moderne platform enables you to easily run recipes across thousands of open-source repositories.

Please contact Moderne for more information about safely running the recipes on your own codebase in a private SaaS.

Data Tables​

Database columns used​

org.openrewrite.sql.table.DatabaseColumnsUsed

Shows which database columns are read/written by a SQL statement.

Column NameDescription
Source pathThe path to the source file.
Line numberThe line number the SQL operation appears at
Commit hashThe commit hash. Used to generate a link to the source code.
OperationWhether the column is read, written, etc.
TableThe table name.
ColumnThe column name. In the case of a DELETE, column will be null.

Contributors​

Sam Snyder, Jonathan Schneider, Knut Wannheden, Tim te Beek