From df5cfc0c2580c5bab0a588279c97dec9145736d4 Mon Sep 17 00:00:00 2001
From: Luke Pulverenti <luke.pulverenti@gmail.com>
Date: Fri, 22 Jul 2016 13:54:43 -0400
Subject: update more from/similar

---
 .../Persistence/SqliteItemRepository.cs                    | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs')

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
index a33e4f3e4..4f8f31a75 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
@@ -2883,6 +2883,20 @@ namespace MediaBrowser.Server.Implementations.Persistence
                 whereClauses.Add(clause);
             }
 
+            if (query.ExcludeArtistNames.Length > 0)
+            {
+                var clauses = new List<string>();
+                var index = 0;
+                foreach (var artist in query.ExcludeArtistNames)
+                {
+                    clauses.Add("@ExcludeArtistName" + index + " not in (select CleanValue from itemvalues where ItemId=Guid and Type <= 1)");
+                    cmd.Parameters.Add(cmd, "@ExcludeArtistName" + index, DbType.String).Value = artist.RemoveDiacritics();
+                    index++;
+                }
+                var clause = "(" + string.Join(" AND ", clauses.ToArray()) + ")";
+                whereClauses.Add(clause);
+            }
+
             if (query.GenreIds.Length > 0)
             {
                 // Todo: improve without having to do this
-- 
cgit v1.2.3