Is anyone else experiencing a crazy high usage of memory whilst running jest tests with prisma?

Hey prisma team, first of thanks for the library. It is awesome. however I am wondering how to implement this specific count. Let's say a team has taskboards and each board has items. How would I go about getting the count of incomplete items for a single team

Hey! Big fan of PlanetScale here! 😍 Quick question. How does the flow look like when using Prisma and PlanetScale with different environments (development, staging, and production)? I'd appreciate if someone could give some insights because I don't see this that clear. I think with the new branch promotion feature, it would be possible to work with different environments on production (Production and Staging). However, I am not sure how this would work when copying Prisma data from development to Staging and Production.

Hello Prisma community. I am new in this Prisma World, but we love the product with our team. We are building a release management tool, in DevOps area where you can easily manage your versions and products if you are interested in contact me 👋 By the way thanks for the hard work to make Prisma live!

In Prisma client, with such schema, what would be best way to get just Posts[] by the user email?

Is there any workaround to sorting by

createdAt

when you are working with seeded data that was all created at the exact same time?

my model looks like

createdAt  DateTime  @default(now())

@default(now())

does not record a specific enough time in order for me to preserve order on seeded data

Getting an error: There are fewer columns in the INSERT statement than values specified in the VALUES clause. But the query calls for: [Title], [Description], [Icon], [Sidebar], [IsActive], [Sort] The query contains: {"Title":"New Item","Description":"","Icon":"pe-7s-refresh-2","Sidebar":"","IsActive":false,"Sort":"1"}

prisma:query SELECT 1                                                                                                                 
prisma:query SELECT [dbo].[Page].[ID], [dbo].[Page].[Title], [dbo].[Page].[Description], [dbo].[Page].[Icon], [dbo].[Page].[Sidebar], 
[dbo].[Page].[IsActive], [dbo].[Page].[Sort] FROM [dbo].[Page] WHERE 1=1                                                              
prisma:query SELECT 1                                                                                                                 
prisma:query SELECT [dbo].[MainSidebar].[ID], [dbo].[MainSidebar].[Main_Sidebar] FROM [dbo].[MainSidebar] WHERE 1=1                   
{"Title":"New Item","Description":"","Icon":"pe-7s-refresh-2","Sidebar":"","IsActive":false,"Sort":"1"}                               
prisma:query SELECT 1                                                                                                                 
prisma:info Begin transaction                                                                                                         
prisma:query BEGIN TRAN                                                                                                               
prisma:query                                                                                                                          
    INSERT INTO [dbo].[Page] (                                                                                                        
      [Title],                                                                                                                        
      [Description],                                                                                                                  
      [Icon],                                                                                                                         
      [Sidebar],                                                                                                                      
      [IsActive],                                                                                                                     
      [Sort]                                                                                                                          
    )                                                                                                                                 
    VALUES (                                                                                                                          
      DEFAULT,                                                                                                                        
      @P1,                                                                                                                            
      @P2,                                                                                                                            
      @P3,                                                                                                                            
      @P4,                                                                                                                            
      @P5,                                                                                                                            
      @P6                                                                                                                             
    );                                                                                                                                
prisma:info Rollback transaction                                                                                                      
prisma:query ROLLBACK                                                                                                                 
[Nest] 146544   - 10/22/2021, 5:40:42 PM   [ExceptionsHandler]                                                                        
Invalid `prisma.executeRaw()` invocation:                                                                                             
                                                                                                                                      
                                                                                                                                      
  Raw query failed. Code: `110`. Message: `There are fewer columns in the INSERT statement than values specified in the VALUES clause.
 The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.` +234239ms             
