// ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
// ┃ ██████ ██████ ██████       █      █      █      █      █ █▄  ▀███ █       ┃
// ┃ ▄▄▄▄▄█ █▄▄▄▄▄ ▄▄▄▄▄█  ▀▀▀▀▀█▀▀▀▀▀ █ ▀▀▀▀▀█ ████████▌▐███ ███▄  ▀█ █ ▀▀▀▀▀ ┃
// ┃ █▀▀▀▀▀ █▀▀▀▀▀ █▀██▀▀ ▄▄▄▄▄ █ ▄▄▄▄▄█ ▄▄▄▄▄█ ████████▌▐███ █████▄   █ ▄▄▄▄▄ ┃
// ┃ █      ██████ █  ▀█▄       █ ██████      █      ███▌▐███ ███████▄ █       ┃
// ┣━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┫
// ┃ 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 { describeDuckDB } from "./setup.js";

describeDuckDB("min_max", (getClient) => {
    test("get_min_max() on integer column", async function () {
        const table = await getClient().open_table("memory.superstore");
        const view = await table.view({ columns: ["Quantity"] });
        const result = await view.get_min_max("Quantity");
        expect(result[0]).toBe(1);
        expect(result[1]).toBe(14);
        await view.delete();
    });

    test("get_min_max() on float column", async function () {
        const table = await getClient().open_table("memory.superstore");
        const view = await table.view({ columns: ["Sales"] });
        const result = await view.get_min_max("Sales");
        expect(result[0]).toBe(0.444);
        expect(result[1]).toBe(22638.48);
        await view.delete();
    });

    test("get_min_max() on string column", async function () {
        const table = await getClient().open_table("memory.superstore");
        const view = await table.view({ columns: ["Category"] });
        const result = await view.get_min_max("Category");
        expect(result[0]).toBe("Furniture");
        expect(result[1]).toBe("Technology");
        await view.delete();
    });

    test("get_min_max() with group_by", async function () {
        const table = await getClient().open_table("memory.superstore");
        const view = await table.view({
            columns: ["Sales"],
            group_by: ["Region"],
            aggregates: { Sales: "sum" },
        });
        const result = await view.get_min_max("Sales");
        expect(result[0]).toBeGreaterThan(0);
        expect(result[1]).toBeGreaterThan(0);
        expect(result[1]).toBeGreaterThanOrEqual(result[0]);
        await view.delete();
    });

    test("get_min_max() with filter", async function () {
        const table = await getClient().open_table("memory.superstore");
        const view = await table.view({
            columns: ["Quantity"],
            filter: [["Quantity", ">", 10]],
        });
        const result = await view.get_min_max("Quantity");
        expect(result[0]).toBeGreaterThanOrEqual(11);
        expect(result[1]).toBe(14);
        await view.delete();
    });
});