How do I create a prisma migration with a dictionary data?

Question

I have some dictionary table in my DB schema. E.g. "EventType" whth fields "id" and "value".

This table have one row:

1    TypeOne

Can I create a prisma migration with sql?

INSERT INTO "EventType" (id, value) VALUES (2, 'TypeTwo')

Tasin Ishmam · Accepted Answer · 2021-11-25 16:45:33Z

11

All the prisma migration files are valid SQL so you can put any arbitrary SQL in your migration files and it will be added to your migration history.

This is what you have to do:

Generate a new migration without applying it to the database with the --create-only flag.

npx prisma migrate dev --create-only

Take a look at the generated migration.sql file and update it accordingly to add any new SQL statements.
Apply the migrations npx prisma migrate dev

Important Note: Always make sure you apply the changes to migration.sql before applying it to your database. Modifying an already applied migration file will lead to a corrupt migration history.

answered Nov 25, 2021 at 16:45

Tasin Ishmam

7,4882 gold badges29 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I create a prisma migration with a dictionary data?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related