neoney Posts - Answer Overflow

neoney

Explore posts from servers

•Created by neoney on 5/31/2024 in #help

issue with update from select

doing this:

    await db
      .update(stores)
      .set({
        discordBotId: db
          .select({
            id: discordBots.id,
          })
          .from(discordBots)
          .leftJoin(stores, eq(stores.discordBotId, discordBots.id))
          .groupBy(discordBots.id)
          .orderBy(asc(sql`COUNT(${stores.id})`))
          .limit(1),
      })
      .where(eq(stores.id, store.id));

    await db
      .update(stores)
      .set({
        discordBotId: db
          .select({
            id: discordBots.id,
          })
          .from(discordBots)
          .leftJoin(stores, eq(stores.discordBotId, discordBots.id))
          .groupBy(discordBots.id)
          .orderBy(asc(sql`COUNT(${stores.id})`))
          .limit(1),
      })
      .where(eq(stores.id, store.id));

causes this:

Type 'Omit<PgSelectBase<"discord_bots", { id: PgColumn<{ name: "id"; tableName: "discord_bots"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: undefined; baseColumn: never; }, {}, {}>; }, ... 5 more ..., { ...; }>, "groupBy" | ... 1 more ... | "lim...' is not assignable to type 'string | SQL<unknown> | null | undefined'.
  Type 'Omit<PgSelectBase<"discord_bots", { id: PgColumn<{ name: "id"; tableName: "discord_bots"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: undefined; baseColumn: never; }, {}, {}>; }, ... 5 more ..., { ...; }>, "groupBy" | ... 1 more ... | "lim...' is missing the following properties from type 'SQL<unknown>': queryChunks, shouldInlineParams, append, toQuery, and 5 more.ts(2322)

Type 'Omit<PgSelectBase<"discord_bots", { id: PgColumn<{ name: "id"; tableName: "discord_bots"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: undefined; baseColumn: never; }, {}, {}>; }, ... 5 more ..., { ...; }>, "groupBy" | ... 1 more ... | "lim...' is not assignable to type 'string | SQL<unknown> | null | undefined'.
  Type 'Omit<PgSelectBase<"discord_bots", { id: PgColumn<{ name: "id"; tableName: "discord_bots"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; enumValues: undefined; baseColumn: never; }, {}, {}>; }, ... 5 more ..., { ...; }>, "groupBy" | ... 1 more ... | "lim...' is missing the following properties from type 'SQL<unknown>': queryChunks, shouldInlineParams, append, toQuery, and 5 more.ts(2322)

1 replies

DTDrizzle Team

•Created by neoney on 1/14/2024 in #help

Select where one->many relation has at least one matching a condition

I'm having a hard time wrapping my head around Drizzle, coming from Prisma. I'm trying to do something like this:

const games = await prisma.db.game.findMany({
    where: {
      products: {
        some: {
          hidden: false,
        },
      },
    },
    select: {
      id: true,
      name: true,
    },
  });

const games = await prisma.db.game.findMany({
    where: {
      products: {
        some: {
          hidden: false,
        },
      },
    },
    select: {
      id: true,
      name: true,
    },
  });

I can't seem to figure out how to do this in Drizzle. Could anyone give me some directions on getting it done? Thanks

26 replies

Gaming

Programming