Varna Comments - Answer Overflow

Varna

Explore posts from servers

NNuxt CDCloudflare Developers DTDrizzle Team

•Created by Varna on 7/23/2024 in #help

Counting many-to-many items

I ended up doing this:

  const items = await db
    .select({
      ...getTableColumns(A),
      B: count(AB.B),
      C: count(AC.C)
    })
    .from(A)
    .orderBy(A.name)
    .leftJoin(AB, eq(AB.A, A.id))
    .leftJoin(AC, eq(AC.A, C.id))
    .groupBy(A.id)

  const items = await db
    .select({
      ...getTableColumns(A),
      B: count(AB.B),
      C: count(AC.C)
    })
    .from(A)
    .orderBy(A.name)
    .leftJoin(AB, eq(AB.A, A.id))
    .leftJoin(AC, eq(AC.A, C.id))
    .groupBy(A.id)

4 replies

DTDrizzle Team

•Created by Varna on 7/23/2024 in #help

Counting many-to-many items

I'm migrating from this Prisma query:

  return prisma.A.findMany({
    include: {
      _count: {
        select: {
          B: true,
          C: true
        }
      }
    }
  })

  return prisma.A.findMany({
    include: {
      _count: {
        select: {
          B: true,
          C: true
        }
      }
    }
  })

4 replies

DTDrizzle Team

•Created by Varna on 4/16/2024 in #help

text mode json for sqlite Dq doesn't parse by default

I tried saving and removing data in both ways: JSON and JSON.stringify

3 replies

DTDrizzle Team

•Created by Varna on 4/16/2024 in #help

text mode json for sqlite Dq doesn't parse by default

support:dev:  ⨯ SyntaxError: "undefined" is not valid JSON
support:dev:     at JSON.parse (<anonymous>)
support:dev:     at Proxy.mapFromDriverValue (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:1641:21)
support:dev:     at mapRelationalRow (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:2312:75)
support:dev:     at /Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:4524:392
support:dev:     at Array.map (<anonymous>)
support:dev:     at D1PreparedQuery.customResultMapper (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:4524:34)
support:dev:     at D1PreparedQuery.mapAllResult (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:5188:25)
support:dev:     at D1PreparedQuery.all (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:5178:21)
support:dev:     at async Page (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/[root of the server]__68b133._.js:677:20)

support:dev:  ⨯ SyntaxError: "undefined" is not valid JSON
support:dev:     at JSON.parse (<anonymous>)
support:dev:     at Proxy.mapFromDriverValue (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:1641:21)
support:dev:     at mapRelationalRow (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:2312:75)
support:dev:     at /Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:4524:392
support:dev:     at Array.map (<anonymous>)
support:dev:     at D1PreparedQuery.customResultMapper (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:4524:34)
support:dev:     at D1PreparedQuery.mapAllResult (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:5188:25)
support:dev:     at D1PreparedQuery.all (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/01594_drizzle-orm_ee7e20._.js:5178:21)
support:dev:     at async Page (/Users/varna/Code/Farmis/cloudflare/apps/support/.next/server/edge/chunks/ssr/[root of the server]__68b133._.js:677:20)

3 replies

Gaming

Programming