Skip to main content

Find SQL function

org.openrewrite.sql.search.FindFunction

Find SQL functions by name.

Recipe source

This recipe is only available to users of Moderne.

This recipe is available under the Moderne Proprietary License.

Options

TypeNameDescriptionExample
StringfunctionNameThe name of the function to find, case insensitive.nvl

Usage

This recipe has required configuration parameters and can only be run by users of Moderne. To run this recipe, you will need to provide the Moderne CLI run command with the required options. Or, if you'd like to create a declarative recipe, please see the below example of a rewrite.yml file:

rewrite.yml
---
type: specs.openrewrite.org/v1beta/recipe
name: com.yourorg.FindFunctionExample
displayName: Find SQL function example
recipeList:
- org.openrewrite.sql.search.FindFunction:
functionName: nvl

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

shell
mod run . --recipe FindFunction --recipe-option "functionName=nvl"

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

SQL queries

org.openrewrite.sql.table.DatabaseQueries

Shows matching SQL queries.

Column NameDescription
Source pathThe path to the source file.
QueryThe text of the query.

Contributors

Jonathan Schneider, Tim te Beek