Class RedemptionQueryService

new RedemptionQueryService(args: { sqlClient: Sql }): RedemptionQueryService

get(
    args: Pick<
        {
            achBatchId?: string;
            amount: string;
            commitId?: string;
            commitTxId?: string;
            createdAt: Date;
            id: string;
            idempotencyKey: string;
            initiateTxId?: string;
            redemptionWalletId: string;
            status: "PENDING"
            | "FAILED"
            | "COMMITTED"
            | "VOIDED";
            updatedAt: Date;
            voidTxId?: string;
            withdrawalId?: string;
        },
        "id",
    > & { customerId: string },
): Promise<
    {
        ok: true;
        value: | {
            achBatchId?: string;
            amount: string;
            commitId?: string;
            commitTxId?: string;
            createdAt: Date;
            id: string;
            idempotencyKey: string;
            initiateTxId?: string;
            redemptionWalletId: string;
            status: "PENDING"
            | "FAILED"
            | "COMMITTED"
            | "VOIDED";
            updatedAt: Date;
            voidTxId?: string;
            withdrawalId?: string;
        }
        | null;
    },
>

search(
    __namedParameters: {
        amount?: string;
        createdAt?: DbTimestampCriteria;
        customerId: string;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            amount: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgNumeric";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "amount";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            commitExternalId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "commitExternalId";
                                    notNull: false;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            commitTxId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "commitTxId";
                                    notNull: false;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            createdAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "createdAt";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            customerId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "customerId";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            externalId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: true;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "externalId";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            id: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: true;
                                    name: "id";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            idempotencyKey: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "idempotencyKey";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            initiateTxId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "initiateTxId";
                                    notNull: false;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            redemptionData: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgJsonb";
                                    data: unknown;
                                    dataType: "json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "redemptionData";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            redemptionWalletId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "redemptionWalletId";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            status: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: (...)
                                    | (...)
                                    | (...)
                                    | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "status";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                { $type: (...)
                                | (...)
                                | (...)
                                | (...) },
                            >;
                            updatedAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "updatedAt";
                                    notNull: true;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                            voidTxId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "voidTxId";
                                    notNull: false;
                                    tableName: "customer_redemption";
                                },
                                {},
                                {},
                            >;
                        };
                        dialect: "pg";
                        name: "customer_redemption";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        status?: "PENDING" | "FAILED" | "COMMITTED" | "VOIDED";
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: {
                achBatchId?: string;
                amount: string;
                commitId?: string;
                commitTxId?: string;
                createdAt: Date;
                id: string;
                idempotencyKey: string;
                initiateTxId?: string;
                redemptionWalletId: string;
                status: "PENDING"
                | "FAILED"
                | "COMMITTED"
                | "VOIDED";
                updatedAt: Date;
                voidTxId?: string;
                withdrawalId?: string;
            }[];
        };
    },
>