#AskPrisma I have read the doc where postgres support table inheritance, now I dont know how do we do it in prisma schema??

Hey, we’re moving some of our stack to use AWS Lambda’s and are sometimes seeing this error

Timed out fetching a new connection from the connection pool

. I have a couple of q’s around this: • Is this error only thrown when prisma client tries to get a connection from the pool to run a query? Or is also thrown when the DB has reached it’s max connection limit and the prisma client isn’t able to reserve connections to create a connection pool? • If it’s only thrown in the first case, what could be the possible reasons for it to be thrown when all queries are executed sequentially and connection pool size is 5? • We get a prisma client by doing ->

const getClient = async () => {
// get connection string stored in AWS parameter store
  return new PrismaClient()
}

And then we call

getClient

in our handler. So basically anytime a handler is called a new prisma client is initialised. What does this mean in terms of the connection pool? Will prisma create a new pool every time we do

new PrismaClient()

?

Hey guys, do you know what piece of code is responsible for programatically restarting the typescript server after generating the prisma client?

Hey all, do you know if there's a way to specify comments on types/fields to be mapped to database comments? Seems like that doesn't exist but just in case

Hey, I am trying to use the json filtering with nodejs, but it is not giving me back what i expect. I have this json in column

values

{
  "test": 10
}

and i trying to grab it this way:

const entries = await this.prismaClient.accountEntity.findMany({
      where: {
        values: {
          path: ["test"],
          gt: 5,
        },
      },
    });

but it doesn't return anything. I would expect it to return all rows above 5. I have the following preview features:

previewFeatures = ["orderByRelation", "filterJson"]

I have tried to upgrade to version 2.25.0 but still no luck. Please let me know if im doing anything wrong

I have a table

Purchases

like this:

id product price date
1  1       10    2014-01-01
2  1       20    2014-02-17
3  1        5    2014-03-28
4  2       25    2014-01-05
5  2       12    2014-02-08
6  2       30    2014-03-12

And I want to get a result that contains only the record/row that has the max date, by

product

. Thus I want to get a result that is like this:

product price date
1        5    2014-03-28
2       30    2014-03-12

(because above for

product

id 1 the most recent date is 2014-03-23 and for

product

2 the most recent date is 2014-03-12. Could anyone help me with constructing a query in Prisma to do this (is it even possible?). I assume I'll be issuing a

groupBy

? Thank you.

Is there a way to update Prisma model by adding new rows in the model(database) after a user request?

HELLO PLEASE, how can I make a unit test with Prisma on nestjs project?

Does anyone know how I can configure certain model fields to be certain types with prisma introspect? I have a MySQL TINYINT(1) being converted to a Boolean when I need it as an Int.

Hey guys, does anyone know if it's possible to easily migrate an Implicit many to many relations table to an explicit many to many relation ?

Hi there, we’re using prisma migrate to manage our Postgres Schema. The prisma client is used for a part of our architecture - another part accesses the db through other tools. Is there a way to configure triggers through prisma schema? The first thing we have problems with is the updatedAt which only gets updated through the prisma client as it doesn’t use a trigger but a timestamp from the client. If not - is it something on the roadmap?

Hello! I didn't found solution before so I will ask for help. I'm trying to dockerize my backend app. I'm doing everything right to generate and aplly migrations to database but when I do "npm run start" command to initialize my backend, it's return this error

Error: @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again.

I already made "prisma generate" command successfully in my dockerfile. How I can solve this? Thanks

Hello guys, wanted to ask about cascading deletes: There are 4 ways to handle it with prisma2 as I see: 1. Manually set it up in the db. 2. Use plugin like this: https://paljs.com/plugins/delete/. But it’s slower I suppose. 3. Implement cascading deletes functionality in the resolvers. 4. Also I thought about creating a migration without applying it with

prisma migrate dev --createOnly

than manually modify it to set cascading deletes, kind of like the variant #1 but that way I save it and can apply later to any db (test, staging, prod, etc) Can you please suggest what would be the optimal solution ? Thank you.

Hey all!, is there a way to generate a

.graphql

file out of the schema, similar to what you got from Prisma 1? Also, is it possible (and somewhat recommended) to expose Prisma directly to the frontend (handling permissions and whatnot ofc)?

Is there a findOrCreate() function in prisma?

How can i add something only if it does not already exist?

error: Invalid

prisma.person.findUnique()

invocation

Invalid `prisma.person.findUnique()` invocation:

{
  where: {
    PKPersonID: {
      PKPersonID: 7
    }
    ~~~~~~~~~~~~~~~

I have two functions that are nearly identical. One fails with the above error, the other works fine. This works:

personByID(id: any) {
    const personID = this.prisma.person.findUnique({
      where: {
        PKPersonID: id
      },
      include: defaultIncludeQuery
    })
    return personID;
  }

This gives an error:

personWContacts(id: any) {
    const personContacts = this.prisma.person.findUnique({
      where: { PKPersonID: id },
      include: contactsIncludeQuery
    })
    return personContacts;
  }

I can switch the includes but the error remains with the personWContacts function.

To provide more information: The controller has these 2 functions which calls, the above functions in the service

@Get(`${Route}/:id`)
  byId(@Param('id', ParseIntPipe) PKPersonID: number) {
    return this.personService.person({
      PKPersonID,
    });
  }

  @Get(`${Route}/contacts/:id`)
  contacts(@Param('id', ParseIntPipe) PKPersonID: number) {
    return this.personService.personWContacts({
      PKPersonID,
    });
  }

You are calling the service functions passing an object but you expect a single value

id

🤔

No reason to fail a part from

include

params

Yes... ugh! Took a long time to see this. Thanks!

Hello, do we have a Nexus channel?

_sum return "null" if no rows is found. How can i make it return 0 instead?

Hi people. How do I separate the models I have. From the docs it seems they are all state within one file and I have 20 tables. Is there a util function to call them as one?

can i include fields from a relation in a groupBy() query somehow?

I have a table with a userId and needs to include username residing in the user model.

Is it possible to autofill table name from variable from model in a raw query?

Does somebody know why these tests only fail sometimes if some tests have been executed before them: https://github.com/tom-richter/prisma-jest-example There is a problem with the seeding in the beforeEach function. After all tests have been run I can see that the data from each of the three tests is in the database. However the db should have been cleared before each test. Run the commands in the Readme.md to reproduce the example. The tests are green if run individually but red if run together. This issue remains the same even if I run the tests it in sequential mode with -i.

How to rewrite that query to prisma?

const qb: QueryBuilder<UserModel> = (orm.em.fork() as any).createQueryBuilder(UserModel, 'user');

      const result: Array<{ id: number; username: string; value: number }> = await orm.em
        .fork()
        .getConnection()
        .execute(
          qb
            .select(['user.id', 'user.username'])
            .where({ username: { $nin: ignored } })
            .join('user.tips', 'tips')
            .addSelect('COALESCE(SUM("tips"."inMainCurrencyAmount"), 0) as "value"')
            .offset(offset)
            .limit(limit)
            .groupBy('id')
            .getKnexQuery()
            .orderBy('value', 'desc')
            .toQuery(),
        );

Google Cloud