The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
import {
setupDatabasesEndpoints,
setupEnginesEndpoint,
setupListTransformsEndpoint,
setupUserAttributesEndpoint,
} from "__support__/server-mocks";
import { createMockSettingsState } from "__support__/state";
import { renderWithProviders, screen } from "__support__/ui";
import type { Database } from "metabase-types/api";
import {
createMockDatabase,
createMockEngine,
createMockEngines,
createMockSettings,
createMockUser,
} from "metabase-types/api/mocks";
import { DatabaseRoutingSection } from "./DatabaseRoutingSection";
interface SetupOpts {
database?: Database;
isAdmin?: boolean;
}
const setup = ({
database = createMockDatabase(),
isAdmin = true,
}: SetupOpts = {}) => {
setupUserAttributesEndpoint(["cool_guy", "boss_gal"]);
setupDatabasesEndpoints([database]);
setupListTransformsEndpoint([]);
setupEnginesEndpoint(
createMockEngines({
"bigquery-cloud-sdk": createMockEngine({
"driver-name": "Big Query",
"extra-info": {
"db-routing-info": {
text: "custom db routing info.",
},
},
}),
}),
);
renderWithProviders(<DatabaseRoutingSection database={database} />, {
storeInitialState: {
currentUser: createMockUser({ is_superuser: isAdmin }),
settings: createMockSettingsState(createMockSettings()),
},
});
};
describe("DatabaseRoutingSection", () => {
it("should render DatabaseRoutingSection", () => {
setup({
database: createMockDatabase({
engine: "postgres",
features: ["database-routing"],
}),
});
expect(screen.getByText("Database routing")).toBeInTheDocument();
expect(
screen.getByText(
"When someone views a question using data from this database, Metabase will send the queries to the destination database set by the person's user attribute. Each destination database must have identical schemas.",
),
).toBeInTheDocument();
expect(screen.getByText("Enable database routing")).toBeInTheDocument();
expect(screen.getByLabelText("Enable database routing")).toBeEnabled();
});
it("should render DatabaseRoutingSection with custom db_routing_info", async () => {
setup({
database: createMockDatabase({
engine: "bigquery-cloud-sdk",
features: ["database-routing"],
}),
});
expect(screen.getByText("Database routing")).toBeInTheDocument();
expect(
await screen.findByText("custom db routing info."),
).toBeInTheDocument();
expect(screen.getByText("Enable database routing")).toBeInTheDocument();
expect(screen.getByLabelText("Enable database routing")).toBeEnabled();
});
it("should hide section if database is attached DWH", () => {
setup({
database: createMockDatabase({
engine: "postgres",
is_attached_dwh: true,
features: ["database-routing"],
}),
});
expect(screen.queryByText("Database routing")).not.toBeInTheDocument();
});
it("should hide section if database is sample", () => {
setup({
database: createMockDatabase({
engine: "postgres",
is_sample: true,
features: ["database-routing"],
}),
});
expect(screen.queryByText("Database routing")).not.toBeInTheDocument();
});
it("should hide section if database routing is not supported by the db engine", async () => {
setup({
database: createMockDatabase({ engine: "clickhouse", features: [] }),
});
expect(screen.queryByText("Database routing")).not.toBeInTheDocument();
});
it("should let a non-admin with database management permission view but not change routing settings", async () => {
setup({
database: createMockDatabase({
engine: "postgres",
features: ["database-routing"],
router_user_attribute: "cool_guy",
}),
isAdmin: false,
});
expect(screen.getByText("Database routing")).toBeInTheDocument();
expect(screen.getByLabelText("Enable database routing")).toBeDisabled();
expect(
await screen.findByTestId("db-routing-user-attribute"),
).toBeDisabled();
expect(screen.queryByRole("link", { name: /Add/ })).not.toBeInTheDocument();
});
it("should let an admin change routing settings", async () => {
setup({
database: createMockDatabase({
engine: "postgres",
features: ["database-routing"],
router_user_attribute: "cool_guy",
}),
});
expect(screen.getByLabelText("Enable database routing")).toBeEnabled();
expect(
await screen.findByTestId("db-routing-user-attribute"),
).toBeEnabled();
expect(screen.getByRole("link", { name: /Add/ })).toBeInTheDocument();
});
it("should show a warning when writable connection is enabled", () => {
setup({
database: createMockDatabase({
engine: "postgres",
features: ["database-routing"],
write_data_details: { host: "localhost" },
}),
});
expect(
screen.getByText(
"Database routing can't be enabled when a Writable Connection is enabled.",
),
).toBeInTheDocument();
});
});