Prisma•11mo ago

Schema migration automation

Public schema is attached to my node.js app...i want to migrate schema of for y name schema to database....
I have prisma/public/public.schema folder structure and prisma/shema.prisma for schema db structure...so on api request i want to do migration how???
I have used excutesafe but its failed due to multiple commands....
Sql inside of it....

Prisma AI Help•1/29/25, 2:03 AM

You selected the bot's instantaneous insights. Let me compile your answer right away!

PPrisma AI Help You selected the bot's instantaneous insights. Let me compile your answer right ...

Prisma AI HelpAPP•1/29/25, 2:03 AM

Based on the information provided in the knowledge sources, I can offer some guidance on automating schema migrations with Prisma in a Nest.js application. However, the specific setup you described with separate schemas for public and other named schemas is not directly addressed in the provided documents.

To automate schema migrations on API request, you can create a custom service in your Nest.js application that runs Prisma Migrate commands. Here's a general approach you could consider:

Create a PrismaService that extends PrismaClient and implements OnModuleInit:

In the method, you can add logic to run migrations based on your application's environment and configuration:

This approach is adapted from an example provided in a GitHub issue comment.

However, it's important to note that running migrations on every API request is not a recommended practice, as it can lead to performance issues and potential conflicts. Typically, migrations are run as part of the deployment pro

PPrisma AI Help You selected the bot's instantaneous insights. Let me compile your answer right ...

Prisma AI HelpAPP•1/29/25, 2:03 AM

cess or during application startup.

For your specific case with multiple schemas, you might need to modify this approach to handle different schema files and potentially use Prisma's programmatic API for more fine-grained control over migrations.

Given that you're experimenting with custom schema setups and automation in Prisma, it might be helpful to reach out to the Prisma Team for more tailored advice on best practices for your specific use case.

PPrisma AI Help cess or during application startup. For your specific case with multiple schema...

Prisma AI HelpAPP•1/29/25, 2:04 AM

Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly.

In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.

Nurul•2/3/25, 8:50 AM

Hey

Do you mind elaborating your query? I didn’t understand your requirement

NNurul Hey 👋 Do you mind elaborating your query? I didn’t understand your requiremen...

hari_narayanOP•2/13/25, 4:27 PM

Thanks for asking sir ....
On api call db url pass to prisma ---run command npx prisma migrate deploy script.....on cli......

Nurul•2/14/25, 8:57 AM

Oh you mean you want to programatically invoke command in your backend?