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。

18.5 KB
Raw Blame
<script setup lang="ts">
import { computed, onBeforeUnmount, onMounted, ref, toRaw, watch } from "vue";
import { useI18n } from "vue-i18n";
import { ArrowDown, ArrowUp, ArrowUpDown, Filter, FolderOpen, Plus, RefreshCcw, Trash2, X } from "@lucide/vue";
import DangerConfirmDialog from "@/components/editor/DangerConfirmDialog.vue";
import { Button } from "@/components/ui/button";
import { Dialog, DialogContent, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog";
import { Input } from "@/components/ui/input";
import { Popover, PopoverContent, PopoverTrigger } from "@/components/ui/popover";
import { useToast } from "@/composables/useToast";
import * as api from "@/lib/backend/api";
import { currentGridFsBucketFilter, currentGridFsBucketSort, currentGridFsBucketSortDirection, gridFsBucketSortInputForColumn } from "@/lib/document/gridFsBrowser";
import { restoreGridFsBrowserState, saveGridFsBrowserState } from "@/lib/tabs/documentBrowserStateCache";
import { useConnectionStore } from "@/stores/connectionStore";
import { connectionIsEffectivelyReadOnly } from "@/lib/database/readOnlyWriteAccess";
import { useQueryStore } from "@/stores/queryStore";

const props = defineProps<{
  connectionId: string;
  database: string;
  /** Tab id; query conditions and the listing are cached per tab. */
  stateKey?: string;
}>();

type GridFsBucket = Awaited<ReturnType<typeof api.documentListGridFsBuckets>>[number];

// ContentArea renders only the active tab, so this component is unmounted on
// every tab switch. Without the per-tab cache, coming back re-lists every
// bucket and drops the user's filter/sort (#8679).
const restoredGridFsState = props.stateKey ? restoreGridFsBrowserState<GridFsBucket>(props.stateKey) : undefined;

const { t } = useI18n();
const { toast } = useToast();
const queryStore = useQueryStore();
const connectionStore = useConnectionStore();

const loading = ref(false);
const creating = ref(false);
const deleting = ref(false);
const error = ref("");
const buckets = ref<GridFsBucket[]>([]);
const selectedBucketName = ref(restoredGridFsState?.selectedId ?? "");
const showCreateDialog = ref(false);
const showDeleteConfirm = ref(false);
const newBucketName = ref("");
const filterInput = ref(restoredGridFsState?.filterInput ?? "");
const sortInput = ref(restoredGridFsState?.sortInput ?? "");
const filterBuilderOpen = ref(false);

const selectedBucket = computed(() => buckets.value.find((bucket) => bucket.name === selectedBucketName.value) || null);
const totalFiles = computed(() => buckets.value.reduce((sum, bucket) => sum + bucket.fileCount, 0));
const totalBytes = computed(() => buckets.value.reduce((sum, bucket) => sum + bucket.totalBytes, 0));
const isReadonly = computed(() => connectionIsEffectivelyReadOnly(connectionStore.getConfig(props.connectionId)));

function formatBytes(bytes: number): string {
  if (bytes < 1024) return `${bytes} B`;
  if (bytes < 1024 * 1024) return `${(bytes / 1024).toFixed(bytes < 10 * 1024 ? 1 : 0)} KB`;
  if (bytes < 1024 * 1024 * 1024) return `${(bytes / (1024 * 1024)).toFixed(bytes < 10 * 1024 * 1024 ? 1 : 0)} MB`;
  return `${(bytes / (1024 * 1024 * 1024)).toFixed(1)} GB`;
}

function gridFsSignature(): string {
  return JSON.stringify([props.connectionId, props.database, filterInput.value, sortInput.value]);
}

// Rows are only replayed when the conditions that produced them still match, so
// an edit made while a listing was in flight can never pair new conditions with
// stale rows on the next remount.
let loadedGridFsSignature: string | undefined;
if (restoredGridFsState?.rows && restoredGridFsState.signature === gridFsSignature()) {
  buckets.value = restoredGridFsState.rows;
  loadedGridFsSignature = restoredGridFsState.signature;
}
const restoredGridFsBuckets = loadedGridFsSignature !== undefined;

function persistGridFsState(options: { includeRows?: boolean } = {}) {
  if (!props.stateKey) return;
  const signature = gridFsSignature();
  const keepRows = options.includeRows === true && !loading.value && !error.value && loadedGridFsSignature === signature;
  saveGridFsBrowserState(props.stateKey, {
    filterInput: filterInput.value,
    sortInput: sortInput.value,
    selectedId: selectedBucketName.value,
    signature: keepRows ? signature : undefined,
    rows: keepRows ? toRaw(buckets.value) : undefined,
  });
}

watch([filterInput, sortInput, selectedBucketName], () => persistGridFsState());

async function loadBuckets() {
  loading.value = true;
  error.value = "";
  try {
    const nextBuckets = await api.documentListGridFsBuckets(props.connectionId, props.database, currentGridFsBucketFilter(filterInput.value), currentGridFsBucketSort(sortInput.value));
    buckets.value = nextBuckets;
    loadedGridFsSignature = gridFsSignature();
    if (selectedBucketName.value && !nextBuckets.some((bucket) => bucket.name === selectedBucketName.value)) {
      selectedBucketName.value = "";
    }
  } catch (e: any) {
    error.value = e?.message || String(e);
  } finally {
    loading.value = false;
  }
}

function applyQuery() {
  void loadBuckets();
}

type SortDirection = "asc" | "desc" | null;

function currentSortDirection(column: "name" | "fileCount" | "totalBytes"): SortDirection {
  const direction = currentGridFsBucketSortDirection(sortInput.value, column);
  return direction === "none" ? null : direction;
}

function toggleSortForColumn(column: "name" | "fileCount" | "totalBytes") {
  const current = currentSortDirection(column);
  const nextDirection: SortDirection = current === "asc" ? "desc" : current === "desc" ? null : "asc";
  sortInput.value = gridFsBucketSortInputForColumn(column, nextDirection);
  void loadBuckets();
}

function sortIconForColumn(column: "name" | "fileCount" | "totalBytes") {
  const direction = currentSortDirection(column);
  return direction === "asc" ? ArrowUp : direction === "desc" ? ArrowDown : ArrowUpDown;
}

function sortIconClass(column: "name" | "fileCount" | "totalBytes"): string {
  return currentSortDirection(column) ? "text-foreground" : "text-muted-foreground/60";
}

function applyBucketNameFilter() {
  filterBuilderOpen.value = false;
  void loadBuckets();
}

function resetBucketNameFilter() {
  filterInput.value = "";
}

function clearBucketNameFilter() {
  filterInput.value = "";
  filterBuilderOpen.value = false;
  void loadBuckets();
}

function openBucket(bucketName = selectedBucketName.value) {
  if (!bucketName) return;
  queryStore.openMongoBucket(props.connectionId, props.database, bucketName);
}

async function createBucket() {
  const bucketName = newBucketName.value.trim();
  if (!bucketName || creating.value) return;
  creating.value = true;
  try {
    await api.documentCreateGridFsBucket(props.connectionId, props.database, bucketName);
    showCreateDialog.value = false;
    newBucketName.value = "";
    selectedBucketName.value = bucketName;
    await loadBuckets();
    toast(t("gridfsBrowser.bucketCreated", { bucket: bucketName }), 2500);
  } catch (e: any) {
    toast(e?.message || String(e), 5000);
  } finally {
    creating.value = false;
  }
}

async function deleteBucket() {
  const bucketName = selectedBucketName.value;
  if (!bucketName || deleting.value) return;
  deleting.value = true;
  try {
    await api.documentDeleteGridFsBucket(props.connectionId, props.database, bucketName);
    showDeleteConfirm.value = false;
    selectedBucketName.value = "";
    await loadBuckets();
    toast(t("gridfsBrowser.bucketDeleted", { bucket: bucketName }), 2500);
  } catch (e: any) {
    toast(e?.message || String(e), 5000);
  } finally {
    deleting.value = false;
  }
}

onMounted(() => {
  // A restored listing means the tab switch costs no round trip; every explicit
  // refresh and mutation path still calls loadBuckets().
  if (!restoredGridFsBuckets) void loadBuckets();
});
onBeforeUnmount(() => {
  persistGridFsState({ includeRows: true });
});
</script>

<template>
  <div class="flex h-full min-h-0 flex-col overflow-hidden">
    <div class="border-b border-border px-4 py-3">
      <div class="flex flex-wrap items-center justify-between gap-3">
        <div class="min-w-0">
          <div class="truncate text-sm font-semibold">{{ database }} / {{ t("tabs.gridfs") }}</div>
          <div class="text-xs text-muted-foreground">{{ buckets.length }} {{ t("gridfsBrowser.bucketCount") }} / {{ totalFiles }} {{ t("gridfsBrowser.fileCount") }} / {{ formatBytes(totalBytes) }}</div>
        </div>
        <div class="flex flex-wrap items-center gap-2">
          <Button size="sm" class="h-8 gap-1.5" :disabled="isReadonly" @click="showCreateDialog = true">
            <Plus class="h-3.5 w-3.5" />
            {{ t("gridfsBrowser.createBucket") }}
          </Button>
          <Button variant="outline" size="sm" class="h-8 gap-1.5" :disabled="!selectedBucket" @click="openBucket()">
            <FolderOpen class="h-3.5 w-3.5" />
            {{ t("gridfsBrowser.openBucket") }}
          </Button>
          <Button variant="destructive" size="sm" class="h-8 gap-1.5" :disabled="isReadonly || !selectedBucket || deleting" @click="showDeleteConfirm = true">
            <Trash2 class="h-3.5 w-3.5" />
            {{ t("gridfsBrowser.deleteBucket") }}
          </Button>
          <Button variant="outline" size="sm" class="h-8 gap-1.5" :disabled="loading" @click="loadBuckets">
            <RefreshCcw class="h-3.5 w-3.5" :class="{ 'animate-spin': loading }" />
            {{ t("grid.refresh") }}
          </Button>
        </div>
      </div>
      <div class="mt-3 overflow-hidden rounded-lg border border-border/70 bg-background/80 shadow-xs">
        <div class="flex flex-col md:flex-row">
          <div class="flex min-w-0 flex-1 items-center gap-1 px-2 py-1.5">
            <Popover v-model:open="filterBuilderOpen">
              <PopoverTrigger as-child>
                <button
                  type="button"
                  class="flex h-7 w-7 shrink-0 items-center justify-center rounded-md border text-[11px] transition-colors"
                  :class="filterInput.trim() ? 'border-primary/40 bg-primary/10 text-primary hover:bg-primary/15' : 'border-border/70 text-muted-foreground hover:bg-accent hover:text-foreground'"
                >
                  <Filter class="h-3.5 w-3.5" />
                </button>
              </PopoverTrigger>
              <PopoverContent align="start" class="w-[420px] max-w-[calc(100vw-24px)] gap-3 p-3" @click.stop @keydown.stop>
                <div class="flex items-center justify-between gap-3">
                  <div class="text-xs font-medium text-foreground">{{ t("grid.filter") }}</div>
                </div>
                <div class="grid grid-cols-[minmax(0,1fr)_minmax(0,0.95fr)_minmax(0,1fr)] items-center gap-1.5">
                  <div class="flex h-8 min-w-0 items-center overflow-hidden rounded-md border px-2 text-xs font-medium text-foreground">
                    <span class="truncate">{{ t("gridfsBrowser.name") }}</span>
                  </div>
                  <div class="flex h-8 min-w-0 items-center overflow-hidden rounded-md border px-2 text-xs text-muted-foreground">
                    <span class="truncate">{{ t("grid.filterBuilderContains") }}</span>
                  </div>
                  <Input v-model="filterInput" class="h-8 min-w-0 text-xs" :placeholder="t('gridfsBrowser.bucketNamePlaceholder')" @keydown.enter.prevent="applyBucketNameFilter" />
                </div>
                <div class="flex items-center justify-between gap-2 pt-1">
                  <Button variant="ghost" size="sm" class="h-8 px-2 text-xs" @click="clearBucketNameFilter">
                    {{ t("grid.clearFilter") }}
                  </Button>
                  <div class="flex items-center gap-2">
                    <Button variant="ghost" size="sm" class="h-8 px-2 text-xs" @click="resetBucketNameFilter">
                      {{ t("grid.resetFilterBuilder") }}
                    </Button>
                    <Button size="sm" class="h-8 px-3 text-xs" @click="applyBucketNameFilter">
                      {{ t("grid.applyFilter") }}
                    </Button>
                  </div>
                </div>
              </PopoverContent>
            </Popover>
            <span class="shrink-0 text-xs font-medium text-blue-600 dark:text-blue-400">{{ t("grid.filter") }}</span>
            <input v-model="filterInput" autocapitalize="off" autocorrect="off" spellcheck="false" class="h-7 min-w-0 flex-1 bg-transparent text-xs outline-none placeholder:text-muted-foreground/60" :placeholder="t('gridfsBrowser.bucketNamePlaceholder')" @keydown.enter="applyQuery" />
            <button
              v-if="filterInput.trim()"
              class="shrink-0 text-muted-foreground hover:text-foreground"
              @click="
                filterInput = '';
                applyQuery();
              "
            >
              <X class="h-3.5 w-3.5" />
            </button>
          </div>
          <div class="h-px bg-border/70 md:h-auto md:w-px" />
          <div class="flex min-w-0 flex-1 items-center gap-1 px-2 py-1.5">
            <span class="shrink-0 text-xs font-medium text-orange-600 dark:text-orange-400">{{ t("grid.sort") }}</span>
            <input v-model="sortInput" autocapitalize="off" autocorrect="off" spellcheck="false" class="h-7 min-w-0 flex-1 bg-transparent font-mono text-xs outline-none placeholder:text-muted-foreground/60" placeholder='{"name":1}' @keydown.enter="applyQuery" />
            <button
              v-if="sortInput.trim()"
              class="shrink-0 text-muted-foreground hover:text-foreground"
              @click="
                sortInput = '';
                applyQuery();
              "
            >
              <X class="h-3.5 w-3.5" />
            </button>
          </div>
        </div>
      </div>
    </div>

    <div v-if="error" class="px-4 py-3 text-sm text-destructive">
      {{ error }}
    </div>

    <div v-else-if="loading && buckets.length === 0" class="flex flex-1 items-center justify-center text-sm text-muted-foreground">
      {{ t("executionSummary.executing") }}
    </div>

    <div v-else-if="buckets.length === 0" class="flex flex-1 items-center justify-center px-6 text-sm text-muted-foreground">
      {{ t("gridfsBrowser.emptyBuckets") }}
    </div>

    <div v-else class="min-h-0 flex flex-1 flex-col overflow-hidden xl:flex-row xl:divide-x xl:divide-border">
      <div class="min-h-0 flex-1 overflow-auto">
        <table class="min-w-full border-collapse text-sm">
          <thead class="sticky top-0 z-10 bg-background">
            <tr class="border-b border-border text-left text-xs text-muted-foreground">
              <th class="px-4 py-2 font-medium">
                <button type="button" class="inline-flex items-center gap-1 hover:text-foreground" @click="toggleSortForColumn('name')">
                  <span>{{ t("gridfsBrowser.name") }}</span>
                  <component :is="sortIconForColumn('name')" class="h-3.5 w-3.5" :class="sortIconClass('name')" />
                </button>
              </th>
              <th class="px-4 py-2 font-medium">
                <button type="button" class="inline-flex items-center gap-1 hover:text-foreground" @click="toggleSortForColumn('fileCount')">
                  <span>{{ t("gridfsBrowser.fileCount") }}</span>
                  <component :is="sortIconForColumn('fileCount')" class="h-3.5 w-3.5" :class="sortIconClass('fileCount')" />
                </button>
              </th>
              <th class="px-4 py-2 font-medium">
                <button type="button" class="inline-flex items-center gap-1 hover:text-foreground" @click="toggleSortForColumn('totalBytes')">
                  <span>{{ t("gridfsBrowser.totalSize") }}</span>
                  <component :is="sortIconForColumn('totalBytes')" class="h-3.5 w-3.5" :class="sortIconClass('totalBytes')" />
                </button>
              </th>
            </tr>
          </thead>
          <tbody>
            <tr v-for="bucket in buckets" :key="bucket.name" class="cursor-pointer border-b border-border/60 transition-colors hover:bg-muted/40" :class="{ 'bg-accent/45': selectedBucketName === bucket.name }" @click="selectedBucketName = bucket.name" @dblclick="openBucket(bucket.name)">
              <td class="px-4 py-2 font-medium">{{ bucket.name }}</td>
              <td class="px-4 py-2 text-muted-foreground">{{ bucket.fileCount }}</td>
              <td class="px-4 py-2 text-muted-foreground">{{ formatBytes(bucket.totalBytes) }}</td>
            </tr>
          </tbody>
        </table>
      </div>

      <aside class="overflow-auto border-t border-border px-4 py-4 xl:w-72 xl:shrink-0 xl:border-t-0">
        <template v-if="selectedBucket">
          <div class="text-xs font-semibold uppercase tracking-[0.18em] text-muted-foreground">{{ t("tabs.gridfs") }}</div>
          <div class="mt-2 break-all text-lg font-semibold">{{ selectedBucket.name }}</div>

          <div class="mt-5 space-y-4 text-sm">
            <div>
              <div class="text-xs text-muted-foreground">{{ t("gridfsBrowser.fileCount") }}</div>
              <div class="mt-1 font-medium">{{ selectedBucket.fileCount }}</div>
            </div>
            <div>
              <div class="text-xs text-muted-foreground">{{ t("gridfsBrowser.totalSize") }}</div>
              <div class="mt-1 font-medium">{{ formatBytes(selectedBucket.totalBytes) }}</div>
            </div>
          </div>
        </template>
        <div v-else class="text-sm text-muted-foreground">
          {{ t("gridfsBrowser.selectBucket") }}
        </div>
      </aside>
    </div>

    <Dialog v-model:open="showCreateDialog">
      <DialogContent class="sm:max-w-[420px]">
        <DialogHeader>
          <DialogTitle>{{ t("gridfsBrowser.createTitle") }}</DialogTitle>
        </DialogHeader>
        <div class="space-y-2 py-2">
          <label class="text-sm font-medium">{{ t("gridfsBrowser.bucketName") }}</label>
          <Input v-model="newBucketName" :placeholder="t('gridfsBrowser.bucketNamePlaceholder')" @keydown.enter="createBucket" />
        </div>
        <DialogFooter>
          <Button variant="outline" :disabled="creating" @click="showCreateDialog = false">{{ t("common.cancel") }}</Button>
          <Button :disabled="creating || !newBucketName.trim()" class="gap-1.5" @click="createBucket">
            <RefreshCcw v-if="creating" class="h-3.5 w-3.5 animate-spin" />
            {{ t("gridfsBrowser.createBucket") }}
          </Button>
        </DialogFooter>
      </DialogContent>
    </Dialog>

    <DangerConfirmDialog v-model:open="showDeleteConfirm" :loading="deleting" :title="t('gridfsBrowser.deleteTitle')" :message="t('gridfsBrowser.deleteMessage')" :details="selectedBucketName" :confirm-label="t('gridfsBrowser.deleteBucket')" @confirm="deleteBucket" />
  </div>
</template>