Repository Public
1import Foundation2import SheetCore3import SheetData4import SheetUI5import FeatureData67/// Clearly synthetic sample data for the preview harness (deterministic, no real names or companies).8enum Samples {9 static let directory = FileManager.default.temporaryDirectory.appendingPathComponent("orix-data-preview", isDirectory: true)10 static let regions = ["North", "South", "East", "West", "Central"]11 static let categories = ["Hardware", "Software", "Services", "Accessories"]12 static let statuses = ["delivered", "shipped", "processing", "returned", "cancelled"]1314 struct Generator {15 var state: UInt6416 mutating func next() -> UInt64 {17 state ^= state << 13; state ^= state >> 7; state ^= state << 1718 return state19 }20 mutating func below(_ n: Int) -> Int { Int(next() % UInt64(n)) }21 }2223 /// Streams a synthetic orders CSV to disk (4 MiB buffer); reused when it already exists with the right size.24 static func ordersCSV(rows: Int) throws -> URL {25 try FileManager.default.createDirectory(at: directory, withIntermediateDirectories: true)26 let url = directory.appendingPathComponent("sample_orders_\(rows).csv")27 if FileManager.default.fileExists(atPath: url.path) { return url }28 let temp = url.appendingPathExtension("part")29 FileManager.default.createFile(atPath: temp.path, contents: nil)30 let handle = try FileHandle(forWritingTo: temp)31 var buffer = Data()32 buffer.reserveCapacity(4 << 20)33 buffer.append(contentsOf: "order_id,order_date,region,category,product,quantity,unit_price,discount,customer_id,status\n".utf8)34 var g = Generator(state: 0x9E37_79B9_7F4A_7C15)35 for i in 0..<rows {36 let day = g.below(365 * 3)37 let date = DataValue.isoDate(days: 19_358 + day) // from 2023-01-0138 let category = g.below(categories.count)39 let quantity = 1 + g.below(12)40 let price = Double(500 + g.below(49_500)) / 10041 let discount = g.below(10) < 7 ? "" : String(format: "%.2f", Double(5 * (1 + g.below(5))) / 100)42 let status = g.below(100)43 let statusName = status < 62 ? 0 : (status < 82 ? 1 : (status < 92 ? 2 : (status < 97 ? 3 : 4)))44 let line = "\(i + 1),\(date),\(regions[g.below(regions.count)]),\(categories[category]),SKU-\(category + 1)\(String(format: "%03d", g.below(240))),\(quantity),\(String(format: "%.2f", price)),\(discount),\(1 + g.below(50_000)),\(statuses[statusName])\n"45 buffer.append(contentsOf: line.utf8)46 if buffer.count >= 4 << 20 { try handle.write(contentsOf: buffer); buffer.removeAll(keepingCapacity: true) }47 }48 try handle.write(contentsOf: buffer)49 try handle.close()50 try FileManager.default.moveItem(at: temp, to: url)51 return url52 }5354 /// A small Parquet file of synthetic customers, written by the engine itself.55 static func customersParquet() throws -> URL {56 try FileManager.default.createDirectory(at: directory, withIntermediateDirectories: true)57 let url = directory.appendingPathComponent("sample_customers.parquet")58 if FileManager.default.fileExists(atPath: url.path) { return url }59 let engine = try DataEngine()60 try engine.execute("""61 CREATE TABLE c AS SELECT i + 1 AS customer_id, 'Customer ' || lpad(CAST(i + 1 AS VARCHAR), 5, '0') AS customer_name,62 ['Enterprise', 'Small business', 'Education', 'Public sector'][1 + i % 4] AS segment,63 DATE '2019-01-01' + CAST(i % 1800 AS INTEGER) AS since64 FROM range(50000) t(i)65 """)66 _ = try engine.exportQuery("SELECT * FROM c", to: url, format: .parquet)67 return url68 }6970 /// A small SQLite-free, engine-written DuckDB-independent CSV with a semicolon delimiter (for the options card).71 static func semicolonCSV() throws -> URL {72 try FileManager.default.createDirectory(at: directory, withIntermediateDirectories: true)73 let url = directory.appendingPathComponent("sample_inventory.csv")74 if FileManager.default.fileExists(atPath: url.path) { return url }75 var text = "sku;warehouse;on_hand;reorder_level\n"76 var g = Generator(state: 42)77 for i in 0..<400 { text += "SKU-\(1 + i % 4)\(String(format: "%03d", i % 240));W\(1 + g.below(6));\(g.below(900));\(20 + g.below(80))\n" }78 try text.write(to: url, atomically: true, encoding: .utf8)79 return url80 }8182 /// Fills a sheet with a few hundred synthetic sales rows and returns the range (header included).83 @MainActor static func fillSales(_ session: WorkbookSession, sheet: Int, rows: Int = 240) -> RangeRef {84 var g = Generator(state: 7)85 let products = ["Laptop", "Monitor", "Dock", "Keyboard", "Licence", "Support plan"]86 session.perform("Sample data") { e in87 for (c, h) in ["Date", "Region", "Category", "Product", "Units", "Revenue"].enumerated() { e.set(sheet: sheet, row: 0, col: c, .value(.text(h))) }88 for i in 0..<rows {89 let product = g.below(products.count)90 let units = 1 + g.below(9)91 let serial = DateSerial.serial(year: 2025, month: 1, day: 1, date1904: false) + Double(g.below(365))92 e.set(sheet: sheet, row: i + 1, col: 0, .value(.number(serial)))93 e.set(sheet: sheet, row: i + 1, col: 1, .value(.text(regions[g.below(4)])))94 e.set(sheet: sheet, row: i + 1, col: 2, .value(.text(categories[product < 4 ? 0 : (product == 4 ? 1 : 2)])))95 e.set(sheet: sheet, row: i + 1, col: 3, .value(.text(products[product])))96 e.set(sheet: sheet, row: i + 1, col: 4, .value(.number(Double(units))))97 e.set(sheet: sheet, row: i + 1, col: 5, .value(.number(Double(units) * Double(40 + product * 180 + g.below(60)))))98 }99 e.setStyle(sheet: sheet, range: RangeRef(r0: 0, c0: 0, r1: 0, c1: 5)) { $0.bold = true }100 e.setStyle(sheet: sheet, range: RangeRef(r0: 1, c0: 0, r1: rows, c1: 0)) { $0.numberFormat = "yyyy-mm-dd" }101 e.setStyle(sheet: sheet, range: RangeRef(r0: 1, c0: 5, r1: rows, c1: 5)) { $0.numberFormat = "#,##0" }102 e.editMeta(sheet: sheet) { $0.colWidths[0] = 86; $0.colWidths[3] = 96; $0.colWidths[4] = 56; $0.frozenRows = 1 }103 }104 return RangeRef(r0: 0, c0: 0, r1: rows, c1: 5)105 }106}107