0.0.12 • Published 4 years ago
tmp-prisma-upgrade v0.0.12
⚠️ EXPERIMENTAL This tool is being built now. It's not ready for use. Please watch this repository for updates.
prisma-upgrade
Upgrade is a CLI tool to help Prisma 1 users upgrade to Prisma 2.
Usage
$ prisma-upgrade datamodel.prisma schema.prismaCurrent features
This table reflects the current feature set of the upgrade CLI and will be updated continuously. Read below for a more detailled explanation of each column. You can also find more info about each of these feautures in the docs.
| Name | MySQL | PostgreSQL | Prisma schema | Prisma 1 compatible |
|---|---|---|---|---|
| Default values | Yes | Not yet | Not yet | Yes |
| @updatedAt | Not yet | n/a | Not yet | Yes |
| Missing UNIQUE for inline 1-1 | Yes | Not yet | Not yet | Yes |
| JSON | Yes | Not yet | Not yet | Yes |
| Enums | Not yet | Not yet | Not yet | Yes |
| Generated IDs | n/a | Not yet | Yes | Yes |
| @createdAt | Yes | Not yet | Not yet | Yes |
| Relation tables are all m-n | Not yet | Not yet | Not yet | No |
| Scalar lists have extra table | Not yet | Not yet | Not yet | No |
| Cascading deletes | No | No | No | No |
| Maintain order of models and fields | n/a | n/a | Not yet | No |
| Maintain relation names | n/a | n/a | Not yet | No |
What do the columns mean?
- MySQL: Does the CLI generate the correct MySQL statements to solve the problem?
- PostgreSQL: Does the CLI generate correct PostgreSQL statements to solve the problem?
- Prisma schema: Does the final Prisma schema I get from the CLI reflect the right solution?
- Prisma 1 compatible: Does the SQL change to the schema maintain Prisma 1 compatibility?
Tests
Testing consists of 2 parts: a Local SQL Dump and Running Tests
Local SQL Dump
Requirements: MySQL@5, Docker
Since it's cumbersome to run Prisma 1 in CI, we need to locally setup test cases first
Setting up MySQL for examples
mysqladmin -h localhost -u root create prisma
mysql -h localhost -u root prisma < ./examples/mysql-ablog/dump.sql
mysqladmin -h localhost -u root drop prisma -f