Sample 22-graphql-prisma not working due to prisma 7 upgrade

[denniske]

Is there an existing issue for this?

• I have searched the existing issues

Current behavior

Prisma db push is failing for this sample:

$ npx prisma db push

Prisma schema loaded from prisma/schema.prisma
Error: Prisma schema validation - (get-config wasm)
Error code: P1012
error: The datasource property `url` is no longer supported in schema files. Move connection URLs for Migrate to `prisma.config.ts` and pass either `adapter` for a direct database connection or `accelerateUrl` for Accelerate to the `PrismaClient` constructor. See https://pris.ly/d/config-datasource and https://pris.ly/d/prisma7-client-config
  -->  prisma/schema.prisma:6
   | 
 5 |   provider = "sqlite"
 6 |   url      = "file:./dev.db"
   | 

Validation Error Count: 1
[Context: getConfig]

Prisma CLI Version : 7.0.0

Minimum reproduction code

https://github.com/nestjs/nest/tree/master/sample/22-graphql-prisma

Steps to reproduce

$ yarn  
                            
$ yarn generate:typings   

$ npx prisma db push

Prisma schema loaded from prisma/schema.prisma
Error: Prisma schema validation - (get-config wasm)
Error code: P1012
error: The datasource property `url` is no longer supported in schema files. Move connection URLs for Migrate to `prisma.config.ts` and pass either `adapter` for a direct database connection or `accelerateUrl` for Accelerate to the `PrismaClient` constructor. See https://pris.ly/d/config-datasource and https://pris.ly/d/prisma7-client-config
  -->  prisma/schema.prisma:6
   | 
 5 |   provider = "sqlite"
 6 |   url      = "file:./dev.db"
   | 

Validation Error Count: 1
[Context: getConfig]

Prisma CLI Version : 7.0.0

Expected behavior

Sample 22 works out of the box.

NestJS version

11.1.9

Packages versions

[Nest CLI]
Nest CLI Version : 11.0.12 

[Nest Platform Information]
platform-express version : 11.1.9
schematics version       : 11.0.9
graphql version          : 13.2.0
testing version          : 11.1.9
apollo version           : 13.2.1
common version           : 11.1.9
core version             : 11.1.9
cli version              : 11.0.12

Node.js version

22.12.0

In which operating systems have you tested?

• macOS
• Windows
• Linux

Other

No response

[micalevisk]

Would you like to create a PR to fix that?

[micalevisk]

Related with nestjs/docs.nestjs.com#3350

[denniske]

Would you like to create a PR to fix that?

I have been trying to use prisma 7 with nestjs the last two days without success. That's how I found this sample. I have no idea how to fix it 😢

[micalevisk]

there is a discussion about this in our discord: https://discord.com/channels/520622812742811698/1441276489457860658

[RareParsec]

This specific issue of The datasource property url is no longer supported in schema files is because of the breaking changes of Prisma v7. Refer to the Upgrading to Primsa ORMv7 guide

Essentially, the url parameter now is no longer supported in the schema file, and has to be removed from there and placed in this prisma.config.ts file.

As per the guide:

Additionally other fields such as url, directUrl, and shadowDatabaseUrl in the datasource block are deprecated. You can configure them in the Prisma Config.

import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  datasource: {
    url: env('DATABASE_URL'),
    shadowDatabaseUrl: env('SHADOW_DATABASE_URL')
  },
})

Note the imports, they're important as well

However, I would still suggest not upgrading to Prisma v7 yet since there seems to be an issue between Prisma now being an ES module and Nestjs using CommonJS which is making them sort of incompatible. Maybe there's a fix somewhere, but I haven't been able to find it. This issue is described in 3350 as someone has already mentioned on this thread.