From aec195eff8a62bfdeb58f98f90b894f5f673360d Mon Sep 17 00:00:00 2001
From: Jake Mannens <jake@asger.xyz>
Date: Mon, 28 Aug 2023 15:45:21 +1000
Subject: Gallery media is now filtered by tag using Object IDs rather than
 Guids, signficantly reducing DB overhead

---
 Pages/Gallery.razor | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'Pages')

diff --git a/Pages/Gallery.razor b/Pages/Gallery.razor
index eea051c..e1ca180 100644
--- a/Pages/Gallery.razor
+++ b/Pages/Gallery.razor
@@ -45,7 +45,6 @@
 
         IEnumerable<Media> media = db.Media
             .Include(m => m.Tags)
-            .ThenInclude(t => t.TagDefinition)
             .OrderByDescending(m => m.ObjectId)
             .ToArray();
 
@@ -61,11 +60,11 @@
         // Filter both NSFW AND ingest images if we're not showing NSFW
         if(!userService.ShowNsfw) {
             var nsfwTags = tagService.TagsThatImply(HBContext.NsfwTag)
-                .Select(td => td.Guid)
+                .Select(td => td.ObjectId)
                 .ToArray();
             media = media
                 .AsEnumerable()
-                .Where(m => !m.Tags.Select(t => t.TagDefinition.Guid).Intersect(nsfwTags).Any())
+                .Where(m => !m.Tags.Select(t => t.TagDefinitionId).Intersect(nsfwTags).Any())
                 .Where(m => !m.IsIngest);
         }
 
-- 
cgit v1.3