Class SupabaseInspectionActionRepository

Implements

InspectionActionRepository

Index

Constructors

Properties

Methods

buildListConditions create findByFinding findById findByStatus findByTenant findingIdsSubquery listPaged update updateStatus

Constructors

constructor

new SupabaseInspectionActionRepository(
db: PostgresJsDatabase<packages/db/src/schema> & {},
): SupabaseInspectionActionRepository
Generated
Executes constructor.
Parameters
- db: PostgresJsDatabase<packages/db/src/schema> & {}
  The db value.
Returns SupabaseInspectionActionRepository
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, run constructor.

Behavior: accepts db; returns a value.
- Defined in packages/db/src/repositories/inspection-action.repository.ts:73

Properties

`Private`db

db: PostgresJsDatabase<packages/db/src/schema> & {}

The db value.

`Private` `Static` `Readonly`SORT_WHITELIST

SORT_WHITELIST: Record<
string,
typeof inspectionActions[keyof typeof inspectionActions],
> = ...

Methods

`Private`buildListConditions

buildListConditions(
    tenantId: string,
    query: ListActionsQuery,
    filter?: HierarchyFilter,
): SQL<unknown>[]
Generated
Executes buildListConditions.
Parameters
- tenantId: string
  The tenantId value.
- query: ListActionsQuery
  The query value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns SQL<unknown>[]
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, run buildListConditions.

Behavior: accepts tenantId and query and filter; returns a value; invokes eq.
- Defined in packages/db/src/repositories/inspection-action.repository.ts:204

create

create(data: CreateInspectionActionData): Promise<InspectionAction>
Generated
Executes create.
Parameters
- data: CreateInspectionActionData
  The data value.
Returns Promise<InspectionAction>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, run create.

