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

describe("github issues > #587 Ordering of fields in composite indexes defined using Index decorator", () => {
    let connections: DataSource[]
    before(
        async () =>
            (connections = await createTestingConnections({
                entities: [__dirname + "/entity/*{.js,.ts}"],
                enabledDrivers: ["mysql"],
            })),
    )
    beforeEach(() => reloadTestingDatabases(connections))
    after(() => closeTestingConnections(connections))

    // this test only works for fields specified as string[]
    it("should preserve field ordering when fields are specified as string[]", () =>
        Promise.all(
            connections.map(async (connection) => {
                connection.entityMetadatas.forEach((entityMetadata) => {
                    entityMetadata.indices.forEach((index) => {
                        if (
                            index.givenColumnNames &&
                            Array.isArray(index.givenColumnNames)
                        ) {
                            for (let i = 0; i < index.columns.length; i++) {
                                const givenColumn = (
                                    index.givenColumnNames as string[]
                                )[i]
                                const actualColumn = index.columns[i]
                                actualColumn.propertyName.should.equal(
                                    givenColumn,
                                )
                            }
                        }
                    })
                })
            }),
        ))
})