sqlc.yaml

# sqlc configuration for the PostgreSQL todo adapter.
#
# The schema is read directly from the goose migrations (sqlc understands goose
# annotations natively, so there is no separate schema.sql to drift). Generated
# code lands in internal/todo/postgres/sqlc and is committed; the sqlc-check
# moon task guards it against drift. The schema stays under the shared
# internal/adapter/postgres (database-level concern), while the generated code
# and queries live with the todo domain.
version: "2"
sql:
  - engine: postgresql
    schema: internal/adapter/postgres/migrations
    queries: internal/todo/postgres/queries
    gen:
      go:
        package: sqlc
        out: internal/todo/postgres/sqlc
        sql_package: pgx/v5
        emit_pointers_for_null_types: true
        emit_interface: true
        # Only emit structs for tables/enums referenced by a todo query. The
        # api_keys table lives in the shared migrations dir (read as the schema)
        # but is queried by the apikey adapter's hand-written pgx, not sqlc, so
        # this keeps the todo sqlc package free of an unused ApiKey model and
        # leaves it untouched whether the api_keys migration is present or not.
        omit_unused_structs: true
        overrides:
          # ID column maps to the same uuid.UUID the rest of the codebase uses;
          # the adapter converts to/from the domain's string at the boundary.
          - db_type: uuid
            go_type: github.com/google/uuid.UUID
          # Map timestamptz to the standard time.Time rather than the pgx
          # pgtype wrapper so the generated rows mirror the domain entity. The
          # non-nullable created_at becomes time.Time; the nullable
          # completed_at becomes *time.Time (matching todo.Todo.CompletedAt).
          - db_type: timestamptz
            nullable: false
            go_type: time.Time
          - db_type: timestamptz
            nullable: true
            go_type:
              type: time.Time
              pointer: true