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 { afterEach, beforeEach, describe, expect, test, vi } from "vitest";
import {
STORAGE_KEY_AI_DISMISS,
STORAGE_KEY_BACK_PATH,
STORAGE_KEY_LANGUAGE,
STORAGE_KEY_ONBOARDING,
STORAGE_KEY_SCHEMA_EDITOR_PREVIEW,
STORAGE_KEY_SQL_EDITOR_AI_PANEL_SIZE,
STORAGE_KEY_SQL_EDITOR_REDIS_NODE,
STORAGE_KEY_SQL_EDITOR_RESULT_LIMIT,
storageKeySqlEditorLastProject,
} from "./storage-keys";
import { migrateStorageKeys, migrateUserStorage } from "./storage-migrate";
const MIGRATION_MARKER = "bb.storage-migration-v1";
function createMockStorage(): Storage {
let store: Record<string, string> = {};
return {
get length() {
return Object.keys(store).length;
},
key(index: number) {
return Object.keys(store)[index] ?? null;
},
getItem(key: string) {
return store[key] ?? null;
},
setItem(key: string, value: string) {
store[key] = String(value);
},
removeItem(key: string) {
delete store[key];
},
clear() {
store = {};
},
};
}
let mockStorage: Storage;
beforeEach(() => {
mockStorage = createMockStorage();
vi.stubGlobal("localStorage", mockStorage);
});
afterEach(() => {
vi.unstubAllGlobals();
});
describe("migrateStorageKeys", () => {
test("sets migration marker after running", () => {
migrateStorageKeys();
expect(localStorage.getItem(MIGRATION_MARKER)).toBe("1");
});
test("skips if migration marker already set", () => {
localStorage.setItem("ui.backPath", "/old");
localStorage.setItem(MIGRATION_MARKER, "1");
migrateStorageKeys();
expect(localStorage.getItem("ui.backPath")).toBe("/old");
expect(localStorage.getItem(STORAGE_KEY_BACK_PATH)).toBeNull();
});
});
describe("static key renames", () => {
test("migrates ui.backPath to bb.back-path", () => {
localStorage.setItem("ui.backPath", "/some/path");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_BACK_PATH)).toBe("/some/path");
expect(localStorage.getItem("ui.backPath")).toBeNull();
});
test("migrates bb.onboarding-state to bb.onboarding", () => {
const state = JSON.stringify({ isOnboarding: true, consumed: ["step1"] });
localStorage.setItem("bb.onboarding-state", state);
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_ONBOARDING)).toBe(state);
expect(localStorage.getItem("bb.onboarding-state")).toBeNull();
});
test("migrates bb.schema-editor.preview.expanded", () => {
localStorage.setItem("bb.schema-editor.preview.expanded", "true");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_SCHEMA_EDITOR_PREVIEW)).toBe(
"true"
);
expect(
localStorage.getItem("bb.schema-editor.preview.expanded")
).toBeNull();
});
test("migrates bb.plugin.open-ai.dismiss-placeholder", () => {
localStorage.setItem("bb.plugin.open-ai.dismiss-placeholder", "true");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_AI_DISMISS)).toBe("true");
});
test("migrates bb.plugin.editor.ai-panel-size", () => {
localStorage.setItem("bb.plugin.editor.ai-panel-size", "0.5");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_SQL_EDITOR_AI_PANEL_SIZE)).toBe(
"0.5"
);
});
test("does not overwrite existing new key", () => {
localStorage.setItem("ui.backPath", "/old");
localStorage.setItem(STORAGE_KEY_BACK_PATH, "/new");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_BACK_PATH)).toBe("/new");
expect(localStorage.getItem("ui.backPath")).toBeNull();
});
});
describe("language migration", () => {
test("migrates bytebase_options nested object to flat string", () => {
localStorage.setItem(
"bytebase_options",
JSON.stringify({ appearance: { language: "zh-CN" } })
);
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_LANGUAGE)).toBe("zh-CN");
expect(localStorage.getItem("bytebase_options")).toBeNull();
});
test("skips language migration if language is empty", () => {
localStorage.setItem(
"bytebase_options",
JSON.stringify({ appearance: { language: "" } })
);
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_LANGUAGE)).toBeNull();
expect(localStorage.getItem("bytebase_options")).toBeNull();
});
test("removes bytebase_options even if new key exists", () => {
localStorage.setItem(
"bytebase_options",
JSON.stringify({ appearance: { language: "zh-CN" } })
);
localStorage.setItem(STORAGE_KEY_LANGUAGE, "en-US");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_LANGUAGE)).toBe("en-US");
expect(localStorage.getItem("bytebase_options")).toBeNull();
});
test("handles malformed bytebase_options gracefully", () => {
localStorage.setItem("bytebase_options", "not-json");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_LANGUAGE)).toBeNull();
expect(localStorage.getItem("bytebase_options")).toBeNull();
});
});
describe("SQL editor migrations", () => {
test("migrates bb.sql-editor.result-rows-limit", () => {
localStorage.setItem("bb.sql-editor.result-rows-limit", "500");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_SQL_EDITOR_RESULT_LIMIT)).toBe(
"500"
);
expect(localStorage.getItem("bb.sql-editor.result-rows-limit")).toBeNull();
});
test("migrates bb.sql-editor.redis-command-node", () => {
localStorage.setItem("bb.sql-editor.redis-command-node", "1");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_SQL_EDITOR_REDIS_NODE)).toBe("1");
expect(localStorage.getItem("bb.sql-editor.redis-command-node")).toBeNull();
});
test("migrates bb.sql-editor.last-viewed-project", () => {
localStorage.setItem(
"bb.sql-editor.last-viewed-project",
'"projects/my-project"'
);
migrateStorageKeys();
expect(localStorage.getItem(storageKeySqlEditorLastProject(""))).toBe(
'"projects/my-project"'
);
expect(
localStorage.getItem("bb.sql-editor.last-viewed-project")
).toBeNull();
});
test("does not overwrite existing sql editor keys", () => {
localStorage.setItem("bb.sql-editor.result-rows-limit", "500");
localStorage.setItem(STORAGE_KEY_SQL_EDITOR_RESULT_LIMIT, "2000");
migrateStorageKeys();
expect(localStorage.getItem(STORAGE_KEY_SQL_EDITOR_RESULT_LIMIT)).toBe(
"2000"
);
});
describe("connection pane expanded state", () => {
test("migrates expanded_{env}.{email} keys", () => {
const state = JSON.stringify({
initialized: true,
expandedKeys: ["env-1/db-1"],
});
localStorage.setItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]",
state
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe(state);
expect(
localStorage.getItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]"
)
).toBeNull();
});
test("migrates multiple environment expanded keys", () => {
localStorage.setItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]",
"prod-state"
);
localStorage.setItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]",
"dev-state"
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe("prod-state");
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe("dev-state");
});
test("does not overwrite existing conn-expanded key when new key exists", () => {
localStorage.setItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]",
"old"
);
localStorage.setItem(
"bb.sql-editor.conn-expanded.environments/[email protected]",
"new"
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe("new");
});
});
describe("tab keys (opening-tab-list and current-tab-id)", () => {
test("migrates opening-tab-list to bb.sql-editor.tabs.*", () => {
const tabs = JSON.stringify([
{ id: "tab-1", worksheet: "projects/my-proj/worksheets/ws-1" },
{ id: "tab-2", worksheet: "projects/my-proj/worksheets/ws-2" },
]);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
tabs
);
migrateStorageKeys();
// The v2 stage renames the legacy `worksheet` link field and its name
// format in the same pass.
expect(
localStorage.getItem(
"bb.sql-editor.tabs.projects/[email protected]"
)
).toBe(
JSON.stringify([
{ id: "tab-1", savedQuery: "projects/my-proj/savedQueries/ws-1" },
{ id: "tab-2", savedQuery: "projects/my-proj/savedQueries/ws-2" },
])
);
expect(
localStorage.getItem(
"bb.sql-editor-tab.projects/[email protected]"
)
).toBeNull();
});
test("migrates current-tab-id to bb.sql-editor.current-tab.*", () => {
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'"tab-1"'
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.current-tab.projects/[email protected]"
)
).toBe('"tab-1"');
expect(
localStorage.getItem(
"bb.sql-editor-tab.projects/[email protected]"
)
).toBeNull();
});
test("migrates both tab list and current tab together", () => {
const tabs = JSON.stringify([
{ id: "tab-a", worksheet: "projects/p1/worksheets/ws-a" },
{ id: "tab-b", worksheet: "projects/p1/worksheets/ws-b" },
]);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
tabs
);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'"tab-b"'
);
migrateStorageKeys();
expect(
localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")
).toBe(
JSON.stringify([
{ id: "tab-a", savedQuery: "projects/p1/savedQueries/ws-a" },
{ id: "tab-b", savedQuery: "projects/p1/savedQueries/ws-b" },
])
);
expect(
localStorage.getItem("bb.sql-editor.current-tab.projects/[email protected]")
).toBe('"tab-b"');
});
test("migrates tabs for multiple projects", () => {
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'[{"id":"t1"}]'
);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'[{"id":"t2"}]'
);
migrateStorageKeys();
expect(
localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")
).toBe('[{"id":"t1"}]');
expect(
localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")
).toBe('[{"id":"t2"}]');
});
test("does not overwrite existing new tab key", () => {
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'[{"id":"old"}]'
);
localStorage.setItem(
"bb.sql-editor.tabs.projects/[email protected]",
'[{"id":"new"}]'
);
migrateStorageKeys();
expect(
localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")
).toBe('[{"id":"new"}]');
});
test("preserves all tabs during migration (no data loss)", () => {
const twoTabs = [
{
id: "tab-1",
worksheet: "worksheets/ws-1",
mode: "READONLY",
viewState: {},
},
{
id: "tab-2",
worksheet: "worksheets/ws-2",
mode: "READONLY",
viewState: {},
},
];
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
JSON.stringify(twoTabs)
);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'"tab-2"'
);
migrateStorageKeys();
const migrated = JSON.parse(
localStorage.getItem(
"bb.sql-editor.tabs.projects/[email protected]"
)!
);
expect(migrated).toHaveLength(2);
expect(migrated[0].id).toBe("tab-1");
expect(migrated[1].id).toBe("tab-2");
expect(
localStorage.getItem(
"bb.sql-editor.current-tab.projects/[email protected]"
)
).toBe('"tab-2"');
});
});
});
describe("prefix renames", () => {
test("migrates bb.plugin.open-ai.suggestions.* keys", () => {
localStorage.setItem(
"bb.plugin.open-ai.suggestions.abc123",
'["SELECT 1"]'
);
localStorage.setItem(
"bb.plugin.open-ai.suggestions.def456",
'["SELECT 2"]'
);
migrateStorageKeys();
expect(localStorage.getItem("bb.ai.suggestions.abc123")).toBe(
'["SELECT 1"]'
);
expect(localStorage.getItem("bb.ai.suggestions.def456")).toBe(
'["SELECT 2"]'
);
expect(
localStorage.getItem("bb.plugin.open-ai.suggestions.abc123")
).toBeNull();
expect(
localStorage.getItem("bb.plugin.open-ai.suggestions.def456")
).toBeNull();
});
test("migrates bb.context-menu-button.* keys", () => {
localStorage.setItem("bb.context-menu-button.task-transition", '"approve"');
migrateStorageKeys();
expect(localStorage.getItem("bb.context-menu.task-transition")).toBe(
'"approve"'
);
expect(
localStorage.getItem("bb.context-menu-button.task-transition")
).toBeNull();
});
});
describe("UI scope key renames", () => {
test("migrates ui.list.collapse.{email}", () => {
const state = JSON.stringify({ section1: true, section2: false });
localStorage.setItem("[email protected]", state);
migrateStorageKeys();
expect(localStorage.getItem("[email protected]")).toBe(
state
);
expect(
localStorage.getItem("[email protected]")
).toBeNull();
});
test("migrates ui.intro.{email}", () => {
const state = JSON.stringify({ tip1: true });
localStorage.setItem("[email protected]", state);
migrateStorageKeys();
expect(localStorage.getItem("[email protected]")).toBe(state);
expect(localStorage.getItem("[email protected]")).toBeNull();
});
test("migrates {email}.require_reset_password", () => {
localStorage.setItem("[email protected]_reset_password", "true");
migrateStorageKeys();
expect(localStorage.getItem("[email protected]")).toBe(
"true"
);
expect(
localStorage.getItem("[email protected]_reset_password")
).toBeNull();
});
});
describe("full migration scenario", () => {
test("migrates all key types in a single run", () => {
// Static
localStorage.setItem("ui.backPath", "/dashboard");
// Language
localStorage.setItem(
"bytebase_options",
JSON.stringify({ appearance: { language: "ja-JP" } })
);
// SQL editor
localStorage.setItem("bb.sql-editor.result-rows-limit", "100");
localStorage.setItem("bb.sql-editor.last-viewed-project", '"projects/p1"');
// Connection expanded
localStorage.setItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]",
'{"initialized":true,"expandedKeys":["k1"]}'
);
// Tab keys
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'[{"id":"t1"},{"id":"t2"}]'
);
localStorage.setItem(
"bb.sql-editor-tab.projects/[email protected]",
'"t2"'
);
// Prefix
localStorage.setItem("bb.plugin.open-ai.suggestions.hash1", '["s1"]');
// UI scope
localStorage.setItem("[email protected]", '{"done":true}');
migrateStorageKeys();
// Verify all migrated
expect(localStorage.getItem(STORAGE_KEY_BACK_PATH)).toBe("/dashboard");
expect(localStorage.getItem(STORAGE_KEY_LANGUAGE)).toBe("ja-JP");
expect(localStorage.getItem(STORAGE_KEY_SQL_EDITOR_RESULT_LIMIT)).toBe(
"100"
);
expect(localStorage.getItem(storageKeySqlEditorLastProject(""))).toBe(
'"projects/p1"'
);
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe('{"initialized":true,"expandedKeys":["k1"]}');
expect(localStorage.getItem("bb.ai.suggestions.hash1")).toBe('["s1"]');
expect(localStorage.getItem("[email protected]")).toBe(
'{"done":true}'
);
// Tab keys
const tabs = JSON.parse(
localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")!
);
expect(tabs).toHaveLength(2);
expect(
localStorage.getItem("bb.sql-editor.current-tab.projects/[email protected]")
).toBe('"t2"');
// Verify old keys removed
expect(localStorage.getItem("ui.backPath")).toBeNull();
expect(localStorage.getItem("bytebase_options")).toBeNull();
expect(localStorage.getItem("bb.sql-editor.result-rows-limit")).toBeNull();
expect(
localStorage.getItem("bb.sql-editor.last-viewed-project")
).toBeNull();
expect(
localStorage.getItem(
"bb.sql-editor.connection-pane.expanded_environments/[email protected]"
)
).toBeNull();
expect(
localStorage.getItem("bb.plugin.open-ai.suggestions.hash1")
).toBeNull();
expect(localStorage.getItem("[email protected]")).toBeNull();
expect(
localStorage.getItem(
"bb.sql-editor-tab.projects/[email protected]"
)
).toBeNull();
expect(
localStorage.getItem(
"bb.sql-editor-tab.projects/[email protected]"
)
).toBeNull();
// Marker set
expect(localStorage.getItem(MIGRATION_MARKER)).toBe("1");
});
test("handles empty localStorage gracefully", () => {
migrateStorageKeys();
expect(localStorage.getItem(MIGRATION_MARKER)).toBe("1");
expect(localStorage.length).toBe(2); // only the v1 and v2 markers
});
test("preserves unrelated keys", () => {
localStorage.setItem("some.other.key", "value");
localStorage.setItem("bb.sql-editor.result-rows-limit", "500");
migrateStorageKeys();
expect(localStorage.getItem("some.other.key")).toBe("value");
});
});
describe("v2: worksheet → saved query rename", () => {
const MARKER_V2 = "bb.storage-migration-v2";
test("moves saved-query pref keys, preserving values and scope segments", () => {
localStorage.setItem(
"bb.sql-editor.worksheet-filter.projects/[email protected]",
'{"mine":true}'
);
localStorage.setItem(
"bb.sql-editor.worksheet-tree.ws1.projects/[email protected]",
'["k1"]'
);
localStorage.setItem(
"bb.sql-editor.worksheet-folder.projects/[email protected]",
'["f1"]'
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.saved-query-filter.projects/[email protected]"
)
).toBe('{"mine":true}');
expect(
localStorage.getItem(
"bb.sql-editor.saved-query-tree.ws1.projects/[email protected]"
)
).toBe('["k1"]');
expect(
localStorage.getItem(
"bb.sql-editor.saved-query-folder.projects/[email protected]"
)
).toBe('["f1"]');
expect(
localStorage.getItem("bb.sql-editor.worksheet-filter.projects/[email protected]")
).toBeNull();
expect(localStorage.getItem(MARKER_V2)).toBe("1");
});
test("does not overwrite an existing saved-query pref key", () => {
localStorage.setItem(
"bb.sql-editor.worksheet-filter.projects/[email protected]",
"old"
);
localStorage.setItem(
"bb.sql-editor.saved-query-filter.projects/[email protected]",
"new"
);
migrateStorageKeys();
expect(
localStorage.getItem(
"bb.sql-editor.saved-query-filter.projects/[email protected]"
)
).toBe("new");
});
test("rewrites persisted tabs already under the current key", () => {
// Users upgraded past v1 have tabs at the new key with legacy fields.
localStorage.setItem(MIGRATION_MARKER, "1");
localStorage.setItem(
"bb.sql-editor.tabs.projects/[email protected]",
JSON.stringify([
{
id: "t1",
worksheet: "projects/p1/worksheets/ws-1",
mode: "WORKSHEET",
},
{
id: "t2",
savedQuery: "projects/p1/savedQueries/ws-2",
mode: "ADMIN",
},
{ id: "t3" },
])
);
migrateStorageKeys();
expect(localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")).toBe(
JSON.stringify([
{
id: "t1",
savedQuery: "projects/p1/savedQueries/ws-1",
mode: "SAVED_QUERY",
},
{
id: "t2",
savedQuery: "projects/p1/savedQueries/ws-2",
mode: "ADMIN",
},
{ id: "t3" },
])
);
});
test("leaves malformed tab values alone", () => {
localStorage.setItem("bb.sql-editor.tabs.projects/[email protected]", "not-json");
migrateStorageKeys();
expect(localStorage.getItem("bb.sql-editor.tabs.projects/[email protected]")).toBe(
"not-json"
);
});
test("maps the persisted sidebar tab value", () => {
localStorage.setItem(
"bb.sql-editor.sidebar.last-visited-tab.projects/p1",
'"WORKSHEET"'
);
localStorage.setItem(
"bb.sql-editor.sidebar.last-visited-tab.projects/p2",
'"SCHEMA"'
);
migrateStorageKeys();
expect(
localStorage.getItem("bb.sql-editor.sidebar.last-visited-tab.projects/p1")
).toBe('"SAVED_QUERY"');
expect(
localStorage.getItem("bb.sql-editor.sidebar.last-visited-tab.projects/p2")
).toBe('"SCHEMA"');
});
test("skips when the v2 marker is set", () => {
localStorage.setItem(MARKER_V2, "1");
localStorage.setItem(
"bb.sql-editor.worksheet-filter.projects/[email protected]",
"old"
);
migrateStorageKeys();
expect(
localStorage.getItem("bb.sql-editor.worksheet-filter.projects/[email protected]")
).toBe("old");
});
});
describe("migrateUserStorage", () => {
test("migrates keys ending with old email to new email", () => {
localStorage.setItem("[email protected]", '{"visits":[]}');
localStorage.setItem("[email protected]", '["link1"]');
migrateUserStorage("[email protected]", "[email protected]");
expect(localStorage.getItem("[email protected]")).toBe(
'{"visits":[]}'
);
expect(localStorage.getItem("[email protected]")).toBe(
'["link1"]'
);
expect(localStorage.getItem("[email protected]")).toBeNull();
expect(localStorage.getItem("[email protected]")).toBeNull();
});
test("migrates keys with variable middle segments", () => {
localStorage.setItem(
"bb.sql-editor.tabs.projects/[email protected]",
'[{"id":"tab1"}]'
);
localStorage.setItem(
"bb.sql-editor.conn-expanded.environments/[email protected]",
'{"expanded":true}'
);
migrateUserStorage("[email protected]", "[email protected]");
expect(
localStorage.getItem(
"bb.sql-editor.tabs.projects/[email protected]"
)
).toBe('[{"id":"tab1"}]');
expect(
localStorage.getItem(
"bb.sql-editor.conn-expanded.environments/[email protected]"
)
).toBe('{"expanded":true}');
});
test("does not migrate keys not ending with old email", () => {
localStorage.setItem("bb.language", '"en-US"');
localStorage.setItem("bb.onboarding", '{"step":1}');
localStorage.setItem("[email protected]", '{"x":1}');
migrateUserStorage("[email protected]", "[email protected]");
expect(localStorage.getItem("bb.language")).toBe('"en-US"');
expect(localStorage.getItem("bb.onboarding")).toBe('{"step":1}');
expect(localStorage.getItem("[email protected]")).toBe(
'{"x":1}'
);
});
test("overwrites existing keys at new location", () => {
localStorage.setItem("[email protected]", '{"old":true}');
localStorage.setItem("[email protected]", '{"new":true}');
migrateUserStorage("[email protected]", "[email protected]");
expect(localStorage.getItem("[email protected]")).toBe(
'{"old":true}'
);
});
test("returns early when oldEmail is empty", () => {
localStorage.setItem("[email protected]", '{"x":1}');
migrateUserStorage("", "[email protected]");
expect(localStorage.getItem("[email protected]")).toBe(
'{"x":1}'
);
});
test("returns early when newEmail is empty", () => {
localStorage.setItem("[email protected]", '{"x":1}');
migrateUserStorage("[email protected]", "");
expect(localStorage.getItem("[email protected]")).toBe(
'{"x":1}'
);
});
test("returns early when emails are the same", () => {
localStorage.setItem("[email protected]", '{"x":1}');
migrateUserStorage("[email protected]", "[email protected]");
expect(localStorage.getItem("[email protected]")).toBe(
'{"x":1}'
);
});
test("handles empty localStorage gracefully", () => {
migrateUserStorage("[email protected]", "[email protected]");
expect(localStorage.length).toBe(0);
});
test("migrates all 17 key families", () => {
const email = "[email protected]";
const newEmail = "[email protected]";
// Set up all key families
localStorage.setItem(`bb.recent-visit.${email}`, "1");
localStorage.setItem(`bb.recent-projects.${email}`, "2");
localStorage.setItem(`bb.quick-access.${email}`, "3");
localStorage.setItem(`bb.last-activity.${email}`, "4");
localStorage.setItem(`bb.collapse-state.${email}`, "5");
localStorage.setItem(`bb.intro-state.${email}`, "6");
localStorage.setItem(`bb.iam-remind.${email}`, "7");
localStorage.setItem(`bb.reset-password.${email}`, "8");
localStorage.setItem(`bb.search./dashboard.${email}`, "9");
localStorage.setItem(`bb.sql-editor.tabs.projects/p1.${email}`, "10");
localStorage.setItem(
`bb.sql-editor.current-tab.projects/p1.${email}`,
"11"
);
localStorage.setItem(`bb.sql-editor.conn-expanded.env/prod.${email}`, "12");
localStorage.setItem(`bb.sql-editor.conn-expanded-keys.${email}`, "13");
localStorage.setItem(
`bb.sql-editor.saved-query-filter.projects/p1.${email}`,
"14"
);
localStorage.setItem(
`bb.sql-editor.saved-query-tree.projects/p1.${email}`,
"15"
);
localStorage.setItem(
`bb.sql-editor.saved-query-folder.projects/p1.list.${email}`,
"16"
);
localStorage.setItem(`bb.sql-editor.ai-suggestion.${email}`, "17");
migrateUserStorage(email, newEmail);
// Verify all migrated
expect(localStorage.getItem(`bb.recent-visit.${newEmail}`)).toBe("1");
expect(localStorage.getItem(`bb.recent-projects.${newEmail}`)).toBe("2");
expect(localStorage.getItem(`bb.quick-access.${newEmail}`)).toBe("3");
expect(localStorage.getItem(`bb.last-activity.${newEmail}`)).toBe("4");
expect(localStorage.getItem(`bb.collapse-state.${newEmail}`)).toBe("5");
expect(localStorage.getItem(`bb.intro-state.${newEmail}`)).toBe("6");
expect(localStorage.getItem(`bb.iam-remind.${newEmail}`)).toBe("7");
expect(localStorage.getItem(`bb.reset-password.${newEmail}`)).toBe("8");
expect(localStorage.getItem(`bb.search./dashboard.${newEmail}`)).toBe("9");
expect(
localStorage.getItem(`bb.sql-editor.tabs.projects/p1.${newEmail}`)
).toBe("10");
expect(
localStorage.getItem(`bb.sql-editor.current-tab.projects/p1.${newEmail}`)
).toBe("11");
expect(
localStorage.getItem(`bb.sql-editor.conn-expanded.env/prod.${newEmail}`)
).toBe("12");
expect(
localStorage.getItem(`bb.sql-editor.conn-expanded-keys.${newEmail}`)
).toBe("13");
expect(
localStorage.getItem(
`bb.sql-editor.saved-query-filter.projects/p1.${newEmail}`
)
).toBe("14");
expect(
localStorage.getItem(
`bb.sql-editor.saved-query-tree.projects/p1.${newEmail}`
)
).toBe("15");
expect(
localStorage.getItem(
`bb.sql-editor.saved-query-folder.projects/p1.list.${newEmail}`
)
).toBe("16");
expect(
localStorage.getItem(`bb.sql-editor.ai-suggestion.${newEmail}`)
).toBe("17");
// Verify old keys removed
expect(localStorage.getItem(`bb.recent-visit.${email}`)).toBeNull();
expect(
localStorage.getItem(`bb.sql-editor.tabs.projects/p1.${email}`)
).toBeNull();
});
});