Function makeCortexkitDb

packages/cli/src/commands/migrate.test.ts:146–182

()

}

function makeCortexkitDb() {
    const ck = new Database(":memory:");
    databases.push(ck);
    ck.exec(`
        CREATE TABLE compartments (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          session_id TEXT NOT NULL,
          sequence INTEGER NOT NULL,
          start_message INTEGER NOT NULL,
          end_message INTEGER NOT NULL,
          start_message_id TEXT DEFAULT '',
          end_message_id TEXT DEFAULT '',
          title TEXT NOT NULL,
          content TEXT NOT NULL,
          p1 TEXT,
          p2 TEXT,
          p3 TEXT,
          p4 TEXT,
          importance INTEGER NOT NULL DEFAULT 50,
          episode_type TEXT,
          legacy INTEGER NOT NULL DEFAULT 0,
          created_at INTEGER NOT NULL,
          harness TEXT NOT NULL DEFAULT 'opencode',
          UNIQUE(session_id, sequence)
        );
        CREATE TABLE session_facts (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          session_id TEXT NOT NULL,
          category TEXT NOT NULL,
          content TEXT NOT NULL,
          created_at INTEGER NOT NULL,
          updated_at INTEGER NOT NULL,
          harness TEXT NOT NULL DEFAULT 'opencode'
        );
    `);
    return ck;
}

afterEach(() => {
    for (const db of databases.splice(0)) db.close();