Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
import { act, createElement } from "react";
import { createRoot } from "react-dom/client";
import { beforeEach, describe, expect, test, vi } from "vitest";
(
globalThis as { IS_REACT_ACT_ENVIRONMENT?: boolean }
).IS_REACT_ACT_ENVIRONMENT = true;
const mocks = vi.hoisted(() => {
const localStorage = {
clear: vi.fn(),
getItem: vi.fn(() => null),
removeItem: vi.fn(),
setItem: vi.fn(),
};
vi.stubGlobal("localStorage", localStorage);
return {
localStorage,
routerPush: vi.fn(),
useProjectDatabaseDetail: vi.fn(),
extractDatabaseResourceName: vi.fn((name: string) => ({
instance: "instances/inst1",
instanceName: "inst1",
database: name,
databaseName: name.split("/databases/").at(-1) ?? "",
})),
extractInstanceResourceName: vi.fn(
(name: string) => name.split("/").at(-1) ?? ""
),
extractProjectResourceName: vi.fn(
(name: string) => name.split("/").at(-1) ?? ""
),
useTranslation: vi.fn(() => ({
t: (key: string) => key,
})),
LoaderCircle: vi.fn(() => <div data-testid="spinner" />),
RevisionDetailPanel: vi.fn(({ revisionName }: { revisionName: string }) => (
<div data-testid="revision-detail-panel">{revisionName}</div>
)),
routeNames: {
databases: "workspace.project.database",
databaseDetail: "workspace.project.database.detail",
databaseRevisionDetail: "workspace.project.database.revision.detail",
},
};
});
type DatabaseRevisionDetailPageComponent =
typeof import("./DatabaseRevisionDetailPage").DatabaseRevisionDetailPage;
let DatabaseRevisionDetailPage: DatabaseRevisionDetailPageComponent;
vi.mock("lucide-react", () => ({
LoaderCircle: mocks.LoaderCircle,
}));
vi.mock("react-i18next", () => ({
useTranslation: mocks.useTranslation,
}));
vi.mock("@/components/revision", () => ({
RevisionDetailPanel: mocks.RevisionDetailPanel,
}));
vi.mock("@/app/router", async (importOriginal) => ({
...(await importOriginal<typeof import("@/app/router")>()),
router: {
push: mocks.routerPush,
resolve: (to: unknown) => ({ href: String(to), fullPath: String(to) }),
},
}));
vi.mock("./database-detail/useProjectDatabaseDetail", () => ({
useProjectDatabaseDetail: mocks.useProjectDatabaseDetail,
}));
vi.mock("@/utils", () => ({
autoDatabaseRoute: (database: { name: string; project: string }) => {
const parent = database.name.split("/databases/")[0];
return {
name: mocks.routeNames.databaseDetail,
params: {
projectId: database.project.split("/").at(-1),
instanceId: parent.split("/instances/").at(-1),
databaseName: database.name.split("/databases/").at(-1),
},
query: { parent },
};
},
}));
vi.mock("@/utils/v1/database", () => ({
extractDatabaseResourceName: mocks.extractDatabaseResourceName,
}));
vi.mock("@/utils/v1/instance", () => ({
extractInstanceResourceName: mocks.extractInstanceResourceName,
}));
vi.mock("@/utils/v1/project", () => ({
extractProjectResourceName: mocks.extractProjectResourceName,
}));
const renderIntoContainer = (element: ReturnType<typeof createElement>) => {
const container = document.createElement("div");
const root = createRoot(container);
return {
container,
render: (nextElement = element) => {
act(() => {
root.render(nextElement);
});
},
unmount: () =>
act(() => {
root.unmount();
}),
};
};
beforeEach(() => {
mocks.localStorage.getItem.mockReset();
mocks.localStorage.getItem.mockReturnValue(null);
mocks.localStorage.setItem.mockReset();
mocks.localStorage.removeItem.mockReset();
mocks.localStorage.clear.mockReset();
mocks.routerPush.mockReset();
mocks.useProjectDatabaseDetail.mockReset();
mocks.extractDatabaseResourceName.mockReset();
mocks.extractDatabaseResourceName.mockImplementation((name: string) => ({
instance: "instances/inst1",
instanceName: "inst1",
database: name,
databaseName: name.split("/databases/").at(-1) ?? "",
}));
mocks.extractInstanceResourceName.mockReset();
mocks.extractInstanceResourceName.mockImplementation(
(name: string) => name.split("/").at(-1) ?? ""
);
mocks.extractProjectResourceName.mockReset();
mocks.extractProjectResourceName.mockImplementation(
(name: string) => name.split("/").at(-1) ?? ""
);
mocks.useTranslation.mockReset();
mocks.useTranslation.mockReturnValue({
t: (key: string) => key,
});
mocks.LoaderCircle.mockClear();
mocks.RevisionDetailPanel.mockClear();
});
beforeEach(async () => {
vi.resetModules();
({ DatabaseRevisionDetailPage } = await import(
"./DatabaseRevisionDetailPage"
));
});
describe("DatabaseRevisionDetailPage", () => {
test("shows a spinner while the shared database hook is loading", async () => {
mocks.useProjectDatabaseDetail.mockReturnValue({
database: {
name: "instances/inst1/databases/db-from-hook",
project: "projects/proj1",
},
databaseName: "instances/inst1/databases/db-from-hook",
loading: true,
ready: false,
allowAlterSchema: true,
isDefaultProject: false,
});
const { container, render, unmount } = renderIntoContainer(
createElement(DatabaseRevisionDetailPage, {
projectId: "proj1",
instanceId: "inst1",
databaseName: "db-from-prop",
revisionId: "7",
})
);
render();
await act(async () => {
await Promise.resolve();
await Promise.resolve();
});
expect(container.querySelector('[data-testid="spinner"]')).not.toBeNull();
expect(mocks.RevisionDetailPanel).not.toHaveBeenCalled();
unmount();
});
test("builds the revision name from the resolved database detail", async () => {
mocks.useProjectDatabaseDetail.mockReturnValue({
database: {
name: "projects/proj1/instances/inst1/databases/db-from-hook",
project: "projects/proj1",
},
databaseName:
"projects/proj1/instances/inst1/databases/db-from-hook",
loading: false,
ready: true,
allowAlterSchema: true,
isDefaultProject: false,
});
const { container, render, unmount } = renderIntoContainer(
createElement(DatabaseRevisionDetailPage, {
projectId: "proj1",
instanceId: "inst1",
databaseName: "db-from-prop",
revisionId: "7",
routeQuery: {
parent: "projects/proj1/instances/inst1",
},
})
);
render();
await act(async () => {
await Promise.resolve();
await Promise.resolve();
});
expect(mocks.useProjectDatabaseDetail).toHaveBeenCalledWith({
parent: "projects/proj1/instances/inst1",
projectId: "proj1",
instanceId: "inst1",
databaseName: "db-from-prop",
});
expect(mocks.RevisionDetailPanel).toHaveBeenCalled();
expect(mocks.RevisionDetailPanel.mock.calls[0]?.[0]).toEqual({
revisionName:
"projects/proj1/instances/inst1/databases/db-from-hook/revisions/7",
});
expect(container.textContent).toContain(
"projects/proj1/instances/inst1/databases/db-from-hook/revisions/7"
);
const clickBreadcrumb = async (label: string) => {
const link = Array.from(container.querySelectorAll("a")).find(
(candidate) => candidate.textContent === label
);
await act(async () => {
link?.dispatchEvent(
new MouseEvent("click", { bubbles: true, cancelable: true })
);
});
};
await clickBreadcrumb("common.databases");
expect(mocks.routerPush).toHaveBeenCalledWith({
name: mocks.routeNames.databases,
params: {
projectId: "proj1",
},
});
await clickBreadcrumb("db-from-prop");
expect(mocks.routerPush).toHaveBeenCalledWith({
name: mocks.routeNames.databaseDetail,
params: {
projectId: "proj1",
instanceId: "inst1",
databaseName: "db-from-hook",
},
query: { parent: "projects/proj1/instances/inst1" },
});
await clickBreadcrumb("database.revision.self");
expect(mocks.routerPush).toHaveBeenCalledWith({
name: mocks.routeNames.databaseDetail,
params: {
projectId: "proj1",
instanceId: "inst1",
databaseName: "db-from-hook",
},
hash: "#revision",
query: { parent: "projects/proj1/instances/inst1" },
});
const databaseBreadcrumb = Array.from(container.querySelectorAll("a")).find(
(link) => link.textContent === "db-from-prop"
);
expect(databaseBreadcrumb).not.toBeNull();
unmount();
});
});