Crossmate/Persistence/ChronicleLedger.swift (5253B)
1import CoreData
2import Foundation
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17extension ChronicleLedgerEntity {
18
19
20
21 static func upsert(
22 originalGameID: UUID,
23 publisher: String?,
24 puzzleDate: Date?,
25 participants: String?,
26 in ctx: NSManagedObjectContext
27 ) {
28
29
30
31
32 let entity = existing(originalGameID: originalGameID, in: ctx)
33 ?? ChronicleLedgerEntity(context: ctx)
34 entity.originalGameID = originalGameID
35 entity.publisher = publisher
36 entity.puzzleDate = puzzleDate
37 entity.participants = participants
38 }
39
40 static func remove(originalGameID: UUID, in ctx: NSManagedObjectContext) {
41 guard let entity = existing(originalGameID: originalGameID, in: ctx) else { return }
42 ctx.delete(entity)
43 }
44
45
46
47 static func knownOriginalGameIDs(in ctx: NSManagedObjectContext) -> Set<UUID> {
48 let request = NSFetchRequest<NSDictionary>(entityName: "ChronicleLedgerEntity")
49 request.resultType = .dictionaryResultType
50 request.propertiesToFetch = ["originalGameID"]
51 let rows = (try? ctx.fetch(request)) ?? []
52 return Set(rows.compactMap { $0["originalGameID"] as? UUID })
53 }
54
55
56
57
58 @discardableResult
59 static func retainOnly(
60 _ originalGameIDs: Set<UUID>,
61 in ctx: NSManagedObjectContext
62 ) -> Int {
63 let request = NSFetchRequest<ChronicleLedgerEntity>(entityName: "ChronicleLedgerEntity")
64 var removed = 0
65 for entity in (try? ctx.fetch(request)) ?? [] {
66 guard let id = entity.originalGameID, !originalGameIDs.contains(id) else { continue }
67 ctx.delete(entity)
68 removed += 1
69 }
70 return removed
71 }
72
73
74
75
76
77 static func puzzleDates(
78 publisher: String,
79 blockedAuthorIDs: Set<String>,
80 in ctx: NSManagedObjectContext
81 ) -> [Date] {
82 let request = NSFetchRequest<NSDictionary>(entityName: "ChronicleLedgerEntity")
83 request.resultType = .dictionaryResultType
84 request.propertiesToFetch = ["puzzleDate", "participants"]
85 request.predicate = NSPredicate(
86 format: "publisher == %@ AND puzzleDate != nil",
87 publisher
88 )
89 let rows = (try? ctx.fetch(request)) ?? []
90 return rows.compactMap { row in
91 guard let date = row["puzzleDate"] as? Date else { return nil }
92 let participants = (row["participants"] as? String)
93 .map(Self.participantAuthorIDs) ?? []
94 guard blockedAuthorIDs.isDisjoint(with: participants) else { return nil }
95 return date
96 }
97 }
98
99
100
101 static func participantAuthorIDs(_ stored: String) -> Set<String> {
102 Set(stored.split(separator: ",").map(String.init).filter { !$0.isEmpty })
103 }
104
105 private static func existing(
106 originalGameID: UUID,
107 in ctx: NSManagedObjectContext
108 ) -> ChronicleLedgerEntity? {
109 let request = NSFetchRequest<ChronicleLedgerEntity>(entityName: "ChronicleLedgerEntity")
110 request.predicate = NSPredicate(format: "originalGameID == %@", originalGameID as CVarArg)
111 request.fetchLimit = 1
112 return try? ctx.fetch(request).first
113 }
114}