import MySqlDatabase from "../../../src/database/mySqlDatabase";

jest.mock("mysql2", () => {
  const mock = {
    createConnection: (config) => {
      expect(config).toEqual({
        host: "localhost",
        user: "user",
        password: "password",
        port: 3306,
      });
      return mock;
    },
    query: (query, callback) => {
      callback({
        sqlMessage: "table does not exist",
      });
    },
    end: () => true,
  };
  return mock;
});

test("it calls createConnection", () => {
  const db = new MySqlDatabase("localhost", "user", "password", 3306);
});

test("it calls callback if there is an error", async () => {
  const db = new MySqlDatabase("localhost", "user", "password", 3306);
  const sql = "SELECT some_column FROM some_table WHERE id = 1";
  expect(await db.lintQuery(sql)).toHaveProperty("sqlMessage", "table does not exist");
});

test("it calls end on connection", () => {
  const db = new MySqlDatabase("localhost", "user", "password", 3306);
  db.end();
});

test("it does not call callback if there is no error", () => {
  const callback = jest.fn(() => true);

  jest.mock("mysql2", () => {
    const mock = {
      createConnection: () => mock,
      query: () => true,
    };
    return mock;
  });

  expect(callback.mock.calls.length).toBe(0);
});