SPB Git

Repository Public

CoreTests.swift 12.8 KB 235 lines swift

1import AppKit2import Foundation3import Testing4import SheetCore5import SheetCharts6import SheetUI7@testable import FeatureCharts89@MainActor @Suite struct DetectionTests {10    @Test func automaticDetection() {11        let s = makeSession()12        let d = detection(s, "A1:D7")13        #expect(d.firstRowIsHeader && d.firstColumnIsCategories && !d.seriesInRows && d.isAutomatic)14        #expect(d.dataRange == RangeRef(a1: "B2:D7")!)15        #expect(d.seriesCount == 3)16        let spec = ChartBuilder.spec(.column, d)17        #expect(spec.series.count == 3)18        #expect(rangeText(spec.categories) == "Data!A2:A7")19        #expect(rangeText(spec.series[0].values) == "Data!B2:B7" && rangeText(spec.series[0].nameRef) == "Data!B1")20        #expect(rangeText(spec.series[2].values) == "Data!D2:D7")21        #expect(spec.xAxis.title == "Month")22    }2324    @Test func switchesChangeTheBinding() {25        let s = makeSession()26        var d = detection(s, "B1:D7")27        d.firstRowIsHeader = false28        #expect(!d.isAutomatic)29        var spec = ChartBuilder.spec(.line, d)30        #expect(rangeText(spec.series[0].values) == "Data!B1:B7" && spec.series[0].nameRef == nil)31        d = detection(s, "A1:D7")32        d.seriesInRows = true33        spec = ChartBuilder.spec(.line, d)34        #expect(spec.series.count == 6)35        #expect(rangeText(spec.series[0].values) == "Data!B2:D2" && rangeText(spec.series[0].nameRef) == "Data!A2")36        #expect(rangeText(spec.categories) == "Data!B1:D1")37        d = detection(s, "A1:D7")38        d.firstColumnIsCategories = false39        spec = ChartBuilder.spec(.column, d)40        #expect(spec.categories == nil && spec.series.count == 3)      // the text column is never a series41        #expect(!ChartBuilder.suggestions(d, area: AreaRef(sheet: 0, range: d.range), in: s.workbook).isEmpty)42    }4344    @Test func kindSpecificBindings() {45        let s = makeSession()46        let d = detection(s, "B1:D7")47        let scatter = ChartBuilder.spec(.scatter, d)48        #expect(scatter.series.count == 2 && rangeText(scatter.series[0].x) == "Data!B2:B7" && rangeText(scatter.series[0].values) == "Data!C2:C7")49        let bubble = ChartBuilder.spec(.bubble, d)50        #expect(bubble.series.count == 1 && rangeText(bubble.series[0].size) == "Data!D2:D7")51        let heat = ChartBuilder.spec(.heatmap, detection(s, "A1:D7"))52        #expect(heat.series.count == 1 && rangeText(heat.series[0].values) == "Data!B2:D7")53        #expect(rangeText(heat.categories) == "Data!B1:D1" && rangeText(heat.rowLabels) == "Data!A2:A7")54        let pie = ChartBuilder.spec(.pie, detection(s, "A1:D7"))55        #expect(pie.series.count == 1 && rangeText(pie.categories) == "Data!A2:A7")56        let hist = ChartBuilder.spec(.histogram, detection(s, "A1:D7"))57        #expect(hist.categories == nil && hist.series.count == 3)58        let candle = ChartBuilder.spec(.candlestick, detection(s, "A1:E7"))59        #expect(candle.series.count == 1 && candle.series[0].open != nil && candle.series[0].close != nil)60        for kind in ChartKind.allCases { #expect(ChartBuilder.spec(kind, detection(s, "A1:E7")).kind == kind) }61        #expect(ChartFamily.allCases.flatMap(\.kinds).count == 21 && Set(ChartFamily.allCases.flatMap(\.kinds)).count == 21)62    }6364    @Test func rangeTextRoundTrip() {65        let s = makeSession()66        let wb = s.workbook67        #expect(ChartFormat.parse("B2:B7", currentSheet: "Data", workbook: wb) == .ref(.range(sheet: "Data", range: RangeRef(a1: "B2:B7")!)))68        #expect(ChartFormat.parse("other!$A$1:$A$3", currentSheet: "Data", workbook: wb) == .ref(.range(sheet: "Other", range: RangeRef(a1: "A1:A3")!)))69        #expect(ChartFormat.parse("Nope!A1", currentSheet: "Data", workbook: wb) == .invalid)70        #expect(ChartFormat.parse("hello world", currentSheet: "Data", workbook: wb) == .invalid)71        #expect(ChartFormat.parse("  ", currentSheet: "Data", workbook: wb) == .empty)72        let lit = DataRef.literal([1, 2.5, 3])73        #expect(ChartFormat.parse(ChartFormat.text(lit, currentSheet: "Data"), currentSheet: "Data", workbook: wb) == .ref(lit))74        let labels = DataRef.labels(["a", "b; c", "say \"hi\""])75        #expect(ChartFormat.parse(ChartFormat.text(labels, currentSheet: "Data"), currentSheet: "Data", workbook: wb) == .ref(labels))76        _ = wb.addSheet(named: "My Sheet")77        let quoted = DataRef.range(sheet: "My Sheet", range: RangeRef(a1: "C3:D9")!)78        #expect(ChartFormat.text(quoted, currentSheet: "Data") == "'My Sheet'!C3:D9")79        #expect(ChartFormat.parse("'My Sheet'!C3:D9", currentSheet: "Data", workbook: wb) == .ref(quoted))80        #expect(ChartFormat.text(.range(sheet: "Data", range: RangeRef(a1: "A1")!), currentSheet: "data") == "A1")81        let f = ChartFormat.formatter(locale: .enUS)82        #expect(f(1234.5, "#,##0.00") == "1,234.50" && f(0.256, "0%") == "26%" && f(3, "") == nil && f(3, "General") == nil)83        #expect(ChartFormat.display(nil) == "—")84    }85}8687@MainActor @Suite struct InsertionTests {88    @Test func insertCreatesBoundObject() throws {89        let s = makeSession()90        s.select(RangeRef(a1: "A1:D7")!)91        let model = ChartPickerModel(session: s)92        #expect(model.detection?.seriesCount == 3)93        #expect(model.suggested.first?.spec.kind == .column)94        #expect(model.families.count == 7 && model.families.flatMap(\.items).count == 21)95        #expect(model.canInsert)96        let object = try #require(model.insert())97        #expect(object.kind == "chart" && s.selectedObjectID == object.id && s.inspectorPane == ChartsFeature.inspectorPaneID)98        #expect(s.sheet.meta.objects.count == 1)99        let origin = s.suggestedObjectOrigin()100        #expect(object.x == Double(origin.x) && object.y == Double(origin.y) && object.width >= 300 && object.height >= 200)101        let spec = try #require(ChartPayload.chart(object)?.spec)102        #expect(spec.id == object.id)103        #expect(Set(spec.referencedRanges.map { $0.sheet + "!" + $0.range.a1 }) == ["Data!A2:A7", "Data!B1", "Data!B2:B7", "Data!C1", "Data!C2:C7", "Data!D1", "Data!D2:D7"])104        s.undo()105        #expect(s.sheet.meta.objects.isEmpty)106        s.redo()107        #expect(s.sheet.meta.objects.count == 1)108    }109110    @Test func quickInsertUsesCurrentRegion() throws {111        let s = makeSession()112        s.select(cell: CellRef(a1: "C4")!)113        let object = try #require(ChartInsertion.quickInsert(.line, in: s))114        let spec = try #require(ChartPayload.chart(object)?.spec)115        #expect(spec.kind == .line && spec.series.count == 4)          // A1:E7 → four numeric columns116        let second = try #require(ChartInsertion.quickInsert(.line, in: s))117        #expect(second.name != object.name)118        s.select(cell: CellRef(a1: "M40")!)119        #expect(ChartInsertion.quickInsert(.pie, in: s) == nil)120        #expect(s.statusMessage != nil)121    }122123    @Test func pickerSwitchesRebuildCandidates() {124        let s = makeSession()125        s.select(RangeRef(a1: "A1:D7")!)126        let model = ChartPickerModel(session: s)127        model.seriesInRows = true128        #expect(model.detection?.seriesCount == 6)129        #expect(model.selected?.spec.series.count == 6)130        model.firstRowIsHeader = false131        #expect(model.detection?.dataRange.r0 == 0)132        // samples stand in for kinds the selection cannot feed, and cannot be inserted133        let empty = makeSession()134        empty.select(cell: CellRef(a1: "M40")!)135        let none = ChartPickerModel(session: empty)136        #expect(none.detection == nil && !none.canInsert && none.families.flatMap(\.items).allSatisfy(\.isSample))137    }138139    @Test func pinThemePayload() throws {140        var spec = ChartSpec(kind: .line, title: "T", series: [SeriesSpec(name: "a", values: .literal([1, 2, 3]))])141        spec.theme = .publication142        let plain = try #require(ChartPayload.encode(ChartValue(spec: spec)))143        let pinned = try #require(ChartPayload.encode(ChartValue(spec: spec, pinTheme: true)))144        #expect(ChartPayload.decode(plain) == ChartValue(spec: spec, pinTheme: false))145        #expect(ChartPayload.decode(pinned) == ChartValue(spec: spec, pinTheme: true))146        #expect(try ChartSpec.decoded(from: pinned) == spec)             // still a valid SheetCharts payload147        #expect(ChartValue(spec: spec, pinTheme: true).effectiveTheme(dark: true) == ChartTheme.publication)148        #expect(ChartValue(spec: spec).effectiveTheme(dark: true).isDark)149        #expect(!ChartValue(spec: spec).effectiveTheme(dark: false).isDark)150    }151}152153@MainActor @Suite struct StructureTests {154    func chart(_ s: WorkbookSession) -> ChartSpec { ChartPayload.chart(s.workbook.sheets[0].meta.objects[0])!.spec }155156    func setup() -> WorkbookSession {157        let s = makeSession()158        s.select(RangeRef(a1: "A1:D7")!)159        _ = ChartInsertion.quickInsert(.column, in: s)160        return s161    }162163    @Test func rowsFollowInsertAndDelete() {164        let s = setup()165        s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 0, count: 3) }166        #expect(rangeText(chart(s).series[0].values) == "Data!B5:B10" && rangeText(chart(s).series[0].nameRef) == "Data!B4")167        #expect(rangeText(chart(s).categories) == "Data!A5:A10")168        s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 6, count: 2) }        // inside the data: the range grows169        #expect(rangeText(chart(s).series[1].values) == "Data!C5:C12")170        s.undo()171        #expect(rangeText(chart(s).series[1].values) == "Data!C5:C10")172        s.undo()173        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")174        s.redo()175        #expect(rangeText(chart(s).series[0].values) == "Data!B5:B10")176        s.perform("Delete Rows") { $0.deleteRows(sheet: 0, at: 0, count: 3) }177        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")178        s.perform("Delete Rows") { $0.deleteRows(sheet: 0, at: 5, count: 2) }        // the last two data rows179        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B5")180    }181182    @Test func columnsFollowInsertAndDelete() {183        let s = setup()184        s.perform("Insert Columns") { $0.insertCols(sheet: 0, at: 1, count: 2) }185        #expect(rangeText(chart(s).series[0].values) == "Data!D2:D7" && rangeText(chart(s).categories) == "Data!A2:A7")186        s.perform("Delete Columns") { $0.deleteCols(sheet: 0, at: 0, count: 1) }187        #expect(rangeText(chart(s).series[0].values) == "Data!C2:C7")188        // the category column was deleted entirely: the chart keeps its last reference instead of losing it189        #expect(chart(s).categories != nil)190        s.undo(); s.undo()191        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")192        // edits on another sheet leave the chart alone193        s.perform("Insert Rows") { $0.insertRows(sheet: 1, at: 0, count: 5) }194        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")195    }196197    @Test func renameAndMove() {198        let s = setup()199        #expect(s.renameSheet(at: 0, to: "Sales 2026"))200        #expect(rangeText(chart(s).series[0].values) == "'Sales 2026'!B2:B7")201        // the chart still reads its data after the rename202        let snap = ChartSnapshot.capture([chart(s)], workbook: s.workbook)203        #expect(ChartData.resolve(chart(s), source: snap).series[0].finiteValues == [10, 13, 16, 19, 22, 25])204        s.undo()205        #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")206        s.redo()207        #expect(rangeText(chart(s).series[0].values) == "'Sales 2026'!B2:B7")208        s.undo()209        s.perform("Move") { $0.move(sheet: 0, from: RangeRef(a1: "A1:E7")!, to: CellRef(a1: "C10")!) }210        #expect(rangeText(chart(s).series[0].values) == "Data!D11:D16" && rangeText(chart(s).categories) == "Data!C11:C16")211        s.undo()212        #expect(rangeText(chart(s).categories) == "Data!A2:A7")213    }214215    @Test func figuresAndPinnedChartsAreRemapped() throws {216        let s = setup()217        let spec = chart(s)218        var figure = FigureTemplates.academicDoubleColumn.makeFigure(charts: [spec, spec])219        figure.title = "F"220        let fo = try figure.sheetObject(x: 10, y: 400)221        s.addObject(fo)222        // pin the chart's theme: the flag must survive the rewrite223        var o = s.sheet.meta.objects[0]224        o.payload = ChartPayload.encode(ChartValue(spec: spec, pinTheme: true))!225        s.updateObject(o)226        s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 0, count: 1) }227        let f = try #require(ChartPayload.figure(s.sheet.meta.objects[1]))228        #expect(rangeText(f.panels[1].chart.series[2].values) == "Data!D3:D8")229        let v = try #require(ChartPayload.chart(s.sheet.meta.objects[0]))230        #expect(v.pinTheme && rangeText(v.spec.series[0].values) == "Data!B3:B8")231        #expect(ChartStructure.remap(kind: "chart", payload: o.payload, .insertRows(sheet: "Other", at: 0, count: 1)) == nil)232        #expect(ChartStructure.remap(kind: "pivot", payload: o.payload, .insertRows(sheet: "Data", at: 0, count: 1)) == nil)233    }234}235
Files main
Menu

Theme