import { JsonContains, DataSource } from "../../../src"
import {
    closeTestingConnections,
    createTestingConnections,
    reloadTestingDatabases,
} from "../../utils/test-utils"
import { Address } from "./entities/Address"
import { expect } from "chai"

describe("github issues > #9664 add JsonContains operator ", () => {
    let dataSources: DataSource[]

    before(async () => {
        dataSources = await createTestingConnections({
            entities: [Address],
            enabledDrivers: ["postgres"],
            schemaCreate: true,
            dropSchema: true,
        })
    })

    beforeEach(() => reloadTestingDatabases(dataSources))
    after(() => closeTestingConnections(dataSources))

    it("should find addresses in json field by name", async () => {
        await Promise.all(
            dataSources.map(async (dataSource) => {
                const address1 = new Address()
                address1.country = {
                    code: 1,
                    name: "United States",
                }
                address1.city = {
                    id: 1,
                    name: "New York",
                }

                const address2 = new Address()
                address2.country = {
                    code: 2,
                    name: "Germany",
                }
                address2.city = {
                    id: 2,
                    name: "Berlin",
                }

                await dataSource.manager.save([address1, address2])

                const addressesByName = await dataSource.manager.find(Address, {
                    where: {
                        city: JsonContains({ name: "Berlin" }),
                    },
                })

                const emptyAddressesResult = await dataSource.manager.find(
                    Address,
                    {
                        where: {
                            city: JsonContains({
                                name: "Berl",
                            }),
                        },
                    },
                )

                // check than operator find correctl
                expect(addressesByName).to.have.length(1)

                expect(
                    addressesByName.find(
                        (address) => address.city.name === "Berlin",
                    ),
                ).to.be.not.undefined

                // check than operator find correctly empty result
                expect(emptyAddressesResult).to.have.length(0)
            }),
        )
    })
})