Behavior: Async; accepts data; returns a value; invokes this.db.insert(inspectionActions).values({ tenantId: data.te.
Implementation of InspectionActionRepository.create
- Defined in packages/db/src/repositories/inspection-action.repository.ts:318

findByFinding

findByFinding(findingId: string, tenantId: string): Promise<InspectionAction[]>
Generated
Returns the result of findByFinding.
Parameters
- findingId: string
  The findingId value.
- tenantId: string
  The tenantId value.
Returns Promise<InspectionAction[]>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, retrieve data through findByFinding.

Behavior: Async; accepts findingId and tenantId; returns a value; invokes this.db.select().from(inspectionActions) .where(and(eq(inspe.
Implementation of InspectionActionRepository.findByFinding
- Defined in packages/db/src/repositories/inspection-action.repository.ts:87

findById

findById(id: string, tenantId: string): Promise<InspectionAction | null>
Generated
Returns the result of findById.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
Returns Promise<InspectionAction | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, retrieve data through findById.

Behavior: Async; accepts id and tenantId; returns a value; invokes this.db.select().from(inspectionActions) .where(and(eq(inspe.
Implementation of InspectionActionRepository.findById
- Defined in packages/db/src/repositories/inspection-action.repository.ts:153

findByStatus

findByStatus(
    tenantId: string,
    status: InspectionActionStatus,
    filter?: HierarchyFilter,
): Promise<InspectionAction[]>
Generated
Returns the result of findByStatus.
Parameters
- tenantId: string
  The tenantId value.
- status: InspectionActionStatus
  The status value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<InspectionAction[]>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, retrieve data through findByStatus.

Behavior: Async; accepts tenantId and status and filter; returns a value; invokes eq.
Implementation of InspectionActionRepository.findByStatus
- Defined in packages/db/src/repositories/inspection-action.repository.ts:173

findByTenant

findByTenant(
tenantId: string,
filter?: HierarchyFilter,
): Promise<InspectionAction[]>
Generated
Returns the result of findByTenant.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<InspectionAction[]>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, retrieve data through findByTenant.

Behavior: Async; accepts tenantId and filter; returns a value; invokes eq.
Implementation of InspectionActionRepository.findByTenant
- Defined in packages/db/src/repositories/inspection-action.repository.ts:131

`Private`findingIdsSubquery

findingIdsSubquery(
    tenantId: string,
    filter: HierarchyFilter,
): Omit<
    PgSelectBase<
        "inspection_findings",
        { id: PgColumn<{}, {}, {}> },
        "partial",
        Record<"inspection_findings", "not-null">,
        false,
        "where",
        { id: string }[],
        { id: PgColumn<{}, {}, {}> },
    >,
    "where",
>
Generated
Executes findingIdsSubquery.
Parameters
- tenantId: string
  The tenantId value.
- filter: HierarchyFilter
  The filter value.
Returns Omit<
    PgSelectBase<
        "inspection_findings",
        { id: PgColumn<{}, {}, {}> },
        "partial",
        Record<"inspection_findings", "not-null">,
        false,
        "where",
        { id: string }[],
        { id: PgColumn<{}, {}, {}> },
    >,
    "where",
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, run findingIdsSubquery.

Behavior: accepts tenantId and filter; returns a value; invokes eq.
- Defined in packages/db/src/repositories/inspection-action.repository.ts:106

listPaged

listPaged(
    tenantId: string,
    query: ListActionsQuery,
    filter?: HierarchyFilter,
): Promise<PagedResult<InspectionAction>>
Generated
Returns the result of listPaged.
Parameters
- tenantId: string
  The tenantId value.
- query: ListActionsQuery
  The query value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<PagedResult<InspectionAction>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, retrieve data through listPaged.

Behavior: Async; accepts tenantId and query and filter; returns a value; invokes Math.max.
Implementation of InspectionActionRepository.listPaged
- Defined in packages/db/src/repositories/inspection-action.repository.ts:272

update

update(
    id: string,
    tenantId: string,
    data: UpdateInspectionActionData,
): Promise<InspectionAction | null>
Generated
Executes update.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- data: UpdateInspectionActionData
  The data value.
Returns Promise<InspectionAction | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, run update.

Behavior: Async; accepts id and tenantId and data; returns a value; invokes this.db.update(inspectionActions).set(dbData) .where(and(eq(.
Implementation of InspectionActionRepository.update
- Defined in packages/db/src/repositories/inspection-action.repository.ts:357

updateStatus

updateStatus(
    id: string,
    tenantId: string,
    status: InspectionActionStatus,
    timestamps?: { completedAt?: Date },
): Promise<InspectionAction | null>
Generated
Updates data through updateStatus.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- status: InspectionActionStatus
  The status value.
- Optionaltimestamps: { completedAt?: Date }
  The timestamps value.
Returns Promise<InspectionAction | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-action.repository.ts, change data through updateStatus.

Behavior: Async; accepts id and tenantId and status and timestamps; returns a value; invokes this.db.update(inspectionActions).set({ status, ...extra }) .
Implementation of InspectionActionRepository.updateStatus
- Defined in packages/db/src/repositories/inspection-action.repository.ts:384

Class SupabaseInspectionActionRepository

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns SupabaseInspectionActionRepository

Remarks

Properties

Privatedb

Private Static ReadonlySORT_WHITELIST

Methods

PrivatebuildListConditions

Parameters

Returns SQL<unknown>[]

Remarks

create

Parameters

Returns Promise<InspectionAction>

Remarks

findByFinding

Parameters

Returns Promise<InspectionAction[]>

Remarks

findById

Parameters

Returns Promise<InspectionAction | null>

Remarks

findByStatus

Parameters

Returns Promise<InspectionAction[]>

Remarks

findByTenant

Parameters

Returns Promise<InspectionAction[]>

Remarks

PrivatefindingIdsSubquery

Parameters

Returns Omit< PgSelectBase< "inspection_findings", { id: PgColumn<{}, {}, {}> }, "partial", Record<"inspection_findings", "not-null">, false, "where", { id: string }[], { id: PgColumn<{}, {}, {}> }, >, "where",>

Remarks

listPaged

Parameters

Returns Promise<PagedResult<InspectionAction>>

Remarks

update

Parameters

Returns Promise<InspectionAction | null>

Remarks

updateStatus

Parameters

Returns Promise<InspectionAction | null>

Remarks

Settings

On This Page

`Private`db

`Private` `Static` `Readonly`SORT_WHITELIST

`Private`buildListConditions

`Private`findingIdsSubquery

Returns Omit<
PgSelectBase<
"inspection_findings",
{ id: PgColumn<{}, {}, {}> },
"partial",
Record<"inspection_findings", "not-null">,
false,
"where",
{ id: string }[],
{ id: PgColumn<{}, {}, {}> },
>,
"where",
>