Configures which name prefixes are allowed for statements that are writing data to your database.

Configuration Options

Option: ‘update, insert, delete, create, write, add, remove, merge, drop’

The default value of the allowedWritePrefixes configuration option is update, insert, delete, create, write, add, remove, merge, drop to allow several commonly used names for writing statements.

Option: ‘scribo’

Changing the allowedWritePrefixes configuration option to scribo only allows names with the prefix scribo to write data.

Related Options

• allowedCallPrefixes: Configures which name prefixes are allowed for statements that are calling stored procedures.
• allowedReadPrefixes: Configures which name prefixes are allowed for statements that are reading data from your database.
• basePackageName: The base package name for all repositories
• catchAndRethrow: Catch exceptions during SQL execution and re-throw them as RuntimeExceptions
• createConnection: Controls whether the generated code should create/open connection itself or use a given connection.
• executeBatch: Generate methods that are executed as batch
• executeBatchPrefix: The method prefix to use for generated methods that execute in a batch.
• executeBatchSuffix: The method suffix to use for generated methods that execute in a batch.
• executeOnce: Generate methods that are executed once with the given parameters
• executeOncePrefix: The method prefix to use for generated methods that execute once.
• executeOnceSuffix: The method suffix to use for generated methods that execute once.
• generateInterfaces: Generate interfaces for all repositories
• injectConverters: Toggles whether converters should be injected as constructor parameters.
• repositoryInterfacePrefix: The repository interface name prefix to use.
• repositoryInterfaceSuffix: The repository interface name suffix to use.
• repositoryNamePrefix: The repository name prefix to use.
• repositoryNameSuffix: The repository name suffix to use.
• throwOnMultipleResults: Throw an exception in case a statement using ReturningMode.SINGLE produces more than 1 result.
• validateMethodNamePrefixes: Validate user given names against list of allowed prefixes per type.
• writesReturnUpdateCount: Writing method which are using ReturningMode.NONE return the number of affected rows instead.

Tooling

Ant

In order to use YoSQL together with Ant, take a look at the tooling documentation for Ant.

Bazel

In order to use YoSQL together with Bazel, take a look at the tooling documentation for Bazel.

CLI

In order to use YoSQL on the command line, take a look at the tooling documentation for CLI.

$ yosql --repositories-allowed-write-prefixes=configValue

As long as the name of the config option is unique across all configuration groups, you can use the shorter form:

$ yosql --allowed-write-prefixes=configValue

Gradle

In order to use YoSQL together with Gradle, take a look at the tooling documentation for Gradle. The allowedWritePrefixes setting can be configured using Gradle in Kotlin syntax like this:

plugins {
  java
  id("wtf.metio.yosql") version "2023.2.22"
}

yosql {
  repositories {
    allowedWritePrefixes.set(configValue)
  }
}

or in Groovy syntax like this:

plugins {
  id "java"
  id "wtf.metio.yosql" version "2023.2.22"
}

yosql {
  repositories {
    allowedWritePrefixes = configValue
  }
}

Maven

In order to use YoSQL together with Maven, take a look at the tooling documentation for Maven. The allowedWritePrefixes setting can be configured using Maven like this:

<build>
  <plugins>
    <plugin>
      <groupId>wtf.metio.yosql</groupId>
      <artifactId>yosql-tooling-maven</artifactId>
      <version>2023.2.22</version>
      <configuration>
        <repositories>
          <allowedWritePrefixes>configValue</allowedWritePrefixes>
        </repositories>
      </configuration>
    </plugin>
  </plugins>
</build>