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 { describe, expect, test, vi } from "vitest";
import {
getRoleEnvironmentLimitationKind,
getRolesEnvironmentLimitationKind,
roleHasDatabaseLimitation,
} from "./utils";
const fixtures: Record<string, string[]> = {
"roles/sqlEditorUser": ["bb.sql.ddl", "bb.sql.dml"],
"roles/sqlEditorDDLOnly": ["bb.sql.ddl"],
"roles/sqlEditorDMLOnly": ["bb.sql.dml"],
"roles/queryOnly": ["bb.sql.select"],
"roles/exportOnly": ["bb.sql.export"],
"roles/projectViewer": [],
};
vi.mock("@/stores/app", () => ({
useAppStore: { getState: () => ({ roleList: [] }) },
}));
vi.mock("@/utils", () => ({
displayRoleTitle: (r: string) => r,
checkRoleContainsAnyPermission: (role: string, ...permissions: string[]) =>
permissions.some((permission) => fixtures[role]?.includes(permission)),
}));
describe("roleHasDatabaseLimitation", () => {
test("offers database scoping for roles that read or export data", () => {
expect(roleHasDatabaseLimitation("roles/queryOnly")).toBe(true);
expect(roleHasDatabaseLimitation("roles/exportOnly")).toBe(true);
});
test("offers no database scoping for roles without SQL permissions", () => {
expect(roleHasDatabaseLimitation("roles/projectViewer")).toBe(false);
});
});
describe("getRoleEnvironmentLimitationKind", () => {
test("returns 'DDL/DML' when role has both ddl and dml", () => {
expect(getRoleEnvironmentLimitationKind("roles/sqlEditorUser")).toBe(
"DDL/DML"
);
});
test("returns 'DDL' when role has only ddl", () => {
expect(getRoleEnvironmentLimitationKind("roles/sqlEditorDDLOnly")).toBe(
"DDL"
);
});
test("returns 'DML' when role has only dml", () => {
expect(getRoleEnvironmentLimitationKind("roles/sqlEditorDMLOnly")).toBe(
"DML"
);
});
test("returns undefined when role has neither ddl nor dml", () => {
expect(getRoleEnvironmentLimitationKind("roles/queryOnly")).toBeUndefined();
});
test("returns undefined for an unknown role", () => {
expect(
getRoleEnvironmentLimitationKind("roles/doesNotExist")
).toBeUndefined();
});
});
describe("getRolesEnvironmentLimitationKind", () => {
test("unions the roles' permissions", () => {
expect(
getRolesEnvironmentLimitationKind([
"roles/sqlEditorDDLOnly",
"roles/sqlEditorDMLOnly",
])
).toBe("DDL/DML");
expect(getRolesEnvironmentLimitationKind(["roles/sqlEditorDDLOnly"])).toBe(
"DDL"
);
});
test("ignores roles without the permissions and unknown roles", () => {
expect(
getRolesEnvironmentLimitationKind(["roles/queryOnly", "roles/missing"])
).toBeUndefined();
expect(getRolesEnvironmentLimitationKind([])).toBeUndefined();
expect(
getRolesEnvironmentLimitationKind([
"roles/missing",
"roles/sqlEditorUser",
])
).toBe("DDL/DML");
});
});