sqlc-gen-python-orm

sqlc-gen-python-orm is a plugin for sqlc that generates an ORM (now, support SQLAlchemy only) for Python.

This softwaer forked from sqlc-gen-python and modified to generate ORM.

Usage

get sha256 hash of wasm file

curl -sSL https://github.com/zztkm/sqlc-gen-python-orm/releases/download/v0.0.1/sqlc-gen-python-orm.wasm.sha256

add plugin to sqlc.yaml

version: '2'
plugins:
- name: py
  wasm:
    url: https://github.com/zztkm/sqlc-gen-python-orm/releases/download/v0.0.1/sqlc-gen-python-orm.wasm
    sha256: <sha256 hash>
sql:
- schema: "schema.sql"
  queries: "query.sql"
  engine: postgresql
  codegen:
  - out: src/authors
    plugin: py
    options:
      package: .
      emit_sync_querier: true
      emit_async_querier: true

Refs

• sqlc plugin を書こう - 薄いブログ