sqlc.yaml

version: "2"
rules:
  - name: "always-order-by"
    rule: |
      query.cmd == "many" && !query.sql.contains("ORDER BY")
    message: |
      SELECT statements must have an ORDER BY clause
sql:
  - &default_domain
    name: "Users SQL"
    engine: "postgresql"
    schema: "../internal/database/migrations"
    queries: "../internal/user/queries"
    rules:
      - "always-order-by"
    gen:
      go: &default_go
        package: "usersql"
        out: "../internal/user/usersql"
        sql_package: "pgx/v5"
        emit_interface: true
        emit_result_struct_pointers: true
        emit_prepared_queries: true
        emit_all_enum_values: true
        emit_enum_valid_method: true
        emit_pointers_for_null_types: true
        emit_empty_slices: true
        json_tags_id_uppercase: true
        omit_unused_structs: true
        omit_sqlc_version: true
        overrides:
          - db_type: "slug"
            go_type: "*github.com/nais/api/internal/slug.Slug"
            nullable: true
          - db_type: "slug"
            go_type: "github.com/nais/api/internal/slug.Slug"
          - db_type: "uuid"
            go_type: "*github.com/google/uuid.UUID"
            nullable: true
          - db_type: "uuid"
            go_type: "github.com/google/uuid.UUID"

  - <<: *default_domain
    name: "Service accounts SQL"
    queries: "../internal/serviceaccount/queries"
    gen:
      go:
        <<: *default_go
        package: "serviceaccountsql"
        out: "../internal/serviceaccount/serviceaccountsql"

  - <<: *default_domain
    name: "Deployments SQL"
    queries: "../internal/deployment/queries"
    gen:
      go:
        <<: *default_go
        package: "deploymentsql"
        out: "../internal/deployment/deploymentsql"

  - <<: *default_domain
    name: "Teams SQL"
    queries: "../internal/team/queries"
    gen:
      go:
        <<: *default_go
        package: "teamsql"
        out: "../internal/team/teamsql"

  - <<: *default_domain
    name: "Authz SQL"
    queries: "../internal/auth/authz/queries"
    gen:
      go:
        <<: *default_go
        package: "authzsql"
        out: "../internal/auth/authz/authzsql"

  - <<: *default_domain
    name: "Activity log SQL"
    queries: "../internal/activitylog/queries"
    gen:
      go:
        <<: *default_go
        package: "activitylogsql"
        out: "../internal/activitylog/activitylogsql"

  - <<: *default_domain
    name: "GitHub repositories SQL"
    queries: "../internal/github/repository/queries"
    gen:
      go:
        <<: *default_go
        package: "repositorysql"
        out: "../internal/github/repository/repositorysql"

  - <<: *default_domain
    name: "Cost SQL"
    queries: "../internal/cost/queries"
    gen:
      go:
        <<: *default_go
        package: "costsql"
        out: "../internal/cost/costsql"

  - <<: *default_domain
    name: "Reconciler SQL"
    queries: "../internal/reconciler/queries"
    gen:
      go:
        <<: *default_go
        package: "reconcilersql"
        out: "../internal/reconciler/reconcilersql"

  - <<: *default_domain
    name: "Environment SQL"
    queries: "../internal/environment/queries"
    gen:
      go:
        <<: *default_go
        package: "environmentsql"
        out: "../internal/environment/environmentsql"

  - <<: *default_domain
    name: "Teams SQL for gRPC"
    queries: "../internal/grpc/grpcteam/queries"
    gen:
      go:
        <<: *default_go
        package: "grpcteamsql"
        out: "../internal/grpc/grpcteam/grpcteamsql"

  - <<: *default_domain
    name: "Users SQL for gRPC"
    queries: "../internal/grpc/grpcuser/queries"
    gen:
      go:
        <<: *default_go
        package: "grpcusersql"
        out: "../internal/grpc/grpcuser/grpcusersql"

  - <<: *default_domain
    name: "Reconcilers SQL for gRPC"
    queries: "../internal/grpc/grpcreconciler/queries"
    gen:
      go:
        <<: *default_go
        package: "grpcreconcilersql"
        out: "../internal/grpc/grpcreconciler/grpcreconcilersql"

  - <<: *default_domain
    name: "Deployments SQL for gRPC"
    queries: "../internal/grpc/grpcdeployment/queries"
    gen:
      go:
        <<: *default_go
        package: "grpcdeploymentsql"
        out: "../internal/grpc/grpcdeployment/grpcdeploymentsql"

  - <<: *default_domain
    name: "Usersync SQL"
    queries: "../internal/usersync/queries"
    gen:
      go:
        <<: *default_go
        package: "usersyncsql"
        out: "../internal/usersync/usersyncsql"

  - <<: *default_domain
    name: "Session SQL"
    queries: "../internal/session/queries"
    gen:
      go:
        <<: *default_go
        package: "sessionsql"
        out: "../internal/session/sessionsql"

  - <<: *default_domain
    name: "Search SQL"
    queries: "../internal/search/queries"
    gen:
      go:
        <<: *default_go
        package: "searchsql"
        out: "../internal/search/searchsql"

  - <<: *default_domain
    name: "K8s events"
    queries: "../internal/kubernetes/event/queries"
    gen:
      go:
        <<: *default_go
        package: "eventsql"
        out: "../internal/kubernetes/event/searchsql"