import "reflect-metadata"
import {
    closeTestingConnections,
    createTestingConnections,
    reloadTestingDatabases,
} from "../../utils/test-utils"
import { DataSource } from "../../../src/data-source/DataSource"
import { Animal } from "./entity/Animal"
import { OffsetWithoutLimitNotSupportedError } from "../../../src/error/OffsetWithoutLimitNotSupportedError"
import { DriverUtils } from "../../../src/driver/DriverUtils"

describe("github issues > #1099 BUG - QueryBuilder MySQL skip sql is wrong", () => {
    let connections: DataSource[]
    before(
        async () =>
            (connections = await createTestingConnections({
                entities: [__dirname + "/entity/*{.js,.ts}"],
            })),
    )
    beforeEach(() => reloadTestingDatabases(connections))
    after(() => closeTestingConnections(connections))

    it("drivers which does not support offset without limit should throw an exception, other drivers must work fine", () =>
        Promise.all(
            connections.map(async (connection) => {
                let animals = ["cat", "dog", "bear", "snake"]
                for (let animal of animals) {
                    await connection
                        .getRepository(Animal)
                        .save({ name: animal })
                }

                const qb = connection
                    .getRepository(Animal)
                    .createQueryBuilder("a")
                    .leftJoinAndSelect("a.categories", "categories")
                    .orderBy("a.id")
                    .skip(1)

                if (
                    DriverUtils.isMySQLFamily(connection.driver) ||
                    connection.driver.options.type === "aurora-mysql" ||
                    connection.driver.options.type === "sap" ||
                    connection.driver.options.type === "spanner"
                ) {
                    await qb
                        .getManyAndCount()
                        .should.be.rejectedWith(
                            OffsetWithoutLimitNotSupportedError,
                        )
                } else {
                    await qb.getManyAndCount().should.eventually.be.eql([
                        [
                            { id: 2, name: "dog", categories: [] },
                            { id: 3, name: "bear", categories: [] },
                            { id: 4, name: "snake", categories: [] },
                        ],
                        4,
                    ])
                }
            }),
        ))
})