Class AchFileService

Hierarchy (View Summary)

AchFileQueryService
- AchFileService

Index

Constructors

constructor

Properties

Methods

archive create get mapDbToAchFile search searchIterator stat submit

Constructors

constructor

new AchFileService(
    args: {
        ACH_INVENTORY_WALLET_ID: string;
        achBatchAdminService: AchBatchAdminService;
        achBatchTransactionService: AchBatchTransactionService;
        achFileS3Service: AchFileS3Service;
        adminEventPublisher: AdminEventPublisher;
        db: B2bDatabase;
        nachaFileGenerator: NachaFileGenerator;
        redemptionWorkflowService: RedemptionWorkflowService;
    },
): AchFileService
Parameters
- args: {
      ACH_INVENTORY_WALLET_ID: string;
      achBatchAdminService: AchBatchAdminService;
      achBatchTransactionService: AchBatchTransactionService;
      achFileS3Service: AchFileS3Service;
      adminEventPublisher: AdminEventPublisher;
      db: B2bDatabase;
      nachaFileGenerator: NachaFileGenerator;
      redemptionWorkflowService: RedemptionWorkflowService;
  }
Returns AchFileService
Overrides AchFileQueryService.constructor
- Defined in packages/ach-services/src/AchFileService.ts:29

Properties

`Protected` `Readonly`db

db: B2bDatabase

Methods

create

create(
    args: { batchIds: string[]; type: "WITHDRAWAL" | "DEPOSIT" },
): Promise<
    { ok: true; value: AchFile }
    | { error: ServiceError; ok: false },
>
Parameters
- args: { batchIds: string[]; type: "WITHDRAWAL" | "DEPOSIT" }
Returns Promise<{ ok: true; value: AchFile } | { error: ServiceError; ok: false }>
- Defined in packages/ach-services/src/AchFileService.ts:49

get

get(args: { id: string }): Promise<{ ok: true; value: AchFile | null }>
Parameters
- args: { id: string }
Returns Promise<{ ok: true; value: AchFile | null }>
Inherited from AchFileQueryService.get
- Defined in packages/ach-services/src/AchFileQueryService.ts:34

`Protected`mapDbToAchFile

mapDbToAchFile(
    dbRow: Omit<
        {
            createdAt: Date;
            externalId: string;
            id: number;
            status: "CREATED"
            | "SUBMITTED"
            | "ARCHIVED";
            type: "WITHDRAWAL" | "DEPOSIT";
            updatedAt: Date;
        },
        "id",
    > & { id: string },
): AchFile
Parameters
- dbRow: Omit<
      {
          createdAt: Date;
          externalId: string;
          id: number;
          status: "CREATED"
          | "SUBMITTED"
          | "ARCHIVED";
          type: "WITHDRAWAL" | "DEPOSIT";
          updatedAt: Date;
      },
      "id",
  > & { id: string }
Returns AchFile
Inherited from AchFileQueryService.mapDbToAchFile
- Defined in packages/ach-services/src/AchFileQueryService.ts:143

search

