Prisma query multiple tables

.traevelliath · 2023-06-14T14:06:52.595Z

So, I have 3 tables that need to be queried. Their schema are very much alike, underlined fields are basically shared between them. I need to 'join' them, I guess, and do a pagination based on timestamp. How would I go about doing this?

D

Diogo•6/14/23, 2:21 PM

const user = await prisma.user.findFirst({
  include: {
    widthdraws: true,
  },
})

const user = await prisma.user.findFirst({
  include: {
    widthdraws: true,
  },
})

const user = await prisma.user.findFirst({
  include: {
    widthdraws: true,
  },
})

const user = await prisma.user.findFirst({
  include: {
    widthdraws: true,
  },
})

D

Diogo•6/14/23, 2:21 PM

something like this

D

Diogo•6/14/23, 2:21 PM

you want to read this https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries

Prisma

Relation queries (Concepts)

Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters.

DDiogo ```ts const user = await prisma.user.findFirst({ include: { widthdraws: tr...

.

.traevelliathOP•6/14/23, 3:15 PM

yeah, it's almost what I was looking for. Unfortunately, I wasn't able to come up with a query that would let me implement pagination, so I wound up using prisma.$queryRaw and writing some SQL.

Thanks anyway.

..traevelliath yeah, it's almost what I was looking for. Unfortunately, I wasn't able to come u...

B

Brendonovich•6/14/23, 3:58 PM

Can you provide some more details? I'm pretty sure what you're asking for can be done

BBrendonovich Can you provide some more details? I'm pretty sure what you're asking for can be...

.

.traevelliathOP•6/14/23, 4:17 PM

Okay, so: I have 3 tables with exact same schemas as per screenshot: Withdraw, Topup, Profit. I need to query them all 3 together, where userId matches with userId from current session and get rows ordered by 'createdAt'.
Like this:

return await ctx.prisma.profit.findMany({
                take   : 5,
                where  : {
                    userId: id
                },
                orderBy: {
                    createdAt: 'desc'
                }
            });

return await ctx.prisma.profit.findMany({
                take   : 5,
                where  : {
                    userId: id
                },
                orderBy: {
                    createdAt: 'desc'
                }
            });

return await ctx.prisma.profit.findMany({
                take   : 5,
                where  : {
                    userId: id
                },
                orderBy: {
                    createdAt: 'desc'
                }
            });

return await ctx.prisma.profit.findMany({
                take   : 5,
                where  : {
                    userId: id
                },
                orderBy: {
                    createdAt: 'desc'
                }
            });

Similar Threads

Similar Threads

Similar Threads