const conn = await pool.connect();

await conn.query("BEGIN");
const userRes = await conn.query("SELECT coins, ... , ... FROM "User" WHERE "id" = 'someId'" FOR UPDATE);

...

await conn.query("COMMIT");

Error: Error serializing `.urls[0].createdAt` returned from `getServerSideProps` in "/urls".
Reason: `object` ("[object Date]") cannot be serialized as JSON. Please only return JSON serializable data types.

warn(prisma-client) Already 10 Prisma Clients are actively running.

//lib/prisma-client.ts
import { PrismaClient } from "@prisma/client"

const prisma = new PrismaClient()
export default prisma

disconnect

// Console log

node[21175]: ../src/node_http_parser.cc:567:static void node::{anonymous}::Parser::Initialize(const v8::FunctionCallbackInfo<v8::Value>&): Assertion `args[3]->IsInt32()' failed.
 1: 0x562789d0ab61 node::Abort() [node]
 2: 0x562789d0abf7  [node]
 3: 0x562789d26945  [node]
 4: 0x562789f4ca37 v8::internal::FunctionCallbackArguments::Call(v8::internal::CallHandlerInfo) [node]
 5: 0x562789f4d869  [node]
 6: 0x562789f4de3f  [node]
 7: 0x562789f4e0e6 v8::internal::Builtin_HandleApiCall(int, unsigned long*, v8::internal::Isolate*) [node]
 8: 0x56278a79d539  [node]
zsh: abort (core dumped)  npm run dev
The code is sample from the website, for nextjs.
import {  PrismaClient } from "@prisma/client";
import { NextApiHandler, NextApiRequest, NextApiResponse } from "next";

// The code:

const prisma = new PrismaClient()
           
async function main(){
  
    const user = await prisma.user.create({
        data:{
            name: "test",
            email: "<mailto:test@gmail.com|test@gmail.com>"
        }
    })
    console.log(user)
  
    prisma.$disconnect()
}


export default async (req: NextApiRequest, res: NextApiResponse, next: NextApiHandler)=>{
    
   
    switch (req.method){
        case 'POST':{

            
            try{
                await main().catch(err=>console.log(err)).finally(async()=>{
                    res.send("ok")
                  
                  })
            }   
            catch(err){
               
            }
         
          
        
          
        }
        case 'GET':{

        }
    }
}

Prisma Studio is up on <http://localhost:5555>
node[6740]: ../src/node_http_parser.cc:567:static void node::{anonymous}::Parser::Initialize(const v8::FunctionCallbackInfo<v8::Value>&): Assertion `args[3]->IsInt32()' failed.

prisma.posts.findUnique_({......}).then().catch()

PATCH /post

prisma.post.update({ where: { id: params.id, user: { id: context.currentUser.id } }, ... })

Role.findOne({
	raw: true,
	where: {
		guild: this.guild.id,
		channel: message.channel.id,
		message: message.id,
		pairs: {
			[Op.contains]: [{ emoji }],
		},
	},
});
// Is this a thing in Prisma? "pairs" in an array of objects which has an emoji prop (along with other props)

model DamFiles {
  id                Bytes     @id @db.Binary(26)
  ...
  createdAt         DateTime  @default(now())
  updatedAt         DateTime? @updatedAt
  deletedAt         DateTime?

  // relations
  type   DamFileTypes     @relation(fields: [typeId], references: [id])
  typeId Bytes            @db.Binary(26)
  mime   DamFileMimeTypes @relation(fields: [mimeId], references: [id])
  mimeId Bytes            @db.Binary(26)
  user   User             @relation(fields: [userId], references: [id])
  userId Bytes            @db.Binary(26)

  DamImages      DamImages[]
  DamFileTags    DamFileTags[]
  DamImageColors DamImageColors[]
}

const query = await db.damFiles.findMany({
      where: {
        parentId: queryParams.parentId,
        deletedAt: null,
      },
      include: {
        user: {
        },
        mime: {
        },
        type: {
        },
        DamFileTags: {
        },
        DamImageColors: {
        },
        DamImages: {          
        },
      },
    })

const conn = await pool.connect();

await conn.query("BEGIN");
const userRes = await conn.query("SELECT coins, ... , ... FROM "User" WHERE "id" = 'someId'" FOR UPDATE);

...

await conn.query("COMMIT");

Query 1: SELECT * FROM `Schema1`.`Requests`

Query 2: SELECT * FROM `Schema2`.`Accounts`

While we're still killing the child processes, after the beforeExit hook has been executed, we're not killing the current process anymore, if there are other listeners on the signals, like SIGINT.

prisma.$use(async (params, next) => {
  if (
    whereActions.includes(params.action) &&
    params.model &&
    prisma[params.model].prototype.hasOwnProperty('tenantId')
  ) {
    params.args.where.tenantId = requestTenantId
  }
  const result = await next(params)
  return result
})

prisma[params.model].prototype.hasOwnProperty('tenantId')

include

*Error:* Failure during a migration command: Generic error. (error: The field .... on model .... already exists in this Datamodel. It is not possible to create it once more.)

const selectPublicFields = {...}

async findOne(
    { id, email }: { id?: number; email?: string },
    selectPrivateFields: { email?: boolean } = {}
  ) {
    return this.prisma.user.findUnique({
      select: {
        ...selectPrivateFields,
        ...selectPublicUserFields
      },
      where: { id, email },
    });
  }