| | | 1 | | using System.IO.Compression; |
| | | 2 | | using Chronicis.Api.Data; |
| | | 3 | | using Chronicis.Shared.Enums; |
| | | 4 | | using Chronicis.Shared.Models; |
| | | 5 | | using Microsoft.EntityFrameworkCore; |
| | | 6 | | |
| | | 7 | | namespace Chronicis.Api.Services; |
| | | 8 | | |
| | | 9 | | /// <summary> |
| | | 10 | | /// Service for exporting world data to downloadable archives |
| | | 11 | | /// </summary> |
| | | 12 | | public sealed partial class ExportService : IExportService |
| | | 13 | | { |
| | | 14 | | private readonly ChronicisDbContext _db; |
| | | 15 | | private readonly IWorldMembershipService _membershipService; |
| | | 16 | | private readonly ILogger<ExportService> _logger; |
| | | 17 | | |
| | | 18 | | public ExportService( |
| | | 19 | | ChronicisDbContext db, |
| | | 20 | | IWorldMembershipService membershipService, |
| | | 21 | | ILogger<ExportService> logger) |
| | | 22 | | { |
| | 21 | 23 | | _db = db; |
| | 21 | 24 | | _membershipService = membershipService; |
| | 21 | 25 | | _logger = logger; |
| | 21 | 26 | | } |
| | | 27 | | |
| | | 28 | | public async Task<byte[]?> ExportWorldToMarkdownAsync(Guid worldId, Guid userId) |
| | | 29 | | { |
| | | 30 | | // Verify user has access to the world |
| | | 31 | | if (!await _membershipService.UserHasAccessAsync(worldId, userId)) |
| | | 32 | | { |
| | | 33 | | _logger.LogWarningSanitized("User {UserId} attempted to export world {WorldId} without access", userId, worl |
| | | 34 | | return null; |
| | | 35 | | } |
| | | 36 | | |
| | | 37 | | var world = await _db.Worlds |
| | | 38 | | .AsNoTracking() |
| | | 39 | | .FirstOrDefaultAsync(w => w.Id == worldId); |
| | | 40 | | |
| | | 41 | | if (world == null) |
| | | 42 | | { |
| | | 43 | | _logger.LogWarningSanitized("World {WorldId} not found for export", worldId); |
| | | 44 | | return null; |
| | | 45 | | } |
| | | 46 | | |
| | | 47 | | _logger.LogTraceSanitized("Starting export of world {WorldId} ({WorldName}) for user {UserId}", |
| | | 48 | | worldId, world.Name, userId); |
| | | 49 | | |
| | | 50 | | // Get all articles for this world with their hierarchy info |
| | | 51 | | var articles = await _db.Articles |
| | | 52 | | .AsNoTracking() |
| | | 53 | | .Where(a => a.WorldId == worldId) |
| | | 54 | | .OrderBy(a => a.Title) |
| | | 55 | | .ToListAsync(); |
| | | 56 | | |
| | | 57 | | // Get campaigns and arcs for building folder structure |
| | | 58 | | var campaigns = await _db.Campaigns |
| | | 59 | | .AsNoTracking() |
| | | 60 | | .Where(c => c.WorldId == worldId) |
| | | 61 | | .ToListAsync(); |
| | | 62 | | |
| | | 63 | | var arcs = await _db.Arcs |
| | | 64 | | .AsNoTracking() |
| | | 65 | | .Where(a => campaigns.Select(c => c.Id).Contains(a.CampaignId)) |
| | | 66 | | .ToListAsync(); |
| | | 67 | | |
| | | 68 | | var arcIds = arcs.Select(a => a.Id).ToList(); |
| | | 69 | | var sessionEntities = await _db.Sessions |
| | | 70 | | .AsNoTracking() |
| | | 71 | | .Where(s => arcIds.Contains(s.ArcId)) |
| | | 72 | | .ToListAsync(); |
| | | 73 | | |
| | | 74 | | // Pre-build lookups so hierarchy traversal and session-note resolution are O(1) |
| | | 75 | | // instead of O(N) per article/session, avoiding O(N²) behaviour on large worlds. |
| | | 76 | | var wikiByParent = articles |
| | | 77 | | .Where(a => a.Type == ArticleType.WikiArticle || a.Type == ArticleType.Legacy) |
| | | 78 | | .ToLookup(a => a.ParentId); |
| | | 79 | | var charactersByParent = articles |
| | | 80 | | .Where(a => a.Type == ArticleType.Character) |
| | | 81 | | .ToLookup(a => a.ParentId); |
| | | 82 | | var sessionNotesBySession = articles |
| | | 83 | | .Where(a => a.Type == ArticleType.SessionNote) |
| | | 84 | | .ToLookup(a => a.SessionId); |
| | | 85 | | var sessionsByArc = sessionEntities |
| | | 86 | | .ToLookup(s => s.ArcId); |
| | | 87 | | |
| | | 88 | | // Build the zip archive |
| | | 89 | | using var memoryStream = new MemoryStream(); |
| | | 90 | | using (var archive = new ZipArchive(memoryStream, ZipArchiveMode.Create, true)) |
| | | 91 | | { |
| | | 92 | | var worldFolderName = SanitizeFileName(world.Name); |
| | | 93 | | |
| | | 94 | | // Export wiki articles (hierarchical) |
| | | 95 | | await ExportArticleHierarchy(archive, wikiByParent, $"{worldFolderName}/Wiki", null); |
| | | 96 | | |
| | | 97 | | // Export characters |
| | | 98 | | await ExportArticleHierarchy(archive, charactersByParent, $"{worldFolderName}/Characters", null); |
| | | 99 | | |
| | | 100 | | // Export campaigns with their sessions |
| | | 101 | | var usedCampaignNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 102 | | foreach (var campaign in campaigns) |
| | | 103 | | { |
| | | 104 | | var campaignFolderName = GetUniqueSiblingName(campaign.Name, usedCampaignNames); |
| | | 105 | | var campaignFolder = $"{worldFolderName}/Campaigns/{campaignFolderName}"; |
| | | 106 | | |
| | | 107 | | // Campaign info file |
| | | 108 | | var campaignContent = BuildCampaignMarkdown(campaign); |
| | | 109 | | await AddFileToArchive(archive, $"{campaignFolder}/{campaignFolderName}.md", campaignContent); |
| | | 110 | | |
| | | 111 | | // Export arcs and sessions |
| | | 112 | | var campaignArcs = arcs.Where(a => a.CampaignId == campaign.Id).OrderBy(a => a.SortOrder).ToList(); |
| | | 113 | | var usedArcNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 114 | | foreach (var arc in campaignArcs) |
| | | 115 | | { |
| | | 116 | | var arcFolderName = GetUniqueSiblingName(arc.Name, usedArcNames); |
| | | 117 | | var arcFolder = $"{campaignFolder}/{arcFolderName}"; |
| | | 118 | | |
| | | 119 | | // Arc info file |
| | | 120 | | var arcContent = BuildArcMarkdown(arc); |
| | | 121 | | await AddFileToArchive(archive, $"{arcFolder}/{arcFolderName}.md", arcContent); |
| | | 122 | | |
| | | 123 | | // Session entities in this arc |
| | | 124 | | var arcSessions = sessionsByArc[arc.Id] |
| | | 125 | | .OrderBy(s => s.SessionDate ?? s.CreatedAt) |
| | | 126 | | .ThenBy(s => s.Name) |
| | | 127 | | .ToList(); |
| | | 128 | | |
| | | 129 | | var usedSessionFolderNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 130 | | foreach (var session in arcSessions) |
| | | 131 | | { |
| | | 132 | | var sessionFolderName = GetUniqueSiblingName(session.Name, usedSessionFolderNames); |
| | | 133 | | var sessionContent = BuildSessionMarkdown(session); |
| | | 134 | | await AddFileToArchive(archive, $"{arcFolder}/{sessionFolderName}/{sessionFolderName}.md", sessi |
| | | 135 | | |
| | | 136 | | // Session notes: O(1) lookup instead of O(articles) scan |
| | | 137 | | var sessionNotes = sessionNotesBySession[session.Id] |
| | | 138 | | .OrderBy(a => a.CreatedAt) |
| | | 139 | | .ThenBy(a => a.Title) |
| | | 140 | | .ToList(); |
| | | 141 | | |
| | | 142 | | var usedSessionNoteNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 143 | | foreach (var note in sessionNotes) |
| | | 144 | | { |
| | | 145 | | var noteContent = BuildArticleMarkdown(note); |
| | | 146 | | var noteFileName = GetUniqueSiblingName(note.Title, usedSessionNoteNames); |
| | | 147 | | await AddFileToArchive(archive, $"{arcFolder}/{sessionFolderName}/{noteFileName}.md", noteCo |
| | | 148 | | } |
| | | 149 | | } |
| | | 150 | | } |
| | | 151 | | } |
| | | 152 | | } |
| | | 153 | | |
| | | 154 | | memoryStream.Position = 0; |
| | | 155 | | var result = memoryStream.ToArray(); |
| | | 156 | | |
| | | 157 | | _logger.LogTraceSanitized("Export completed for world {WorldId}. Archive size: {Size} bytes", |
| | | 158 | | worldId, result.Length); |
| | | 159 | | |
| | | 160 | | return result; |
| | | 161 | | } |
| | | 162 | | |
| | | 163 | | private async Task ExportArticleHierarchy( |
| | | 164 | | ZipArchive archive, |
| | | 165 | | ILookup<Guid?, Article> byParent, |
| | | 166 | | string basePath, |
| | | 167 | | Guid? parentId) |
| | | 168 | | { |
| | | 169 | | var children = byParent[parentId].OrderBy(a => a.Title); |
| | | 170 | | var usedSiblingNames = new HashSet<string>(StringComparer.OrdinalIgnoreCase); |
| | | 171 | | |
| | | 172 | | foreach (var article in children) |
| | | 173 | | { |
| | | 174 | | var articleFileName = GetUniqueSiblingName(article.Title, usedSiblingNames); |
| | | 175 | | var hasChildren = byParent[article.Id].Any(); |
| | | 176 | | |
| | | 177 | | if (hasChildren) |
| | | 178 | | { |
| | | 179 | | // Article with children: ArticleName/ArticleName.md |
| | | 180 | | var articleFolder = $"{basePath}/{articleFileName}"; |
| | | 181 | | var content = BuildArticleMarkdown(article); |
| | | 182 | | await AddFileToArchive(archive, $"{articleFolder}/{articleFileName}.md", content); |
| | | 183 | | |
| | | 184 | | // Recursively export children |
| | | 185 | | await ExportArticleHierarchy(archive, byParent, articleFolder, article.Id); |
| | | 186 | | } |
| | | 187 | | else |
| | | 188 | | { |
| | | 189 | | // Leaf article: ArticleName.md |
| | | 190 | | var content = BuildArticleMarkdown(article); |
| | | 191 | | await AddFileToArchive(archive, $"{basePath}/{articleFileName}.md", content); |
| | | 192 | | } |
| | | 193 | | } |
| | | 194 | | } |
| | | 195 | | |
| | | 196 | | } |