Peter Kellner
02/08/2022, 8:38 PMconst data = await context.prisma.News.findMany({
include: { CodeCampYear: true }
});
model News {
Id Int @id(map: "PK__News__3214EC07CA2FD4E0") @default(autoincrement())
CodeCampYearId Int
Visible Boolean?
Title String? @db.VarChar(256)
Description String @db.VarChar(1024)
Authors String @db.VarChar(256)
CreatedDate DateTime @db.DateTime
UpdatedDate DateTime? @db.DateTime
ContentData String? @db.Text
UrlExternal String? @db.VarChar(512)
PostDate DateTime? @db.DateTime
YouTubeUrl String? @db.VarChar(256)
AuthorImageUrl String? @db.VarChar(256)
AuthorAttendeesId Int?
AuthorEmail String? @db.VarChar(128)
YouTubeCode String? @db.VarChar(128)
PictureUrl String? @db.VarChar(128)
CodeCampYear CodeCampYear @relation(fields: [CodeCampYearId], references: [Id], onUpdate: NoAction, map: "News_fk")
@@unique([CodeCampYearId, Title], map: "News_uq")
}
model CodeCampYear {
Id Int @id(map: "PK__CodeCamp__3214EC07BF12A5BA")
Name String @db.VarChar(128)
...
VolunteerJob VolunteerJob[]
}
and the generated sql logged
SELECT
[ dbo ].[ CodeCampYear ].[ Id ],
[ dbo ].[ CodeCampYear ].[ Name ],
[ dbo ].[ CodeCampYear ].[ CampStartDate ],
[ dbo ].[ CodeCampYear ].[ CampEndDate ],
[ dbo ].[ CodeCampYear ].[ CodeCampDateString ],
[ dbo ].[ CodeCampYear ].[ CodeCampSaturdayString ],
[ dbo ].[ CodeCampYear ].[ CodeCampSundayString ],
[ dbo ].[ CodeCampYear ].[ HostName ],
[ dbo ].[ CodeCampYear ].[ BaseUrl ],
[ dbo ].[ CodeCampYear ].[ UrlPostToken ],
[ dbo ].[ CodeCampYear ].[ TagLine ],
[ dbo ].[ CodeCampYear ].[ CodeCampYearTypeId ],
[ dbo ].[ CodeCampYear ].[ EmailFooterImage ],
[ dbo ].[ CodeCampYear ].[ EmailHeaderImage ],
[ dbo ].[ CodeCampYear ].[ EmailBgImage ],
[ dbo ].[ CodeCampYear ].[ EmailAdLinkUrl ],
[ dbo ].[ CodeCampYear ].[ EmailAdLinkImage ],
[ dbo ].[ CodeCampYear ].[ EmailAdLinkImageMarginTop ],
[ dbo ].[ CodeCampYear ].[ EmailAdLinkImageWidth ],
[ dbo ].[ CodeCampYear ].[ MeetupDetailsRequiredWord1 ],
[ dbo ].[ CodeCampYear ].[ MeetupDetailsRequiredWord2 ],
[ dbo ].[ CodeCampYear ].[ MeetupReferralUrl ],
[ dbo ].[ CodeCampYear ].[ MeetupGroupReferralImage ],
[ dbo ].[ CodeCampYear ].[ MeetupReferralText ],
[ dbo ].[ CodeCampYear ].[ SiteLocked ],
[ dbo ].[ CodeCampYear ].[ NgUrlDefault ],
[ dbo ].[ CodeCampYear ].[ LiveStreamFeedOverride ],
[ dbo ].[ CodeCampYear ].[ ShowLiveFeedStart ],
[ dbo ].[ CodeCampYear ].[ ShowLiveFeedEnd ],
[ dbo ].[ CodeCampYear ].[ LiveFeedEmbedCode ],
[ dbo ].[ CodeCampYear ].[ LiveFeedEmbedCodeEmpty ],
[ dbo ].[ CodeCampYear ].[ LiveFeedTitle ],
[ dbo ].[ CodeCampYear ].[ LiveFeedTrackId ],
[ dbo ].[ CodeCampYear ].[ LiveFeedSponsorNameDefault ],
[ dbo ].[ CodeCampYear ].[ LiveFeedSponsorUrlDefault ],
[ dbo ].[ CodeCampYear ].[ LiveFeedCurrentSessionId ],
[ dbo ].[ CodeCampYear ].[ Address ],
[ dbo ].[ CodeCampYear ].[ City ],
[ dbo ].[ CodeCampYear ].[ State ],
[ dbo ].[ CodeCampYear ].[ Zipcode ],
[ dbo ].[ CodeCampYear ].[ LocationName ],
[ dbo ].[ CodeCampYear ].[ HackathonDateString ],
[ dbo ].[ CodeCampYear ].[ HackathonLocation ],
[ dbo ].[ CodeCampYear ].[ HackathonLocationUrl ]
FROM
[ dbo ].[ CodeCampYear ]
WHERE
1 = 1 []
Query CodeCampYear.findMany took 792ms
SELECT
1 []
SELECT
[ dbo ].[ News ].[ Id ],
[ dbo ].[ News ].[ CodeCampYearId ],
[ dbo ].[ News ].[ Visible ],
[ dbo ].[ News ].[ Title ],
[ dbo ].[ News ].[ Description ],
[ dbo ].[ News ].[ Authors ],
[ dbo ].[ News ].[ CreatedDate ],
[ dbo ].[ News ].[ UpdatedDate ],
[ dbo ].[ News ].[ ContentData ],
[ dbo ].[ News ].[ UrlExternal ],
[ dbo ].[ News ].[ PostDate ],
[ dbo ].[ News ].[ YouTubeUrl ],
[ dbo ].[ News ].[ AuthorImageUrl ],
[ dbo ].[ News ].[ AuthorAttendeesId ],
[ dbo ].[ News ].[ AuthorEmail ],
[ dbo ].[ News ].[ YouTubeCode ],
[ dbo ].[ News ].[ PictureUrl ]
FROM
[ dbo ].[ News ]
WHERE
1 = 1 []
Query News.findMany took 556ms