wehub-resource-sync
109 lines
5.2 KiB
TypeScript
109 lines
5.2 KiB
TypeScript
// ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
|
|
// ┃ ██████ ██████ ██████ █ █ █ █ █ █▄ ▀███ █ ┃
|
|
// ┃ ▄▄▄▄▄█ █▄▄▄▄▄ ▄▄▄▄▄█ ▀▀▀▀▀█▀▀▀▀▀ █ ▀▀▀▀▀█ ████████▌▐███ ███▄ ▀█ █ ▀▀▀▀▀ ┃
|
|
// ┃ █▀▀▀▀▀ █▀▀▀▀▀ █▀██▀▀ ▄▄▄▄▄ █ ▄▄▄▄▄█ ▄▄▄▄▄█ ████████▌▐███ █████▄ █ ▄▄▄▄▄ ┃
|
|
// ┃ █ ██████ █ ▀█▄ █ ██████ █ ███▌▐███ ███████▄ █ ┃
|
|
// ┣━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┫
|
|
// ┃ Copyright (c) 2017, the Perspective Authors. ┃
|
|
// ┃ ╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌ ┃
|
|
// ┃ This file is part of the Perspective library, distributed under the terms ┃
|
|
// ┃ of the [Apache License 2.0](https://www.apache.org/licenses/LICENSE-2.0). ┃
|
|
// ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛
|
|
|
|
import { test, expect } from "@perspective-dev/test";
|
|
import perspective from "../perspective_client";
|
|
|
|
test.describe("to_csv", () => {
|
|
test("0-sided view returns CSV string", async () => {
|
|
const table = await perspective.table([
|
|
{ x: 1, y: "a" },
|
|
{ x: 2, y: "b" },
|
|
]);
|
|
const view = await table.view();
|
|
const csv = await view.to_csv();
|
|
expect(csv).toEqual('"x","y"\n1,"a"\n2,"b"\n');
|
|
view.delete();
|
|
table.delete();
|
|
});
|
|
|
|
test("respects start_row/end_row viewport", async () => {
|
|
const table = await perspective.table([
|
|
{ x: 1, y: "a" },
|
|
{ x: 2, y: "b" },
|
|
{ x: 3, y: "c" },
|
|
]);
|
|
const view = await table.view();
|
|
const csv = await view.to_csv({ start_row: 1, end_row: 2 });
|
|
expect(csv).toEqual('"x","y"\n2,"b"\n');
|
|
view.delete();
|
|
table.delete();
|
|
});
|
|
|
|
test("1-sided view emits row paths", async () => {
|
|
const table = await perspective.table([
|
|
{ x: 1, y: "a" },
|
|
{ x: 2, y: "a" },
|
|
{ x: 3, y: "b" },
|
|
]);
|
|
const view = await table.view({ group_by: ["y"] });
|
|
const csv = await view.to_csv();
|
|
expect(csv).toEqual(
|
|
'"y (Group by 1)","x","y"\n,6,3\n"a",3,2\n"b",3,1\n',
|
|
);
|
|
view.delete();
|
|
table.delete();
|
|
});
|
|
|
|
test("escapes quotes and commas in string values", async () => {
|
|
const table = await perspective.table([
|
|
{ x: 'he said "hi"', y: "a,b" },
|
|
]);
|
|
const view = await table.view();
|
|
const csv = await view.to_csv();
|
|
expect(csv).toEqual('"x","y"\n"he said ""hi""","a,b"\n');
|
|
view.delete();
|
|
table.delete();
|
|
});
|
|
|
|
// https://github.com/perspective-dev/perspective/issues/3152
|
|
test("escapes utf8 in string values", async () => {
|
|
const table = await perspective.table([
|
|
{
|
|
年月: "2023/01/01",
|
|
轄區分局: "第四分局",
|
|
路口名稱: "南屯區",
|
|
路口名稱split: "五權西路與環中路口",
|
|
A1: 0.0,
|
|
A2: 3.0,
|
|
A3: 130.0,
|
|
總件數: 18.0,
|
|
死亡人數: 0.0,
|
|
受傷人數: null,
|
|
主要肇因: "未注意車前狀態",
|
|
},
|
|
{
|
|
年月: "2023/01/01",
|
|
轄區分局: "第六分局",
|
|
路口名稱: "西屯區",
|
|
路口名稱split: "中清聯絡道與環中路口",
|
|
A1: 0.0,
|
|
A2: 2.0,
|
|
A3: 100.0,
|
|
總件數: 15.0,
|
|
死亡人數: 0.0,
|
|
受傷人數: null,
|
|
主要肇因: "未注意車前狀態",
|
|
},
|
|
]);
|
|
|
|
const view = await table.view();
|
|
const csv = await view.to_csv();
|
|
expect(csv).toEqual(
|
|
`"年月","轄區分局","路口名稱","路口名稱split","A1","A2","A3","總件數","死亡人數","主要肇因","受傷人數"\n2023-01-01,"第四分局","南屯區","五權西路與環中路口",0,3,130,18,0,"未注意車前狀態",\n2023-01-01,"第六分局","西屯區","中清聯絡道與環中路口",0,2,100,15,0,"未注意車前狀態",\n`,
|
|
);
|
|
|
|
view.delete();
|
|
table.delete();
|
|
});
|
|
});
|