From aec195eff8a62bfdeb58f98f90b894f5f673360d Mon Sep 17 00:00:00 2001 From: Jake Mannens 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 --- HBContext.cs | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'HBContext.cs') diff --git a/HBContext.cs b/HBContext.cs index d0cd26f..f6bc15c 100644 --- a/HBContext.cs +++ b/HBContext.cs @@ -4,6 +4,9 @@ using HyperBooru.Services; namespace HyperBooru; public class HBContext : DbContext { + public const int NsfwTagId = -1; + public const int IngestTagId = -2; + public static readonly Guid NsfwTag = new("EBDAD4F8-455A-4351-8017-1D4854D6FA38"); public static readonly Guid IngestTag = new("EA212801-5BCC-4C0E-814F-FB9D30DB58BC"); @@ -38,13 +41,13 @@ public class HBContext : DbContext { // These should NEVER change modelBuilder.Entity().HasData(new TagDefinition[] { new() { - ObjectId = -1, + ObjectId = NsfwTagId, Guid = NsfwTag, Source = TagSource.Internal, Name = "nsfw" }, new() { - ObjectId = -2, + ObjectId = IngestTagId, Guid = IngestTag, Source = TagSource.Internal, Name = "ingest" -- cgit v1.3