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.9 KB
Raw Blame
import { ref } from "vue";
import { safeLocalStorageGet, safeLocalStorageSet } from "@/lib/backend/safeStorage";

export { getSqlFileSortOrder, saveSqlFileSortOrder, DEFAULT_SQL_FILE_SORT_ORDER, type SqlFileSortOrder } from "@/lib/sql/sqlFileTreeFilter";

const STORAGE_KEY = "dbx-sql-file-folders";
const FILTER_STORAGE_KEY = "dbx-sql-file-filter";
export const DEFAULT_SQL_FILE_FILTER = "(?i)\\.(sql|ddl)$";

/**
 * Shared reactive version counter — bumped whenever SQL file folder paths change.
 * Components that cache folder contents (e.g. useQuickOpen) can watch this
 * to know when they should re-read from localStorage and reload.
 */
export const sqlFileFoldersVersion = ref(0);

/** Read the current list of SQL file folder paths from localStorage. */
export function getSqlFileFolderPaths(): string[] {
  try {
    const raw = safeLocalStorageGet(STORAGE_KEY);
    if (!raw) return [];
    const parsed = JSON.parse(raw);
    return Array.isArray(parsed) ? parsed.filter((p): p is string => typeof p === "string") : [];
  } catch {
    return [];
  }
}

/** Read the file-name filter used by the external SQL file browser. */
export function getSqlFileFilter(): string {
  const filter = safeLocalStorageGet(FILTER_STORAGE_KEY)?.trim();
  return filter || DEFAULT_SQL_FILE_FILTER;
}

/** Persist the file-name filter and invalidate cached external file listings. */
export function saveSqlFileFilter(filter: string): void {
  safeLocalStorageSet(FILTER_STORAGE_KEY, filter.trim() || DEFAULT_SQL_FILE_FILTER);
  sqlFileFoldersVersion.value++;
}

/** Persist folder paths to localStorage and notify subscribers. */
export function saveSqlFileFolderPaths(paths: string[]): void {
  safeLocalStorageSet(STORAGE_KEY, JSON.stringify(paths));
  sqlFileFoldersVersion.value++;
}

/** Notify subscribers that folder contents may have changed (e.g. after refresh). */
export function notifySqlFileFoldersChanged(): void {
  sqlFileFoldersVersion.value++;
}