Classplugin-kysely-postgresv0.6.0

KyselyService

Base class for KyselyPostgres services.

Provides a small, typed shim around the shared Kysely instance and ensures that subclasses have been decorated with @RegisterKyselyService.

abstract class KyselyService<
    TTable extends LiteralUnion<KyselyTable, string> =
        KyselyTable
>

\@RegisterKyselyService('users')
export class UsersService extends KyselyService<'users'> {
  public async findById(id: string) {
    return this.db
      .selectFrom(this.table)
      .selectAll().where('id', '=', id)
      .executeTakeFirst();
  }
}

// Usage inside handlers:
const user = await this.core.db.services.users.findById('abc');

Member visibility

Filter class members by access level.

constructor

Constructs a new instance of the KyselyService class

KyselyService(kysely: KyselyPostgres, core: CoreBase)

Showing members with Protected visibility and higher.

TTable

The table this service works with. Defaults to every table in the schema.

TTable extends LiteralUnion<KyselyTable, string> = KyselyTable

core

protected readonly core: CoreBase

db

Shared Kysely instance used to interact with the Postgres database.

public get db(): Kysely<KyselySchema>

kysely

protected readonly kysely: KyselyPostgres

table

public readonly table: TTable