SPB Git

Repository Public

ProviderTests.swift 12.0 KB 223 lines swift

1import Foundation2import Testing3import SheetCore4import SheetUI5import Audit6@testable import FeatureAudit78@MainActor @Suite struct EffectsAdapterTests {9    func numbers() -> WorkbookSession {10        let s = Fixture.session()11        Fixture.fill(s, (1...20).map { [String($0), String($0 * 10), String($0 - 10)] })12        return s13    }1415    @Test func mapsStyleScaleBarAndIcon() throws {16        let s = numbers()      // column C holds -9…1017        var style = DiffStyle(bold: true, italic: nil, textColor: RGBA(hex: 0x112233), fill: RGBA(hex: 0xFFC7CE))18        style.strikethrough = true19        s.perform("rules") { e in20            e.editMeta(sheet: 0) { m in21                m.conditionalFormats = [22                    ConditionalFormat(ranges: [Fixture.rg("C1:C20")], kind: .cellIs(op: "equal", formulas: ["10"]), style: style, priority: 1),23                    RulePresets.rule(.colorScale, ranges: [Fixture.rg("C1:C20")], priority: 2),24                    RulePresets.rule(.dataBars, ranges: [Fixture.rg("C1:C20")], priority: 3),25                    ConditionalFormat(ranges: [Fixture.rg("C1:C20")], kind: .iconSet(name: "3Arrows", thresholds: RuleEditorModel.defaultThresholds(for: "3Arrows"), reversed: false), priority: 4),26                ]27            }28        }29        let f = ConditionalFormatter(engine: s.engine)30        let top = ConditionalEffectsAdapter.map(try #require(f.effect(sheet: 0, row: 19, col: 2)))31        #expect(top.fill == RGBA(hex: 0xFFC7CE))            // explicit fill wins over the scale32        #expect(top.textColor == RGBA(hex: 0x112233))33        #expect(top.bold == true && top.italic == nil && top.strikethrough == true)34        #expect(top.dataBarColor == RGBA(hex: 0x0891B2))35        #expect(abs((top.dataBarFraction ?? 0) - 10.0 / 19.0) < 1e-12)     // from the zero axis to the right edge36        #expect(top.icon == "arrow.up" && top.iconColor == IconSets.green)3738        let low = ConditionalEffectsAdapter.map(try #require(f.effect(sheet: 0, row: 0, col: 2)))39        #expect(low.fill == RGBA(hex: 0xF8696B))            // colour-scale minimum40        #expect(low.textColor == RGBA(hex: 0x0E1222))       // a fill without text colour gets a readable one41        #expect(ConditionalEffectsAdapter.readableText(on: RGBA(hex: 0x10131F)) == .white)42        #expect(ConditionalEffectsAdapter.readableText(on: RGBA(hex: 0xFFEB84)) == RGBA(hex: 0x0E1222))43        #expect(low.bold == nil)44        #expect(abs((low.dataBarFraction ?? 0) - 9.0 / 19.0) < 1e-12 && low.dataBarColor == IconSets.red)   // negative bar45        #expect(low.icon == "arrow.down" && low.iconColor == IconSets.red)46    }4748    @Test func iconSetsCoverEveryDeclaredSize() {49        for name in IconSets.names {50            let icons = IconSets.icons(for: name)51            #expect(icons.count == IconSets.count(of: name), "\(name)")52            #expect(icons.allSatisfy { !$0.symbol.isEmpty })53        }54        #expect(IconSets.icons(for: "4Unknown").count == 4)55        #expect(IconSets.icon(set: "3Arrows", index: 9).symbol == "arrow.up")56    }5758    @Test func producesEffectsForVisibleRangeAndCachesRows() {59        let s = numbers()60        s.perform("rules") { e in61            e.editMeta(sheet: 0) { m in62                m.conditionalFormats = [63                    ConditionalFormat(ranges: [Fixture.rg("A1:A20")], kind: .cellIs(op: "greaterThan", formulas: ["15"]), style: RulePresets.redStyle, priority: 1),64                    RulePresets.rule(.dataBars, ranges: [Fixture.rg("B1:B20")], priority: 2),65                    RulePresets.rule(.iconSet, ranges: [Fixture.rg("C1:C20")], priority: 3),66                ]67            }68        }69        let adapter = ConditionalEffectsAdapter()70        let fx = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)71        #expect(fx[CellRef(a1: "A16")!]?.fill == RulePresets.redStyle.fill)72        #expect(fx[CellRef(a1: "A15")!] == nil)73        #expect(fx[CellRef(a1: "B20")!]?.dataBarFraction == 1)74        #expect(fx[CellRef(a1: "C1")!]?.icon == "circle.fill" && fx[CellRef(a1: "C1")!]?.iconColor == IconSets.red)75        #expect(fx[CellRef(a1: "C20")!]?.iconColor == IconSets.green)7677        let resolved = adapter.resolvedCells78        let again = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A5:C12"), revision: s.contentRevision)79        #expect(adapter.resolvedCells == resolved)          // served from the row cache80        #expect(again.count == 16 && again.keys.allSatisfy { $0.row >= 4 && $0.row <= 11 })8182        // an edit invalidates: A1 now exceeds the threshold83        s.perform("edit") { $0.set(sheet: 0, row: 0, col: 0, .value(.number(99))) }84        let after = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)85        #expect(after[CellRef(a1: "A1")!]?.fill == RulePresets.redStyle.fill)86        #expect(adapter.resolvedCells > resolved)87        s.undo()88        let undone = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)89        #expect(undone[CellRef(a1: "A1")!] == nil)90    }9192    @Test func noRulesNoWork() {93        let s = numbers()94        let adapter = ConditionalEffectsAdapter()95        #expect(adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: 1).isEmpty)96        #expect(adapter.resolvedCells == 0)97        #expect(adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 7, range: Fixture.rg("A1"), revision: 1).isEmpty)98    }99}100101@MainActor @Suite struct ValidationAdapterTests {102    func session() -> WorkbookSession {103        let s = Fixture.session()104        Fixture.fill(s, at: "H1", [["Red"], ["Green"], ["Blue"]])105        s.perform("rules") { e in106            e.editMeta(sheet: 0) { m in107                var whole = DataValidation(ranges: [Fixture.rg("A1:A10")], kind: .whole, op: "between", formula1: "1", formula2: "10")108                whole.errorTitle = "Out of range"; whole.errorMessage = "1 to 10 only"109                var warn = DataValidation(ranges: [Fixture.rg("B1:B10")], kind: .decimal, op: "greaterThan", formula1: "0")110                warn.errorStyle = "warning"111                var info = DataValidation(ranges: [Fixture.rg("C1:C10")], kind: .textLength, op: "lessThanOrEqual", formula1: "3")112                info.errorStyle = "information"113                let list = DataValidation(ranges: [Fixture.rg("D1:D10")], kind: .list, formula1: "\"Yes,No,Maybe\"")114                let fromRange = DataValidation(ranges: [Fixture.rg("E1:E10")], kind: .list, formula1: "$H$1:$H$3")115                m.validations = [whole, warn, info, list, fromRange]116            }117        }118        return s119    }120121    func outcome(_ s: WorkbookSession, _ a1: String, _ input: String) -> SheetUI.ValidationOutcome {122        SessionRegistry.shared.note(s)123        return ValidationAdapter().validate(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: a1)!, input: input)124    }125126    @Test func stopRulesBlock() {127        let s = session()128        guard case .ok = outcome(s, "A1", "5") else { Issue.record("5 should be valid"); return }129        guard case .invalid(let title, let message, let blocking) = outcome(s, "A1", "11") else { Issue.record("11 should be invalid"); return }130        #expect(title == "Out of range" && message == "1 to 10 only" && blocking)131        guard case .invalid(_, _, let b2) = outcome(s, "A2", "2.5") else { Issue.record("2.5 is not whole"); return }132        #expect(b2)133        guard case .invalid(_, _, let b3) = outcome(s, "D1", "Perhaps") else { Issue.record("not in list"); return }134        #expect(b3)135        guard case .ok = outcome(s, "D1", "Maybe") else { Issue.record("in list"); return }136        guard case .ok = outcome(s, "Z9", "anything") else { Issue.record("no rule"); return }137    }138139    @Test func warningAndInformationDoNotBlockAndReachTheStatusLine() {140        let s = session()141        s.statusMessage = nil142        guard case .invalid(_, _, let blocking) = outcome(s, "B1", "-4") else { Issue.record("-4 violates > 0"); return }143        #expect(!blocking)144        #expect(s.statusMessage?.isEmpty == false)145        guard case .invalid(_, _, let b2) = outcome(s, "C1", "toolong") else { Issue.record("length"); return }146        #expect(!b2)147        // the session accepts the entry148        s.select(cell: CellRef(a1: "B1")!)149        s.beginEdit(text: "-4")150        #expect(s.commitEdit(move: nil))151        #expect(Fixture.value(s, "B1") == .number(-4))152        // and refuses a blocked one153        Workspace.shared.validator = ValidationAdapter()154        s.select(cell: CellRef(a1: "A1")!)155        s.beginEdit(text: "50")156        #expect(!s.commitEdit(move: nil))157        s.cancelEdit()158        #expect(Fixture.value(s, "A1") == .blank)159    }160161    @Test func dropdownItems() {162        let s = session()163        let v = ValidationAdapter()164        #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "D3")!) == ["Yes", "No", "Maybe"])165        #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "E3")!) == ["Red", "Green", "Blue"])166        #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "A1")!) == nil)167        ValidationActions.choose("Green", for: CellRef(a1: "E3")!, in: s)168        #expect(Fixture.value(s, "E3") == .text("Green"))169        s.undo()170        #expect(Fixture.value(s, "E3") == .blank)171    }172}173174@MainActor @Suite struct AssistAdapterTests {175    func workbook() -> Workbook {176        let s = Fixture.sales()177        s.perform("meta") { e in178            e.setDefinedName(DefinedName(name: "SalesTax", formula: "Sales!$A$1"))179            _ = try? TableActions.create(engine: e, sheet: 0, range: Fixture.rg("A1:D7"), options: .init(name: "SalesData"))180        }181        return s.workbook182    }183184    @Test func completesFunctionsWithCategoryNamesTablesAndSheets() throws {185        let wb = workbook()186        let a = try #require(AssistAdapter.assist(text: "=SU", cursor: 3, workbook: wb))187        #expect(a.replaceStart == 1 && a.replaceLength == 2)188        let sum = try #require(a.candidates.first { $0.text == "SUM" })189        #expect(sum.kind == "function" && sum.detail.contains("Math"))190191        let b = try #require(AssistAdapter.assist(text: "=1+Sal", cursor: 6, workbook: wb))192        #expect(b.candidates.contains { $0.kind == "name" && $0.text == "SalesTax" })193        #expect(b.candidates.contains { $0.kind == "table" && $0.text == "SalesData" })194        #expect(b.candidates.contains { $0.kind == "sheet" && $0.text == "Sales!" })195196        let c = try #require(AssistAdapter.assist(text: "=SUM(SalesData[Re", cursor: 17, workbook: wb))197        #expect(c.candidates.map(\.text) == ["Region]", "Revenue]"])198        #expect(c.replaceLength == 2)199    }200201    @Test func specialFormsAreOfferedAndExplained() throws {202        for name in ["IF", "IFS", "IFERROR", "IFNA", "SWITCH", "CHOOSE", "LET", "LAMBDA"] {203            let text = "=" + name204            let a = try #require(AssistAdapter.assist(text: text, cursor: text.utf16.count, workbook: nil, limit: 200), "\(name)")205            #expect(a.candidates.contains { $0.text == name && $0.kind == "function" }, "\(name)")206            let call = text + "("207            let sig = try #require(AssistAdapter.assist(text: call, cursor: call.utf16.count, workbook: nil), "\(name)")208            #expect(sig.signature?.hasPrefix(name + "(") == true, "\(name)")209            #expect(sig.argumentIndex == 0)210        }211    }212213    @Test func signatureFollowsTheActiveArgument() throws {214        let text = "=IF(A1>2,\"yes\","215        let a = try #require(AssistAdapter.assist(text: text, cursor: text.utf16.count, workbook: nil))216        #expect(a.signature == "IF(condition, value_if_true, [value_if_false])")217        #expect(a.argumentIndex == 2)218        #expect(a.summary?.isEmpty == false)219        #expect(AssistAdapter.assist(text: "=\"SU", cursor: 4, workbook: nil) == nil)       // inside a string220        #expect(AssistAdapter.assist(text: "=1+2", cursor: 4, workbook: nil) == nil)221    }222}223
Files main
Menu

Theme