Error:                                                                                                                                
Invalid `prisma.executeRaw()` invocation:                                                                                             
                                                                                                                                      
                                                                                                                                      
  Raw query failed. Code: `110`. Message: `There are fewer columns in the INSERT statement than values specified in the VALUES clause.
 The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.`                       
    at cb (C:\Sites\AM-API-LMS\node_modules\@prisma\client\runtime\index.js:38537:17)                                                 
    at async Promise.all (index 0)                                                                                                    
    at async PageService.createPage (C:\Sites\AM-API-LMS\dist\Page\Page.service.js:73:30)                                             
    at async C:\Sites\AM-API-LMS\node_modules\@nestjs\core\router\router-execution-context.js:46:28                                   
    at async C:\Sites\AM-API-LMS\node_modules\@nestjs\core\router\router-proxy.js:9:17

schema:

model Page {
  ID                Int      @id @default(autoincrement()) 
  Title             String?  @db.NVarChar(255)
  Description       String?  @db.NText
  Icon              String?  @db.NVarChar(255)
  Sidebar           String?  @db.NText
  IsActive          Boolean?
  Sort              Int?
  // Assoc_Page_Tag    Assoc_Page_Tag[]
}

page.service.ts

async createPage(data: Prisma.PageCreateInput) {
    const payload = {
      ...data
    };
    console.log(JSON.stringify(data));
    const insert = this.prisma.$executeRaw`
    INSERT INTO [dbo].[Page] (
      [Title],
      [Description],
      [Icon],
      [Sidebar],
      [IsActive],
      [Sort]
    )
    VALUES (
      DEFAULT,
      ${payload.Title},
      ${payload.Description},
      ${payload.Icon},
      ${payload.Sidebar},
      ${payload.IsActive},
      ${payload.Sort}
    );`;


    const lastId = this.prisma.$queryRaw`
      SELECT  @@IDENTITY as id;
    `;

    const [, response] = await this.prisma.$transaction([insert, lastId]);

    return this.PagebyID({ id: response?.[0]?.id });
  }

Hello team. Are any investigation being made about this issue https://github.com/prisma/prisma/issues/9584 ? It makes the whole interactive transaction featurz unreliable for us.

JS Monthly #17: Lewis Prescott - Double up your component & integration tests with Supertest & Nock This talk builds on my course for Test Automation University (https://testautomationu.applitools.com/javascript-api-testing/) Using the power of mocking and the tool Nock. You can build component and integration tests with one set of scripts. I will show you how this is possible and also explain the difference between component and integration tests. In order to make your tests fast and build tests at the right level, use the power of mocking. The JS Monthly Meetup was organised by Aris Markogiannakis (JS Monthly host) and hosted by Prisma. ✨ Join the Prisma Meetup group here: https://www.meetup.com/js-monthly/ Follow Lewis: Twitter: https://twitter.com/WuigPrescott Next: 👉 Check Previous video: Heavily Connected Data Applications -

Hi everybody, I'm following a videocourse on udemy for GraphQL Prisma PosteGresql but in this course, they are using Prisma 1.01 that uses Docker, creates automatically GraphQL APIs, now i'm tryiing to replicate on latest version of prisma a backend with Apollo but the guide is completely different Can someone help me, please?

Prisma is always timing out whenever I run a

deploy

or

resolve

command . Please how can I resolve this, there's nothing in the docs on resolving this

hi, is the Prisma + MongoDB stable yet ?

Hi, im getting the following error - Cannot use GraphQLNonNull “UserWhereUniqueInput!” from another module or realm. when i try to run PRISMA GENERATE i have the following dependencies - “@apollo/gateway”: “^0.42.3”, “@aws-sdk/client-s3": “^3.38.0”, “@aws-sdk/node-http-handler”: “^3.38.0”, “@aws-sdk/s3-request-presigner”: “^3.38.0”, “@fixefy/fixefy-core”: “^1.9.19”, “@graphql-tools/schema”: “^8.3.0”, “@graphql-tools/utils”: “^8.5.0”, “apollo-server-core”: “^3.4.0”, “apollo-server-express”: “^3.4.0”, “apollo-server-types”: “^3.3.0”, “aws-sdk”: “^2.1013.0”, “cors”: “^2.8.5”, “date-fns”: “^2.25.0”, “dotenv”: “^10.0.0”, “dotenv-expand”: “^5.1.0”, “express”: “^4.17.1”, “got”: “^11.8.2”, “graphql”: “^15.6.1”, “graphql-cli”: “^4.1.0”, “graphql-import”: “1.0.2”, “md5": “^2.3.0”, “mongoose”: “^6.0.12”, “nodemon”: “2.0.14”, “pdf2json”: “^1.2.5”, “prisma-client-lib”: “^1.34.12”, “socket.io”: “^4.3.1”

