| | | 1 | | using Elsa.Common.Models; |
| | | 2 | | using Elsa.Extensions; |
| | | 3 | | using Elsa.Workflows; |
| | | 4 | | using Elsa.Workflows.Runtime; |
| | | 5 | | using Elsa.Workflows.Runtime.Entities; |
| | | 6 | | using Elsa.Workflows.Runtime.Filters; |
| | | 7 | | using Elsa.Workflows.Runtime.Options; |
| | | 8 | | using Elsa.Workflows.Runtime.OrderDefinitions; |
| | | 9 | | using JetBrains.Annotations; |
| | | 10 | | using Microsoft.EntityFrameworkCore; |
| | | 11 | | using Open.Linq.AsyncExtensions; |
| | | 12 | | |
| | | 13 | | namespace Elsa.Persistence.EFCore.Modules.Runtime; |
| | | 14 | | |
| | | 15 | | /// <summary> |
| | | 16 | | /// An EF Core implementation of <see cref="IBookmarkQueueDeadLetterStore"/>. |
| | | 17 | | /// </summary> |
| | | 18 | | [UsedImplicitly] |
| | 261 | 19 | | public class EFBookmarkQueueDeadLetterStore(Store<RuntimeElsaDbContext, BookmarkQueueDeadLetterItem> store, IPayloadSeri |
| | | 20 | | { |
| | | 21 | | /// <inheritdoc /> |
| | | 22 | | public Task SaveAsync(BookmarkQueueDeadLetterItem record, CancellationToken cancellationToken = default) |
| | | 23 | | { |
| | 0 | 24 | | return store.SaveAsync(record, s => s.Id, OnSaveAsync, cancellationToken); |
| | | 25 | | } |
| | | 26 | | |
| | | 27 | | /// <inheritdoc /> |
| | | 28 | | public Task AddAsync(BookmarkQueueDeadLetterItem record, CancellationToken cancellationToken = default) |
| | | 29 | | { |
| | 0 | 30 | | return store.AddAsync(record, OnSaveAsync, cancellationToken); |
| | | 31 | | } |
| | | 32 | | |
| | | 33 | | /// <inheritdoc /> |
| | | 34 | | public async Task<BookmarkQueueDeadLetterItem> AddOrGetExistingAsync(BookmarkQueueDeadLetterItem record, Cancellatio |
| | | 35 | | { |
| | | 36 | | try |
| | | 37 | | { |
| | 0 | 38 | | await AddAsync(record, cancellationToken); |
| | 0 | 39 | | return record; |
| | | 40 | | } |
| | 0 | 41 | | catch (Exception ex) when (DbExceptionClassifier.IsDuplicateKey(ex)) |
| | | 42 | | { |
| | 0 | 43 | | var existing = await FindAsync(new BookmarkQueueDeadLetterFilter { OriginalQueueItemId = record.OriginalQueu |
| | 0 | 44 | | if (existing != null) |
| | 0 | 45 | | return existing; |
| | | 46 | | |
| | 0 | 47 | | throw; |
| | | 48 | | } |
| | 0 | 49 | | } |
| | | 50 | | |
| | | 51 | | /// <inheritdoc /> |
| | | 52 | | public async Task<IReadOnlyCollection<BookmarkQueueDeadLetterItem>> AddOrGetExistingManyAsync(IEnumerable<BookmarkQu |
| | | 53 | | { |
| | 0 | 54 | | var recordList = records.ToList(); |
| | | 55 | | |
| | 0 | 56 | | if (recordList.Count == 0) |
| | 0 | 57 | | return Array.Empty<BookmarkQueueDeadLetterItem>(); |
| | | 58 | | |
| | 0 | 59 | | var originalQueueItemIds = recordList.Select(x => x.OriginalQueueItemId).ToList(); |
| | 0 | 60 | | var existingItems = (await FindManyAsync(new BookmarkQueueDeadLetterFilter { OriginalQueueItemIds = originalQueu |
| | 0 | 61 | | var existingByOriginalQueueItemId = existingItems.ToDictionary(x => x.OriginalQueueItemId); |
| | 0 | 62 | | var recordsToAdd = recordList.Where(x => !existingByOriginalQueueItemId.ContainsKey(x.OriginalQueueItemId)).ToLi |
| | | 63 | | |
| | 0 | 64 | | if (recordsToAdd.Count == 0) |
| | 0 | 65 | | return recordList.Select(x => existingByOriginalQueueItemId[x.OriginalQueueItemId]).ToList(); |
| | | 66 | | |
| | | 67 | | try |
| | | 68 | | { |
| | 0 | 69 | | await store.AddManyAsync(recordsToAdd, OnSaveAsync, cancellationToken); |
| | 0 | 70 | | } |
| | 0 | 71 | | catch (Exception ex) when (DbExceptionClassifier.IsDuplicateKey(ex)) |
| | | 72 | | { |
| | 0 | 73 | | return await AddOrGetExistingIndividuallyAsync(recordList, cancellationToken); |
| | | 74 | | } |
| | | 75 | | |
| | 0 | 76 | | return recordList.Select(x => existingByOriginalQueueItemId.GetValueOrDefault(x.OriginalQueueItemId) ?? x).ToLis |
| | 0 | 77 | | } |
| | | 78 | | |
| | | 79 | | /// <inheritdoc /> |
| | | 80 | | public async Task<BookmarkQueueDeadLetterItem?> TryMarkReplayedAsync(string id, string queueItemId, DateTimeOffset r |
| | | 81 | | { |
| | 0 | 82 | | await using var dbContext = await store.CreateDbContextAsync(cancellationToken); |
| | 0 | 83 | | var affectedRows = await dbContext.Set<BookmarkQueueDeadLetterItem>() |
| | 0 | 84 | | .Where(x => x.Id == id && x.CanReplay && x.ReplayedAt == null) |
| | 0 | 85 | | .ExecuteUpdateAsync( |
| | 0 | 86 | | setters => setters |
| | 0 | 87 | | .SetProperty(x => x.CanReplay, false) |
| | 0 | 88 | | .SetProperty(x => x.ReplayedAt, replayedAt) |
| | 0 | 89 | | .SetProperty(x => x.ReplayedQueueItemId, queueItemId), |
| | 0 | 90 | | cancellationToken); |
| | | 91 | | |
| | 0 | 92 | | if (affectedRows == 0) |
| | 0 | 93 | | return null; |
| | | 94 | | |
| | 0 | 95 | | var entity = await dbContext.Set<BookmarkQueueDeadLetterItem>().AsNoTracking().FirstOrDefaultAsync(x => x.Id == |
| | 0 | 96 | | if (entity == null) |
| | 0 | 97 | | return null; |
| | | 98 | | |
| | 0 | 99 | | await OnLoadAsync(dbContext, entity, cancellationToken); |
| | 0 | 100 | | return entity; |
| | 0 | 101 | | } |
| | | 102 | | |
| | | 103 | | /// <inheritdoc /> |
| | | 104 | | public Task<BookmarkQueueDeadLetterItem?> FindAsync(BookmarkQueueDeadLetterFilter filter, CancellationToken cancella |
| | | 105 | | { |
| | 0 | 106 | | return store.FindAsync(filter.Apply, OnLoadAsync, cancellationToken); |
| | | 107 | | } |
| | | 108 | | |
| | | 109 | | /// <inheritdoc /> |
| | | 110 | | public async Task<IEnumerable<BookmarkQueueDeadLetterItem>> FindManyAsync(BookmarkQueueDeadLetterFilter filter, Canc |
| | | 111 | | { |
| | 0 | 112 | | return await store.QueryAsync(filter.Apply, OnLoadAsync, filter.TenantAgnostic, cancellationToken); |
| | 0 | 113 | | } |
| | | 114 | | |
| | | 115 | | /// <inheritdoc /> |
| | | 116 | | public async Task<Page<BookmarkQueueDeadLetterItem>> PageAsync<TOrderBy>(PageArgs pageArgs, BookmarkQueueDeadLetterI |
| | | 117 | | { |
| | 0 | 118 | | var count = await store.QueryAsync(queryable => queryable, cancellationToken).LongCount(); |
| | 0 | 119 | | var results = await store.QueryAsync(queryable => queryable.OrderBy(orderBy).Paginate(pageArgs), OnLoadAsync, ca |
| | 0 | 120 | | return new(results, count); |
| | 0 | 121 | | } |
| | | 122 | | |
| | | 123 | | /// <inheritdoc /> |
| | | 124 | | public async Task<Page<BookmarkQueueDeadLetterItem>> PageAsync<TOrderBy>(PageArgs pageArgs, BookmarkQueueDeadLetterF |
| | | 125 | | { |
| | 0 | 126 | | var count = await store.QueryAsync(filter.Apply, filter.TenantAgnostic, cancellationToken).LongCount(); |
| | 0 | 127 | | var results = await store.QueryAsync(queryable => filter.Apply(queryable).OrderBy(orderBy).Paginate(pageArgs), O |
| | 0 | 128 | | return new(results, count); |
| | 0 | 129 | | } |
| | | 130 | | |
| | | 131 | | /// <inheritdoc /> |
| | | 132 | | public async Task<long> DeleteAsync(BookmarkQueueDeadLetterFilter filter, CancellationToken cancellationToken = defa |
| | | 133 | | { |
| | 0 | 134 | | return await store.DeleteWhereAsync(filter.Apply, cancellationToken); |
| | 0 | 135 | | } |
| | | 136 | | |
| | | 137 | | private async Task<IReadOnlyCollection<BookmarkQueueDeadLetterItem>> AddOrGetExistingIndividuallyAsync(IEnumerable<B |
| | | 138 | | { |
| | 0 | 139 | | var results = new List<BookmarkQueueDeadLetterItem>(); |
| | | 140 | | |
| | 0 | 141 | | foreach (var record in records) |
| | 0 | 142 | | results.Add(await AddOrGetExistingAsync(record, cancellationToken)); |
| | | 143 | | |
| | 0 | 144 | | return results; |
| | 0 | 145 | | } |
| | | 146 | | |
| | | 147 | | private ValueTask OnSaveAsync(RuntimeElsaDbContext dbContext, BookmarkQueueDeadLetterItem entity, CancellationToken |
| | | 148 | | { |
| | 0 | 149 | | dbContext.Entry(entity).Property("SerializedOptions").CurrentValue = entity.Options != null ? serializer.Seriali |
| | 0 | 150 | | return default; |
| | | 151 | | } |
| | | 152 | | |
| | | 153 | | private ValueTask OnLoadAsync(RuntimeElsaDbContext dbContext, BookmarkQueueDeadLetterItem? entity, CancellationToken |
| | | 154 | | { |
| | 0 | 155 | | if (entity is null) |
| | 0 | 156 | | return default; |
| | | 157 | | |
| | 0 | 158 | | var optionsJson = dbContext.Entry(entity).Property<string>("SerializedOptions").CurrentValue; |
| | 0 | 159 | | entity.Options = !string.IsNullOrEmpty(optionsJson) ? serializer.Deserialize<ResumeBookmarkOptions>(optionsJson) |
| | | 160 | | |
| | 0 | 161 | | return default; |
| | | 162 | | } |
| | | 163 | | } |