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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
import assert from "node:assert/strict";
import { readFileSync } from "node:fs";
import { test } from "vitest";
const appSource = readFileSync("apps/desktop/src/App.vue", "utf8");
const sqlFilePanelSource = readFileSync("apps/desktop/src/components/layout/SqlFilePanel.vue", "utf8");
const externalSqlFileChangesSource = readFileSync("apps/desktop/src/composables/useExternalSqlFileChanges.ts", "utf8");
function functionSource(source: string, startMarker: string, endMarker: string) {
const start = source.indexOf(startMarker);
const end = source.indexOf(endMarker, start);
assert.ok(start >= 0 && end > start);
return source.slice(start, end);
}
test("external SQL saves persist their selected data source before closing", () => {
const source = functionSource(appSource, "async function writeExternalSqlTab", "async function saveExternalSqlPath");
const write = source.indexOf("api.writeExternalSqlFile");
const remember = source.indexOf("rememberExternalSqlFileTarget");
const close = source.indexOf("queryStore.closeTab");
assert.ok(write >= 0);
assert.ok(write < remember);
assert.ok(remember < close);
assert.ok(source.includes("catalog: tab.catalog"));
// The schema is part of the saved target too: without it a reopened file lands
// on the connection default and sidebar locate misses the table (issue #7648).
assert.ok(source.includes("schema: tab.schema"));
});
test("external SQL open entry points restore a saved data source", () => {
const startupOpen = functionSource(appSource, "async function openSqlFilePath", "async function openPendingSqlFiles");
const startupResolve = startupOpen.indexOf("resolveExternalSqlFileTarget");
const startupTabOpen = startupOpen.indexOf("queryStore.openExternalSqlFile");
assert.ok(startupResolve >= 0);
assert.ok(startupResolve < startupTabOpen);
assert.ok(startupOpen.includes("snapshot.version, target.catalog, target.schema"));
const panelOpen = functionSource(sqlFilePanelSource, "async function openFile", "function executeFile");
const panelResolve = panelOpen.indexOf("resolveExternalSqlFileTarget");
const panelTabOpen = panelOpen.indexOf("queryStore.openExternalSqlFile");
assert.ok(panelResolve >= 0);
assert.ok(panelResolve < panelTabOpen);
assert.ok(panelOpen.includes("snapshot.version, target.catalog, target.schema"));
const pickerOpen = functionSource(appSource, "async function openSqlFile()", "async function importResultArchive");
assert.ok(pickerOpen.includes("applyExternalSqlFileTarget(tab, sqlPath)"));
});
test("external SQL catalog changes persist their complete target", () => {
const source = functionSource(appSource, "function changeActiveCatalog", "async function setActiveDatabaseAsDefault");
assert.ok(source.includes("queryStore.updateCatalog(tab.id, catalog, database)"));
assert.ok(source.includes("rememberExternalSqlFileTarget"));
assert.ok(source.includes("{ connectionId: tab.connectionId, database, catalog, schema: tab.schema }"));
});
test("external SQL schema changes persist their complete target", () => {
const source = functionSource(appSource, "function changeActiveSchema", "function openGitHub");
assert.ok(source.includes("queryStore.updateSchema(tab.id, schema, { schemaQualifiesSql: true })"));
assert.ok(source.includes("rememberExternalSqlFileTarget"));
assert.ok(source.includes("{ connectionId: tab.connectionId, database: tab.database, catalog: tab.catalog, schema }"));
});
test("external SQL overwrite and recreate actions keep checked-write preconditions", () => {
const prepareSave = functionSource(externalSqlFileChangesSource, "async function prepareSave", "\n watch(");
assert.ok(prepareSave.includes("expectedContentHash: change.snapshot.version.contentHash"));
assert.ok(prepareSave.includes("expectedMissing: true"));
assert.equal(prepareSave.includes("force: true"), false);
const setup = appSource.slice(appSource.indexOf("const externalSqlFileChanges = useExternalSqlFileChanges"), appSource.indexOf("const externalSqlFilePrompt"));
assert.ok(setup.includes("writeExternalSqlTab(tab, { expectedMissing: true })"));
});