1 reply

Type errors with `@effect/sql-drizzle`

https://github.com/kylekz/effect-drizzle-repro

i'm experimenting with discord bot stuff based on

effect-ts/discord-bot

effect-ts/discord-bot

and having some type issues using

@effect/sql-drizzle

@effect/sql-drizzle

packages/db/src/index.ts

packages/db/src/index.ts

has two errors:
when defining the schema passed into

Pg.layerWithConfig

Pg.layerWithConfig

Type 'typeof import("/home/kyle/code/effect-drizzle-repro/packages/db/src/schema")' is not assignable to type 'Record<string, never>'.
  Property 'Servers' is incompatible with index signature.
    Type 'PgTableWithColumns<{ name: "servers"; schema: undefined; columns: { guildId: PgColumn<{ name: "guildId"; tableName: "servers"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; ... 7 more ...; generated: undefined; }, {}, { ...; }>; ... 4 more ...; id: PgColumn<...>; }; d...' is not assignable to type 'never'.ts(2322)

Type 'typeof import("/home/kyle/code/effect-drizzle-repro/packages/db/src/schema")' is not assignable to type 'Record<string, never>'.
  Property 'Servers' is incompatible with index signature.
    Type 'PgTableWithColumns<{ name: "servers"; schema: undefined; columns: { guildId: PgColumn<{ name: "guildId"; tableName: "servers"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; ... 7 more ...; generated: undefined; }, {}, { ...; }>; ... 4 more ...; id: PgColumn<...>; }; d...' is not assignable to type 'never'.ts(2322)

and when exporting the layer:

The inferred type of 'DatabaseLive' cannot be named without a reference to '.bun/@[email protected]+b58dd6837bc1e26a/node_modules/@effect/sql/SqlClient'. This is likely not portable. A type annotation is necessary.ts(2742)

The inferred type of 'DatabaseLive' cannot be named without a reference to '.bun/@[email protected]+b58dd6837bc1e26a/node_modules/@effect/sql/SqlClient'. This is likely not portable. A type annotation is necessary.ts(2742)

doing

Pg.layer

Pg.layer

instead of

Pg.layerWithConfig()

Pg.layerWithConfig()

resolves that type error, but i'd like to be able to use drizzle's rqb which requires passing the schema in.
at the moment i'm just assuming this is a bun/monorepo issue with types, as it works at runtime

Type errors with `@effect/sql-drizzle`

https://github.com/kylekz/effect-drizzle-repro

i'm experimenting with discord bot stuff based on

effect-ts/discord-bot

effect-ts/discord-bot

and having some type issues using

@effect/sql-drizzle

@effect/sql-drizzle

packages/db/src/index.ts

packages/db/src/index.ts

has two errors:
when defining the schema passed into

Pg.layerWithConfig

Pg.layerWithConfig

Type 'typeof import("/home/kyle/code/effect-drizzle-repro/packages/db/src/schema")' is not assignable to type 'Record<string, never>'.
  Property 'Servers' is incompatible with index signature.
    Type 'PgTableWithColumns<{ name: "servers"; schema: undefined; columns: { guildId: PgColumn<{ name: "guildId"; tableName: "servers"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; ... 7 more ...; generated: undefined; }, {}, { ...; }>; ... 4 more ...; id: PgColumn<...>; }; d...' is not assignable to type 'never'.ts(2322)

Type 'typeof import("/home/kyle/code/effect-drizzle-repro/packages/db/src/schema")' is not assignable to type 'Record<string, never>'.
  Property 'Servers' is incompatible with index signature.
    Type 'PgTableWithColumns<{ name: "servers"; schema: undefined; columns: { guildId: PgColumn<{ name: "guildId"; tableName: "servers"; dataType: "string"; columnType: "PgVarchar"; data: string; driverParam: string; notNull: true; ... 7 more ...; generated: undefined; }, {}, { ...; }>; ... 4 more ...; id: PgColumn<...>; }; d...' is not assignable to type 'never'.ts(2322)

and when exporting the layer:

The inferred type of 'DatabaseLive' cannot be named without a reference to '.bun/@[email protected]+b58dd6837bc1e26a/node_modules/@effect/sql/SqlClient'. This is likely not portable. A type annotation is necessary.ts(2742)

The inferred type of 'DatabaseLive' cannot be named without a reference to '.bun/@[email protected]+b58dd6837bc1e26a/node_modules/@effect/sql/SqlClient'. This is likely not portable. A type annotation is necessary.ts(2742)

doing

Pg.layer

Pg.layer

instead of

Pg.layerWithConfig()

Pg.layerWithConfig()

Type errors with `@effect/sql-drizzle`

Similar Threads

Type errors with `@effect/sql-drizzle`

Similar Threads

Similar Threads

Similar Threads