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。

963 B
Raw Blame
import { strict as assert } from "node:assert";
import { test } from "vitest";
import { resolveHistoryActivityKind } from "../../apps/desktop/src/lib/history/historyActivityKind.ts";

test("legacy INSERT history entries are treated as data changes", () => {
  assert.equal(
    resolveHistoryActivityKind({
      activity_kind: "query",
      operation: "INSERT",
      sql: "INSERT INTO job_entries (id) VALUES (1)",
    }),
    "data_change",
  );
});

test("legacy CREATE history entries are treated as schema changes", () => {
  assert.equal(
    resolveHistoryActivityKind({
      activity_kind: "query",
      operation: "CREATE",
      sql: "CREATE TABLE resume_contexts (id bigint)",
    }),
    "schema_change",
  );
});

test("SELECT history entries stay queries", () => {
  assert.equal(
    resolveHistoryActivityKind({
      activity_kind: "query",
      operation: "SELECT",
      sql: "SELECT * FROM education_notes",
    }),
    "query",
  );
});