Skip to content

SqlSchema

4 exports Added in v1.0.0 Source

Constructor

findAll

Added in v1.0.0 Source

Run a sql query with a request schema and a result schema.

Signature

declare function findAll<IR, II, IA, AR, AI, A, R, E>(options: {
  readonly execute: (request: II) => Effect<readonly Array<unknown>, E, R>;
  readonly Request: any;
  readonly Result: any;
}): (request: IA) => Effect<readonly Array<A>, any, IR | AR | R>

findOne

Added in v1.0.0 Source

Run a sql query with a request schema and a result schema and return the first result.

Signature

declare function findOne<IR, II, IA, AR, AI, A, R, E>(options: {
  readonly execute: (request: II) => Effect<readonly Array<unknown>, E, R>;
  readonly Request: any;
  readonly Result: any;
}): (request: IA) => Effect<Option<A>, any, IR | AR | R>

single

Added in v1.0.0 Source

Run a sql query with a request schema and a result schema and return the first result.

Signature

declare function single<IR, II, IA, AR, AI, A, R, E>(options: {
  readonly execute: (request: II) => Effect<readonly Array<unknown>, E, R>;
  readonly Request: any;
  readonly Result: any;
}): (request: IA) => Effect<A, any, IR | AR | R>

Other

Signature

declare function void<IR, II, IA, R, E>(options: {
  readonly execute: (request: II) => Effect<unknown, E, R>;
  readonly Request: any;
}): (request: IA) => Effect<void, any, IR | R>