Kysely•12mo ago

jsonArrayFrom with `as` not being typed

I have the following query

await db
    .selectFrom('user')
    .selectAll()
    .select((eb) => [
      jsonArrayFrom(
        eb
          .selectFrom('book')
          .selectAll()
          .where('book.is_enabled', '=', true)
      ).as('books'),
    ])
    .execute();

await db
    .selectFrom('user')
    .selectAll()
    .select((eb) => [
      jsonArrayFrom(
        eb
          .selectFrom('book')
          .selectAll()
          .where('book.is_enabled', '=', true)
      ).as('books'),
    ])
    .execute();

but the resulting query is not seeing the jsonArrayFrom field with the name books , rather it types it like this:

{
  [x: string]: {
      created_at: TimestampTZ;
      description: string | null;
      id: string;
      label: string | null;
      name: string;
      is_enabled: boolean;
  }[];
  ... 5 more ...;
  name: string;
}[]

{
  [x: string]: {
      created_at: TimestampTZ;
      description: string | null;
      id: string;
      label: string | null;
      name: string;
      is_enabled: boolean;
  }[];
  ... 5 more ...;
  name: string;
}[]

How can i fix this?

Solution:

so Im using deno, and it uses import maps to import deps, I have these 2 import paths set up: I forgot to bump the helper path version to 0.27.3 as well 🤦‍♂️...

Jump to solution

14 Replies

Igal•12mo ago

Hey 👋 This works fine in the playground. Is tsconfig.json#compilerOptions.strict not true by any chance?

bombillazoOP•12mo ago

let me check yes, it is true hey, somethign weird, this happens on kysely v 0.27.3, not on 0.27.2 hmmmm esm.sh CDN has a kysely version for 0.27.3, but the GH releases stop at 0.27.2 it works for 0.27.2

Igal•12mo ago

the playground can use 0.27.3, 0.27.2, etc. this is something local what typescript version?

bombillazoOP•12mo ago

what chagnes occurred for .3? I dont see them in the release notes. Im using TS 5.4.4

Igal•12mo ago

We haven't posted a release, nothing major

bombillazoOP•12mo ago

its strange that there is no TS problem on 0.27.2 but there is for 0.27.3, using the same TS version

Igal•12mo ago

can you share your Database interface with just the two tables?

bombillazoOP•12mo ago

sure, one sec

declare const TimestampTZ: unique symbol;

export type TimestampTZ = string & { _opaque: typeof TimestampTZ };

export type DBTimestampTZ = ColumnType<TimestampTZ, TimestampTZ, TimestampTZ>;

export interface BookTable {
  created_at: Generated<DBTimestampTZ>;
  description: string | null;
  id: Generated<string>;
  is_enabled: Generated<boolean>;
  label: string;
  name: string;
}

export interface UserTable {
  created_at: Generated<DBTimestampTZ>;
  description: string | null;
  id: Generated<string>;
  name: string;
  interests: string[]
  email: string;
  level: number;
  birthdate: string;
  score: number;
}

export interface KyselyDB {
  user:UserTable,
  book: BookTable,
}

declare const TimestampTZ: unique symbol;

export type TimestampTZ = string & { _opaque: typeof TimestampTZ };

export type DBTimestampTZ = ColumnType<TimestampTZ, TimestampTZ, TimestampTZ>;

export interface BookTable {
  created_at: Generated<DBTimestampTZ>;
  description: string | null;
  id: Generated<string>;
  is_enabled: Generated<boolean>;
  label: string;
  name: string;
}

export interface UserTable {
  created_at: Generated<DBTimestampTZ>;
  description: string | null;
  id: Generated<string>;
  name: string;
  interests: string[]
  email: string;
  level: number;
  birthdate: string;
  score: number;
}

export interface KyselyDB {
  user:UserTable,
  book: BookTable,
}

Igal•12mo ago

can you share the definition of DBTeimstampTZ ?

bombillazoOP•12mo ago

updated*

Igal•12mo ago

where did you import jsonArrayFrom from ?

bombillazoOP•12mo ago

aaaaaaaah 🙂

Solution

bombillazo•12mo ago

so Im using deno, and it uses import maps to import deps, I have these 2 import paths set up: I forgot to bump the helper path version to 0.27.3 as well 🤦‍♂️

bombillazoOP•12mo ago

now its fixed, thanks 😄

Gaming

Programming

jsonArrayFrom with `as` not being typed

Did you find this page helpful?