3 replies

Subqueries with INSERT - errors

I'm trying to create an insert that uses a subquery

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

Getting type errors on orgId, seems its not detecting correct type of sq.id

If I explicitly set sq.id to a number, no more errors

Still need to queries though....

Drizzle Team•3y ago•

3 replies

McPizza

Subqueries with INSERT - errors

I'm trying to create an insert that uses a subquery

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

Getting type errors on orgId, seems its not detecting correct type of sq.id

If I explicitly set sq.id to a number, no more errors

Still need to queries though....

Subqueries with INSERT - errors

Similar Threads

Subqueries with INSERT - errors

Similar Threads

Similar Threads

Similar Threads