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 { describe, expect, it } from "vitest";
import { oracleDependencyProvider, oracleObjectDependenciesSql } from "@/lib/database/oracleObjectDependencies";
const node = (overrides: Record<string, unknown> = {}) => ({ type: "procedure" as const, schema: "APP", objectName: "RUN_JOB", label: "RUN_JOB", ...overrides });
describe("Oracle object dependencies", () => {
it("queries both direct directions and preserves raw dictionary details", () => {
const sql = oracleDependencyProvider.buildQuery(node());
expect(sql).toContain("'DEPENDS_ON' AS DIRECTION");
expect(sql).toContain("'REFERENCED_BY' AS DIRECTION");
expect(sql).toContain("d.TYPE = 'PROCEDURE'");
expect(sql).toContain("d.REFERENCED_TYPE = 'PROCEDURE'");
for (const column of ["OBJECT_OWNER", "OBJECT_NAME", "OBJECT_TYPE", "REFERENCED_OWNER", "REFERENCED_NAME", "REFERENCED_TYPE", "DEPENDENCY_TYPE", "REFERENCED_LINK_NAME"]) {
expect(sql).toContain(column);
}
expect(sql).toContain("FROM ALL_DEPENDENCIES d");
expect(sql).not.toContain("DBA_DEPENDENCIES");
expect(sql).not.toContain("Package/body scope");
});
it("matches local reverse references without hiding remote outbound dependencies", () => {
const sql = oracleDependencyProvider.buildQuery(node())!;
const [dependsOn, referencedBy] = sql.split("UNION ALL");
expect(dependsOn).not.toContain("REFERENCED_LINK_NAME IS NULL");
expect(dependsOn).toContain("d.REFERENCED_LINK_NAME");
expect(referencedBy).toContain("d.REFERENCED_LINK_NAME IS NULL");
});
it("uses the owning package scope for members and exposes it in the title", () => {
const member = node({ type: "function", objectName: "CALC", parentType: "package", parentName: "PAYROLL", parentSchema: "HR" });
expect(oracleDependencyProvider.targetLabel?.(member)).toEqual({ name: "HR.PAYROLL", packageScope: true });
const sql = oracleDependencyProvider.buildQuery(member)!;
expect(sql).toContain("'PAYROLL' AS TARGET_NAME");
expect(sql).toContain("d.TYPE IN ('PACKAGE', 'PACKAGE BODY')");
expect(sql).not.toContain("'CALC' AS TARGET_NAME");
expect(sql).toContain("Package/body scope, not member-level dependencies");
});
it("keeps package and body types distinct in package-scoped results", () => {
const sql = oracleObjectDependenciesSql({ schema: "HR", objectName: "PAYROLL", objectType: "PACKAGE" });
expect(sql).toContain("d.TYPE IN ('PACKAGE', 'PACKAGE BODY')");
expect(sql).toContain("d.REFERENCED_TYPE IN ('PACKAGE', 'PACKAGE BODY')");
expect(sql).toContain("d.TYPE AS OBJECT_TYPE");
});
it("escapes literals and rejects incomplete or unsupported tree nodes", () => {
expect(oracleObjectDependenciesSql({ schema: "O'BRIEN", objectName: "R'UN", objectType: "FUNCTION" })).toContain("'O''BRIEN'");
expect(oracleDependencyProvider.buildQuery(node({ schema: undefined }))).toBeNull();
expect(oracleDependencyProvider.supports(node({ type: "procedure", parentType: "package", parentName: "PKG" }))).toBe(false);
expect(oracleDependencyProvider.supports(node({ type: "procedure", parentType: "package", parentName: "PKG", parentSchema: undefined }))).toBe(false);
expect(oracleDependencyProvider.supports(node({ type: "column" }))).toBe(false);
expect(oracleDependencyProvider.supports(node({ type: "trigger" }))).toBe(false);
const trigger = node({ type: "trigger", meta: { name: "RUN_JOB", event: "INSERT", timing: "BEFORE", oracle_metadata: { contractVersion: 1, identityMode: "exact", engine: "oracle", owner: "APP", name: "RUN_JOB", scope: "TABLE", reads: {} } } });
expect(oracleDependencyProvider.supports(trigger)).toBe(true);
expect(oracleDependencyProvider.buildQuery(trigger)).toContain("d.TYPE = 'TRIGGER'");
});
});