Prisma #orm-help

Join Slack Communities

Iwamoto Yuki

12/13/2021, 1:53 AM

As a senior full-stack web and blockchain dev, I have rich experience.

👍 1

🤣 1

😆 1

👋 2

12/13/2021, 4:18 AM

Is there anyway to mock Prisma easily without jest…

12/13/2021, 4:18 AM

I am finding it very cumbersome to have to write a fake client almost to mock Prisma

Haru Hinata

12/13/2021, 4:47 AM

I am a senior full-stack and blockchain developer

Haru Hinata

12/13/2021, 4:47 AM

I am looking for a new job

Haru Hinata

12/13/2021, 4:47 AM

if you are interested in me, please contact me

Haru Hinata

12/13/2021, 4:47 AM

I will share my resume

Γιώργος Κραχτόπουλος

12/13/2021, 5:30 AM

How to force Prisma Client to generate

string

instead of

number

for

Int

attributes with

@id?

Martí Crespí

12/13/2021, 5:57 AM

Hi! How do you manage your connection pool and connection timeout? I'm having some issues using Postgresql+NestJS+Prismav3.5.0! For start to fix this issue, I have removed all my $connects and $disconnects onModuleDestroy and onModuleInit functions on my services (lazy connection). Should I try something more? I have modified the connectionString to increase both parameters, but I want to know how you configure them to work properly. Many thanks!

Γιώργος Κραχτόπουλος

12/13/2021, 6:07 AM

I have a GraphQL API that treats

id

fields, with the corresponding string GraphQL scalar

ID

type, but TypeScript throws error because the Client parses

@id

number

Thomas Minato

12/13/2021, 8:15 AM

Hi everyone, I'm a professional fullstack developer. If you interested work me, Pls DM to me!

😂 1

Ramu Narasinga

12/13/2021, 8:39 AM

Hi, does Prisma provide any API to implement linked list data structure to fetch, insert?

Levi

12/13/2021, 8:39 AM

sure

Fishie

12/13/2021, 9:36 AM

how can i return the array of id only?

Fishie

12/13/2021, 9:37 AM

how can i target 1 field of a model and get it as a string array?

Gopesh Jangid

12/13/2021, 10:48 AM

hey folks ! i am looking for a help i am trying to migrate from postgresql to ms sql in prisma

Gopesh Jangid

12/13/2021, 10:49 AM

for what data type prisma does support in case large text string in ms-sql ?

Gopesh Jangid

12/13/2021, 10:50 AM

as prisma support nvarchar(1000) , what about more than this...which data type can i use and for what lenght

P V

12/13/2021, 2:02 PM

hello fellows, someone knows hows the best way to filter integers like "contains" for strings?

user

12/13/2021, 3:56 PM

Migrating a live Prisma project from MySQL to PlanetScale

https://www.youtube.com/watch?v=B0nrosAyN3w▾

In this live stream, Daniel from the Prisma team will be joined by Taylor Barnett from the PlanetScale team to migrate a live Prisma project deployed to Vercel with MySQL on AWS RDS to PlanetScale using the PlanetScale import service.

Tyler Clendenin

12/13/2021, 4:25 PM

does Prisma offer any way to aggregate JSON values without having to write the query oneself?

Chris Bitoy

12/13/2021, 4:55 PM

Yes - https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#aggregate

Tyler Clendenin

12/13/2021, 5:09 PM

hrm, when I do that I don't see any method of describing the JSON values I want to aggregate

Tyler Clendenin

12/13/2021, 5:13 PM

second question, I believe the answer is no, but is there any way to do a groupBy in an includes?

Γιώργος Κραχτόπουλος

12/13/2021, 5:38 PM

Where can I find Prisma generated

model

types, that also have their relations attached?

user

12/13/2021, 5:40 PM

How Panther champions talent over geography with Prisma Panther fully leverages Prisma and a cutting edge tech stack to power a domain-driven architecture that allows its developers to build and maintain seamlessly a complex platform with multiple services. This allows Panther to ensure that its customers can automate global payroll and compliance for their remote teams with one click.

user

12/13/2021, 6:18 PM

📚 Best Prisma Courses (Part 1) #shorts

https://www.youtube.com/watch?v=Xhu8wcAC3Wk▾

📚 Trying to learn something new? Here are some of the top courses that we recommend checking out! ✏️ #shorts #learning #courses

user

12/13/2021, 6:21 PM

📚 Best Prisma Courses (Part 2)

https://www.youtube.com/watch?v=_hao_80NUT0▾

📚 Trying to learn something new? Here are some of the top courses that we recommend checking out! ✏️ #shorts #learning #courses

Mo El

12/14/2021, 1:27 AM

How to create a column with default value

NULL

mooy bot

12/14/2021, 6:06 AM

Copy code

async buyPlayer(ownerId: string): Promise<void> {
    const previousTeam = await this.prismaService.team.findFirst({
      where: {
        ownerId,
      },
      include: {
        players: true,
      },
    })
    await this.prismaService.team.update({
      where: {
        ownerId,
      },
      data: {
        players: [...previousTeam.players],
      },
    })
  }