How to create multiple relationships to the same filed in prisma The 2019 Stack Overflow Developer Survey Results Are InThe ambiguity is on a relation between User and UserLeagueGraphQL Prisma - define “vote” type that links to two usersCascade delete related nodes using GraphQL and PrismaHow to nuke everything in Prisma?Correct way to declare fields for Prisma provided by GraphQL Yoga but not required in resolverSpecifying Prisma's database name in postgresqlHow to Define a Schema for the Relationship of Events, Teams, and MembersHow to create nested connection in prisma query?Add data from a JSON file to the Prisma database with a seed filePrisma graphql computed fields
Button changing its text & action. Good or terrible?
Can we generate random numbers using irrational numbers like π and e?
How do you keep chess fun when your opponent constantly beats you?
Why are there uneven bright areas in this photo of black hole?
I am an eight letter word. What am I?
How did passengers keep warm on sail ships?
Old scifi movie from the 50s or 60s with men in solid red uniforms who interrogate a spy from the past
How to type a long/em dash `—`
Is it possible for absolutely everyone to attain enlightenment?
Why “相同意思的词” is called “同义词” instead of "同意词"？
A word that means fill it to the required quantity
If my opponent casts Ultimate Price on my Phantasmal Bear, can I save it by casting Snap or Curfew?
What is preventing me from simply constructing a hash that's lower than the current target?
If a sorcerer casts the Banishment spell on a PC while in Avernus, does the PC return to their home plane?
What information about me do stores get via my credit card?
Did the UK government pay "millions and millions of dollars" to try to snag Julian Assange?
The difference between dialogue marks
Correct punctuation for showing a character's confusion
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
Geography at the pixel level
Did Scotland spend $250,000 for the slogan "Welcome to Scotland"?
Relationship between Gromov-Witten and Taubes' Gromov invariant
Can a flute soloist sit?
What is this sharp, curved notch on my knife for?
How to create multiple relationships to the same filed in prisma
The 2019 Stack Overflow Developer Survey Results Are InThe ambiguity is on a relation between User and UserLeagueGraphQL Prisma - define “vote” type that links to two usersCascade delete related nodes using GraphQL and PrismaHow to nuke everything in Prisma?Correct way to declare fields for Prisma provided by GraphQL Yoga but not required in resolverSpecifying Prisma's database name in postgresqlHow to Define a Schema for the Relationship of Events, Teams, and MembersHow to create nested connection in prisma query?Add data from a JSON file to the Prisma database with a seed filePrisma graphql computed fields
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Here Is the related portion of my datamodel.prisma file.
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone
preferredShift: Shift
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
Here I want to create the relationship for preferredZone and preferredShift to be type Zone and Shift according to the datamodel I have created.
this is a one way relationship.
The relation field preferredShift must specify a @relation directive: @relation(name: "MyRelation")
, The relation field preferredZone must specify a @relation directive: @relation(name: "MyRelation")
I'm using PostgreSQL for my prisma database. How to build the relationship between preferredZone to Zone. and preferredShift to Shift.
prisma prisma-graphql
edited Mar 21 at 20:08
marc_s
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
add a comment |
Here Is the related portion of my datamodel.prisma file.
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone
preferredShift: Shift
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
Here I want to create the relationship for preferredZone and preferredShift to be type Zone and Shift according to the datamodel I have created.
this is a one way relationship.
The relation field preferredShift must specify a @relation directive: @relation(name: "MyRelation")
, The relation field preferredZone must specify a @relation directive: @relation(name: "MyRelation")
I'm using PostgreSQL for my prisma database. How to build the relationship between preferredZone to Zone. and preferredShift to Shift.
prisma prisma-graphql
edited Mar 21 at 20:08
marc_s
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
add a comment |
Here Is the related portion of my datamodel.prisma file.
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone
preferredShift: Shift
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
Here I want to create the relationship for preferredZone and preferredShift to be type Zone and Shift according to the datamodel I have created.
this is a one way relationship.
The relation field preferredShift must specify a @relation directive: @relation(name: "MyRelation")
, The relation field preferredZone must specify a @relation directive: @relation(name: "MyRelation")
I'm using PostgreSQL for my prisma database. How to build the relationship between preferredZone to Zone. and preferredShift to Shift.
prisma prisma-graphql
edited Mar 21 at 20:08
marc_s
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
Here Is the related portion of my datamodel.prisma file.
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone
preferredShift: Shift
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
Here I want to create the relationship for preferredZone and preferredShift to be type Zone and Shift according to the datamodel I have created.
this is a one way relationship.
The relation field preferredShift must specify a @relation directive: @relation(name: "MyRelation")
, The relation field preferredZone must specify a @relation directive: @relation(name: "MyRelation")
I'm using PostgreSQL for my prisma database. How to build the relationship between preferredZone to Zone. and preferredShift to Shift.
prisma prisma-graphql
prisma prisma-graphql
edited Mar 21 at 20:08
marc_s
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
edited Mar 21 at 20:08
marc_s
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
edited Mar 21 at 20:08
marc_s
585k13011251272
edited Mar 21 at 20:08
marc_s
585k13011251272
edited Mar 21 at 20:08
marc_s
585k13011251272
585k13011251272
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
asked Mar 8 at 10:43
Dulara MalinduDulara Malindu
426413
426413
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You need to name the relations since you have two relations between same types (Driver <-> Shift and Driver <-> Zone both are connected by two relations each).
In cases like this Prisma asks you to name the relations which is what the error message you posted is about. I think this data model should work:
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone @relation(name: "PreferredZone")
preferredShift: Shift @relation(name: "PreferredShift")
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
edited Mar 21 at 20:08
marc_s
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55061483%2fhow-to-create-multiple-relationships-to-the-same-filed-in-prisma%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to name the relations since you have two relations between same types (Driver <-> Shift and Driver <-> Zone both are connected by two relations each).
In cases like this Prisma asks you to name the relations which is what the error message you posted is about. I think this data model should work:
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone @relation(name: "PreferredZone")
preferredShift: Shift @relation(name: "PreferredShift")
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
edited Mar 21 at 20:08
marc_s
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
add a comment |
You need to name the relations since you have two relations between same types (Driver <-> Shift and Driver <-> Zone both are connected by two relations each).
In cases like this Prisma asks you to name the relations which is what the error message you posted is about. I think this data model should work:
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone @relation(name: "PreferredZone")
preferredShift: Shift @relation(name: "PreferredShift")
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
edited Mar 21 at 20:08
marc_s
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
add a comment |
You need to name the relations since you have two relations between same types (Driver <-> Shift and Driver <-> Zone both are connected by two relations each).
In cases like this Prisma asks you to name the relations which is what the error message you posted is about. I think this data model should work:
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone @relation(name: "PreferredZone")
preferredShift: Shift @relation(name: "PreferredShift")
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
edited Mar 21 at 20:08
marc_s
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
You need to name the relations since you have two relations between same types (Driver <-> Shift and Driver <-> Zone both are connected by two relations each).
In cases like this Prisma asks you to name the relations which is what the error message you posted is about. I think this data model should work:
type Driver
id: ID! @unique
zones: [Zone!] @relation(name: "DriverZones")
shifts: [Shift!] @relation(name: "DriverShifts")
preferredZone: Zone @relation(name: "PreferredZone")
preferredShift: Shift @relation(name: "PreferredShift")
type Shift
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverShifts")
type Zone
id: ID! @unique
drivers: [Driver! ] @relation(name: "DriverZones")
edited Mar 21 at 20:08
marc_s
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
edited Mar 21 at 20:08
marc_s
585k13011251272
edited Mar 21 at 20:08
marc_s
585k13011251272
edited Mar 21 at 20:08
marc_s
585k13011251272
585k13011251272
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
answered Mar 8 at 17:42
Matthias OertelMatthias Oertel
2487
2487
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55061483%2fhow-to-create-multiple-relationships-to-the-same-filed-in-prisma%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
