Why can't I get the

@relation

object type appear in the editor (VS Code), when using TypeScript and the query has

include: { user: true }

...? It will work on the actual app when running it, but the editor doesn't realize the type should be there.

Hey folks, https://www.prisma.io/docs/ isn't working.

I'm genuinely beyond lost; I've checked out the docs and just can't figure out how to work with Json object arrays. This is my model (postgresql):

model FishInventory {
  id            String @id @unique
  fishInventory User?  @relation(fields: [id], references: [id], onDelete: Cascade)
  fish          Json
}

This is the data structure in the database:

[{"name": "bass", "amount": 1}, {"name": "salmon", "amount": 1}]

This is something I've tried as shown on the docs:

const user = await prisma.fishInventory.findFirst({
   where: {
      id: "10",
      fish: {
         path: ["name"],
         equals: "bass"
      },
   },
})

That returns null ^, not quite sure why. If someone could show me how I am able to fully manipulate that data (adding, updating, and removing particular objects by "name" from that array and also being able to change the "amount"), that would be a massive help. I've been trying various methods for hours now and just can't figure it out!

👋 Hi everyone! I've been working on a CLI tool (releasing tomorrow) that allows merging of multiple schema files and I was wondering if you'd be interesting in generating schema files from your code! I know, it sounds like an alien concept, but basically create schema files using a JavaScript (and TypeScript for that matter) API that get ran before you use any Prisma commands. Please let me know if this is a feature that you'd personally use, so I can look into improving the CLI.

Hey, I understand that prisma client does not support triggers. Does that also mean that manually adding triggers to a database would negatively affect the prisma client, or we can manually add our own triggers?

Hello, it is my first time using Prisma on a prototype project. I am developing my API server with Node.js Express and Prisma with MySQL. I am done with my local development. Now I am deploying my project on cPanel web hosting as Node.js application for further development and testing. Database migration is done. Server is running. Now the only problem is an error all my REST endpoints are returning:

Unable to load Node-API Library from /home/tobakz13/surapi/src/generated/client/libquery_engine-debian-openssl-1.1.x.so.node, Library may be corrupt.

I am looking for some pointers on how to solve this problem as I am not a server knowhow or prisma expert yet. My standard google research left me with no success. I thank you all in advance and have a nice weekend.

Does anyone have a clue why prisma studio is complaining about invalid JSON? I used JSON.stringify to convert a created object from prisma, and it complains about "Value must be a valid Json" in prisma studio

Hello Getting this error using a Gist index I thought they where supported since version 4? Any ideas how to overcome this?

Hello, I have a table and I want to make updatedBy and createdBy a one to many relationship with the user table.

model AssetCollection {
  id          Int        @id @default(autoincrement())
  department  String?    @db.VarChar(50)
  reviewed    String?    @db.VarChar(50)
  createdAt   DateTime   @default(now())
  updatedAt   DateTime   @updatedAt
  createdBy   Int        
  updatedBy   Int       
  locationId  String
  caseBarcode String
  prep        Int
  assetCount  Int
  currStatus  String?
  bayLocation String?
  assetEquip  AssetEquip @relation(fields: [caseBarcode], references: [barId], onDelete: Cascade)
  location    Location   @relation(fields: [locationId], references: [locNum], onDelete: Cascade)
  assetPrep   AssetPrep  @relation(fields: [prep], references: [id], onDelete: Cascade)
}

Hi everyone! Quick update on the utility CLI: I've been working on releasing it on NPM and it's scheduled to release tomorrow at 19:30 UTC. I've also prepared a proposal there so you can vote on the new implementation of code generated schemas for Prisma. I'll post an update in #showcase with the download link and the link to the proposal once the package goes live.

Hello everyone, is there a good place to discuss writing a connector for a new database? specifically looking to implement one for firestore

does prisma do any sort of comparison checks for

.update

? meaning, if value is the same, does it still run the query?

Hey, y'all 👋 A quick question, though it's not directly linked to Prisma. I'm trying to wrap a REST API with GraphQl, I'm using Graphql Yoga. So I have an endpoint

/ideas

that returns a response that looks like this:

{
  "status": true,
  "message": "All ideas",
  "data": [
    {
      "id": 57,
      "title": "a demo title",
      "description": "a demo description",
      "creatorId": "0xF95f8038Eb7874Cde88A0A9a8270fcC94f5C226e",
      "votecount": 1,
    },
    {
      "id": 23,
      "title": "a demo title",
      "description": "a demo description",
      "creatorId": "0xF95f8038Eb7874Cde88A0A9a8270fcC94f5C226e",
      "votecount": 8,
    },
  ]
}

I want to implement a filter for the votecount field for a value greater than a given value. Can anyone please help here?

👋 Hi everyone! I've got a new feature idea for the Prisma CLI I've been talking about and I was wondering if you would be interested in it: loading

DATABASE_URL

from another source rather than the

.env

file (like a YAML file). Let me know if this is something you'd like to see!

Quick question. When creating/updating/removing records, should you make a query before to check if the record already exists, or should that be handled with error codes in catch?

Hi all. I'm fairly new to everything in general. Trying to write a resolver for this query (using Graphql and Nestjs with Prisma) to filter through

gigs

. I want the entire

OR

part to run only if the

filter

argument has been passed to this query since right now, executing the query without any arguments does not list all the

gigs

. I know it must be a trivial thing, but I'm stuck at it since quite a while. Help please!

@Query()

async gigs(

@Args('title') title: string,

@Args('published') published: boolean,

@Args('filter') filter: string,

): Promise<Gig[]> {

return this.gigService.gigs({

where: {

title: title,

published: published,

OR: [

{ title: { contains: filter, mode: 'insensitive' } },

{ description: { contains: filter, mode: 'insensitive' } },

],

},

});

}

Hi people! Just a quick reminder that the utility CLI I've talked about is releasing in 1 hour, along with a proposal for code-generated schemas and a proposal for loading data using other sources (such as YAML). I'll provide the links in #showcase when it's ready to be used!

I am a little behind on the multi-schema stuff that has been announced in preview, but can it generate the prisma schema file from an existing db?

Hi All. I’m new around here hand have question. When I look at my types i see, for example, types like this - PassUncheckedUpdateInput, PassUpdateInput. What is the use case for the two of these. i.e what is an “unchecked” input?

Hey y'all. I'm new to prisma and looking to spin up a project management app using nextjs. I'm hoping to get some advice in a DB service that works well with prisma? I'm seeing a ton of options. Planetscale? Heroku? Render? Supabase?

hi, I have a bigInt field and it keeps getting appended with an 'n'... It's an integer, so Im not sure how this is even possible. Any good explanation?

The

n

represents it's being cast to a

BigInt

Noticed a bug with Prisma throwing errors. Reported here: https://github.com/prisma/prisma/issues/15180 Critical to be addressed since these are breaking the way we used to catch errors

hey, I am new to slack. is this the right channel for help?

Christ almighty

This is frustrating

I am following the Prisma query structure perfectly

`Did you mean

is

?`

Yes, I meant

is

- proceeds to add

is

and then get `Unknown arg

is

in where.OR.0.Auction.is for type AuctionWhereInput.`

I can record a video