Arthur Danjou 🧸 Posts - Answer Overflow

Arthur Danjou 🧸

Explore posts from servers

•Created by Arthur Danjou 🧸 on 4/17/2024 in #help

Migration from prisma to Drizzle

Hello, i'm migrating from prisma to drizzle in my nuxt 3 app. I have some issues migrating this file:

export default defineEventHandler(async (event) => {
  const { favorite, category } = getQuery(event)
  const prisma = usePrisma()

  let whereClause: any

  if (favorite === 'true') {
    category === 'all'
      ? whereClause = {
        favorite: true,
        categories: { every: { category: {} } },
      }
      : whereClause = {
        favorite: true,
        categories: { some: { category: { slug: category } } },
      }
  }
  else {
    category === 'all'
      ? whereClause = {
        categories: { every: { category: {} } },
      }
      : whereClause = {
        categories: { some: { category: { slug: category } } },
      }
  }

  return await prisma.talent.findMany({
    where: whereClause,
    orderBy: {
      name: 'asc',
    },
    include: {
      categories: {
        include: {
          category: true,
        },
        orderBy: {
          category: {
            name: 'asc',
          },
        },
      },
    },
  })
})

export default defineEventHandler(async (event) => {
  const { favorite, category } = getQuery(event)
  const prisma = usePrisma()

  let whereClause: any

  if (favorite === 'true') {
    category === 'all'
      ? whereClause = {
        favorite: true,
        categories: { every: { category: {} } },
      }
      : whereClause = {
        favorite: true,
        categories: { some: { category: { slug: category } } },
      }
  }
  else {
    category === 'all'
      ? whereClause = {
        categories: { every: { category: {} } },
      }
      : whereClause = {
        categories: { some: { category: { slug: category } } },
      }
  }

  return await prisma.talent.findMany({
    where: whereClause,
    orderBy: {
      name: 'asc',
    },
    include: {
      categories: {
        include: {
          category: true,
        },
        orderBy: {
          category: {
            name: 'asc',
          },
        },
      },
    },
  })
})

. Can you help me ? You can find my code here : https://github.com/arthurDanjou/website-v2/tree/drizzle and my schema here : https://github.com/ArthurDanjou/website-v2/blob/drizzle/server/database/schema.ts

6 replies

Gaming

Programming