I am using a package prisma offset pagination to apply pagin Prisma #orm-help

I am using a package prisma-offset-pagination to a...

Ibad Shaikh

09/18/2021, 8:51 PM

I am using a package prisma-offset-pagination to apply pagination. In this I have to use Prisma Model in my code , how is that possible:

const result = prismaOffsetPagination({

model: User, // How to access prisma model like in this example.
cursor: <cursor>,
size: 5,
buttonNum: 7,
orderBy: 'id',
orderDirection: 'desc',
where: {
email: {
contains: 'smallbee',
},
},
prisma: prisma,

});

Check Line:2

Jakub Hrášek

09/19/2021, 7:47 AM

did you tried

import { User } from '@prisma/client'

? See the code https://github.com/prisma-korea/prisma-offset-pagination/blob/master/src/paginator/pageEdge.ts#L77

Ibad Shaikh

09/20/2021, 9:15 AM

Didn't work.

Ibad Shaikh

09/20/2021, 1:59 PM

@Ryan 👋 Please guide.

Ryan

09/20/2021, 2:03 PM

Copy code

const result = prismaOffsetPagination({
    model: 'User', 
    cursor: <cursor>,
    size: 5,
    buttonNum: 7,
    orderBy: 'id',
    orderDirection: 'desc',
    where: {
      email: {
        contains: 'smallbee',
      },
    },
    prisma: prisma,
});

Ryan

09/20/2021, 2:03 PM

Try this.

Ibad Shaikh

09/20/2021, 2:11 PM

Already tried this in beginning but it failed. Throws an error : UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'toLowerCase' of undefined at prismaOffsetPagination

Ibad Shaikh

09/20/2021, 2:11 PM

Please check this: https://github.com/prisma-korea/prisma-offset-pagination/blob/master/src/paginator/pageEdge.ts#L77

Ryan

09/20/2021, 2:13 PM

Add User in quotes like this:

'User'

Ibad Shaikh

09/20/2021, 2:16 PM

const result = _prismaOffsetPagination_({ _model_:_ _'Post', _cursor_:_ _2, _size_:_ _5, _buttonNum_:_ _3, _orderBy_:_ _'id', _orderDirection_:_ _'desc', _ _}) I have used single quotes but no effect.

Ryan

09/20/2021, 2:30 PM

This works:

Copy code

const result = await prismaOffsetPagination({
    model: { name: 'Post' },
    size: 5,
    orderBy: 'id',
    orderDirection: 'desc',
    prisma,
  })

Ibad Shaikh

09/20/2021, 5:14 PM

Thanks @Ryan Atleast it worked without the error which it throws before. But as you know Im already stuck in the failure of prisma.post.count() query. Inside the code of prisma-offset-pagination ,the count() method is used multiple times. Ultimately it throws the error I already mentioned in the seperate thread : UnhandledPromiseRejectionWarning: Error: Invalid

prisma.post.aggregate()

invocation: Failed to validate the query:

Field does not exist on enclosing type.

Query.aggregatepost.AggregatePost._count

Ibad Shaikh

09/20/2021, 5:19 PM

I have submitted the issue of .count( ). The issue id is #9340

👍 1

Ibad Shaikh

09/24/2021, 11:20 PM

Hi, @Ryan 👋 Please update me on this issue.

Ryan

09/27/2021, 6:28 AM

It works fine for me with the above with count so this would be specific to your system. We will be looking into this.

6 Views

Open in Slack

Previous Next