sqlc-gen-java

SQLC Gen Java

A WASM plugin for SQLC allowing the generation of Java code.

[!NOTE] Only the PostgreSQL engine is supported currently. Support for MySQL is planned.

Configuration Values

Usage

sqlc.yaml

version: "2"
plugins:
  - name: java
    wasm:
      url: TODO
      sha256: TODO
sql:
  - schema: src/main/resources/postgresql/schema.sql
    queries: src/main/resources/postgresql/queries.sql
    engine: postgresql
    codegen:
      - out: src/main/java/com/example/postgresql
        plugin: java
        options:
          package: com.example.postgresql

Building From Source

Building the plugin is very simple, just clone the repository and run the following command:

GOOS=wasip1 GOARCH=wasm go build -o sqlc-gen-java.wasm plugin/main.go

A file sqlc-gen-java.wasm will be created in the repository root - you can then move it to your sqlc-enabled project and reference the plugin in your sqlc.yaml file using file://sqlc-gen-java.wasm as the plugin URL.

You should ensure that the sha256 value in your sqlc.yaml is correct for this new plugin file.

Planned Features

• MySQL support
• SQLite support
• Improved parameter naming
• First-class support for bytes, blob, bytea datatypes

Tentative:

• r2dbc support
• Support for PostgreSQL enum types
• copyfrom support where possible ref