How to generate CUID in migrations?

[villesau]

I need to generate new records in the migration. However the migration files are SQL files, and the CUID seems to be generated by Prisma client I'm not able to find a way to use CUID. How can this be achieved? The idea is to split one table in two tables and I would not want to reuse the ids.

[arosemena]

You can import the cuid package manually into the migration and generate them that way:

https://github.com/paralleldrive/cuid

Create an empty migration and write the code that splits the table there, whenever you need a new cuid just call the cuid() function.

[ludralph]

Hi @villesau

Do you have any more questions around this issue? If no, it would be really helpful if you could quickly mark this Discussion as answered to indicate that your issue has been resolved.

In case you do have any outstanding questions, feel free to let us know and we'd be happy to help!

[villesau]

Unfortunately that does not answer to my question. Prisma only supports SQL migrations and the package linked is javascript..

[alan345]

Prisma is using cuid1 or 2?

https://github.com/paralleldrive/cuid2

[madhugb]

@villesau Its probably too late! but I was able to do this from MySQL migrations.
Documented the process here - https://gist.github.com/madhugb/6ab4a341e3f3d67b6355d3f954e4400d