sqlc-ext

sqlc plugin to generate type-safe code for SQL using templates.

Installation

go install github.com/donkeywon/sqlc-ext@latest

Usage

version: "2"
plugins:
  - name: sqlc-ext
    process:
      cmd: sqlc-ext
sql:
  - engine: mysql
    queries: path/to/query.sql
    schema: path/to/migration_or_ddl.sql
    gen:
      go:
        package: sample
        out: path/to/out/dir
        emit_db_tags: true
        emit_interface: true
        emit_exported_queries: true
        emit_prepared_queries: true
        emit_json_tags: true
        emit_result_struct_pointers: false
        emit_pointers_for_null_types: false
        emit_params_struct_pointers: true
        emit_enum_valid_method: true
        emit_all_enum_values: true
    codegen:
      - plugin: sqlc-ext
        out: path/to/out/dir
        options:
          package: sample
          template_dir: sqlc-ext/codegen/golang/templates
          template_patterns:
            - "*.tmpl"
          template_output_file_names:
            modelsExtFile: models_ext.go