CODEWITHSUNDEEP
prisma
schutte
schutte

Reputation: 2166

How to migrate a database programmatically? prisma

I'm planning to create a secondary database for testing purposes. As of now I'm using Prisma's Client to perform CRUD to my secondary database. Good thing it worked fine.

My problem is the migration part. I still need to do it manually. Like editing the schema.prisma file, change the database url, and run prisma migrate dev manually.

I already browsed to Prisma's github, but I can't find an exact solution. I would like to ask here, maybe someone has an idea on how to achieve it.

Working code below.

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient({
  datasources: {
    db: {
      url: 'postgresql://capstone:capstone@postgres:5432/blogpost_test?schema=public'
    }
  }
})

export default prisma

I expect something like below, in which we can just migrate the database programmatically??

prisma.$migrate or prisma.migrate()

Upvotes: 4

Views: 6363

Answers (1)

Austin Crim
Austin Crim

Reputation: 1307

This is not directly supported by Prisma. There is an open feature request that you could +1 here.

Best workaround for now would be to writes scripts that use the CLI commands.

Upvotes: 4

Related Questions