Class BankInternalTransferQueryService

constructor

• new BankInternalTransferQueryService(
      args: { db: B2bDatabase },
  ): BankInternalTransferQueryService

  Parameters

  • args: { db: B2bDatabase }

  Returns BankInternalTransferQueryService

Staticinstance

get

• get(
      args: {
          id: string;
          now?: Date;
          tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
      },
  ): Promise<{ ok: true; value: BankInternalTransfer | null }>

  Parameters

  • args: {
        id: string;
        now?: Date;
        tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
    }

    • id: string

    • Optionalnow?: Date

      The clock deadline is read at. Defaults to now.

    • Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

  Returns Promise<{ ok: true; value: BankInternalTransfer | null }>

search

• search(
      __namedParameters: {
          amount?: BigNumber;
          createdAt?: DbTimestampCriteria;
          depositId?: string;
          executors?: Executor[];
          hasExecutor?: true;
          idempotencyKeys?: string[];
          ids?: string[];
          idsIgnoringCase?: string[];
          legAccount?: Pick<
              BankTransaction,
              "type"
              | "routingNumber"
              | "accountNumber",
          >;
          legIds?: string[];
          now?: Date;
          orderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              countsInImpliedBalance: PgBuildColumn<
                                  "bank_internal_transfer",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: boolean;
                                      dataType: "boolean";
                                      driverParam: boolean;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "bank_internal_transfer",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "bank_internal_transfer",
                                  Set$Type<
                                      SetHasDefault<(...)>,
                                      {
                                          amount: ...;
                                          createdPublished?: ...;
                                          depositId?: ...;
                                          executor?: ...;
                                          executorClaims?: ...;
                                          failedBy?: ...;
                                          failureReason?: ...;
                                          initiatedBy?: ...;
                                          memo?: ...;
                                          mintRefusals?: ...;
                                          note?: ...;
                                          providerReference?: ...;
                                          resendRefusals?: ...;
                                          routeFusionBeneficiaryId?: ...;
                                          routeFusionSource?: ...;
                                          routeFusionTransferId?: ...;
                                          source?: ...;
                                          sourceBankAccountId?: ...;
                                          sourceVirtualAccountId?: ...;
                                          target?: ...;
                                          targetBankAccountId?: ...;
                                          targetVirtualAccountId?: ...;
                                          victorCounterpartyId?: ...;
                                          victorTransactionId?: ...;
                                          wireBatchAmount?: ...;
                                          wireBatchId?: ...;
                                          wireInstruction?: ...;
                                          withdrawalId?: ...;
                                      },
                                  >,
                                  {
                                      data: {
                                          amount: ...;
                                          createdPublished?: ...;
                                          depositId?: ...;
                                          executor?: ...;
                                          executorClaims?: ...;
                                          failedBy?: ...;
                                          failureReason?: ...;
                                          initiatedBy?: ...;
                                          memo?: ...;
                                          mintRefusals?: ...;
                                          note?: ...;
                                          providerReference?: ...;
                                          resendRefusals?: ...;
                                          routeFusionBeneficiaryId?: ...;
                                          routeFusionSource?: ...;
                                          routeFusionTransferId?: ...;
                                          source?: ...;
                                          sourceBankAccountId?: ...;
                                          sourceVirtualAccountId?: ...;
                                          target?: ...;
                                          targetBankAccountId?: ...;
                                          targetVirtualAccountId?: ...;
                                          victorCounterpartyId?: ...;
                                          victorTransactionId?: ...;
                                          wireBatchAmount?: ...;
                                          wireBatchId?: ...;
                                          wireInstruction?: ...;
                                          withdrawalId?: ...;
                                      };
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "bank_internal_transfer",
                                  SetHasRuntimeDefault<SetNotNull<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "bank_internal_transfer",
                                  HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: "byDefault";
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              idempotencyKey: PgBuildColumn<
                                  "bank_internal_transfer",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              status: PgBuildColumn<
                                  "bank_internal_transfer",
                                  SetHasDefault<Set$Type<(...), (...)>>,
                                  {
                                      data: (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "bank_internal_transfer",
                                  SetHasDefault<SetHasDefault<(...)>>,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              withdrawalExternalId: PgBuildColumn<
                                  "bank_internal_transfer",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                              withdrawalId: PgBuildColumn<
                                  "bank_internal_transfer",
                                  PgIntegerBuilder,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...)
                                      | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "bank_internal_transfer";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "bank_internal_transfer";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "createdAt"
              | "updatedAt",
          >[];
          page?: number;
          pageSize?: number;
          sourceAccountNumber?: string;
          stale?: true;
          status?: "PENDING" | "COMPLETED" | "FAILED";
          tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
          updatedAt?: DbTimestampCriteria;
          withdrawalId?: string;
          withoutLeg?: "CREDIT" | "DEBIT";
      },
  ): Promise<
      {
          ok: true;
          value: { hasNext: boolean; items: BankInternalTransfer[]; total: number };
      },
  >

  Parameters

  • __namedParameters: {
        amount?: BigNumber;
        createdAt?: DbTimestampCriteria;
        depositId?: string;
        executors?: Executor[];
        hasExecutor?: true;
        idempotencyKeys?: string[];
        ids?: string[];
        idsIgnoringCase?: string[];
        legAccount?: Pick<
            BankTransaction,
            "type"
            | "routingNumber"
            | "accountNumber",
        >;
        legIds?: string[];
        now?: Date;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            countsInImpliedBalance: PgBuildColumn<
                                "bank_internal_transfer",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: boolean;
                                    dataType: "boolean";
                                    driverParam: boolean;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "bank_internal_transfer",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            data: PgBuildColumn<
                                "bank_internal_transfer",
                                Set$Type<
                                    SetHasDefault<(...)>,
                                    {
                                        amount: ...;
                                        createdPublished?: ...;
                                        depositId?: ...;
                                        executor?: ...;
                                        executorClaims?: ...;
                                        failedBy?: ...;
                                        failureReason?: ...;
                                        initiatedBy?: ...;
                                        memo?: ...;
                                        mintRefusals?: ...;
                                        note?: ...;
                                        providerReference?: ...;
                                        resendRefusals?: ...;
                                        routeFusionBeneficiaryId?: ...;
                                        routeFusionSource?: ...;
                                        routeFusionTransferId?: ...;
                                        source?: ...;
                                        sourceBankAccountId?: ...;
                                        sourceVirtualAccountId?: ...;
                                        target?: ...;
                                        targetBankAccountId?: ...;
                                        targetVirtualAccountId?: ...;
                                        victorCounterpartyId?: ...;
                                        victorTransactionId?: ...;
                                        wireBatchAmount?: ...;
                                        wireBatchId?: ...;
                                        wireInstruction?: ...;
                                        withdrawalId?: ...;
                                    },
                                >,
                                {
                                    data: {
                                        amount: ...;
                                        createdPublished?: ...;
                                        depositId?: ...;
                                        executor?: ...;
                                        executorClaims?: ...;
                                        failedBy?: ...;
                                        failureReason?: ...;
                                        initiatedBy?: ...;
                                        memo?: ...;
                                        mintRefusals?: ...;
                                        note?: ...;
                                        providerReference?: ...;
                                        resendRefusals?: ...;
                                        routeFusionBeneficiaryId?: ...;
                                        routeFusionSource?: ...;
                                        routeFusionTransferId?: ...;
                                        source?: ...;
                                        sourceBankAccountId?: ...;
                                        sourceVirtualAccountId?: ...;
                                        target?: ...;
                                        targetBankAccountId?: ...;
                                        targetVirtualAccountId?: ...;
                                        victorCounterpartyId?: ...;
                                        victorTransactionId?: ...;
                                        wireBatchAmount?: ...;
                                        wireBatchId?: ...;
                                        wireInstruction?: ...;
                                        withdrawalId?: ...;
                                    };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "bank_internal_transfer",
                                SetHasRuntimeDefault<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            id: PgBuildColumn<
                                "bank_internal_transfer",
                                HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            idempotencyKey: PgBuildColumn<
                                "bank_internal_transfer",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            status: PgBuildColumn<
                                "bank_internal_transfer",
                                SetHasDefault<Set$Type<(...), (...)>>,
                                {
                                    data: (...) | (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "bank_internal_transfer",
                                SetHasDefault<SetHasDefault<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            withdrawalExternalId: PgBuildColumn<
                                "bank_internal_transfer",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                            withdrawalId: PgBuildColumn<
                                "bank_internal_transfer",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "bank_internal_transfer";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "bank_internal_transfer";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        sourceAccountNumber?: string;
        stale?: true;
        status?: "PENDING" | "COMPLETED" | "FAILED";
        tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
        updatedAt?: DbTimestampCriteria;
        withdrawalId?: string;
        withoutLeg?: "CREDIT" | "DEBIT";
    }

    • Optionalamount?: BigNumber

      Transfers whose data.amount equals this, compared as numbers.

    • OptionalcreatedAt?: DbTimestampCriteria

    • OptionaldepositId?: string

    • Optionalexecutors?: Executor[]

      Transfers whose recorded executor is one of these. An empty list matches none.

    • OptionalhasExecutor?: true

      Transfers the operator workflow started; the leg guard leaves the rest alone.

    • OptionalidempotencyKeys?: string[]

      Transfers an operator initiated under these idempotency keys.

    • Optionalids?: string[]

    • OptionalidsIgnoringCase?: string[]

      Like ids, ignoring case: a rail can upper-case the id it carries in free text.

    • OptionallegAccount?: Pick<BankTransaction, "type" | "routingNumber" | "accountNumber">

      Transfers whose end on the side type names (source for a DEBIT, target for a CREDIT) is this account, as attachLeg checks a leg's account.

    • OptionallegIds?: string[]

      Transfers with any leg among these bank transactions.

    • Optionalnow?: Date

      The clock deadline and the stale filter are read at. Defaults to now.

    • OptionalorderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          countsInImpliedBalance: PgBuildColumn<
                              "bank_internal_transfer",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: boolean;
                                  dataType: "boolean";
                                  driverParam: boolean;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "bank_internal_transfer",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          data: PgBuildColumn<
                              "bank_internal_transfer",
                              Set$Type<
                                  SetHasDefault<(...)>,
                                  {
                                      amount: ...;
                                      createdPublished?: ...;
                                      depositId?: ...;
                                      executor?: ...;
                                      executorClaims?: ...;
                                      failedBy?: ...;
                                      failureReason?: ...;
                                      initiatedBy?: ...;
                                      memo?: ...;
                                      mintRefusals?: ...;
                                      note?: ...;
                                      providerReference?: ...;
                                      resendRefusals?: ...;
                                      routeFusionBeneficiaryId?: ...;
                                      routeFusionSource?: ...;
                                      routeFusionTransferId?: ...;
                                      source?: ...;
                                      sourceBankAccountId?: ...;
                                      sourceVirtualAccountId?: ...;
                                      target?: ...;
                                      targetBankAccountId?: ...;
                                      targetVirtualAccountId?: ...;
                                      victorCounterpartyId?: ...;
                                      victorTransactionId?: ...;
                                      wireBatchAmount?: ...;
                                      wireBatchId?: ...;
                                      wireInstruction?: ...;
                                      withdrawalId?: ...;
                                  },
                              >,
                              {
                                  data: {
                                      amount: ...;
                                      createdPublished?: ...;
                                      depositId?: ...;
                                      executor?: ...;
                                      executorClaims?: ...;
                                      failedBy?: ...;
                                      failureReason?: ...;
                                      initiatedBy?: ...;
                                      memo?: ...;
                                      mintRefusals?: ...;
                                      note?: ...;
                                      providerReference?: ...;
                                      resendRefusals?: ...;
                                      routeFusionBeneficiaryId?: ...;
                                      routeFusionSource?: ...;
                                      routeFusionTransferId?: ...;
                                      source?: ...;
                                      sourceBankAccountId?: ...;
                                      sourceVirtualAccountId?: ...;
                                      target?: ...;
                                      targetBankAccountId?: ...;
                                      targetVirtualAccountId?: ...;
                                      victorCounterpartyId?: ...;
                                      victorTransactionId?: ...;
                                      wireBatchAmount?: ...;
                                      wireBatchId?: ...;
                                      wireInstruction?: ...;
                                      withdrawalId?: ...;
                                  };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "bank_internal_transfer",
                              SetHasRuntimeDefault<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          id: PgBuildColumn<
                              "bank_internal_transfer",
                              HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: "byDefault";
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          idempotencyKey: PgBuildColumn<
                              "bank_internal_transfer",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          status: PgBuildColumn<
                              "bank_internal_transfer",
                              SetHasDefault<Set$Type<(...), (...)>>,
                              {
                                  data: (...) | (...) | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "bank_internal_transfer",
                              SetHasDefault<SetHasDefault<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          withdrawalExternalId: PgBuildColumn<
                              "bank_internal_transfer",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                          withdrawalId: PgBuildColumn<
                              "bank_internal_transfer",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "bank_internal_transfer";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "bank_internal_transfer";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[]

      Must name the same table as the dbOrderBy call below.

    • Optionalpage?: number

      Defaults to 1

    • OptionalpageSize?: number

      Defaults to 10

    • OptionalsourceAccountNumber?: string

      Transfers whose recorded source account has this number, matched on the number alone like bankTransactionSourceAccountTypeSql.

    • Optionalstale?: true

      Transfers whose deadline has passed.

    • Optionalstatus?: "PENDING" | "COMPLETED" | "FAILED"

    • Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

    • OptionalupdatedAt?: DbTimestampCriteria

    • OptionalwithdrawalId?: string

    • OptionalwithoutLeg?: "CREDIT" | "DEBIT"

      Transfers holding no leg on this side yet.

  Returns Promise<
      {
          ok: true;
          value: { hasNext: boolean; items: BankInternalTransfer[]; total: number };
      },
  >

staleStat

• staleStat(
      __namedParameters?: {
          now?: Date;
          tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
      },
  ): Promise<
      { ok: true; value: { count: number; earliestDeadline: Date
      | null } },
  >

  How many transfers the stale filter returns, and the earliest of their deadlines. Grouped by executor, orphaned sweeps being the group with none. Within a group the deadline moves only with the clock, so its earliest clock gives its earliest deadline.

  Parameters

  • __namedParameters: { now?: Date; tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations> } = {}

    • Optionalnow?: Date

      The clock the deadlines are read at. Defaults to now.

    • Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

  Returns Promise<{ ok: true; value: { count: number; earliestDeadline: Date | null } }>