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 { create, type MessageInitShape } from "@bufbuild/protobuf";
import { describe, expect, test } from "vitest";
import {
BindingSchema,
IamPolicySchema,
} from "@/types/proto-es/v1/iam_policy_pb";
import { UserSchema } from "@/types/proto-es/v1/user_service_pb";
import {
buildDatabaseFilter,
buildProjectFilter,
getLabelFilter,
projectWideBindings,
} from "./utils";
const QUOTED = 'SELECT * FROM "users"';
const ESCAPED = 'SELECT * FROM \\"users\\"';
describe("buildDatabaseFilter", () => {
test("escapes the database name query as a CEL string literal", () => {
expect(buildDatabaseFilter({ query: 'Payroll "Q3"\\West\nArchive' })).toBe(
'name.contains("payroll \\"q3\\"\\\\west\\narchive")'
);
});
test("escapes a quote in the table filter", () => {
expect(buildDatabaseFilter({ table: 't"1' })).toBe(
'table.contains("t\\"1")'
);
});
});
describe("buildProjectFilter", () => {
test("escapes a quote in the free-text query", () => {
const filter = buildProjectFilter(QUOTED).toLowerCase();
expect(filter).not.toContain(QUOTED.toLowerCase());
expect(filter).toContain(ESCAPED.toLowerCase());
});
});
describe("getLabelFilter", () => {
// Label keys allow dashes. `labels.cost-center` parses as subtraction, so
// the backend never saw the key and rejected the whole filter.
test("uses index syntax so a dashed key survives CEL parsing", () => {
expect(getLabelFilter(["cost-center:eng"])).toEqual([
'labels["cost-center"] == "eng"',
]);
});
test("uses index syntax for multi-value keys", () => {
expect(getLabelFilter(["cost-center:eng,ops"])).toEqual([
'labels["cost-center"] in ["eng", "ops"]',
]);
});
});
describe("projectWideBindings", () => {
const me = create(UserSchema, {
name: "users/[email protected]",
groups: ["groups/eng"],
});
const policyWith = (bindings: MessageInitShape<typeof BindingSchema>[]) =>
create(IamPolicySchema, {
bindings: bindings.map((binding) => create(BindingSchema, binding)),
});
const roles = (policy: ReturnType<typeof policyWith>, skipAllUsers = false) =>
projectWideBindings(policy, me, { skipAllUsers }).map((b) => b.role);
test("matches the user directly, via group, and via allUsers", () => {
const policy = policyWith([
{ role: "roles/direct", members: ["user:[email protected]"] },
{ role: "roles/viaGroup", members: ["group:eng"] },
{ role: "roles/viaAllUsers", members: ["allUsers"] },
{ role: "roles/somebodyElse", members: ["user:[email protected]"] },
]);
expect(roles(policy)).toEqual([
"roles/direct",
"roles/viaGroup",
"roles/viaAllUsers",
]);
});
test("skips allUsers when asked, as the server does for workspace policy in SaaS mode", () => {
const policy = policyWith([
{ role: "roles/direct", members: ["user:[email protected]"] },
{ role: "roles/viaAllUsers", members: ["allUsers"] },
]);
expect(roles(policy, true)).toEqual(["roles/direct"]);
});
test("a resource-scoped condition confers nothing", () => {
const policy = policyWith([
{
role: "roles/scoped",
members: ["user:[email protected]"],
condition: {
expression: 'resource.database == "instances/i/databases/d"',
},
},
]);
expect(roles(policy)).toEqual([]);
});
test("honors the canonical expiry form in both directions", () => {
const policy = policyWith([
{
role: "roles/live",
members: ["user:[email protected]"],
condition: {
expression: 'request.time < timestamp("2099-01-01T00:00:00Z")',
},
},
{
role: "roles/expired",
members: ["user:[email protected]"],
condition: {
expression: 'request.time < timestamp("2000-01-01T00:00:00Z")',
},
},
]);
expect(roles(policy)).toEqual(["roles/live"]);
});
test("a time-only condition outside the canonical form hides the grant", () => {
// The server evaluates the full CEL expression and would grant both of
// these until 2099; the client cannot, so it hides the affordance
// rather than showing one whose expiry it would never notice.
const policy = policyWith([
{
role: "roles/reversed",
members: ["user:[email protected]"],
condition: {
expression: 'timestamp("2099-01-01T00:00:00Z") > request.time',
},
},
{
role: "roles/window",
members: ["user:[email protected]"],
condition: {
expression:
'request.time > timestamp("2000-01-01T00:00:00Z") && request.time < timestamp("2099-01-01T00:00:00Z")',
},
},
]);
expect(roles(policy)).toEqual([]);
});
});