import "reflect-metadata"
import {
    closeTestingConnections,
    createTestingConnections,
    reloadTestingDatabases,
} from "../../utils/test-utils"
import { DataSource } from "../../../src/data-source/DataSource"
import { Post } from "./entity/Post"
import { Category } from "./entity/Category"
import { expect } from "chai"

describe("github issues > #345 Join query on ManyToMany relations not working", () => {
    let connections: DataSource[]
    before(
        async () =>
            (connections = await createTestingConnections({
                entities: [__dirname + "/entity/*{.js,.ts}"],
            })),
    )
    beforeEach(() => reloadTestingDatabases(connections))
    after(() => closeTestingConnections(connections))

    it("embedded with custom column name should persist and load without errors", () =>
        Promise.all(
            connections.map(async (connection) => {
                for (let i = 0; i < 20; i++) {
                    const category = new Category()
                    category.name = "Category #" + i
                    await connection.manager.save(category)
                }

                const post = new Post()
                post.title = "SuperRace"
                post.categories = [new Category()]
                post.categories[0].name = "SuperCategory"
                await connection.manager.save(post)

                const loadedPost = await connection.manager
                    .createQueryBuilder(Post, "post")
                    .leftJoinAndSelect("post.categories", "category")
                    .where("category.category_id IN (:...ids)", { ids: [21] })
                    .getOne()

                expect(loadedPost).not.to.be.null
                expect(loadedPost!.categories).not.to.be.undefined
            }),
        ))
})