how can i query only Date such as

where year=x and month=y and date=z

from DateTime field eg

2022-06-03 13:10:03

thank yous

skipDuplicates not working with mongodb?

How to create native DATE type for mysql? I have tried to use the @db.Date and it still creating the field as a datetime. Does prisma doesn’t support the Mysql Native Date type?

delivery_date Datetime @db.Date

and also

delivery_date Datetime @db.Date()

but prisma is still creating the field as a DateTime.

hi all

Hi

Hello! Is anyone working with Next-Auth adapter and manage to have it work with credentials provider.

Building a REST API with NestJS and Prisma 20 min read NestJS is one of the prominent Node.js frameworks, and it has recently gained a lot of developer love and traction. This article will teach you how to build a backend REST API with NestJS, Prisma, PostgreSQL and Swagger.

I just inherited a simple project that uses Prisma. Struggling to run it locally. Let me open a thread here to clear my own thoughts and maybe i got lucky and get some help. 📌

Hi folks, would this be the right place to ask for advice about one of the Prisma project tutorials (awesome-links)? I've got to Stage 4 and am thoroughly enjoying it but I've hit an issue that I can't get to the bottom of regarding image uploads.

Hello Team… Does anyone facing this issue while running

yarn redwood prisma db pull

Error logs Prisma schema loaded from api/db/schema.prisma Environment variables loaded from .env Datasource “db”: PostgreSQL database “postgres”, schema “public” at “db.dymhsbaxmnfzfkmatyeb.supabase.co:5432" ✖️ Introspecting based on datasource defined in api/db/schema.prisma Oops, an unexpected error occured! [libs/sql-schema-describer/src/postgres.rs103928] no entry found for key Using RedwoodJS, and supabase DB…

I'm using mongo DB and I would like, if possible, to have "dynamic" properties as such :

{
    // ...
    options: {
        // we do not know in advance what prop1 or prop2 are:
        prop1: "foo",
        prop2: "bar"
    }
}

Is it doable using Prisma ?

Hey question regarding the

$transaction

API. I see this example: https://www.prisma.io/docs/guides/performance-and-optimization/prisma-client-transactions-guide#transaction-api Where Prisma apparently makes three “delete” calls, then uses the returned promises as arguments to the

$transaction

API. I’m confused how this works. Don’t the delete calls make requests to the database as soon as those lines of code are executed? How does Prisma then retroactively include them in a database transaction? Or does the

$transaction

API not actually use database transactions?

when I enter a date through the prism it has the wrong time zone

Hello! 🙂

I'm using prisma for MongoDB. I'm trying to write a schema with an inventory object that has it's own schema. Object is not supported so is there a way to write how the object should look?

Can someone please tell me how to debug this? I do not want to reset. I know I didn't modify anything after it was applied. Is there some easy command that will just tell me what it thinks was modified instead of being so vague.

The migration `my_migration_here` was modified after it was applied.

select code, count(code) as invites

from table where server_id = '234'

group by code

having count(code) > 0

order by count(code) desc

Can i do this with prisma?

Hey guys, if I want to go with node + prisma + graphql + federation what would be the best solution for 2022? I mean apollo or something else?

Hello! Is there a way to generate this "KEY" only through Prisma? PRIMARY KEY (

id

), KEY

player_id

(

player_id

,

sale

) I can only generate PRIMARY KEY 😕

@kmenux check out Pothos, it is (in my very biased opinion) by far the best way to build graphql APIs with prisma

Hey guys is there a way to exclude certain fields natively or is the only viable way to delete it „manually“

Anyone dealing with connection pool problems on Vercel?

Getting a “Timed out fetching a new connection from the connection pool”

from prisma

Hello, everyone! I have a question. The firebase functions application is running using prisma. However, the following error occurs.

PrismaClientInitializationError: Timed out fetching a new connection from the connection pool. More info: <http://pris.ly/d/connection-pool> (Current connection pool timeout: 10, connection limit: 10)

How can I solve this problem? I think it’s a connection problem, but is it a mistake to set up the prism client? Is there anyone who uses the firebase application using Prisma2? If there’s a better example than the picture below, please share it 🙏 I look forward to hearing from you. Thank you!🙂

/@prisma/client/runtime/index.js:45409
[0]         throw new PrismaClientUnknownRequestError(message, this.client._clientVersion);
[0]               ^
[0]
[0] PrismaClientUnknownRequestError:
[0] Invalid `prisma.post.deleteMany()` invocation in (...)

does anyone know when the deleteMany method will be supported for the SQLite connector?

Can I have silent output for

prisma generate

? Currently it writes to stdout something like

✔ Generated Prisma Client (3.14.0 | library)...

Does Prisma support grouping by a relation? For example: Each post can have reports like “Copyright”, “Spam”, “Nudity” etc. So my Posts table has a relation to my Report table. What I can do is:

const reports =  await prisma.posts.findMany({
        include:{
          reports: {
            orderBy: {
              reason: 'asc'
            }
          }
        }
      })

the output looks like this with graphQl (see image) How can I call groupBy inside of the query. I want to get the top 5 reasons why the post got reportet in an desc order

Where do I get these kinds of types from with typescript? Im tryna add some typings for a variable that contains a row from a specific table, but idk where to get the type for that table from

does prisma is coming for deno?