sqlc.yaml

version: "2"
overrides:
  go:
    rename:
      cfe: CVE
sql:
  - engine: "postgresql"
    queries: "internal/store/queries/"
    schema: "migrations/"
    gen:
      go:
        package: "store"
        out: "internal/store/generated"
        # PLAN.md §18.3: map Postgres UUID columns to google/uuid.UUID for
        # standard JSON marshaling without manual pgtype.UUID conversions.
        overrides:
          - db_type: "uuid"
            go_type: "github.com/google/uuid.UUID"
          - db_type: "uuid"
            nullable: true
            go_type: "github.com/google/uuid.NullUUID"
          # Postgres TIME (time without time zone) doesn't scan into time.Time
          # via database/sql — store as string "HH:MM:SS".
          - db_type: "pg_catalog.time"
            go_type: "string"