search(
    __namedParameters: {
        createdAt?: DbTimestampCriteria;
        ids?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            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: "ach_file";
                                },
                                {},
                                {},
                            >;
                            externalId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: { type: ... };
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "externalId";
                                    notNull: true;
                                    tableName: "ach_file";
                                },
                                {},
                                {},
                            >;
                            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: "ach_file";
                                },
                                {},
                                {},
                            >;
                            status: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: (...)
                                    | (...)
                                    | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "status";
                                    notNull: true;
                                    tableName: "ach_file";
                                },
                                {},
                                { $type: (...)
                                | (...)
                                | (...) },
                            >;
                            type: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: (...)
                                    | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "type";
                                    notNull: true;
                                    tableName: "ach_file";
                                },
                                {},
                                { $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: "ach_file";
                                },
                                {},
                                {},
                            >;
                        };
                        dialect: "pg";
                        name: "ach_file";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        status?: "CREATED" | "SUBMITTED" | "ARCHIVED";
        updatedAt?: DbTimestampCriteria;
    },
): Promise<{ ok: true; value: { hasNext: boolean; items: AchFile[] } }>
Parameters
- __namedParameters: {
      createdAt?: DbTimestampCriteria;
      ids?: string[];
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          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: "ach_file";
                              },
                              {},
                              {},
                          >;
                          externalId: PgColumn<
                              {
                                  baseColumn: never;
                                  columnType: "PgText";
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: [(...), ...(...)[]];
                                  generated: { type: ... };
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: "externalId";
                                  notNull: true;
                                  tableName: "ach_file";
                              },
                              {},
                              {},
                          >;
                          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: "ach_file";
                              },
                              {},
                              {},
                          >;
                          status: PgColumn<
                              {
                                  baseColumn: never;
                                  columnType: "PgText";
                                  data: (...)
                                  | (...)
                                  | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: [(...), ...(...)[]];
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: "status";
                                  notNull: true;
                                  tableName: "ach_file";
                              },
                              {},
                              { $type: (...)
                              | (...)
                              | (...) },
                          >;
                          type: PgColumn<
                              {
                                  baseColumn: never;
                                  columnType: "PgText";
                                  data: (...)
                                  | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: [(...), ...(...)[]];
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: "type";
                                  notNull: true;
                                  tableName: "ach_file";
                              },
                              {},
                              { $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: "ach_file";
                              },
                              {},
                              {},
                          >;
                      };
                      dialect: "pg";
                      name: "ach_file";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      page?: number;
      pageSize?: number;
      status?: "CREATED" | "SUBMITTED" | "ARCHIVED";
      updatedAt?: DbTimestampCriteria;
  }
  - OptionalcreatedAt?: DbTimestampCriteria
  - Optionalids?: string[]
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        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: "ach_file";
                            },
                            {},
                            {},
                        >;
                        externalId: PgColumn<
                            {
                                baseColumn: never;
                                columnType: "PgText";
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: [(...), ...(...)[]];
                                generated: { type: ... };
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: "externalId";
                                notNull: true;
                                tableName: "ach_file";
                            },
                            {},
                            {},
                        >;
                        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: "ach_file";
                            },
                            {},
                            {},
                        >;
                        status: PgColumn<
                            {
                                baseColumn: never;
                                columnType: "PgText";
                                data: (...)
                                | (...)
                                | (...);
                                dataType: "string";
                                driverParam: string;
                                enumValues: [(...), ...(...)[]];
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: "status";
                                notNull: true;
                                tableName: "ach_file";
                            },
                            {},
                            { $type: (...)
                            | (...)
                            | (...) },
                        >;
                        type: PgColumn<
                            {
                                baseColumn: never;
                                columnType: "PgText";
                                data: (...)
                                | (...);
                                dataType: "string";
                                driverParam: string;
                                enumValues: [(...), ...(...)[]];
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: "type";
                                notNull: true;
                                tableName: "ach_file";
                            },
                            {},
                            { $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: "ach_file";
                            },
                            {},
                            {},
                        >;
                    };
                    dialect: "pg";
                    name: "ach_file";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
  - Optionalpage?: number
    Defaults to 1
  - OptionalpageSize?: number
    Defaults to 100
  - Optionalstatus?: "CREATED" | "SUBMITTED" | "ARCHIVED"
  - OptionalupdatedAt?: DbTimestampCriteria
Returns Promise<{ ok: true; value: { hasNext: boolean; items: AchFile[] } }>
Inherited from AchFileQueryService.search
- Defined in packages/ach-services/src/AchFileQueryService.ts:45

searchIterator

searchIterator(
params: Omit<Parameters<AchFileQueryService["search"]>[0], "page">,
): AsyncGenerator<AchFile>
Parameters
- params: Omit<Parameters<AchFileQueryService["search"]>[0], "page">
Returns AsyncGenerator<AchFile>
Inherited from AchFileQueryService.searchIterator
- Defined in packages/ach-services/src/AchFileQueryService.ts:101

stat

stat(
args?: { status?: "CREATED" | "SUBMITTED" | "ARCHIVED" },
): Promise<{ ok: true; value: { count: number } }>
Scalar count of ach_file rows, optionally filtered by status. Used by operator dashboards (work-queue tiles) where iterating search just to derive a count would be wasteful.
Parameters
- args: { status?: "CREATED" | "SUBMITTED" | "ARCHIVED" } = {}
Returns Promise<{ ok: true; value: { count: number } }>
Inherited from AchFileQueryService.stat
- Defined in packages/ach-services/src/AchFileQueryService.ts:129

submit

submit(args: { ids: string[] }): Promise<{ ok: true; value: undefined }>
Parameters
- args: { ids: string[] }
Returns Promise<{ ok: true; value: undefined }>
- Defined in packages/ach-services/src/AchFileService.ts:224

Class AchFileService

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns AchFileService

Properties

Protected Readonlydb

Methods

archive

Parameters

Returns Promise<{ ok: true; value: { affectedBatchIds: string[] } }>

create

Parameters

Returns Promise<{ ok: true; value: AchFile } | { error: ServiceError; ok: false }>

get

Parameters

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

ProtectedmapDbToAchFile

Parameters

Returns AchFile

search

Parameters

OptionalcreatedAt?: DbTimestampCriteria

Optionalids?: string[]

Optionalpage?: number

OptionalpageSize?: number

Optionalstatus?: "CREATED" | "SUBMITTED" | "ARCHIVED"

OptionalupdatedAt?: DbTimestampCriteria

Returns Promise<{ ok: true; value: { hasNext: boolean; items: AchFile[] } }>

searchIterator

Parameters

Returns AsyncGenerator<AchFile>

stat

Parameters

Returns Promise<{ ok: true; value: { count: number } }>

submit

Parameters

Returns Promise<{ ok: true; value: undefined }>

Settings

On This Page

`Protected` `Readonly`db

`Protected`mapDbToAchFile

`Optional`createdAt?: DbTimestampCriteria

`Optional`ids?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`status?: "CREATED" | "SUBMITTED" | "ARCHIVED"

`Optional`updatedAt?: DbTimestampCriteria