Class RedemptionQueryService

constructor

• new RedemptionQueryService(args: { db: B2bDatabase }): RedemptionQueryService

  Parameters

  • args: { db: B2bDatabase }

  Returns RedemptionQueryService

Staticinstance

get

• get(
      args: Pick<
          {
              achBatchId?: string;
              amount: string;
              commitId?: string;
              commitTxId?: string;
              createdAt: Date;
              fees?: { amount: string; ledgerAccountId: string }[];
              id: string;
              idempotencyKey: string;
              initiateTxId?: string;
              ledgerAccountId: string | null;
              sourceWalletAddress: string | null;
              status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
              updatedAt: Date;
              voidRefund?: { ledgerAccountId: string } | { owner: string };
              voidTxId?: string;
              withdrawalId?: string;
          },
          "id",
      > & { customerId: string },
  ): Promise<
      {
          ok: true;
          value: | {
              achBatchId?: string;
              amount: string;
              commitId?: string;
              commitTxId?: string;
              createdAt: Date;
              fees?: { amount: string; ledgerAccountId: string }[];
              id: string;
              idempotencyKey: string;
              initiateTxId?: string;
              ledgerAccountId: string | null;
              sourceWalletAddress: string | null;
              status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
              updatedAt: Date;
              voidRefund?: { ledgerAccountId: string } | { owner: string };
              voidTxId?: string;
              withdrawalId?: string;
          }
          | null;
      },
  >

  Parameters

  • args: Pick<
        {
            achBatchId?: string;
            amount: string;
            commitId?: string;
            commitTxId?: string;
            createdAt: Date;
            fees?: { amount: string; ledgerAccountId: string }[];
            id: string;
            idempotencyKey: string;
            initiateTxId?: string;
            ledgerAccountId: string | null;
            sourceWalletAddress: string | null;
            status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
            updatedAt: Date;
            voidRefund?: { ledgerAccountId: string } | { owner: string };
            voidTxId?: string;
            withdrawalId?: string;
        },
        "id",
    > & { customerId: string }

  Returns Promise<
      {
          ok: true;
          value: | {
              achBatchId?: string;
              amount: string;
              commitId?: string;
              commitTxId?: string;
              createdAt: Date;
              fees?: { amount: string; ledgerAccountId: string }[];
              id: string;
              idempotencyKey: string;
              initiateTxId?: string;
              ledgerAccountId: string | null;
              sourceWalletAddress: string | null;
              status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
              updatedAt: Date;
              voidRefund?: { ledgerAccountId: string } | { owner: string };
              voidTxId?: string;
              withdrawalId?: string;
          }
          | null;
      },
  >

search

