Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.9 KB
Raw Blame
import { beforeEach, describe, expect, test, vi } from "vitest";
import {
  type AccessGrantDraft,
  consumeAccessGrantDraft,
  markDeniedQueryRequestDraftDelivered,
  saveAccessGrantDraft,
  wasDeniedQueryRequestDraftDelivered,
} from "./accessGrantDraft";

const draft: AccessGrantDraft = {
  project: "projects/sample",
  sourceDatabase: "instances/prod/databases/app",
  targets: ["instances/prod/databases/app"],
  statement: "SELECT id FROM users",
  schema: "public",
};

beforeEach(() => {
  vi.useRealTimers();
  sessionStorage.clear();
});

describe("access grant draft storage", () => {
  test("holds the exact draft in session storage without putting SQL in its key", () => {
    const key = saveAccessGrantDraft(draft);
    expect(key).not.toContain("SELECT");
    expect(consumeAccessGrantDraft(key)).toEqual(draft);
    expect(sessionStorage.getItem(key)).toBeNull();
  });

  test("rejects unknown keys and malformed stored drafts", () => {
    expect(consumeAccessGrantDraft("other-key")).toBeUndefined();
    const key = saveAccessGrantDraft(draft);
    sessionStorage.setItem(key, "not json");
    expect(consumeAccessGrantDraft(key)).toBeUndefined();
  });

  test("expires a draft instead of opening stale prefilled data", () => {
    vi.useFakeTimers();
    const key = saveAccessGrantDraft(draft);
    vi.advanceTimersByTime(11 * 60 * 1000);
    expect(consumeAccessGrantDraft(key)).toBeUndefined();
  });

  test("reports delivery only after a consumed draft opens a drawer", () => {
    const key = saveAccessGrantDraft(draft);
    markDeniedQueryRequestDraftDelivered(key);
    expect(wasDeniedQueryRequestDraftDelivered(key)).toBe(false);
    expect(consumeAccessGrantDraft(key)).toEqual(draft);
    expect(wasDeniedQueryRequestDraftDelivered(key)).toBe(false);
    markDeniedQueryRequestDraftDelivered(key);
    expect(wasDeniedQueryRequestDraftDelivered(key)).toBe(true);
  });
});