Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

1.0 KB
Raw Blame
export interface AiConversationSearchItem {
  title: string;
  connectionName: string;
  database: string;
  messages: readonly { content: string }[];
}

export interface AiConversationSearchEntry<T extends AiConversationSearchItem> {
  conversation: T;
  searchText: string;
}

export function buildAiConversationSearchIndex<T extends AiConversationSearchItem>(conversations: readonly T[]): AiConversationSearchEntry<T>[] {
  return conversations.map((conversation) => ({
    conversation,
    searchText: [conversation.title, conversation.connectionName, conversation.database, ...conversation.messages.map((message) => message.content)].join("\n").toLowerCase(),
  }));
}

export function filterAiConversationSearchIndex<T extends AiConversationSearchItem>(index: readonly AiConversationSearchEntry<T>[], query: string): T[] {
  const normalizedQuery = query.trim().toLowerCase();
  if (!normalizedQuery) return index.map((entry) => entry.conversation);

  return index.filter((entry) => entry.searchText.includes(normalizedQuery)).map((entry) => entry.conversation);
}