Function searchByFts

packages/node-runtime/src/fts/index.ts:111–140

(
  db: DatabaseAdapter,
  keywords: string[],
  limit = 1000,
  offset = 0
)

 * Search messages using FTS5, returning matching rowids.
 */
export function searchByFts(
  db: DatabaseAdapter,
  keywords: string[],
  limit = 1000,
  offset = 0
): { rowids: number[]; total: number } {
  if (keywords.length === 0) return { rowids: [], total: 0 }

  const matchQuery = tokenizeQueryForFts(keywords)
  if (!matchQuery) return { rowids: [], total: 0 }

  try {
    const countRow = db.prepare('SELECT COUNT(*) as total FROM message_fts WHERE content MATCH ?').get(matchQuery) as
      | { total: number }
      | undefined
    const total = countRow?.total ?? 0

    const rows = db
      .prepare(`SELECT rowid FROM message_fts WHERE content MATCH ? ORDER BY rank LIMIT ? OFFSET ?`)
      .all(matchQuery, limit, offset) as Array<{ rowid: number }>

    return {
      rowids: rows.map((r) => r.rowid),
      total,
    }
  } catch (error) {
    console.error('[FTS] Search failed, query:', matchQuery, error)
    return { rowids: [], total: 0 }
  }
}