Function seedChatSessionDb

tests/e2e/smoke/chart-runtime.smoke.test.js:146–193

(chatDataDir)

}

function seedChatSessionDb(chatDataDir) {
  const Database = getDatabaseConstructor()
  const dbDir = path.join(chatDataDir, 'databases')
  ensureDir(dbDir)
  const db = new Database(path.join(dbDir, `${SESSION_ID}.db`), {
    nativeBinding: resolveNativeBinding(),
  })

  try {
    db.exec(CHAT_DB_SCHEMA)
    db.prepare(
      `INSERT INTO meta (name, platform, type, imported_at, group_id, owner_id, schema_version)
       VALUES (?, ?, ?, ?, ?, ?, 5)`
    ).run(SESSION_NAME, 'wechat', 'group', unixTs('2026-06-03T00:00:00Z'), 'g_chart', 'u_alice')

    const insertMember = db.prepare(
      `INSERT INTO member (platform_id, account_name, group_nickname)
       VALUES (?, ?, ?)`
    )
    insertMember.run('u_alice', 'Alice Account', 'Alice')
    insertMember.run('u_bob', 'Bob Account', 'Bob')
    insertMember.run('u_cara', 'Cara Account', 'Cara')

    const members = db.prepare('SELECT id, group_nickname FROM member').all()
    const memberIds = new Map(members.map((row) => [row.group_nickname, row.id]))
    const insertMessage = db.prepare(
      `INSERT INTO message (sender_id, sender_account_name, sender_group_nickname, ts, type, content, platform_message_id)
       VALUES (?, ?, ?, ?, ?, ?, ?)`
    )

    const addMessage = (name, ts, type, content) => {
      const id = memberIds.get(name)
      assert.ok(id, `missing member id for ${name}`)
      insertMessage.run(id, `${name} Account`, name, unixTs(ts), type, content, `${name}-${ts}`)
    }

    addMessage('Alice', '2026-06-01T09:00:00Z', 0, 'morning hello')
    addMessage('Alice', '2026-06-01T10:00:00Z', 0, 'standup note')
    addMessage('Alice', '2026-06-02T09:00:00Z', 1, '[图片]')
    addMessage('Alice', '2026-06-02T10:00:00Z', 0, 'follow up')
    addMessage('Bob', '2026-06-01T09:00:00Z', 0, 'first reply')
    addMessage('Bob', '2026-06-02T10:00:00Z', 0, 'second reply')
    addMessage('Bob', '2026-06-02T11:00:00Z', 0, 'third reply')
    addMessage('Cara', '2026-06-01T09:00:00Z', 0, 'other member')
  } finally {
    db.close()
  }
}

function seedAiConversationDb(homeDir) {
  const Database = getDatabaseConstructor()