The separator to split SQL statements inside a single .sql file.

Configuration Options

Option: ‘;’

The default value of the sqlStatementSeparator configuration option is .sql. It matches all files that end with .sql.

Option: ‘|’

Changing the sqlStatementSeparator configuration option to | configures YoSQL split .sql files using the | character.

Related Options

• inputBaseDirectory: The input directory for the user written SQL files.
• outputBaseDirectory: The output directory for the generated classes.
• skipLines: The number of lines to skip in each file (e.g. a copyright header).
• sqlFilesCharset: The charset to use while reading .sql files.
• sqlFilesSuffix: The file ending to use while searching for SQL files.

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 --files-sql-statement-separator=configValue

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

$ yosql --sql-statement-separator=configValue

Gradle

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

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

yosql {
  files {
    sqlStatementSeparator.set(configValue)
  }
}

or in Groovy syntax like this:

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

yosql {
  files {
    sqlStatementSeparator = configValue
  }
}

Maven

In order to use YoSQL together with Maven, take a look at the tooling documentation for Maven. The sqlStatementSeparator 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>
        <files>
          <sqlStatementSeparator>configValue</sqlStatementSeparator>
        </files>
      </configuration>
    </plugin>
  </plugins>
</build>