Repository Public
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