Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
// @vitest-environment node
import { beforeEach, describe, expect, test, vi } from "vitest";
import type { SavedQuery } from "@/types/proto-es/v1/saved_query_service_pb";
import { SavedQueryBinding_Level } from "@/types/proto-es/v1/saved_query_service_pb";
const mocks = vi.hoisted(() => ({
currentUser: { email: "[email protected]" },
level: 0 as SavedQueryBinding_Level,
hasProjectWidePermissionV2: vi.fn(
(_project: unknown, _permission: string): boolean => false
),
}));
vi.mock("@/stores", () => ({
getCurrentUserV1: () => mocks.currentUser,
}));
vi.mock("@/stores/app/projectAccess", () => ({
getProjectByName: (name: string) => ({ name }),
}));
vi.mock("@/stores/app/savedQueryAccess", () => ({
getSavedQueryLevel: () => mocks.level,
}));
vi.mock("@/utils", () => ({
hasProjectWidePermissionV2: mocks.hasProjectWidePermissionV2,
}));
import {
isSavedQueryDeletableV1,
isSavedQueryReadableV1,
isSavedQueryShareableV1,
isSavedQueryWritableV1,
} from "./savedQuery";
const sheet = (creator: string) =>
({
name: "projects/proj/savedQueries/sq",
project: "projects/proj",
creator,
}) as SavedQuery;
const mine = sheet("users/[email protected]");
const theirs = sheet("users/[email protected]");
describe("saved query access predicates", () => {
beforeEach(() => {
mocks.level = SavedQueryBinding_Level.LEVEL_UNSPECIFIED;
mocks.hasProjectWidePermissionV2.mockReset();
mocks.hasProjectWidePermissionV2.mockReturnValue(false);
});
test("the creator holds every predicate", () => {
expect(isSavedQueryReadableV1(mine)).toBe(true);
expect(isSavedQueryWritableV1(mine)).toBe(true);
expect(isSavedQueryDeletableV1(mine)).toBe(true);
expect(isSavedQueryShareableV1(mine)).toBe(true);
});
test("a VIEWER binding grants read only", () => {
mocks.level = SavedQueryBinding_Level.VIEWER;
expect(isSavedQueryReadableV1(theirs)).toBe(true);
expect(isSavedQueryWritableV1(theirs)).toBe(false);
expect(isSavedQueryDeletableV1(theirs)).toBe(false);
expect(isSavedQueryShareableV1(theirs)).toBe(false);
});
test("an EDITOR binding grants read and write, never delete or share", () => {
mocks.level = SavedQueryBinding_Level.EDITOR;
expect(isSavedQueryReadableV1(theirs)).toBe(true);
expect(isSavedQueryWritableV1(theirs)).toBe(true);
expect(isSavedQueryDeletableV1(theirs)).toBe(false);
expect(isSavedQueryShareableV1(theirs)).toBe(false);
});
test("each predicate asks for exactly its project-level verb", () => {
const byVerb = (verb: string) =>
mocks.hasProjectWidePermissionV2.mockImplementation(
(_project: unknown, permission: string) => permission === verb
);
byVerb("bb.savedQueries.get");
expect(isSavedQueryReadableV1(theirs)).toBe(true);
expect(isSavedQueryWritableV1(theirs)).toBe(false);
byVerb("bb.savedQueries.update");
expect(isSavedQueryWritableV1(theirs)).toBe(true);
expect(isSavedQueryDeletableV1(theirs)).toBe(false);
byVerb("bb.savedQueries.delete");
expect(isSavedQueryDeletableV1(theirs)).toBe(true);
expect(isSavedQueryShareableV1(theirs)).toBe(false);
// setIamPolicy alone is not enough: the write is compare-and-swap over
// the policy's etag, which only getIamPolicy can read.
byVerb("bb.savedQueries.setIamPolicy");
expect(isSavedQueryShareableV1(theirs)).toBe(false);
byVerb("bb.savedQueries.getIamPolicy");
expect(isSavedQueryShareableV1(theirs)).toBe(false);
mocks.hasProjectWidePermissionV2.mockImplementation(
(_project: unknown, permission: string) =>
permission === "bb.savedQueries.setIamPolicy" ||
permission === "bb.savedQueries.getIamPolicy"
);
expect(isSavedQueryShareableV1(theirs)).toBe(true);
expect(isSavedQueryReadableV1(theirs)).toBe(false);
});
});