SPB Git

Repository Public MIT

TemplateTests.swift 4.7 KB 95 lines swift

1// ORIX Calc2// File: Packages/ORIXFeatureWorkspace/Tests/ORIXFeatureWorkspaceTests/TemplateTests.swift3// Description: Every template computes without errors and matches values obtained by direct arithmetic.4//5// Author: Simon-Pierre Boucher6// Contact: contact@spboucher.ai7import Foundation8import Testing9import ORIXExpression10import ORIXUI11import ORIXWorkspace12@testable import ORIXFeatureWorkspace1314@MainActor func makeApp() -> AppModel {15    let suite = "orix.workspace.tests.\(UUID().uuidString)"16    return AppModel(settings: AppSettings(defaults: UserDefaults(suiteName: suite)!), inMemory: true)17}18@MainActor func value(_ sheet: SheetModel, _ name: String) -> Double? {19    sheet.cellDefining(name).flatMap { sheet.result($0.id)?.value?.doubleValue }20}21func close(_ a: Double?, _ b: Double, _ tol: Double = 1e-9) -> Bool {22    guard let a else { return false }23    return abs(a - b) <= tol * max(1, abs(b))24}2526@MainActor @Suite struct TemplateTests {27    @Test(arguments: WorkspaceTemplate.allCases) func computesWithoutErrors(_ template: WorkspaceTemplate) {28        let sheet = SheetModel(document: template.document(), app: makeApp())29        #expect(!sheet.cells.isEmpty)30        for cell in sheet.cells {31            let r = sheet.result(cell.id)32            #expect(r?.error == nil, "\(template.title): \(sheet.label(cell)) → \(r?.error?.description ?? "")")33            switch cell.kind {34            case .formula: #expect(r?.value != nil || r?.isFunction == true, "\(sheet.label(cell)) has no value")35            case .parameter: #expect(r?.value != nil)36            case .table:37                #expect(r?.table?.count == cell.table?.count)38                #expect(r?.table?.allSatisfy { $0.y != nil } == true, "\(template.title): table has undefined rows")39            case .graph, .text: break40            }41        }42        #expect(sheet.cells.contains { $0.kind == .parameter } && sheet.cells.contains { $0.kind == .table } && sheet.cells.contains { $0.kind == .graph })43        // identifiers are fresh for each document44        #expect(Set(template.document().cells.map(\.id)).isDisjoint(with: sheet.cells.map(\.id)))45    }4647    @Test func capitalBudgetingValues() throws {48        let sheet = SheetModel(document: WorkspaceTemplate.capitalBudgeting.document(), app: makeApp())49        let npv = -100000 + 25000 / 1.08 + 30000 / pow(1.08, 2) + 40000 / pow(1.08, 3)50        #expect(close(value(sheet, "NPV"), npv))51        #expect(value(sheet, "Decision") == 0)52        #expect(sheet.result(try #require(sheet.cellDefining("NPV")).id)?.isExact == true)53        let table = try #require(sheet.cells.first { $0.kind == .table })54        let rows = try #require(sheet.result(table.id)?.table)55        for (k, row) in rows.enumerated() {56            let r = 0.02 * Double(k)57            #expect(close(row.x, r, 1e-12))58            #expect(close(row.y, -100000 + 25000 / (1 + r) + 30000 / pow(1 + r, 2) + 40000 / pow(1 + r, 3), 1e-9))59        }60    }6162    @Test func loanComparisonValues() {63        let sheet = SheetModel(document: WorkspaceTemplate.loanComparison.document(), app: makeApp())64        func payment(_ rate: Double) -> Double { let i = rate / 12; return 350000 * i / (1 - pow(1 + i, -300)) }65        let a = payment(0.0549), b = payment(0.0499)66        #expect(close(value(sheet, "PaymentA"), a))67        #expect(close(value(sheet, "PaymentB"), b))68        #expect(close(value(sheet, "TotalB"), b * 300 + 2500))69        #expect(close(value(sheet, "InterestA"), a * 300 - 350000))70        #expect(close(value(sheet, "Savings"), a * 300 - (b * 300 + 2500)))71    }7273    @Test func projectileValues() {74        let sheet = SheetModel(document: WorkspaceTemplate.projectile.document(), app: makeApp())75        #expect(sheet.settings.angleMode == .degrees)76        let g = 9.80665, v = 30.0, a = 45.0 * Double.pi / 18077        #expect(close(value(sheet, "FlightTime"), 2 * v * sin(a) / g))78        #expect(close(value(sheet, "Distance"), v * v * sin(2 * a) / g))79        #expect(close(value(sheet, "MaxHeight"), pow(v * sin(a), 2) / (2 * g)))80        let table = sheet.cells.first { $0.kind == .table }!81        let rows = sheet.result(table.id)!.table!82        #expect(close(rows[3].y, 30 * tan(a) - g * 900 / (2 * pow(v * cos(a), 2))))83    }8485    @Test func unitEconomicsValues() {86        let sheet = SheetModel(document: WorkspaceTemplate.unitEconomics.document(), app: makeApp())87        #expect(value(sheet, "Margin") == 35)88        #expect(close(value(sheet, "LTV"), 35 / 0.04))89        #expect(close(value(sheet, "ValueToCost"), 35 / 0.04 / 220))90        #expect(close(value(sheet, "Payback"), 220.0 / 35))91        #expect(close(value(sheet, "BreakEvenCustomers"), 30000.0 / 35))92        #expect(value(sheet, "MonthlyProfit") == 12000)93    }94}95
Files main
Menu

Theme