Janady13/missionmatch / sqlc.yaml · Consciousness Atlas

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / sqlc.yaml
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	1675031db74316e100782d063e9eda1a597fe3a1
Branch	workstream-a-opportunity-intelligence
Path or archive member	sqlc.yaml
Original SHA-256	91adb1d24c0961fc3d9ed97a03f258044fd7ab3d73ef2f13e6aab4fb3b3f6a36
Git blob SHA	5e04f1ee65e39dd7594b3ba7b118bdb81d15d1df
Reading-copy SHA-256	91adb1d24c0961fc3d9ed97a03f258044fd7ab3d73ef2f13e6aab4fb3b3f6a36

Original source ↗

Every recorded occurrence

These 11 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / sqlc.yaml	workstream-a-opportunity-intelligence	1675031db74316e100782d063e9eda1a597fe3a1	Open original
Janady13/missionmatch / sqlc.yaml	workstream-d-command-center	255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9	Open original
Janady13/missionmatch / sqlc.yaml	workstream-e-commercial-stubs	4437da660539284a400ee380b9b427a300c369ee	Open original
Janady13/missionmatch / sqlc.yaml	ruthless-debug-sweep	b7d742f8f032984be3817efffa3eb8b13b651c1f	Open original
Janady13/missionmatch / sqlc.yaml	workstream-b-sam-contract-awards	d5101cceb98e70000cebb31d3e7ac73d747d3a6d	Open original
Janady13/missionmatch / sqlc.yaml	workstream-a-shared-core	e0de03ac3a1ec826bd15d0e048e3b02baa23eeff	Open original
Janady13/missionmatch / sqlc.yaml	workstream-d-command-center	255e7d1d420abf5e277d0cd8c9b14f6f72b6acb9	Open original
Janady13/missionmatch / sqlc.yaml	ruthless-debug-sweep	b7d742f8f032984be3817efffa3eb8b13b651c1f	Open original
Janady13/missionmatch / sqlc.yaml	workstream-a-opportunity-intelligence	1675031db74316e100782d063e9eda1a597fe3a1	Open original
Janady13/missionmatch / sqlc.yaml	workstream-e-commercial-stubs	4437da660539284a400ee380b9b427a300c369ee	Open original
Janady13/missionmatch / sqlc.yaml	workstream-b-sam-contract-awards	d5101cceb98e70000cebb31d3e7ac73d747d3a6d	Open original

Recovered source transcript

Download complete source text ↓58 lines · 3.2 KB

version: "2"
sql:
  - engine: "postgresql"
    schema: "db/migrations"      # goose-annotated; sqlc parses these as the schema (ignores -- +goose Down)
    queries: "db/queries"        # ONLY public-schema queries — no eeo queries here, so generated
                                 # matching code physically cannot reference eeo.candidate_demographics
    gen:
      go:
        package: "dbgen"
        out: "internal/platform/database/dbgen"
        sql_package: "pgx/v5"
        emit_json_tags: true
        emit_pointers_for_null_types: true
        emit_interface: true
        emit_empty_slices: true
        overrides:
          - db_type: "uuid"
            go_type: { import: "github.com/google/uuid", type: "UUID" }
          - db_type: "uuid"
            nullable: true
            go_type: { import: "github.com/google/uuid", type: "UUID", pointer: true }
          - db_type: "timestamptz"            # BARE name (pg_catalog.timestamptz does NOT match under pgx/v5)
            go_type: "time.Time"
          - db_type: "timestamptz"
            nullable: true
            go_type: { type: "time.Time", pointer: true }
          - db_type: "pg_catalog.numeric"     # covers AVG()/expression numeric results
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          # NUMERIC db_type override is IGNORED for plain columns under pgx/v5 — a per-column override
          # is REQUIRED on every numeric table column to honor the decimal-determinism rule.
          - column: "opportunities.value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "usaspending_awards.award_amount"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "bls_wages.value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "opportunity_records.estimated_value"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal", pointer: true }
          - column: "slate_members.total_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.clearance_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.skills_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.certs_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.customer_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.experience_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - column: "slate_members.location_score"
            go_type: { import: "github.com/shopspring/decimal", type: "Decimal" }
          - db_type: "vector"
            go_type: { import: "github.com/pgvector/pgvector-go", package: "pgvector", type: "Vector" }
          - db_type: "vector"
            nullable: true
            go_type: { import: "github.com/pgvector/pgvector-go", package: "pgvector", type: "Vector", pointer: true }