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

describe("github issues > #70 cascade deleting works incorrect", () => {

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

    it("should persist successfully and return persisted entity", () => Promise.all(connections.map(async connection => {

        // create objects to save
        const category1 = new Category();
        category1.name = "category #1";

        const category2 = new Category();
        category2.name = "category #2";

        const post = new Post();
        post.title = "Hello Post #1";
        post.categories = [category1, category2];

        // persist post (other are persisted by cascades)
        await connection.manager.save(post);

        // check that all persisted objects exist
        const loadedPost = await connection.manager
            .createQueryBuilder(Post, "post")
            .innerJoinAndSelect("post.categories", "category")
            .orderBy("post.id, category.id")
            .getOne()!;

        const loadedCategories = await connection.manager
            .createQueryBuilder(Category, "category")
            .orderBy("category.id")
            .getMany();

        expect(loadedPost!).not.to.be.empty;
        loadedPost!.should.include({
            id: 1,
            title: "Hello Post #1"
        });
        loadedPost!.categories.length.should.be.equal(2);

        expect(loadedCategories).not.to.be.empty;
        loadedCategories[0].id.should.be.equal(1);
        loadedCategories[1].id.should.be.equal(2);

        // now remove post. categories should be removed too
        await connection.manager.remove(post);

        // load them again to make sure they are not exist anymore
        const loadedPosts2 = await connection.manager
            .createQueryBuilder(Post, "post")
            .getMany();

        const loadedCategories2 = await connection.manager
            .createQueryBuilder(Category, "category")
            .getMany();

        expect(loadedPosts2).to.be.empty;
        expect(loadedCategories2).to.be.empty;

    })));

});