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

describe("embedded > embedded-many-to-one-case2", () => {

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

    describe("owner side", () => {

        it("should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation", () => Promise.all(connections.map(async connection => {

            const post1 = new Post();
            post1.title = "About cars";
            post1.counters = new Counters();
            post1.counters.code = 1;
            post1.counters.comments = 1;
            post1.counters.favorites = 2;
            post1.counters.likes = 3;
            post1.counters.subcounters = new Subcounters();
            post1.counters.subcounters.version = 1;
            post1.counters.subcounters.watches = 5;
            await connection.getRepository(Post).save(post1);

            const post2 = new Post();
            post2.title = "About airplanes";
            post2.counters = new Counters();
            post2.counters.code = 2;
            post2.counters.comments = 2;
            post2.counters.favorites = 3;
            post2.counters.likes = 4;
            post2.counters.subcounters = new Subcounters();
            post2.counters.subcounters.version = 1;
            post2.counters.subcounters.watches = 10;
            await connection.getRepository(Post).save(post2);

            const post3 = new Post();
            post3.title = "About horses";
            post3.counters = new Counters();
            post3.counters.code = 3;
            post3.counters.comments = 5;
            post3.counters.favorites = 10;
            post3.counters.likes = 15;
            post3.counters.subcounters = new Subcounters();
            post3.counters.subcounters.version = 1;
            post3.counters.subcounters.watches = 30;
            await connection.getRepository(Post).save(post3);

            const user1 = new User();
            user1.name = "Alice";
            user1.likedPost = post1;
            await connection.getRepository(User).save(user1);

            const user2 = new User();
            user2.name = "Bob";
            user2.likedPost = post2;
            await connection.getRepository(User).save(user2);

            let loadedUsers = await connection.manager
                .createQueryBuilder(User, "user")
                .leftJoinAndSelect("user.likedPost", "likedPost")
                .orderBy("user.id")
                .getMany();

            expect(loadedUsers[0].should.be.eql(
                {
                    id: 1,
                    name: "Alice",
                    likedPost: {
                        id: 1,
                        title: "About cars",
                        counters: {
                            code: 1,
                            comments: 1,
                            favorites: 2,
                            likes: 3,
                            subcounters: {
                                version: 1,
                                watches: 5
                            }
                        }
                    }
                }
            ));
            expect(loadedUsers[1].should.be.eql(
                {
                    id: 2,
                    name: "Bob",
                    likedPost: {
                        id: 2,
                        title: "About airplanes",
                        counters: {
                            code: 2,
                            comments: 2,
                            favorites: 3,
                            likes: 4,
                            subcounters: {
                                version: 1,
                                watches: 10
                            }
                        }
                    }
                }
            ));

            let loadedUser = await connection.manager
                .createQueryBuilder(User, "user")
                .leftJoinAndSelect("user.likedPost", "likedPost")
                .where("user.id = :id", { id: 1 })
                .getOne();

            expect(loadedUser!.should.be.eql(
                {
                    id: 1,
                    name: "Alice",
                    likedPost: {
                        id: 1,
                        title: "About cars",
                        counters: {
                            code: 1,
                            comments: 1,
                            favorites: 2,
                            likes: 3,
                            subcounters: {
                                version: 1,
                                watches: 5
                            }
                        }
                    }
                }
            ));

            loadedUser!.name = "Anna";
            loadedUser!.likedPost = post3;
            await connection.getRepository(User).save(loadedUser!);

            loadedUser = await connection.manager
                .createQueryBuilder(User, "user")
                .leftJoinAndSelect("user.likedPost", "likedPost")
                .where("user.id = :id", { id: 1 })
                .getOne();

            expect(loadedUser!.should.be.eql(
                {
                    id: 1,
                    name: "Anna",
                    likedPost: {
                        id: 3,
                        title: "About horses",
                        counters: {
                            code: 3,
                            comments: 5,
                            favorites: 10,
                            likes: 15,
                            subcounters: {
                                version: 1,
                                watches: 30
                            }
                        }
                    }
                }
            ));

            await connection.getRepository(User).remove(loadedUser!);

            loadedUsers = (await connection.getRepository(User).find())!;
            expect(loadedUsers.length).to.be.equal(1);
            expect(loadedUsers[0].name).to.be.equal("Bob");
        })));
    });

    describe("inverse side", () => {

        it("should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation", () => Promise.all(connections.map(async connection => {

            const user1 = new User();
            user1.name = "Alice";
            await connection.getRepository(User).save(user1);

            const user2 = new User();
            user2.name = "Bob";
            await connection.getRepository(User).save(user2);

            const user3 = new User();
            user3.name = "Clara";
            await connection.getRepository(User).save(user3);

            const post1 = new Post();
            post1.title = "About cars";
            post1.counters = new Counters();
            post1.counters.code = 1;
            post1.counters.comments = 1;
            post1.counters.favorites = 2;
            post1.counters.likes = 3;
            post1.counters.likedUsers = [user1, user2];
            post1.counters.subcounters = new Subcounters();
            post1.counters.subcounters.version = 1;
            post1.counters.subcounters.watches = 5;
            await connection.getRepository(Post).save(post1);

            const post2 = new Post();
            post2.title = "About airplanes";
            post2.counters = new Counters();
            post2.counters.code = 2;
            post2.counters.comments = 2;
            post2.counters.favorites = 3;
            post2.counters.likes = 4;
            post2.counters.likedUsers = [user3];
            post2.counters.subcounters = new Subcounters();
            post2.counters.subcounters.version = 1;
            post2.counters.subcounters.watches = 10;
            await connection.getRepository(Post).save(post2);

            const loadedPosts = await connection.manager
                .createQueryBuilder(Post, "post")
                .leftJoinAndSelect("post.counters.likedUsers", "likedUser")
                .orderBy("post.id, likedUser.id")
                .getMany();

            expect(loadedPosts[0].should.be.eql(
                {
                    id: 1,
                    title: "About cars",
                    counters: {
                        code: 1,
                        comments: 1,
                        favorites: 2,
                        likes: 3,
                        likedUsers: [
                            { id: 1, name: "Alice" },
                            { id: 2, name: "Bob" }
                        ],
                        subcounters: {
                            version: 1,
                            watches: 5
                        }
                    }
                }
            ));
            expect(loadedPosts[1].should.be.eql(
                {
                    id: 2,
                    title: "About airplanes",
                    counters: {
                        code: 2,
                        comments: 2,
                        favorites: 3,
                        likes: 4,
                        likedUsers: [
                            { id: 3, name: "Clara" }
                        ],
                        subcounters: {
                            version: 1,
                            watches: 10
                        }
                    }
                }
            ));

            let loadedPost = await connection.manager
                .createQueryBuilder(Post, "post")
                .leftJoinAndSelect("post.counters.likedUsers", "likedUser")
                .orderBy("likedUser.id")
                .where("post.id = :id", { id: 1 })
                .getOne();

            expect(loadedPost!.should.be.eql(
                {
                    id: 1,
                    title: "About cars",
                    counters: {
                        code: 1,
                        comments: 1,
                        favorites: 2,
                        likes: 3,
                        likedUsers: [
                            { id: 1, name: "Alice" },
                            { id: 2, name: "Bob" }
                        ],
                        subcounters: {
                            version: 1,
                            watches: 5
                        }
                    }
                }
            ));

            loadedPost!.counters.favorites += 1;
            loadedPost!.counters.subcounters.watches += 1;
            loadedPost!.counters.likedUsers = [user1];
            await connection.getRepository(Post).save(loadedPost!);

            loadedPost = await connection.manager
                .createQueryBuilder(Post, "post")
                .leftJoinAndSelect("post.counters.likedUsers", "likedUser")
                .orderBy("likedUser.id")
                .where("post.id = :id", { id: 1 })
                .getOne();

            expect(loadedPost!.should.be.eql(
                {
                    id: 1,
                    title: "About cars",
                    counters: {
                        code: 1,
                        comments: 1,
                        favorites: 3,
                        likes: 3,
                        likedUsers: [
                            { id: 1, name: "Alice" }
                        ],
                        subcounters: {
                            version: 1,
                            watches: 6
                        }
                    }
                }
            ));

            const loadedUser = await connection.manager
                .createQueryBuilder(User, "user")
                .leftJoinAndSelect("user.likedPost", "likedPost")
                .where("user.id = :id", { id: 2 })
                .getOne();

            expect(loadedUser!.likedPost).to.be.null;
        })));
    });
});