Category "prisma"

Timestamp with timezone column in Prisma

I am evaluating Prisma and I am a complete noob... I am using Postgresql I have the following model definition model Sth { id Int @defau

Error connecting server to DigitalOcean Postgresql droplet

I am aware that I can connect to a pre-configured Digital Ocean PostgreSQL database cluster and that's what I'm actually connected to right now, but I'd like to

zod-prisma keeps getting stuck at the generation step

I just installed zod-prisma to try it out, but so far nothing is working. I attempted to run it on two separate projects, one has a small prisma and the other h

Is it possible to make a join query with Prisma without a foreign key?

I've been struggling with this for a while but with no success. I have two tables that might have a relation but not necessarily. FIRST +----+-----------+------

Is it possible to make a join query with Prisma without a foreign key?

I've been struggling with this for a while but with no success. I have two tables that might have a relation but not necessarily. FIRST +----+-----------+------

Prisma, update scalarList/array

I´m doing an Spotify clone and I´m trying to add a song to a playlist but my query doesn't work, until this point, everything was good following the

Orm or RAW sql which one is better?

I have a question about Orm or RAW sql Can you tell me which one I should choose if I want to create a large-scale project? And why?

TypeError: Cannot convert undefined or null to object in NextAuth

NextAuth.js automatically creates simple, unbranded authentication pages for handling Sign in, Sign out.So I created it like the document suggest.I created in s

Prisma: update nested entities in a single query

I am using Prisma and Express.js to make requests to my MySQL database table. I have one-to-many relationship between my Contest-Round tables and am trying to w

Return ENUM - Cannot return null for non-nullable field

I am using apollo-server-lambda, Prisma ORM and graphql-codegen. I have a query (getBookById) that returns a Book. Book contains an enum called BookStatus. I wa

How to inject a value via middleware into a graphql query body (prisma-typegraphql)?

I am currently using prisma-typegraphql for generating a schema and it's props. Problem: Is there a way to write a middleware that accesses a value from an arbi

Some Prisma Model @@map not generating

I have a few models in my schema.prisma file that are not generating with their @@map for use in the client. model ContentFilter { id Int

Prisma ORM Postgres SQL DB Schema Not Null Fields

Just so you have it here is my defined prisma schema. Now if I read correctly in the prisma docs it said, that every field in which I do not declare a ? after t

Filtering relations with 'include' and 'where'

I'm building a simple todo app where a user can have multiple lists and share them. Here is my Prisma Schema: model users { id String @

Prisma Satellite Data Projection Problem when exporting as .tiff in Python

I have Prisma Hyperspectral data. However I don't have software to open .he5. That's why I try to convert the data via Python. First of all, I share screenshots

How to resolve 'error - InvalidDatasourceError: Datasource URL should use prisma'

So I am using Prisma as an ORM on my project to communicate with the database that I set up with AWS. Not happy with the AWS service I am now switching my datab

How to resolve 'error - InvalidDatasourceError: Datasource URL should use prisma'

So I am using Prisma as an ORM on my project to communicate with the database that I set up with AWS. Not happy with the AWS service I am now switching my datab

Using React-Hook Form, How do I post data to my MongoDB in React Native

I am facing an issue where Im trying to post data to my mongoDB from the frontend using React Hooks on React Native. The problem is that Im struggling to get th

"Authentication failed for user" when running prisma db pull on a SQL Server database

I am trying to import a SQL Server database into prisma using to prisma db pull command. I created a new DB user with proper rights (that I can log in to SQL Se

Prisma schema - Create a relation field from multiple possible foreign keys (OR relation)

How to create a relation field in prisma schema that target 2 possible relation scalar fields ? For instance, in soccer, let's say we've got the following 2 mo