prisma-client-js | safe database client for TypeScript & Node.js ( ORM | Database library

One of my schema.prisma's file is wrote like this:

Could anyone suggest how to go about creating a nested resolver to show an array of objects that are held in a parent object through graphql.

In this case, my schema.prisma file has two models GiftCard and Transaction where each GiftCard has a ledger (array of transactions):

I am using Prisma version 3.8.1. Prisma client does not mark the User.oauthData property as nullable in TS. Can someone help? Prisma schema and generated SQL files below:

I'm attempting to populate a postgresql db based off of a remote Api's response every xx min.

The script would be calling the Api on a determined interval, iterating over the response from the Api, upserting the data into the database for the relevant record.

This is the code that I've been starting with just to try to get the where statement functioning.

I am creating a basic crud api with nodejs and prisma. My Schema is as follows:

I'm having an issue with running Prisma in my project. Running npx prisma generate works, but then running my app I get:

I've setup my Nextjs (Next12) with NextAuth CredentialsProvider and use Prisma Adapter to persist user's session in the database.

I followed this documentation here from NextAuth team themselves. But nothing happen after I clicked on login button.

Before that:-

• I've make sure to try get the data first from the database & it works just fine.
• I did also did try to just use the normal session: { jwt: true, maxAge: 30 * 24 * 60 * 60 } instead of straight away use Adapter. Also works fine.

Now, I just want to know whether it's possible or not to use CredentialsProvider with Adapter at all?

Below are 2 examples or working one and not working one: /pages/api/auth/[...nextauth].js

• working: does not use adapter

I have a Prisma client connected to a local MySQL database inside of an express server. The server and database work fine at first and the typings are also correct. But:

After running npx prisma migrate dev or npx prisma generate, nothing works anymore.

It always throws connect ECONNREFUSED ::1:50898 when performing any request

The only workaround that kind of works is creating the same exact schema again, but on another node project, doing prisma generate and then copying the generated ".prisma" folder inside of my node_modules.

The error comes up on my localhost MySQL DB, but also when connected to a PrismaCloud Postgres DB.

It is really annoying to me because I really likee Prisma, but with this issue I can't really use it productively.

I am using a global prisma client for my server like this:

I'm building a Nuxt-electron-prisma app and I kinda stuck here. when I use prisma normally as guided every thing is fine on dev but on build i get this error :