SPB Git

Repository Public

ReferenceTests.swift 3.7 KB 95 lines swift

1import Foundation2import Testing3import SheetCore4import SheetFormat5@testable import FunctionsText67/// One-sheet workbook driving the engine with the text/date library registered.8final class Book {9    static let registered: Bool = { TextFunctions.register(into: .standard, locale: .enUS); return true }()10    let wb = Workbook(sheetNames: ["Sheet1"])11    let engine: CalcEngine12    let parser = InputParser(locale: Locale(identifier: "en_US"))13    init(date1904: Bool = false) {14        _ = Book.registered15        wb.date1904 = date190416        engine = CalcEngine(workbook: wb)17    }18    func set(_ a1: String, _ text: String) {19        let ref = CellRef(a1: a1)!20        try! engine.setInput(sheet: 0, row: ref.row, col: ref.col, text, parser: parser)21    }22    func get(_ a1: String) -> Value {23        _ = engine.recalculate()24        let ref = CellRef(a1: a1)!25        return wb.sheets[0].value(ref.row, ref.col)26    }27    func eval(_ f: String) -> Value { engine.evaluate(f.hasPrefix("=") ? f : "=" + f, sheet: 0) }28}2930struct ReferenceCase: Decodable {31    enum V: Decodable, CustomStringConvertible {32        case number(Double), text(String), bool(Bool)33        init(from decoder: Decoder) throws {34            let c = try decoder.singleValueContainer()35            if let b = try? c.decode(Bool.self) { self = .bool(b) }36            else if let d = try? c.decode(Double.self) { self = .number(d) }37            else { self = .text(try c.decode(String.self)) }38        }39        var description: String {40            switch self {41            case .number(let d): "\(d)"42            case .text(let s): "\"\(s)\""43            case .bool(let b): "\(b)"44            }45        }46    }47    var fn: String48    var f: String49    var t: String50    var v: V51    var src: String5253    func matches(_ got: Value) -> Bool {54        switch (t, v, got) {55        case ("n", .number(let e), .number(let g)): return abs(e - g) <= 1e-9 * max(1, abs(e))56        case ("s", .text(let e), .text(let g)): return e == g57        case ("s", .text(let e), .blank): return e.isEmpty58        case ("b", .bool(let e), .bool(let g)): return e == g59        case ("e", .text(let e), .error(let g)): return e == g.rawValue60        default: return false61        }62    }63}6465@Suite struct ReferenceTests {66    @Test func functionsMatchReferences() throws {67        let url = try #require(Bundle.module.url(forResource: "function_references", withExtension: "json", subdirectory: "Fixtures"))68        let cases = try JSONDecoder().decode([ReferenceCase].self, from: Data(contentsOf: url))69        #expect(cases.count > 5000)70        let book = Book()71        var failures: [String] = []72        var perFunction: [String: (pass: Int, fail: Int)] = [:]73        var perSource: [String: Int] = [:]74        for c in cases {75            let got = book.eval(c.f)76            perSource[c.src, default: 0] += 177            if c.matches(got) {78                perFunction[c.fn, default: (0, 0)].pass += 179            } else {80                perFunction[c.fn, default: (0, 0)].fail += 181                failures.append("[\(c.src)] \(c.f) → \(got) (expected \(c.t):\(c.v))")82            }83        }84        print("Function references: \(cases.count) cases, sources \(perSource.sorted { $0.key < $1.key }), \(failures.count) failures")85        for (fn, r) in perFunction.sorted(by: { $0.key < $1.key }) {86            print("  \(fn): \(r.pass)/\(r.pass + r.fail)" + (r.fail > 0 ? "  FAIL" : ""))87        }88        for f in failures.prefix(60) { print("  " + f) }89        #expect(failures.isEmpty)90        // every registered function of the library must be covered by references91        let covered = Set(perFunction.keys)92        for name in TextFunctionsCatalog.all where !covered.contains(name) { Issue.record("no reference case for \(name)") }93    }94}95
Files main
Menu

Theme