Hi, I’ve got a question about inline relationships...
# prisma1-communitym
Moray Macdonald
09/15/2020, 1:01 PMHi, I’ve got a question about inline relationships. As the foreign key for this relationship is stored inline in the same table as the root basic fields, is there any way to resolve the foreign key value as a root field? At the moment I’m having to run extra queries to resolve this field which is leading to n+1 query problems
r
Ryan
09/15/2020, 1:11 PM@Moray Macdonald 👋
Could you provide an example if possible?
m
Moray Macdonald
09/15/2020, 1:12 PMOf course, just a sec
Moray Macdonald
09/15/2020, 1:12 PM Copy code
type Tenant {
id: ID! @id
}
type User {
id: ID! @id
owner: Tenant! @relation(link: INLINE)
}Moray Macdonald
09/15/2020, 1:15 PMso if I wanted the ID of the
TenantUserMoray Macdonald
09/15/2020, 1:16 PM Copy code
owner: (root, args, context) => await context.db.user({ id: root.id }).owner().id();Moray Macdonald
09/15/2020, 1:16 PMOr in GraphQL
Moray Macdonald
09/15/2020, 1:17 PM Copy code
user(id: $id){
owner {
id
}
}Moray Macdonald
09/15/2020, 1:18 PMAs this inline Tenant-User relationship will get translated into this SQL
Moray Macdonald
09/15/2020, 1:19 PM Copy code
CREATE TABLE User (id CHAR(25), owner CHAR(25));Moray Macdonald
09/15/2020, 1:21 PMCan I get the value of the owner column on the root
UserMoray Macdonald
09/15/2020, 1:21 PMAs the data is right there, next to all the other root fields!
r
Ryan
09/15/2020, 1:23 PMI don’t think that is possible though unless you use a raw query.
👍 1
m
Moray Macdonald
09/15/2020, 1:24 PMAh OK, thanks for your help
🙌 1