Function makeTestDb

packages/node-runtime/src/cache/session-cache.test.ts:36–49

* Create an in-memory (or temp-file) chat DB with schema and one member so * sender_id FK joins work.

(filePath?: string)

 * sender_id FK joins work.
 */
function makeTestDb(filePath?: string): Database.Database {
  const db = new Database(filePath ?? ':memory:', { nativeBinding })
  db.exec(CHAT_DB_SCHEMA)
  // Insert a system member and a regular member
  db.prepare(
    `INSERT INTO member (platform_id, account_name, group_nickname, avatar, roles)
     VALUES (?, ?, ?, NULL, '[]')`
  ).run('sys', '系统消息', null)
  db.prepare(
    `INSERT INTO member (platform_id, account_name, group_nickname, avatar, roles)
     VALUES (?, ?, ?, NULL, '[]')`
  ).run('u1', 'Alice', 'Alice')
  return db
}

function insertMessage(db: Database.Database, senderId: number, ts: number): void {
  db.prepare('INSERT INTO message (sender_id, ts, type, content) VALUES (?, ?, 0, ?)').run(senderId, ts, `msg at ${ts}`)