SPB Git

Repository Public

main.swift 9.5 KB 183 lines swift

1import AppKit2import SwiftUI3import SheetCore4import SheetUI5import SheetPython6import FeaturePython78// Development harness for Python Studio.9//   python-studio-preview [--shot out.png] [--dark] [--size WxH] [--run] [--script demo|error|loop] [--tab console|tables|plots|changes|history]10//                         [--consent] [--no-python] [--info] [--environment] [--inspector] [--fr] [--delay seconds]11// With --shot the window content is rendered to a PNG by the app itself and the process exits.1213let demoScript = """14import orix15import matplotlib.pyplot as plt1617sheet = orix.active_sheet()18df = sheet.range("A1:E41").to_dataframe()19print(f"{len(df)} rows · columns: {', '.join(df.columns)}")2021# Revenue by category22summary = df.groupby("Category")["Revenue"].agg(["sum", "mean", "count"]).round(2)23print(summary)24orix.show(summary, name="Revenue by category")25orix.show(df)2627fig, ax = plt.subplots(figsize=(7.5, 3.6))28ax.bar(summary.index, summary["sum"], color="#0891B2")29ax.set_title("Revenue by category")30ax.set_ylabel("Revenue ($)")31ax.spines[["top", "right"]].set_visible(False)3233# Buffered: applied as one undoable step when the script succeeds34sheet.range("G1").write(summary)35sheet.range("G7").write_formula("=SUM(H2:H5)")36"""3738let errorScript = """39import orix4041df = orix.active_sheet().range("A1:E41").to_dataframe()42print("columns:", list(df.columns))4344def margin(row):45    return row["Revenue"] / row["Cost"]      # there is no "Cost" column4647orix.active_sheet().range("G1").write("never written")48df["Margin"] = df.apply(margin, axis=1)49"""5051@MainActor func demoSession() -> WorkbookSession {52    let wb = Workbook(sheetNames: ["Sales", "Notes"])53    wb.properties.title = "Sales 2026"54    let session = WorkbookSession(workbook: wb, locale: Locale(identifier: "en_US"))55    let categories = ["Hardware", "Software", "Services", "Training"], regions = ["East", "West", "North"]56    session.perform("Demo") { e in57        for (c, h) in ["Category", "Region", "Date", "Units", "Revenue"].enumerated() { e.set(sheet: 0, row: 0, col: c, .value(.text(h))) }58        for i in 0..<40 {59            let units = Double(3 + (i * 7) % 23)60            e.set(sheet: 0, row: i + 1, col: 0, .value(.text(categories[i % 4])))61            e.set(sheet: 0, row: i + 1, col: 1, .value(.text(regions[i % 3])))62            e.set(sheet: 0, row: i + 1, col: 2, .value(.number(DateSerial.serial(year: 2026, month: 1 + i % 12, day: 1 + (i * 5) % 27))))63            e.set(sheet: 0, row: i + 1, col: 3, .value(.number(units)))64            e.set(sheet: 0, row: i + 1, col: 4, .value(.number((units * (120 + Double((i * 37) % 260)) * 100).rounded() / 100)))65        }66        e.setStyle(sheet: 0, range: RangeRef(a1: "A1:E1")!) { $0.bold = true }67        e.setStyle(sheet: 0, range: RangeRef(a1: "C2:C41")!) { $0.numberFormat = "yyyy-mm-dd" }68        e.setStyle(sheet: 0, range: RangeRef(a1: "E2:E41")!) { $0.numberFormat = "#,##0.00" }69    }70    session.select(RangeRef(a1: "A1:E41")!, active: CellRef(a1: "A1")!)71    return session72}7374/// The preview has no number-format engine: this stand-in recognises date formats so that date columns reach Python as datetimes.75struct PreviewDisplay: CellDisplayProvider {76    func display(_ value: Value, format: String, maxChars: Int?, date1904: Bool) -> CellDisplay {77        if case .number(let n) = value, isDateTime(format) {78            let c = DateSerial.components(n, date1904: date1904)79            return CellDisplay(text: String(format: "%04d-%02d-%02d", c.year, c.month, c.day))80        }81        if case .number(let n) = value, format.contains("0.00") { return CellDisplay(text: String(format: "%.2f", n)) }82        return CellDisplay(text: value.description)83    }84    func isDateTime(_ format: String) -> Bool { format.lowercased().contains("yy") || format.lowercased().contains("hh:") }85}8687final class AppDelegate: NSObject, NSApplicationDelegate {88    var window: NSWindow!89    var session: WorkbookSession!90    var model: PythonStudioModel!9192    func applicationDidFinishLaunching(_ notification: Notification) {93        let args = CommandLine.arguments94        func value(_ flag: String) -> String? { args.firstIndex(of: flag).flatMap { $0 + 1 < args.count ? args[$0 + 1] : nil } }95        var size = NSSize(width: 1280, height: 800)96        if let s = value("--size")?.split(separator: "x").compactMap({ Double($0) }), s.count == 2 { size = NSSize(width: s[0], height: s[1]) }97        if args.contains("--dark") { NSApp.appearance = NSAppearance(named: .darkAqua) }98        let shot = value("--shot")99        if shot != nil {100            // screenshots must not touch the user's real audit log, trust store or preferences101            PythonPaths.supportDirectory = FileManager.default.temporaryDirectory.appendingPathComponent("orix-python-preview-support", isDirectory: true)102        }103        Workspace.shared.displayProvider = PreviewDisplay()104        PythonFeature.register()105        session = demoSession()106        session.inspectorPane = args.contains("--inspector") ? "format" : nil107        session.showSidebar = args.contains("--inspector")108        model = PythonStudioStore.model(for: session)109        let which = value("--script") ?? "demo"110        let code = which == "error" ? errorScript : which == "loop" ? "import time\nn = 0\nwhile True:\n    n += 1\n    print('tick', n)\n    time.sleep(0.2)\n" : demoScript111        if args.contains("--consent") {112            // as if the script had arrived inside the workbook file113            PythonScripts.save(PythonScript(name: "Quarterly summary", code: code), to: session.workbook)114            PythonScripts.save(PythonScript(name: "Clean-up", code: "import orix\n"), to: session.workbook)115            model.reloadScripts()116            model.select(model.scripts.first { $0.name == "Quarterly summary" }?.id)117        } else if !args.contains("--empty") {118            model.newScript(code: "import orix\nprint(orix.sheets())\n", name: "Scratch")119            model.newScript(code: code, name: "Revenue by category")120        }121        if args.contains("--no-python") { model.setInterpreters([]) }122        session.studioPane = PythonFeature.paneID123124        window = NSWindow(contentRect: NSRect(origin: .zero, size: size), styleMask: [.titled, .closable, .resizable, .miniaturizable], backing: .buffered, defer: false)125        window.title = "ORIX Sheet — Python Studio preview"126        window.contentView = NSHostingView(rootView: WorkbookView(session: session))127        window.center()128        window.makeKeyAndOrderFront(nil)129        NSApp.activate(ignoringOtherApps: false)130131        let delay = Double(value("--delay") ?? "") ?? 1.0132        func capture() {133            guard let out = shot else { return }134            DispatchQueue.main.asyncAfter(deadline: .now() + delay) {135                MainActor.assumeIsolated {136                    // sheets are separate windows: capture the frontmost attached sheet when there is one137                    let popover = args.contains("--info") ? NSApp.windows.first { $0 !== self.window && $0.isVisible && $0.contentView != nil && $0.frame.width > 100 } : nil138                    let target = popover ?? self.window.attachedSheet ?? self.window!139                    guard let view = target.contentView, let rep = view.bitmapImageRepForCachingDisplay(in: view.bounds) else { exit(2) }140                    view.cacheDisplay(in: view.bounds, to: rep)141                    try? rep.representation(using: .png, properties: [:])?.write(to: URL(fileURLWithPath: out))142                    print("status: \(self.model.status) · tables \(self.model.tables.count) · figures \(self.model.figures.count) · changes \(self.model.changes.count) · undo: \(self.session.engine.undoLabel ?? "-")")143                    try? FileManager.default.removeItem(at: PythonPaths.supportDirectory)144                    PythonRunner.killAllRunningScripts()145                    exit(0)146                }147            }148        }149        // wait for interpreter discovery, then run (when asked), then capture150        func whenReady(_ body: @escaping @MainActor () -> Void) {151            DispatchQueue.main.asyncAfter(deadline: .now() + 0.15) {152                MainActor.assumeIsolated { if self.model.hasDiscovered { body() } else { whenReady(body) } }153            }154        }155        whenReady {156            if args.contains("--info") { self.model.showRestrictedInfo = true }157            if args.contains("--environment") { self.model.showEnvironment = true }158            if args.contains("--unrestricted") { self.model.confirmUnrestricted() }159            if args.contains("--run") || args.contains("--consent") {160                self.model.onRunFinished = {161                    if let t = value("--tab").flatMap(StudioTab.init(rawValue:)) { self.model.tab = t; if t == .history { self.model.refreshHistory() } }162                    capture()163                }164                self.model.run()165                if args.contains("--consent") {166                    if args.contains("--approve") { DispatchQueue.main.asyncAfter(deadline: .now() + 0.5) { MainActor.assumeIsolated { self.model.answerConsent(.runOnce) } } } else { capture() }167                } else if which == "loop" { capture() }168            } else {169                if let t = value("--tab").flatMap(StudioTab.init(rawValue:)) { self.model.tab = t }170                capture()171            }172        }173    }174    func applicationShouldTerminateAfterLastWindowClosed(_ sender: NSApplication) -> Bool { true }175}176177if CommandLine.arguments.contains("--fr") { PythonStrings.forceLanguage("fr-CA") }178let app = NSApplication.shared179let delegate = AppDelegate()180app.delegate = delegate181app.setActivationPolicy(CommandLine.arguments.contains("--shot") ? .accessory : .regular)182app.run()183
Files main
Menu

Theme