Class SupabaseInspectionFindingRepository

Implements

InspectionFindingRepository

Index

Constructors

Properties

Methods

buildListConditions compareAndSetEscalation create findById findByInspection findByStatus findByTenant findingHierarchyConds listPaged update updateStatus

Constructors

constructor

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

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

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

Properties

`Private`db

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

The db value.

`Private` `Static` `Readonly`SORT_WHITELIST

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

Methods

`Private`buildListConditions

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

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

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

compareAndSetEscalation

compareAndSetEscalation(
    id: string,
    tenantId: string,
    expectedLevel: string | null,
    nextLevel: string,
    escalatedAt: Date,
): Promise<InspectionFinding | null>
Generated
Executes compareAndSetEscalation.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- expectedLevel: string | null
  The expectedLevel value.
- nextLevel: string
  The nextLevel value.
- escalatedAt: Date
  The escalatedAt value.
Returns Promise<InspectionFinding | null>
The function result.

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

Behavior: Async; accepts id and tenantId and expectedLevel and nextLevel and escalatedAt; returns a value; invokes eq.
Implementation of InspectionFindingRepository.compareAndSetEscalation
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:384

create

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

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

Behavior: Async; accepts data; returns a value; invokes this.db.insert(inspectionFindings).values({ tenantId: data.t.
Implementation of InspectionFindingRepository.create
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:317

findById

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

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

Behavior: Async; accepts id and tenantId; returns a value; invokes this.db.select().from(inspectionFindings) .where(and(eq(insp.
Implementation of InspectionFindingRepository.findById
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:148

findByInspection

findByInspection(
inspectionId: string,
tenantId: string,
): Promise<InspectionFinding[]>
Generated
Returns the result of findByInspection.
Parameters
- inspectionId: string
  The inspectionId value.
- tenantId: string
  The tenantId value.
Returns Promise<InspectionFinding[]>
The function result.

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

Behavior: Async; accepts inspectionId and tenantId; returns a value; invokes this.db.select().from(inspectionFindings) .where(and(eq(insp.
Implementation of InspectionFindingRepository.findByInspection
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:92

findByStatus

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

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

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

findByTenant

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

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

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

`Private`findingHierarchyConds

findingHierarchyConds(
tenantId: string,
filter?: HierarchyFilter,
): SQL<unknown>[]
Hierarchy conditions for findings. Handles null-unit findings by falling back to the parent inspection's unit_id (which is NOT NULL).
Parameters
- tenantId: string
- Optionalfilter: HierarchyFilter
Returns SQL<unknown>[]
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:103

listPaged

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

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

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

update

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

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

Behavior: Async; accepts id and tenantId and data; returns a value; invokes this.db.update(inspectionFindings).set(data) .where(and(eq(i.
Implementation of InspectionFindingRepository.update
- Defined in packages/db/src/repositories/inspection-finding.repository.ts:362

updateStatus

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

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

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

Class SupabaseInspectionFindingRepository

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns SupabaseInspectionFindingRepository

Remarks

Properties

Privatedb

Private Static ReadonlySORT_WHITELIST

Methods

PrivatebuildListConditions

Parameters

Returns SQL<unknown>[]

Remarks

compareAndSetEscalation

Parameters

Returns Promise<InspectionFinding | null>

Remarks

create

Parameters

Returns Promise<InspectionFinding>

Remarks

findById

Parameters

Returns Promise<InspectionFinding | null>

Remarks

findByInspection

Parameters

Returns Promise<InspectionFinding[]>

Remarks

findByStatus

Parameters

Returns Promise<InspectionFinding[]>

Remarks

findByTenant

Parameters

Returns Promise<InspectionFinding[]>

Remarks

PrivatefindingHierarchyConds

Parameters

Returns SQL<unknown>[]

listPaged

Parameters

Returns Promise<PagedResult<InspectionFinding>>

Remarks

update

Parameters

Returns Promise<InspectionFinding | null>

Remarks

updateStatus

Parameters

Returns Promise<InspectionFinding | null>

Remarks

Settings

On This Page

`Private`db

`Private` `Static` `Readonly`SORT_WHITELIST

`Private`buildListConditions

`Private`findingHierarchyConds