| | | 1 | | using Elsa.AI.Abstractions.Models; |
| | | 2 | | using Elsa.AI.Persistence.EFCore.Entities; |
| | | 3 | | using Microsoft.EntityFrameworkCore; |
| | | 4 | | |
| | | 5 | | namespace Elsa.AI.Persistence.EFCore.Services; |
| | | 6 | | |
| | | 7 | | public static class EFCoreAIConversationCleanup |
| | | 8 | | { |
| | | 9 | | public static async ValueTask<int> DeleteExpiredAsync(AIDbContext dbContext, DateTimeOffset now, CancellationToken c |
| | | 10 | | { |
| | 1 | 11 | | var ephemeralRetentionMode = AIRetentionMode.Ephemeral.ToString(); |
| | 1 | 12 | | var configuredRetentionMode = AIRetentionMode.Configured.ToString(); |
| | 1 | 13 | | var completedStatus = AIConversationStatus.Completed.ToString(); |
| | 1 | 14 | | var failedStatus = AIConversationStatus.Failed.ToString(); |
| | | 15 | | |
| | 1 | 16 | | var deletedEphemeral = await dbContext.Conversations |
| | 1 | 17 | | .Where(x => x.RetentionMode == ephemeralRetentionMode && (x.Status == completedStatus || x.Status == failedS |
| | 1 | 18 | | .ExecuteDeleteAsync(cancellationToken); |
| | | 19 | | |
| | 1 | 20 | | var deletedConfigured = await DeleteExpiredConfiguredAsync(dbContext, configuredRetentionMode, now, cancellation |
| | | 21 | | |
| | 1 | 22 | | return deletedEphemeral + deletedConfigured; |
| | 1 | 23 | | } |
| | | 24 | | |
| | | 25 | | private static async ValueTask<int> DeleteExpiredConfiguredAsync(AIDbContext dbContext, string configuredRetentionMo |
| | | 26 | | { |
| | 1 | 27 | | if (IsSqliteProvider(dbContext.Database.ProviderName)) |
| | | 28 | | { |
| | | 29 | | // EF Core SQLite cannot translate this DateTimeOffset predicate in ExecuteDeleteAsync for this model. |
| | 1 | 30 | | var tableName = ResolveConversationTableName(dbContext); |
| | 1 | 31 | | var sql = $@"DELETE FROM {QuoteSqliteIdentifier(tableName)} |
| | 1 | 32 | | WHERE ""RetentionMode"" = {{0}} |
| | 1 | 33 | | AND ""RetentionExpiresAt"" IS NOT NULL |
| | 1 | 34 | | AND ""RetentionExpiresAt"" <= {{1}}"; |
| | 1 | 35 | | return await dbContext.Database.ExecuteSqlRawAsync( |
| | 1 | 36 | | sql, |
| | 1 | 37 | | [configuredRetentionMode, now], |
| | 1 | 38 | | cancellationToken); |
| | | 39 | | } |
| | | 40 | | |
| | 0 | 41 | | return await dbContext.Conversations |
| | 0 | 42 | | .Where(x => x.RetentionMode == configuredRetentionMode && x.RetentionExpiresAt != null && x.RetentionExpires |
| | 0 | 43 | | .ExecuteDeleteAsync(cancellationToken); |
| | 1 | 44 | | } |
| | | 45 | | |
| | | 46 | | private static string ResolveConversationTableName(AIDbContext dbContext) |
| | | 47 | | { |
| | 1 | 48 | | var entityType = dbContext.Model.FindEntityType(typeof(AIConversationRecord)) ?? throw new InvalidOperationExcep |
| | 1 | 49 | | return entityType.GetTableName() ?? throw new InvalidOperationException("AI conversation table metadata was not |
| | | 50 | | } |
| | | 51 | | |
| | | 52 | | private static bool IsSqliteProvider(string? providerName) => |
| | 1 | 53 | | providerName?.Contains("Sqlite", StringComparison.OrdinalIgnoreCase) == true; |
| | | 54 | | |
| | 1 | 55 | | private static string QuoteSqliteIdentifier(string identifier) => $"\"{identifier.Replace("\"", "\"\"", StringCompar |
| | | 56 | | } |