diff options
| author | dkanada <dkanada@users.noreply.github.com> | 2020-01-02 15:32:25 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-01-02 15:32:25 +0900 |
| commit | d756233f62aeb5e7f769df30a2f132a5dae6cdbe (patch) | |
| tree | 3112cf5956314f572e0d0dc288f7f74a0405f7bc | |
| parent | 653610d57838f010053b69ac7a94612549f5252c (diff) | |
| parent | d9c0721e3dee52ec8a101cf3d35ca18ef5bd6cf3 (diff) | |
Merge pull request #2144 from neilsb/feature/Add-Excluded-Tags-to-SQLite-query-using-parameters
Add Excluded Tags to SQLite query using parameters
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index 69cfcb67b..ef1fe07c1 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -4593,10 +4593,20 @@ namespace Emby.Server.Implementations.Data if (query.ExcludeInheritedTags.Length > 0) { - var tagValues = query.ExcludeInheritedTags.Select(i => "'" + GetCleanValue(i) + "'"); - var tagValuesList = string.Join(",", tagValues); - - whereClauses.Add("((select CleanValue from itemvalues where ItemId=Guid and Type=6 and cleanvalue in (" + tagValuesList + ")) is null)"); + var paramName = "@ExcludeInheritedTags"; + if (statement == null) + { + int index = 0; + string excludedTags = string.Join(",", query.ExcludeInheritedTags.Select(t => paramName + index++)); + whereClauses.Add("((select CleanValue from itemvalues where ItemId=Guid and Type=6 and cleanvalue in (" + excludedTags + ")) is null)"); + } + else + { + for (int index = 0; index < query.ExcludeInheritedTags.Length; index++) + { + statement.TryBind(paramName + index, GetCleanValue(query.ExcludeInheritedTags[index])); + } + } } if (query.SeriesStatuses.Length > 0) |