Repository Public
1import Foundation23/// Versioned schema. Each migration is applied once, in order, inside a transaction; the current4/// version lives in `PRAGMA user_version`. Never edit a shipped migration — append a new one.5public enum Migrations {6 public static let current = 178 static let steps: [(version: Int, sql: [String])] = [9 (1, [10 """11 CREATE TABLE IF NOT EXISTS meta (12 key TEXT PRIMARY KEY,13 value TEXT NOT NULL14 )15 """,16 """17 CREATE TABLE IF NOT EXISTS workspaces (18 id TEXT PRIMARY KEY,19 name TEXT NOT NULL,20 is_current INTEGER NOT NULL DEFAULT 0,21 created_at REAL NOT NULL,22 updated_at REAL NOT NULL23 )24 """,25 """26 CREATE TABLE IF NOT EXISTS windows (27 id TEXT PRIMARY KEY,28 workspace_id TEXT NOT NULL REFERENCES workspaces(id) ON DELETE CASCADE,29 position INTEGER NOT NULL,30 selected_tab_id TEXT,31 role TEXT,32 frame_x REAL, frame_y REAL, frame_w REAL, frame_h REAL,33 display_id INTEGER,34 display_name TEXT,35 is_fullscreen INTEGER NOT NULL DEFAULT 036 )37 """,38 """39 CREATE TABLE IF NOT EXISTS tabs (40 id TEXT PRIMARY KEY,41 window_id TEXT NOT NULL REFERENCES windows(id) ON DELETE CASCADE,42 position INTEGER NOT NULL,43 custom_title TEXT,44 layout_json TEXT NOT NULL,45 focused_pane_id TEXT,46 maximized_pane_id TEXT47 )48 """,49 """50 CREATE TABLE IF NOT EXISTS panes (51 id TEXT PRIMARY KEY,52 workspace_id TEXT NOT NULL REFERENCES workspaces(id) ON DELETE CASCADE,53 session_id TEXT NOT NULL,54 profile_json TEXT NOT NULL55 )56 """,57 """58 CREATE TABLE IF NOT EXISTS settings (59 key TEXT PRIMARY KEY,60 value_json TEXT NOT NULL,61 updated_at REAL NOT NULL62 )63 """,64 """65 CREATE TABLE IF NOT EXISTS ssh_hosts (66 id TEXT PRIMARY KEY,67 alias TEXT NOT NULL UNIQUE,68 hostname TEXT,69 user TEXT,70 port INTEGER,71 label TEXT,72 group_name TEXT,73 tags_json TEXT NOT NULL DEFAULT '[]',74 tmux_session TEXT,75 remote_directory TEXT,76 favorite INTEGER NOT NULL DEFAULT 0,77 source TEXT NOT NULL DEFAULT 'ssh_config'78 )79 """,80 """81 CREATE TABLE IF NOT EXISTS claude_sessions (82 session_id TEXT PRIMARY KEY,83 pane_id TEXT,84 project_dir TEXT,85 label TEXT,86 started_at REAL,87 last_event_at REAL,88 last_event TEXT,89 status TEXT90 )91 """,92 """93 CREATE TABLE IF NOT EXISTS layout_presets (94 id TEXT PRIMARY KEY,95 name TEXT NOT NULL,96 kind TEXT NOT NULL,97 json TEXT NOT NULL,98 created_at REAL NOT NULL99 )100 """,101 "CREATE INDEX IF NOT EXISTS idx_windows_workspace ON windows(workspace_id, position)",102 "CREATE INDEX IF NOT EXISTS idx_tabs_window ON tabs(window_id, position)",103 "CREATE INDEX IF NOT EXISTS idx_panes_workspace ON panes(workspace_id)",104 ]),105 ]106107 /// Applies pending migrations. Returns the versions applied.108 @discardableResult109 public static func migrate(_ db: SQLiteDatabase) throws -> [Int] {110 var applied: [Int] = []111 let from = db.userVersion112 for step in steps where step.version > from {113 try db.transaction {114 for sql in step.sql { try db.execute(sql) }115 try db.setUserVersion(step.version)116 }117 applied.append(step.version)118 }119 try db.execute("INSERT OR REPLACE INTO meta(key, value) VALUES('schema_version', ?)", [.text(String(current))])120 return applied121 }122}123