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

export const SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY = "dbx-sql-file-folders-ui-state";

export interface SqlFileFolderUiState {
  collapsed?: boolean;
  expanded?: string[];
}

/**
 * Load the persisted UI state (collapsed root flag and expanded subdirectory paths)
 * for each external SQL file folder.
 */
export function getSqlFileFoldersUiState(): Record<string, SqlFileFolderUiState> {
  try {
    const raw = safeLocalStorageGet(SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY);
    if (!raw) return {};
    const parsed = JSON.parse(raw);
    if (!parsed || typeof parsed !== "object" || Array.isArray(parsed)) return {};
    const result: Record<string, SqlFileFolderUiState> = {};
    for (const [key, value] of Object.entries(parsed)) {
      if (!value || typeof value !== "object") continue;
      const v = value as { collapsed?: unknown; expanded?: unknown };
      result[key] = {
        collapsed: typeof v.collapsed === "boolean" ? v.collapsed : false,
        expanded: Array.isArray(v.expanded) ? v.expanded.filter((p): p is string => typeof p === "string") : [],
      };
    }
    return result;
  } catch {
    return {};
  }
}

/**
 * Persist the UI state for all external SQL file folders.
 */
export function saveSqlFileFoldersUiState(state: Record<string, SqlFileFolderUiState>): void {
  safeLocalStorageSet(SQL_FILE_FOLDERS_UI_STATE_STORAGE_KEY, JSON.stringify(state));
}