import { TableNotFound } from "../../../../../src/checker/checks/any/tableNotFound";
import { tokenise } from "../../../../../src/lexer/lexer";
import { putContentIntoLines } from "../../../../../src/reader/reader";
import { CheckerResult } from "../../../../../src/checker/checkerResult";
import { Query } from "../../../../../src/reader/query";

test.each([
  [
    "SELECT * FROM symfony.dont_exist ;",
    {
      content: "Table 'dont_exist' does not exist in database 'symfony'.",
      line: 1,
    },
  ],
])("It finds tables that don't exist", (query, expected) => {
  const checker = new TableNotFound([{ Table: "non_existent_table" }]);

  const queryObj = putContentIntoLines(query);
  const tokenised = tokenise(queryObj[0]);

  const actual = checker.check(tokenised);
  expect(actual).toMatchObject(expected);
});

test("It brings back an empty checkerResult for an empty query", () => {
  const checker = new TableNotFound([{ Table: "non_existent_table" }]);
  const query = new Query();
  const actual = checker.check(query);
  const expected = new CheckerResult(0, "");
  expect(actual).toEqual(expected);
});

test.each([
  ["non_existent_table", ["non_existent_table"]],
  ["", []],
])("It correctly cleans a table name", (table, expected) => {
  const checker = new TableNotFound([{ Table: table }]);
  const actual = checker.tables;
  expect(actual).toEqual(expected);
});