Class SupabaseGheRepository

Implements

GheRepository

Index

Constructors

constructor

Properties

Methods

countLinkedRecords create delete deleteLinkedConfig findById findBySector findByTenant findByUnit update updateStatus

Constructors

constructor

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

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

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

Properties

`Private`db

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

The db value.

Methods

countLinkedRecords

countLinkedRecords(
    gheId: string,
    tenantId: string,
): Promise<
    {
        collaborators: number;
        epiRequirements: number;
        epiSuggestions: number;
        functions: number;
        riskCatalogItems: number;
        riskItems: number;
        total: number;
        trainingRequirements: number;
    },
>
Generated
Executes countLinkedRecords.
Parameters
- gheId: string
  The gheId value.
- tenantId: string
  The tenantId value.
Returns Promise<
    {
        collaborators: number;
        epiRequirements: number;
        epiSuggestions: number;
        functions: number;
        riskCatalogItems: number;
        riskItems: number;
        total: number;
        trainingRequirements: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/ghe.repository.ts, run countLinkedRecords.

Behavior: Async; accepts gheId and tenantId; returns a value; invokes Promise.all.
Implementation of GheRepository.countLinkedRecords
- Defined in packages/db/src/repositories/ghe.repository.ts:278

create

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

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

Behavior: Async; accepts data; returns a value; invokes this.db .insert(ghes) .values({ tenantId: data.tenantId, sec.
Implementation of GheRepository.create
- Defined in packages/db/src/repositories/ghe.repository.ts:156

delete

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

Remarks
Objective: In module packages/db/src/repositories/ghe.repository.ts, run delete.

Behavior: Async; accepts id and tenantId; returns a value; invokes this.db .delete(ghes) .where(and(eq(ghes.id, id), eq(ghes.te.
Implementation of GheRepository.delete
- Defined in packages/db/src/repositories/ghe.repository.ts:220

deleteLinkedConfig

deleteLinkedConfig(gheId: string, tenantId: string): Promise<void>
Generated
Updates data through deleteLinkedConfig.
Parameters
- gheId: string
  The gheId value.
- tenantId: string
  The tenantId value.
Returns Promise<void>
The function result.

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

Behavior: Async; accepts gheId and tenantId; returns a value; invokes Promise.all.
Implementation of GheRepository.deleteLinkedConfig
- Defined in packages/db/src/repositories/ghe.repository.ts:349

findById

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

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

Behavior: Async; accepts id and tenantId; returns a value; invokes this.db .select() .from(ghes) .where(and(eq(ghes.id, id), eq.
Implementation of GheRepository.findById
- Defined in packages/db/src/repositories/ghe.repository.ts:74

findBySector

findBySector(sectorId: string, tenantId: string): Promise<Ghe[]>
Generated
Returns the result of findBySector.
Parameters
- sectorId: string
  The sectorId value.
- tenantId: string
  The tenantId value.
Returns Promise<Ghe[]>
The function result.

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

Behavior: Async; accepts sectorId and tenantId; returns a value; invokes this.db .select() .from(ghes) .where(and(eq(ghes.sectorId, s.
Implementation of GheRepository.findBySector
- Defined in packages/db/src/repositories/ghe.repository.ts:95

findByTenant

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

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

Behavior: Async; accepts tenantId; returns a value; invokes this.db .select() .from(ghes) .where(eq(ghes.tenantId, tenan.
Implementation of GheRepository.findByTenant
- Defined in packages/db/src/repositories/ghe.repository.ts:136

findByUnit

findByUnit(unitId: string, tenantId: string): Promise<Ghe[]>
Generated
Returns the result of findByUnit.
Parameters
- unitId: string
  The unitId value.
- tenantId: string
  The tenantId value.
Returns Promise<Ghe[]>
The function result.

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

Behavior: Async; accepts unitId and tenantId; returns a value; invokes this.db .select() .from(ghes) .where(and(eq(ghes.unitId, uni.
Implementation of GheRepository.findByUnit
- Defined in packages/db/src/repositories/ghe.repository.ts:116

update

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

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

Behavior: Async; accepts id and tenantId and data; returns a value; invokes this.db .update(ghes) .set(patch) .where(and(eq(ghes.id, id).
Implementation of GheRepository.update
- Defined in packages/db/src/repositories/ghe.repository.ts:188

updateStatus

updateStatus(
    id: string,
    tenantId: string,
    status: GheStatus,
    validatedBy?: string,
    justification?: string,
): Promise<Ghe | null>
Generated
Updates data through updateStatus.
Parameters
- id: string
  The id value.
- tenantId: string
  The tenantId value.
- status: GheStatus
  The status value.
- OptionalvalidatedBy: string
  The validatedBy value.
- Optionaljustification: string
  The justification value.
Returns Promise<Ghe | null>
The function result.

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

Behavior: Async; accepts id and tenantId and status and validatedBy and justification; returns a value; invokes this.db .update(ghes) .set(patch) .where(and(eq(ghes.id, id).
Implementation of GheRepository.updateStatus
- Defined in packages/db/src/repositories/ghe.repository.ts:243

Class SupabaseGheRepository

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns SupabaseGheRepository

Remarks

Properties

Privatedb

Methods

countLinkedRecords

Parameters

Returns Promise< { collaborators: number; epiRequirements: number; epiSuggestions: number; functions: number; riskCatalogItems: number; riskItems: number; total: number; trainingRequirements: number; },>

Remarks

create

Parameters

Returns Promise<Ghe>

Remarks

delete

Parameters

Returns Promise<boolean>

Remarks

deleteLinkedConfig

Parameters

Returns Promise<void>

Remarks

findById

Parameters

Returns Promise<Ghe | null>

Remarks

findBySector

Parameters

Returns Promise<Ghe[]>

Remarks

findByTenant

Parameters

Returns Promise<Ghe[]>

Remarks

findByUnit

Parameters

Returns Promise<Ghe[]>

Remarks

update

Parameters

Returns Promise<Ghe | null>

Remarks

updateStatus

Parameters

Returns Promise<Ghe | null>

Remarks

Settings

On This Page

`Private`db

Returns Promise<
{
collaborators: number;
epiRequirements: number;
epiSuggestions: number;
functions: number;
riskCatalogItems: number;
riskItems: number;
total: number;
trainingRequirements: number;
},
>