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。

3.7 KB
Raw Blame
import { computed, onBeforeUnmount, ref, shallowRef, watch } from "vue";
import type { SqlFileContentMatch, SqlFileEntry } from "@/lib/backend/api";
import { contentMatchPathSet, searchSqlFileContents, type SqlFileContentSearchResult } from "@/lib/sql/sqlFileContentSearch";
import { getSqlFileFilter } from "@/lib/sqlFile/sqlFileFolders";

interface SearchFolder {
  path: string;
  entries: SqlFileEntry[];
  loading: boolean;
  refreshing: boolean;
}

interface SearchRequest {
  generation: number;
  roots: string[];
  query: string;
  fileFilter: string;
}

/** Keep disk reads off the render path and serialize scans while typing. */
export function useSqlFileContentSearch(getQuery: () => string, getFolders: () => SearchFolder[], getInputPending: () => boolean = () => false) {
  const result = shallowRef<SqlFileContentSearchResult | null>(null);
  const searching = ref(false);
  const error = ref("");
  let generation = 0;
  let disposed = false;
  let running = false;
  let pending: SearchRequest | null = null;
  let resultQuery = "";
  let resultFileFilter = "";

  async function runPending() {
    if (disposed || running || !pending) return;
    const request = pending;
    pending = null;
    running = true;
    try {
      const response = await searchSqlFileContents(request);
      if (!disposed && request.generation === generation) {
        resultQuery = request.query;
        resultFileFilter = request.fileFilter;
        result.value = response;
      }
    } catch (cause) {
      if (!disposed && request.generation === generation) error.value = cause instanceof Error ? cause.message : String(cause);
    } finally {
      running = false;
      if (!disposed && request.generation === generation) searching.value = false;
      // Only the latest committed request survives a slow filesystem scan.
      void runPending();
    }
  }

  watch(
    () => ({
      query: getQuery(),
      inputPending: getInputPending(),
      // Track entry replacement and refresh state, not expansion/selection.
      folders: getFolders().map((folder) => ({ path: folder.path, entries: folder.entries, loading: folder.loading, refreshing: folder.refreshing })),
    }),
    ({ query, folders, inputPending }) => {
      const current = ++generation;
      pending = null;
      const fileFilter = getSqlFileFilter();
      // Refresh in place: removing content-only hits while rescanning shrinks
      // the scroll container and destroys its rows and expanded snippets.
      // A different query/filter must never display the previous search's hits.
      if (!query || query !== resultQuery || fileFilter !== resultFileFilter || folders.length === 0) result.value = null;
      error.value = "";
      searching.value = !inputPending && !!query && folders.length > 0;
      if (!searching.value || folders.some((folder) => folder.loading || folder.refreshing)) return;

      pending = { generation: current, roots: folders.map((folder) => folder.path), query, fileFilter };
      void runPending();
    },
    { immediate: true, flush: "sync" },
  );

  onBeforeUnmount(() => {
    disposed = true;
    generation++;
    pending = null;
  });

  const matchesByPath = computed(() => result.value?.matchesByPath ?? new Map<string, SqlFileContentMatch>());
  const matchingPaths = computed(() => contentMatchPathSet(result.value));
  const incomplete = computed(() => !!result.value && (result.value.truncated || result.value.skippedFiles.length > 0));
  const skippedCount = computed(() => result.value?.skippedFiles.length ?? 0);
  const skippedFiles = computed(() => result.value?.skippedFiles ?? []);
  const truncated = computed(() => result.value?.truncated ?? false);

  return { searching, error, matchesByPath, matchingPaths, incomplete, skippedCount, skippedFiles, truncated };
}