Prisma1: Multiple field unique constraint

[aidanxyz]

It would be nice to have it on the data store level.

[kbrandwijk]

@marktani Just thinking, if I have two (relation) fields, and I want the combination to be unique, would it be possible to concatenate the two id's in a TRANSFORM_ARGUMENT RP into a field on the Type that has a unique constraint? And enforce the unique constraint on the combination like that? It's a lot easier than PQ's...

[Trellian]

This is a feature that is already supported by every conventional SQL backend, it would be great to be able to specify it with an annotation or similar.

[sorenbs]

Please see proposed spec: https://github.com/graphcool/framework/issues/1300 I'd love your input, especially on the syntax.

[ForsakenHarmony]

This would be very nice to have in prisma, are there any plans?

[marktani]

Yes, a possible specification is being considered + discussed in detail here: https://github.com/graphcool/prisma/issues/1300

[develomark]

@marktani is there an update on where we are at with this?

[schickling]

This is related to #3405. Additionally we should consider the following:

• [ ] Ordering by multi-column indexes
• [ ] Generated API schema (especially the generated where input types)

[john-osullivan]

Bumping this one up! About to write a weird hack because I'm saving API responses which are only uniquely identified by a combination of data points which I also need saved separately. Writing my own unique checkers feels sad after using also this slick autogenerated magic.

[carrering]

this is sorely needed feature. i have to build all of these useless primary keys for linking tables representing many-to-many relationships.

[chris-rock]

I agree that I miss this feature too.

[icj217]

Chiming in to also request this feature. Seems like a no brainer to support many existing schemas.

[chenzhendong]

This is a common case that I encounter on my 1st hello world case. Looking fwd it.

[solarsoft0]

please where are with this, any luck

[ahmedfouzan]

+1

[vidrepar]

+1

[sapkra]

@nicovalencia @ahmedfouzan @vidrepar
Please don't comment +1 and give the issue a thumbs up 👍 instead. It's really annoying for everybody who has subscribed to this issue.

[sanjaySP]

There is a workaround. Please check this answer https://stackoverflow.com/a/56984957/4578951
Give a thumbs up if you like this workaround 👍

[blazestudios23]

I have an issue with existing DBs which already have composite keys. It would be so much easier if Prisma could just use them.

[iki]

+1 to support composite/compound primary keys, almost any existing db uses them in m:n relations

[jontroncoso]

After a few days convincing the dev team to move forward with prisma, I spent a couple days actually implementing this. Only to discover that composite unique (which is a crucia requirement for our project), is not supported by prisma. Its very frustrating to have to throw away all that wasted work and go back to the drawing board because one missing feature, which was reported 3 years ago, makes this library unusable. I wish I could've used prisma, other than missing feature, it seems really awesome.

[blazestudios23]

Hey Jontroncoso,
To handle this problem I just added a new field to the table named ID with an auto-incriminating Int. I also set it as a unique and as an index. Then I introspect the DB and assign the the ID as the ID, works perfectly.

[counterbeing]

@blazestudios23 I'm trying to understand your solution, but not quite getting it. Do you mind elaborating?

Are you saying that you created an ID column on your table manually in your database? If so, I don't understand how that fixes the issue of composite keys.

[blazestudios23]

@counterbeing Yes, it's a work around for example if you have a composite key of name + address, but no actual ID. I just added an ID column, set it as a unique index and as an auto-incrementing int. I then set this field as @id in Prisma. I set name and address as strings. This works perfectly.

It's actually a very simple and easy solution, that takes a few minutes to implement.