Add a Prisma adapter

[timleslie]

Prisma 2 has recently been released. It provides a powerful javascript library for interfacing with databases. The Prisma team have recently received significant funding to continue development of their library.

This PR introduces support for using Prisma as a database adapter within Keystone.

We are still reviewing Prisma for feature completeness and correctness to ensure that all of Keystone's features will work as expected.

We are also investigating the Prisma migration framework in order to provide a better DX for developers who need to perform migrations on their database as their Keystone system evolves.

Note: This PR is still WIP, particularly in regard to how, where and when we are generating the Prisma client.

See also: prisma/prisma#3265

Feature Completeness

Relationships

Type	Create	Read	Count	Update	Delete	Notes
One-to-many one-sided	✅	✅	✅	✅	✅
One-to-many two-sided	✅	✅	✅	✅	✅	prisma/prisma#3141
Many-to-many one-sided	✅	✅	✅	✅	✅
Many-to-many two-sided	✅	✅	✅	✅	✅
One-to-one	✅	✅	☑️	✅	✅
Self-referential
One-to-many one-sided	✅	✅	✅	✅	✅
One-to-many two-sided	✅	✅	✅	✅	✅	prisma/prisma#3078
Many-to-many one-sided	✅	✅	✅	✅	✅
Many-to-many two-sided	✅	✅	✅	✅	✅
One-to-one	✅	✅	☑️	✅	✅	prisma/prisma#3153

Fields

Name	Prisma Type	Core	Filter	Required	Unique	Notes
Core
CalendarDay	DateTime	✅	✅	✅	✅
Checkbox	Boolean	✅	✅	✅	☑️
DateTime	DateTime + String	✅	✅	✅	✅
DateTimeUtc	DateTime	✅	✅	✅	✅
Decimal	N/A	🔴	🔴	🔴	🔴	Prisma does not currently support a decimal database type (prisma/prisma#3374) (prisma/prisma#3447)
File	Json	?	🔴	✅	☑️	prisma/prisma#3579
Float	Float	✅	✅	✅	✅
Integer	Int	✅	✅	✅	✅
Password	String	?	✅	✅	☑️	Need to be able to check for a regex
Relationship	@relation	✅	✅	☑️	☑️
Select	Enum | Int | String	✅	✅	✅	✅
Slug	String	✅	✅	✅	✅
Text	String	✅	✅	✅	✅	prisma/prisma-client-js#690
Url	String	✅	✅	✅	✅	prisma/prisma-client-js#690
Uuid	String	?	✅	✅	✅	We have used a String here for now, but we should really work out how to get an actual uuid column
Virtual	☑️	☑️	☑️	☑️	☑️
Extra
Color	String	✅	✅	✅	✅	prisma/prisma-client-js#690
Content	@relation	✅	✅	☑️	☑️
AuthedRelationship	@relation	✅	✅	☑️	☑️
AutoIncrement	Int	✅	✅	✅	✅
CloudinaryImage	Json	?	?	?	☑️
GoogleLocation	Json	?	?	✅	☑️
Markdown	String	✅	✅	✅	✅	prisma/prisma-client-js#690
MongoId	String	✅	✅	✅	✅
OEmbed	Json	?	?	?	☑️
Unsplash	Json	?	?	?	☑️
Wysiwyg	String	✅	✅	✅	✅

• ✅ - Working
• 🔴 - Not working (test failures)
• ☑️ - N/A (working by default)
• ❓ - Still being investigated

[changeset-bot]

🦋 Changeset detected

Latest commit: 66c00bc

The changes in this PR will be included in the next version bump.

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

[emmatown]

Is there a prisma issue about this? I tried searching on the prisma repo but couldn't find anything

[timleslie]

Not that I know of, it's something I need to bring up with them, I just need to take the time to formulate the question properly so I can explain exactly what the feature would look like.