Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

1.9 KB
Raw Blame
import * as Lib from "metabase-lib";
import { ORDERS_ID } from "metabase-types/api/mocks/presets";

import { SAMPLE_PROVIDER } from "./test-helpers";

describe("findColumnIndexesFromLegacyRefs", () => {
  const stageIndex = -1;

  it("should match columns that differ only by temporal buckets", () => {
    const query = Lib.createTestQuery(SAMPLE_PROVIDER, {
      stages: [
        {
          source: {
            type: "table",
            id: ORDERS_ID,
          },
          breakouts: [
            {
              type: "column",
              name: "CREATED_AT",
              unit: "year",
            },
            {
              type: "column",
              name: "CREATED_AT",
              unit: "month",
            },
          ],
        },
      ],
    });
    const columns = Lib.returnedColumns(query, stageIndex);
    const columnIndexes = Lib.findColumnIndexesFromLegacyRefs(
      query,
      stageIndex,
      columns,
      columns.map((column) => Lib.legacyRef(query, stageIndex, column)),
    );
    expect(columnIndexes).toEqual([0, 1]);
  });

  it("should match columns that differ only by binning", () => {
    const query = Lib.createTestQuery(SAMPLE_PROVIDER, {
      stages: [
        {
          source: {
            type: "table",
            id: ORDERS_ID,
          },
          breakouts: [
            {
              type: "column",
              name: "TOTAL",
              binning: { strategy: "num-bins", numBins: 10 },
            },
            {
              type: "column",
              name: "TOTAL",
              binning: { strategy: "num-bins", numBins: 50 },
            },
          ],
        },
      ],
    });
    const columns = Lib.returnedColumns(query, stageIndex);
    const columnIndexes = Lib.findColumnIndexesFromLegacyRefs(
      query,
      stageIndex,
      columns,
      columns.map((column) => Lib.legacyRef(query, stageIndex, column)),
    );
    expect(columnIndexes).toEqual([0, 1]);
  });
});