Drizzle TeamDT
Drizzle Team•3y ago
Jim

TypeError when adding subquery to `drizzle.insert.values`

Hey all, I'm a bit new to drizzle so not sure if this is even possible or if I'm just doing something wrong. I'm getting type errors when using a subquery to select for companyId based on a company name:

    return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: db  // using subquery
      .select({ id: company.id })
      .from(company)
      .where(eq(
        company.name,
        userCompany
        )),
    typeId: widgetTypeId,
    slug: generateSlug(),
  });


but this checks out ok:

  return await db.insert(widgetItem).values({
    name: "New Widget",
    companyId: BigInt(2),  // hardcoded
    typeId: widgetTypeId,
    slug: generateSlug(),
  });


wondering if this is possible or will I have to send multiple queries?

Cheers
Was this page helpful?