import "reflect-metadata";
import {closeTestingConnections, createTestingConnections, reloadTestingDatabases} from "../../utils/test-utils";
import {Connection} from "../../../src/connection/Connection";
import {expect} from "chai";
import {Car} from "./entity/Car";

describe("github issues > #479 orWhere breaks skip / take", () => {

    let connections: Connection[];
    before(async () => connections = await createTestingConnections({
        entities: [__dirname + "/entity/*{.js,.ts}"],
    }));
    beforeEach(() => reloadTestingDatabases(connections));
    after(() => closeTestingConnections(connections));

    it("where expression of the skip/take should not break original where query", () => Promise.all(connections.map(async connection => {

        const car1 = new Car();
        car1.name = "Test1";
        const car2 = new Car();
        car2.name = "Test2";
        const car3 = new Car();
        car3.name = "Test3";
        const car4 = new Car();
        car4.name = "BMW";
        const car5 = new Car();
        car5.name = "Mercedes";
        const car6 = new Car();
        car6.name = "Porshe";

        await connection
            .getRepository(Car)
            .save([car1, car2, car3, car4, car5, car6]);

        const cars = await connection
            .getRepository(Car)
            .createQueryBuilder("car")
            .where("car.name LIKE :filter1", { filter1: "Test%" })
            .orWhere("car.name LIKE :filter2", { filter2: "BM%" })
            .orderBy("car.id")
            .skip(0)
            .take(1)
            .getMany();

        expect(cars.length).to.be.equal(1);
    })));

});