Class SupabaseAiUsageLedgerRepository

Persistent UsageLedger backed by ai_usage_ledger table. Idempotent on requestId+tenantId (unique constraint).

Implements

UsageLedgerPort

Index

Constructors

Properties

Methods

getTenantCreditsUsed getUserCreditsUsed record

Constructors

constructor

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

Remarks
Objective: In module packages/db/src/repositories/ai-usage-ledger.repository.ts, run constructor.

Behavior: accepts db; returns a value.
- Defined in packages/db/src/repositories/ai-usage-ledger.repository.ts:22

Properties

`Private`db

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

The db value.

Methods

getTenantCreditsUsed

getTenantCreditsUsed(
    tenantId: string,
    periodStart: Date,
    periodEnd: Date,
): Promise<number>
Generated
Returns the result of getTenantCreditsUsed.
Parameters
- tenantId: string
- periodStart: Date
- periodEnd: Date
Returns Promise<number>
The function result.

Remarks
Objective: In module packages/db/src/repositories/ai-usage-ledger.repository.ts, retrieve data through getTenantCreditsUsed.

Behavior: Async; accepts tenantId and periodStart and periodEnd; returns a value; invokes this.db .select({ total: sql<number>COALESCE(SUM(${aiUsageL. @param tenantId The tenantIdvalue. @param periodStart TheperiodStartvalue. @param periodEnd TheperiodEnd` value.
Implementation of UsageLedgerPort.getTenantCreditsUsed
- Defined in packages/db/src/repositories/ai-usage-ledger.repository.ts:76

getUserCreditsUsed

getUserCreditsUsed(
    tenantId: string,
    userId: string,
    periodStart: Date,
    periodEnd: Date,
): Promise<number>
Generated
Returns the result of getUserCreditsUsed.
Parameters
- tenantId: string
- userId: string
- periodStart: Date
- periodEnd: Date
Returns Promise<number>
The function result.

Remarks
Objective: In module packages/db/src/repositories/ai-usage-ledger.repository.ts, retrieve data through getUserCreditsUsed.

Behavior: Async; accepts tenantId and userId and periodStart and periodEnd; returns a value; invokes this.db .select({ total: sql<number>COALESCE(SUM(${aiUsageL. @param tenantId The tenantIdvalue. @param userId TheuserIdvalue. @param periodStart TheperiodStartvalue. @param periodEnd TheperiodEnd` value.
Implementation of UsageLedgerPort.getUserCreditsUsed
- Defined in packages/db/src/repositories/ai-usage-ledger.repository.ts:111

record

record(entry: Omit<UsageLedgerEntry, "id" | "createdAt">): Promise<void>
Generated
Executes record.
Parameters
- entry: Omit<UsageLedgerEntry, "id" | "createdAt">
  The entry value.
Returns Promise<void>
The function result.

Remarks
Objective: In module packages/db/src/repositories/ai-usage-ledger.repository.ts, run record.

Behavior: Async; accepts entry; returns a value; invokes this.db .insert(aiUsageLedger) .values({ requestId: entry.re.
Implementation of UsageLedgerPort.record
- Defined in packages/db/src/repositories/ai-usage-ledger.repository.ts:35