Hi there, Does anyone know when PostgreSQL 14 will be supported? Any approximate dates from devs? Thanks!

Hello, when will the third part of the tutorial (https://www.prisma.io/blog/fullstack-nextjs-graphql-prisma-2-fwpc6ds155) be published? thank you

For postgres, can prisma use a schema different from public?

I’d like to create a health check endpoint if prisma is connected with my backend server(Nodejs or NestJS). Anyone has good idea on this?

Why does prisma need to connect to the db if it only needs to write migrations?

prisma migrate dev --create-only

The above command is only meant to create migrations but not execute them. It should NOT need to connect, For comparison, Django’s

makemigrations

can create the migrations without connecting to the database.

Anyone experienced the following issues whilst running jest tests?

(node:79018) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 beforeExit listeners added to [process]. Use emitter.setMaxListeners() to increase limit

(node:79018) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 exit listeners added to [process]. Use emitter.setMaxListeners() to increase limit

(node:79018) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 SIGUSR1 listeners added to [process]. Use emitter.setMaxListeners() to increase limit

Maybe a noob question, I'm very new to Primsa, but is there an abstract type or interface for all the schemas? Since each of them has it's own type after Prisma generates them

We have an issue with Connection Pool timout. We can’t figure out whats causing the connection pool limit to get filled up and exhaust the connection pool queue. This leads to connection pool timeouts. Tried to use the built in prisma logger but there is no way to log which query is failing when timeout is happening. Preferably there should be a query parameter in this errorobject.

}

meta: { connection_limit: 9 }

clientVersion: '2.29.1',

code: 'P2024',

at processTicksAndRejections (internal/process/task_queues.js:97:5) {

at runMicrotasks (<anonymous>)

at RequestHandler.request (/app/node_modules/@prisma/client/runtime/index.js:36744:15)

PrismaClientKnownRequestError3 [PrismaClientKnownRequestError]: Timed out fetching a new connection from the connection pool. (More info: <http://pris.ly/d/connection-pool>, Current connection limit: 9)

}

Hey guys it looks like our database connection was removed from Prisma cloud https://cloud.prisma.io/ and now when I try to re-add it I get this error:

I keep getting this error almost anytime I run

migrate resolve

or

migrate deploy

. Can anyone please help with this, it has slowed down my work. N.B: Postgres DB is hosted on Heroku

Edit: This issue is now resolved. There may be some data loss between the incident and its resolution as we have restored an earlier backup. If that is the case, feel free to re-create the projects or let us know by opening an issue in this repo. Thank you for your patience. ======== Hello there, we are currently encountering an issue in the Prisma Data Platform (cloud.prisma.io) where every project's Database is unlinked, thus making your projects unavailable. Our current plan of action is to restore an earlier backup to make sure that everything is functioning properly. We understand that this may have seriously disrupted your workflows so we deeply apologize for that. We will post another update once the incident is resolved. Thank you for your patience.

Anyone have any luck seeing DB transactions in NewRelic? Everything else is instrumented except my DB and Im not sure why

How fast is

findFirst

? Would it be faster to use two

findUnique

calls to prisma, utilizing the indexes? See example:

can i do a nested

connectOrCreate

from within an

upsert

query? i'm getting an error that prisma doesn't understand my args at the moment

@Jaye could you post the call you are trying to make?