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