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。

9.9 KB
Raw Blame
<script setup lang="ts">
import { computed, onMounted, ref } from "vue";
import { useI18n } from "vue-i18n";
import { Activity, Database, FileText, KeyRound, Loader2, Plus, RefreshCcw, Tags } from "@lucide/vue";
import { Button } from "@/components/ui/button";
import { Input } from "@/components/ui/input";
import { Dialog, DialogContent, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog";
import ErrorBanner from "@/components/ui/ErrorBanner.vue";
import QueryLoadingState from "@/components/common/QueryLoadingState.vue";
import * as api from "@/lib/backend/api";
import { formatBytes } from "@/lib/database/serverMetrics";
import { formatMeilisearchTaskDateTime, type MeilisearchSystemOverview, type OverviewSection } from "@/types/meilisearchManagement";
import { useConnectionStore } from "@/stores/connectionStore";
import { connectionIsEffectivelyReadOnly } from "@/lib/database/readOnlyWriteAccess";
import { useToast } from "@/composables/useToast";

const props = defineProps<{ connectionId: string }>();
const { locale, t } = useI18n();
const { toast } = useToast();
const connectionStore = useConnectionStore();
const loading = ref(false);
const error = ref("");
const overview = ref<MeilisearchSystemOverview | null>(null);
const createOpen = ref(false);
const createWorking = ref(false);
const createError = ref("");
const createUid = ref("");
const createPrimaryKey = ref("");
const readOnly = computed(() => connectionIsEffectivelyReadOnly(connectionStore.getConfig(props.connectionId)));
let loadRequestId = 0;

const stats = computed(() => overview.value?.stats.data ?? null);
const cards = computed(() => [
  { label: t("meilisearch.health"), value: overview.value?.health.data?.status ?? sectionLabel(overview.value?.health), icon: Activity },
  { label: t("meilisearch.version"), value: overview.value?.version.data?.pkgVersion ?? sectionLabel(overview.value?.version), icon: Tags },
  { label: t("meilisearch.indexCount"), value: stats.value?.indexCount ?? sectionLabel(overview.value?.stats), icon: Database },
  { label: t("meilisearch.totalDocuments"), value: stats.value?.documentCount ?? sectionLabel(overview.value?.stats), icon: FileText },
  { label: t("meilisearch.indexingCount"), value: stats.value?.indexingCount ?? sectionLabel(overview.value?.stats), icon: RefreshCcw },
  { label: t("meilisearch.keyCount"), value: overview.value?.keyCount.data ?? sectionLabel(overview.value?.keyCount), icon: KeyRound },
]);

function sectionLabel(section?: OverviewSection<unknown>): string {
  if (!section) return "-";
  return section.message || t(`meilisearch.sectionStatus.${section.status}`);
}

async function load() {
  const requestId = ++loadRequestId;
  loading.value = true;
  error.value = "";
  try {
    const result = await api.meilisearchGetSystemOverview(props.connectionId);
    if (requestId !== loadRequestId) return;
    overview.value = result;
  } catch (cause: any) {
    if (requestId !== loadRequestId) return;
    error.value = cause?.message || String(cause);
  } finally {
    if (requestId === loadRequestId) loading.value = false;
  }
}

function refresh() {
  if (loading.value) return;
  void load();
}

function openCreate() {
  createUid.value = "";
  createPrimaryKey.value = "";
  createError.value = "";
  createOpen.value = true;
}

async function createIndex() {
  const uid = createUid.value.trim();
  if (!uid) {
    createError.value = t("meilisearch.createIndexUidRequired");
    return;
  }

  createWorking.value = true;
  createError.value = "";
  try {
    await api.meilisearchCreateIndex(props.connectionId, {
      uid,
      ...(createPrimaryKey.value.trim() ? { primaryKey: createPrimaryKey.value.trim() } : {}),
    });
    createOpen.value = false;
    toast(t("meilisearch.indexCreated"));
    await load();
    try {
      await connectionStore.loadElasticsearchIndices(props.connectionId);
    } catch (refreshError) {
      console.warn("[DBX][meilisearch-index-refresh:error]", refreshError);
    }
  } catch (cause: any) {
    createError.value = cause?.message || String(cause);
  } finally {
    createWorking.value = false;
  }
}

onMounted(() => void load());
</script>

<template>
  <div class="h-full select-none overflow-y-auto p-4">
    <div class="mb-4 flex items-center justify-between">
      <div>
        <h2 class="text-base font-semibold">{{ t("meilisearch.overview") }}</h2>
        <p class="text-xs text-muted-foreground">{{ t("meilisearch.overviewDescription") }}</p>
      </div>
      <div class="flex items-center gap-2">
        <Button size="sm" variant="outline" :disabled="readOnly" @click="openCreate"><Plus class="mr-1 h-3.5 w-3.5" />{{ t("meilisearch.createIndex") }}</Button>
        <Button size="sm" variant="outline" :disabled="loading" @click="refresh"><RefreshCcw class="mr-1 h-3.5 w-3.5" />{{ t("meilisearch.refresh") }}</Button>
      </div>
    </div>
    <QueryLoadingState v-if="loading && !overview" class="py-12" />
    <ErrorBanner v-else-if="error && !overview" :message="error" />
    <template v-else-if="overview">
      <ErrorBanner v-if="error" class="mb-3" :message="error" />
      <div class="grid gap-3 sm:grid-cols-2 xl:grid-cols-3">
        <div v-for="card in cards" :key="card.label" class="rounded-lg border bg-card p-4">
          <div class="flex items-center gap-2 text-xs text-muted-foreground"><component :is="card.icon" class="h-4 w-4" />{{ card.label }}</div>
          <div class="mt-2 break-words text-xl font-semibold tabular-nums">{{ card.value }}</div>
        </div>
      </div>

      <div class="mt-4 grid gap-3 xl:grid-cols-2">
        <section class="rounded-lg border bg-card p-4">
          <h3 class="mb-3 text-sm font-semibold">{{ t("meilisearch.storage") }}</h3>
          <div v-if="stats" class="grid grid-cols-2 gap-3 text-xs">
            <div>
              <div class="text-muted-foreground">{{ t("meilisearch.databaseSize") }}</div>
              <div class="mt-1 text-sm font-medium">{{ stats.databaseSize == null ? "-" : formatBytes(stats.databaseSize) }}</div>
            </div>
            <div>
              <div class="text-muted-foreground">{{ t("meilisearch.usedDatabaseSize") }}</div>
              <div class="mt-1 text-sm font-medium">{{ stats.usedDatabaseSize == null ? "-" : formatBytes(stats.usedDatabaseSize) }}</div>
            </div>
            <div class="col-span-2">
              <div class="text-muted-foreground">{{ t("meilisearch.lastUpdate") }}</div>
              <div class="mt-1 text-sm font-medium" :title="stats.lastUpdate || undefined">{{ formatMeilisearchTaskDateTime(stats.lastUpdate, locale) }}</div>
            </div>
          </div>
          <p v-else class="text-xs text-muted-foreground">{{ sectionLabel(overview.stats) }}</p>
        </section>

        <section class="rounded-lg border bg-card p-4">
          <h3 class="mb-3 text-sm font-semibold">{{ t("meilisearch.taskStatusDistribution") }}</h3>
          <div v-if="overview.taskCounts.data" class="grid grid-cols-2 gap-2 text-xs sm:grid-cols-3">
            <div v-for="(count, status) in overview.taskCounts.data" :key="status" class="rounded border px-2 py-2">
              <div class="text-muted-foreground">{{ status }}</div>
              <div class="mt-1 text-base font-semibold tabular-nums">{{ count }}</div>
            </div>
          </div>
          <p v-else class="text-xs text-muted-foreground">{{ sectionLabel(overview.taskCounts) }}</p>
        </section>
      </div>

      <section class="mt-4 rounded-lg border bg-card">
        <div class="border-b px-4 py-3 text-sm font-semibold">{{ t("meilisearch.topIndexes") }}</div>
        <div v-if="overview.topIndexes.data?.length" class="overflow-x-auto">
          <table class="w-full text-left text-xs">
            <thead class="bg-muted/40 text-muted-foreground">
              <tr>
                <th class="px-4 py-2">{{ t("meilisearch.uid") }}</th>
                <th class="px-4 py-2">{{ t("meilisearch.documentCountLabel") }}</th>
                <th class="px-4 py-2">{{ t("meilisearch.status") }}</th>
              </tr>
            </thead>
            <tbody>
              <tr v-for="item in overview.topIndexes.data" :key="item.uid" class="border-t">
                <td class="px-4 py-2 font-mono">{{ item.uid }}</td>
                <td class="px-4 py-2 tabular-nums">{{ item.numberOfDocuments }}</td>
                <td class="px-4 py-2">{{ item.isIndexing ? t("meilisearch.isIndexing") : t("meilisearch.idle") }}</td>
              </tr>
            </tbody>
          </table>
        </div>
        <p v-else class="p-4 text-xs text-muted-foreground">{{ sectionLabel(overview.topIndexes) }}</p>
      </section>
    </template>
    <Dialog v-model:open="createOpen">
      <DialogContent class="max-w-md">
        <DialogHeader
          ><DialogTitle>{{ t("meilisearch.createIndex") }}</DialogTitle></DialogHeader
        >
        <div class="grid gap-3 text-xs">
          <label class="grid gap-1"
            ><span class="font-medium">{{ t("meilisearch.uid") }}</span
            ><Input v-model="createUid" class="select-text" :disabled="createWorking" :placeholder="t('meilisearch.createIndexUidPlaceholder')"
          /></label>
          <label class="grid gap-1"
            ><span class="font-medium">{{ t("meilisearch.primaryKey") }}</span
            ><Input v-model="createPrimaryKey" class="select-text" :disabled="createWorking" :placeholder="t('meilisearch.createIndexPrimaryKeyPlaceholder')" /><span class="text-[11px] text-muted-foreground">{{ t("meilisearch.createIndexPrimaryKeyHelp") }}</span></label
          >
          <ErrorBanner v-if="createError" :message="createError" />
        </div>
        <DialogFooter
          ><Button variant="outline" :disabled="createWorking" @click="createOpen = false">{{ t("common.cancel") }}</Button
          ><Button :disabled="createWorking || readOnly" @click="createIndex"><Loader2 v-if="createWorking" class="mr-1 h-3.5 w-3.5 animate-spin" />{{ t("meilisearch.createIndex") }}</Button></DialogFooter
        >
      </DialogContent>
    </Dialog>
  </div>
</template>