Change a SQL function name
org.openrewrite.sql.ChangeFunctionName
When migrating between dialects, often one name can be substituted for another. For example, Oracle's NVL function can be replaced with Postgres COALESCE.
Recipe source
This recipe is only available to users of Moderne.
Options
| Type | Name | Description | Example |
|---|---|---|---|
String | oldFunctionName | The name of the function to find, case insensitive. | NVL |
String | newFunctionName | The new name to use. This will match the casing of the original method when a replacement is made. | COALESCE |
License
This recipe is available under the Moderne Proprietary License.
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:
---
type: specs.openrewrite.org/v1beta/recipe
name: com.yourorg.ChangeFunctionNameExample
displayName: Change a SQL function name example
recipeList:
- org.openrewrite.sql.ChangeFunctionName:
oldFunctionName: NVL
newFunctionName: COALESCE
- Moderne CLI
You will need to have configured the Moderne CLI on your machine before you can run the following command.
mod run . --recipe ChangeFunctionName --recipe-option "oldFunctionName=NVL" --recipe-option "newFunctionName=COALESCE"
If the recipe is not available locally, then you can install it using:
mod config recipes jar install org.openrewrite.recipe:rewrite-sql:1.13.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 Name | Description |
|---|---|
| Source path | The path to the source file. |
| Query | The text of the query. |
SQL functions in use
org.openrewrite.sql.table.DatabaseFunctions
Shows matching SQL functions and the queries that contain them.
| Column Name | Description |
|---|---|
| Source path | The path to the source file. |
| Query | The text of the query. |
| Function | Function name. |
Source files that had results
org.openrewrite.table.SourcesFileResults
Source files that were modified by the recipe run.
| Column Name | Description |
|---|---|
| Source path before the run | The source path of the file before the run. null when a source file was created during the run. |
| Source path after the run | A recipe may modify the source path. This is the path after the run. null when a source file was deleted during the run. |
| Parent of the recipe that made changes | In a hierarchical recipe, the parent of the recipe that made a change. Empty if this is the root of a hierarchy or if the recipe is not hierarchical at all. |
| Recipe that made changes | The specific recipe that made a change. |
| Estimated time saving | An estimated effort that a developer to fix manually instead of using this recipe, in unit of seconds. |
| Cycle | The recipe cycle in which the change was made. |
Source files that errored on a recipe
org.openrewrite.table.SourcesFileErrors
The details of all errors produced by a recipe run.
| Column Name | Description |
|---|---|
| Source path | The file that failed to parse. |
| Recipe that made changes | The specific recipe that made a change. |
| Stack trace | The stack trace of the failure. |
Recipe performance
org.openrewrite.table.RecipeRunStats
Statistics used in analyzing the performance of recipes.
| Column Name | Description |
|---|---|
| The recipe | The recipe whose stats are being measured both individually and cumulatively. |
| Source file count | The number of source files the recipe ran over. |
| Source file changed count | The number of source files which were changed in the recipe run. Includes files created, deleted, and edited. |
| Cumulative scanning time | The total time spent across the scanning phase of this recipe. |
| 99th percentile scanning time | 99 out of 100 scans completed in this amount of time. |
| Max scanning time | The max time scanning any one source file. |
| Cumulative edit time | The total time spent across the editing phase of this recipe. |
| 99th percentile edit time | 99 out of 100 edits completed in this amount of time. |
| Max edit time | The max time editing any one source file. |