version: "2"
sql:
  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/meta/queries
    gen:
      go:
        package: metadb
        out: internal/meta/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true
        rename:
          tg_set_updated_at: TgSetUpdatedAt

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/users/queries
    gen:
      go:
        package: usersdb
        out: internal/users/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/repos/queries
    gen:
      go:
        package: reposdb
        out: internal/repos/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/issues/queries
    gen:
      go:
        package: issuesdb
        out: internal/issues/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/pulls/queries
    gen:
      go:
        package: pullsdb
        out: internal/pulls/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/checks/queries
    gen:
      go:
        package: checksdb
        out: internal/checks/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/auth/policy/queries
    gen:
      go:
        package: policydb
        out: internal/auth/policy/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/worker/queries
    gen:
      go:
        package: workerdb
        out: internal/worker/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/social/queries
    gen:
      go:
        package: socialdb
        out: internal/social/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/notif/queries
    gen:
      go:
        package: notifdb
        out: internal/notif/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/orgs/queries
    gen:
      go:
        package: orgsdb
        out: internal/orgs/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/webhook/queries
    gen:
      go:
        package: webhookdb
        out: internal/webhook/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/admin/queries
    gen:
      go:
        package: admindb
        out: internal/admin/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/ratelimit/queries
    gen:
      go:
        package: ratelimitdb
        out: internal/ratelimit/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/actions/queries
    gen:
      go:
        package: actionsdb
        out: internal/actions/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true
        rename:
          # sqlc strips "-es" suffixes naively; ours has a CH cluster so
          # the default singular "WorkflowCach" reads as a typo. The
          # rename targets the pre-snake-case Go identifier sqlc would
          # otherwise emit, not the table name.
          workflow_cach: WorkflowCache

  - engine: postgresql
    schema: internal/migrationsfs/migrations
    queries: internal/billing/queries
    gen:
      go:
        package: billingdb
        out: internal/billing/sqlc
        sql_package: pgx/v5
        emit_json_tags: false
        emit_pointers_for_null_types: false
        emit_prepared_queries: false
        emit_interface: true
        emit_exact_table_names: false
        emit_empty_slices: true
        emit_methods_with_db_argument: true