Function createSqliteDb

packages/core/src/query/__tests__/session-index.test.ts:74–100

()

}

function createSqliteDb(): TestSqliteDb {
  const db = new TestSqliteDb(new Database(':memory:'))
  db.exec(`
    CREATE TABLE message (
      id INTEGER PRIMARY KEY,
      ts INTEGER NOT NULL
    );
    CREATE TABLE segment (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      start_ts INTEGER NOT NULL,
      end_ts INTEGER NOT NULL,
      message_count INTEGER NOT NULL,
      is_manual INTEGER DEFAULT 0,
      summary TEXT
    );
    CREATE TABLE message_context (
      message_id INTEGER NOT NULL,
      segment_id INTEGER NOT NULL,
      topic_id INTEGER
    );
    CREATE TABLE meta (
      session_gap_threshold INTEGER
    );
    INSERT INTO meta (session_gap_threshold) VALUES (NULL);
  `)
  return db
}

function seedMessages(db: DatabaseAdapter, msgs: Array<{ id: number; ts: number }>) {
  const insert = db.prepare('INSERT INTO message (id, ts) VALUES (?, ?)')