Class SupabaseInspectionRepository

Implements

InspectionRepository

Index

Constructors

Properties

Methods

buildListConditions compareAndSetStatus create createIdempotent existsOccurrenceKey findById findByTenant listPaged updateStatus

Constructors

constructor

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

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

Behavior: accepts db; returns a value.
- Defined in packages/db/src/repositories/inspecoes.repository.ts:243

Properties

`Private`db

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

The db value.

`Private` `Static` `Readonly`SORT_WHITELIST

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

Methods

`Private`buildListConditions

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

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

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

compareAndSetStatus

compareAndSetStatus(
    id: string,
    tenantId: string,
    expectedStatus: InspectionStatus,
    nextStatus: InspectionStatus,
): Promise<boolean>
Generated
Executes compareAndSetStatus.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- expectedStatus: InspectionStatus
  The expectedStatus value.
- nextStatus: InspectionStatus
  The nextStatus value.
Returns Promise<boolean>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspecoes.repository.ts, run compareAndSetStatus.

Behavior: Async; accepts id and tenantId and expectedStatus and nextStatus; returns a value; invokes this.db .update(inspections) .set({ status: nextStatus }) .w.
Implementation of InspectionRepository.compareAndSetStatus
- Defined in packages/db/src/repositories/inspecoes.repository.ts:478

create

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

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

Behavior: Async; accepts data; returns a value; invokes this.db .insert(inspections) .values({ id: crypto.randomUUID.
Implementation of InspectionRepository.create
- Defined in packages/db/src/repositories/inspecoes.repository.ts:406

createIdempotent

createIdempotent(data: CreateInspectionData): Promise<Inspection | null>
Generated
Updates data through createIdempotent.
Parameters
- data: CreateInspectionData
  The data value.
Returns Promise<Inspection | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspecoes.repository.ts, change data through createIdempotent.

Behavior: Async; accepts data; returns a value; invokes this.create; may throw.

Throws
When the function cannot complete normally.
Implementation of InspectionRepository.createIdempotent
- Defined in packages/db/src/repositories/inspecoes.repository.ts:503

existsOccurrenceKey

existsOccurrenceKey(key: string): Promise<boolean>
Generated
Executes existsOccurrenceKey.
Parameters
- key: string
  The key value.
Returns Promise<boolean>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspecoes.repository.ts, run existsOccurrenceKey.

Behavior: Async; accepts key; returns a value; invokes this.db.select({ id: inspections.id }) .from(inspections) .w.
Implementation of InspectionRepository.existsOccurrenceKey
- Defined in packages/db/src/repositories/inspecoes.repository.ts:529

findById

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

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

Behavior: Async; accepts id and tenantId; returns a value; invokes this.db .select() .from(inspections) .where(and(eq(inspectio.
Implementation of InspectionRepository.findById
- Defined in packages/db/src/repositories/inspecoes.repository.ts:277

findByTenant

findByTenant(tenantId: string): Promise<Inspection[]>
Generated
Returns the result of findByTenant.
Parameters
- tenantId: string
  The tenantId value.
Returns Promise<Inspection[]>
The function result.

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

Behavior: Async; accepts tenantId; returns a value; invokes this.db .select() .from(inspections) .where(eq(inspections.t.
Implementation of InspectionRepository.findByTenant
- Defined in packages/db/src/repositories/inspecoes.repository.ts:256

listPaged

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

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

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

updateStatus

updateStatus(
    id: string,
    tenantId: string,
    status: InspectionStatus,
): Promise<void>
Generated
Updates data through updateStatus.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- status: InspectionStatus
  The status value.
Returns Promise<void>
The function result.

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

Behavior: Async; accepts id and tenantId and status; returns a value; invokes this.db .update(inspections) .set({ status }) .where.
Implementation of InspectionRepository.updateStatus
- Defined in packages/db/src/repositories/inspecoes.repository.ts:457

Class SupabaseInspectionRepository

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns SupabaseInspectionRepository

Remarks

Properties

Privatedb

Private Static ReadonlySORT_WHITELIST

Methods

PrivatebuildListConditions

Parameters

Returns SQL<unknown>[]

Remarks

compareAndSetStatus

Parameters

Returns Promise<boolean>

Remarks

create

Parameters

Returns Promise<Inspection>

Remarks

createIdempotent

Parameters

Returns Promise<Inspection | null>

Remarks

Throws

existsOccurrenceKey

Parameters

Returns Promise<boolean>

Remarks

findById

Parameters

Returns Promise<Inspection | null>

Remarks

findByTenant

Parameters

Returns Promise<Inspection[]>

Remarks

listPaged

Parameters

Returns Promise<PagedResult<Inspection>>

Remarks

updateStatus

Parameters

Returns Promise<void>

Remarks

Settings

On This Page

`Private`db

`Private` `Static` `Readonly`SORT_WHITELIST

`Private`buildListConditions