116 lines
4.0 KiB
TypeScript
116 lines
4.0 KiB
TypeScript
import { expect, test, type Page } from "@playwright/test";
|
|
const ORIGIN = "http://127.0.0.1:4220";
|
|
async function local(page: Page) {
|
|
const out: string[] = [];
|
|
await page.route("**/*", async (r) => {
|
|
const u = new URL(r.request().url());
|
|
if (u.origin !== ORIGIN) {
|
|
out.push(u.href);
|
|
await r.abort();
|
|
} else await r.continue();
|
|
});
|
|
return out;
|
|
}
|
|
test("nested local query workflow", async ({ page }) => {
|
|
await page.setViewportSize({ width: 1800, height: 900 });
|
|
const external = await local(page);
|
|
await page.goto("/deep/nested/query/");
|
|
await expect(
|
|
page.getByRole("heading", { name: "Query Tools" }),
|
|
).toBeVisible();
|
|
await page
|
|
.getByRole("textbox", { name: "Query", exact: true })
|
|
.fill("SELECT name, score WHERE score >= 84 ORDER BY score DESC");
|
|
await page.getByRole("button", { name: "Run query" }).click();
|
|
await expect(page.getByRole("cell", { name: "Ada" })).toBeVisible();
|
|
expect(external).toEqual([]);
|
|
expect(
|
|
await page
|
|
.locator(".toolbox-shell__main")
|
|
.evaluate((n) => getComputedStyle(n).width),
|
|
).toBe("1440px");
|
|
});
|
|
test("retains results on an error and exports", async ({ page }) => {
|
|
await page.goto("/deep/nested/query/");
|
|
await page
|
|
.getByRole("textbox", { name: "Query", exact: true })
|
|
.fill("eval(data)");
|
|
await page.getByRole("button", { name: "Run query" }).click();
|
|
await expect(page.getByRole("status")).toContainText("last valid result");
|
|
const pending = page.waitForEvent("download");
|
|
await page.getByRole("button", { name: "JSON", exact: true }).click();
|
|
expect((await pending).suggestedFilename()).toBe("query-result.json");
|
|
});
|
|
test("runs the locally bundled bounded DuckDB worker in Chromium", async ({
|
|
page,
|
|
browserName,
|
|
request,
|
|
}) => {
|
|
test.skip(browserName !== "chromium", "Targeted DuckDB-WASM Chromium flow");
|
|
const external = await local(page);
|
|
await page.goto("/deep/nested/query/");
|
|
await page.getByLabel("Execution engine").selectOption("duckdb-wasm");
|
|
await page
|
|
.getByRole("textbox", { name: "Query", exact: true })
|
|
.fill(
|
|
"SELECT team, avg(score) AS average FROM data GROUP BY team ORDER BY team",
|
|
);
|
|
const wasmResponse = page.waitForResponse((response) =>
|
|
response.url().endsWith(".wasm"),
|
|
);
|
|
await page.getByRole("button", { name: "Run query" }).click();
|
|
await expect(page.getByRole("status")).toContainText(
|
|
"returned 2 result rows",
|
|
{
|
|
timeout: 60_000,
|
|
},
|
|
);
|
|
await expect(page.getByRole("cell", { name: "blue" })).toBeVisible();
|
|
const wasmUrl = (await wasmResponse).url();
|
|
const wasm = await request.get(wasmUrl);
|
|
expect(wasm.headers()["content-type"]).toBe("application/wasm");
|
|
expect(wasm.headers()["cache-control"]).toContain("immutable");
|
|
expect(wasm.headers()["content-security-policy"]).toContain(
|
|
"'wasm-unsafe-eval'",
|
|
);
|
|
expect(external).toEqual([]);
|
|
});
|
|
test("shell PWA headers, offline reload, and theme", async ({
|
|
page,
|
|
context,
|
|
request,
|
|
}) => {
|
|
await page.goto("/deep/nested/query/");
|
|
await page.getByRole("button", { name: "Help" }).click();
|
|
await expect(page.getByRole("dialog")).toContainText(
|
|
"never evaluate JavaScript",
|
|
);
|
|
await page.keyboard.press("Escape");
|
|
await page.getByRole("button", { name: "Personalize" }).click();
|
|
await page.getByRole("button", { name: "Dark" }).click();
|
|
await expect(page.locator(".toolbox-shell").first()).toHaveAttribute(
|
|
"data-toolbox-theme",
|
|
"dark",
|
|
);
|
|
expect(
|
|
await page.evaluate(async () =>
|
|
Boolean(await navigator.serviceWorker.ready),
|
|
),
|
|
).toBe(true);
|
|
await context.setOffline(true);
|
|
await page.reload();
|
|
await expect(
|
|
page.getByRole("heading", { name: "Query Tools" }),
|
|
).toBeVisible();
|
|
await context.setOffline(false);
|
|
const response = await request.get("/deep/nested/query/");
|
|
expect(response.headers()["content-security-policy"]).toContain(
|
|
"connect-src 'self'",
|
|
);
|
|
const manifest = await request.get("/deep/nested/query/toolbox-app.json");
|
|
await expect(manifest.json()).resolves.toMatchObject({
|
|
id: "de.add-ideas.query-tools",
|
|
version: "0.2.0",
|
|
});
|
|
});
|