• search(
      __namedParameters: {
          amount?: string;
          amounts?: string[];
          createdAt?: DbTimestampCriteria;
          customerId: string;
          ids?: string[];
          orderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              achBatchExternalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              achBatchId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              amount: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<PgNumericBuilder>,
                                  {
                                      data: string;
                                      dataType: "string numeric";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              commitExternalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              commitTxId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              customerExternalId: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<PgTextBuilder<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              customerId: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<PgIntegerBuilder>,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              idempotencyKey: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<PgTextBuilder<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              ik: PgBuildColumn<
                                  "redemption",
                                  SetHasGenerated<SetNotNull<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string uuid";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: true;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              initiateTxId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              ledgerAccountExternalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              ledgerAccountId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              redemptionData: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<PgJsonbBuilder>,
                                  {
                                      data: unknown;
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              sourceWalletAddress: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              status: PgBuildColumn<
                                  "redemption",
                                  SetNotNull<Set$Type<(...), (...)>>,
                                  {
                                      data: (...) | (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "redemption";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              voidTxId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              withdrawalExternalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                              withdrawalId: PgBuildColumn<
                                  "redemption",
                                  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: "redemption";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "redemption";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "createdAt"
              | "updatedAt",
          >[];
          page?: number;
          pageSize?: number;
          standalone?: boolean;
          status?: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
          updatedAt?: DbTimestampCriteria;
      },
  ): Promise<
      {
          ok: true;
          value: {
              hasNext: boolean;
              items: {
                  achBatchId?: string;
                  amount: string;
                  commitId?: string;
                  commitTxId?: string;
                  createdAt: Date;
                  fees?: { amount: string; ledgerAccountId: string }[];
                  id: string;
                  idempotencyKey: string;
                  initiateTxId?: string;
                  ledgerAccountId: string | null;
                  sourceWalletAddress: string | null;
                  status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
                  updatedAt: Date;
                  voidRefund?: { ledgerAccountId: string } | { owner: string };
                  voidTxId?: string;
                  withdrawalId?: string;
              }[];
              total: number;
          };
      },
  >

  Parameters

  • __namedParameters: {
        amount?: string;
        amounts?: string[];
        createdAt?: DbTimestampCriteria;
        customerId: string;
        ids?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            achBatchExternalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            achBatchId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            amount: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgNumericBuilder>,
                                {
                                    data: string;
                                    dataType: "string numeric";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            commitExternalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            commitTxId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            customerExternalId: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            id: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            idempotencyKey: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            ik: PgBuildColumn<
                                "redemption",
                                SetHasGenerated<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string uuid";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: true;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            initiateTxId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            ledgerAccountExternalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            ledgerAccountId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            redemptionData: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgJsonbBuilder>,
                                {
                                    data: unknown;
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            sourceWalletAddress: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            status: PgBuildColumn<
                                "redemption",
                                SetNotNull<Set$Type<(...), (...)>>,
                                {
                                    data: (...) | (...) | (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            voidTxId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            withdrawalExternalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                            withdrawalId: PgBuildColumn<
                                "redemption",
                                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: "redemption";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "redemption";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        standalone?: boolean;
        status?: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
        updatedAt?: DbTimestampCriteria;
    }

    • Optionalamount?: string

    • Optionalamounts?: string[]

      Numeric equality on amount; an empty list matches nothing.

    • OptionalcreatedAt?: DbTimestampCriteria

    • customerId: string

    • Optionalids?: string[]

    • OptionalorderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          achBatchExternalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          achBatchId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          amount: PgBuildColumn<
                              "redemption",
                              SetNotNull<PgNumericBuilder>,
                              {
                                  data: string;
                                  dataType: "string numeric";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          commitExternalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          commitTxId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          customerExternalId: PgBuildColumn<
                              "redemption",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "redemption",
                              SetNotNull<PgIntegerBuilder>,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          id: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          idempotencyKey: PgBuildColumn<
                              "redemption",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          ik: PgBuildColumn<
                              "redemption",
                              SetHasGenerated<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string uuid";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: true;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          initiateTxId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          ledgerAccountExternalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          ledgerAccountId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          redemptionData: PgBuildColumn<
                              "redemption",
                              SetNotNull<PgJsonbBuilder>,
                              {
                                  data: unknown;
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          sourceWalletAddress: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          status: PgBuildColumn<
                              "redemption",
                              SetNotNull<Set$Type<(...), (...)>>,
                              {
                                  data: (...) | (...) | (...) | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "redemption";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          voidTxId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          withdrawalExternalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                          withdrawalId: PgBuildColumn<
                              "redemption",
                              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: "redemption";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "redemption";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[]

    • Optionalpage?: number

      Defaults to 1

    • OptionalpageSize?: number

      Defaults to 50

    • Optionalstandalone?: boolean

      true: no withdrawalId and no achBatchId. false: either one.

    • Optionalstatus?: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED"

    • OptionalupdatedAt?: DbTimestampCriteria

  Returns Promise<
      {
          ok: true;
          value: {
              hasNext: boolean;
              items: {
                  achBatchId?: string;
                  amount: string;
                  commitId?: string;
                  commitTxId?: string;
                  createdAt: Date;
                  fees?: { amount: string; ledgerAccountId: string }[];
                  id: string;
                  idempotencyKey: string;
                  initiateTxId?: string;
                  ledgerAccountId: string | null;
                  sourceWalletAddress: string | null;
                  status: "FAILED" | "PROCESSING" | "COMPLETED" | "RETURNED";
                  updatedAt: Date;
                  voidRefund?: { ledgerAccountId: string } | { owner: string };
                  voidTxId?: string;
                  withdrawalId?: string;
              }[];
              total: number;
          };
      },
  >

  customer redemption records