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

import { expect } from "chai"
import { PostgresDriver } from "../../../src/driver/postgres/PostgresDriver"
import { VersionUtils } from "../../../src/util/VersionUtils"

describe("github issues > #9318 Change version query from SHOW server_version to SELECT version", () => {
    let connections: DataSource[]
    before(
        async () =>
            (connections = await createTestingConnections({
                entities: [],
                schemaCreate: false,
                dropSchema: true,
                enabledDrivers: ["postgres"],
            })),
    )
    beforeEach(() => reloadTestingDatabases(connections))
    after(() => closeTestingConnections(connections))

    it("should have proper isGeneratedColumnsSupported value for postgres version", () =>
        Promise.all(
            connections.map(async (connection) => {
                const { isGeneratedColumnsSupported } =
                    connection.driver as PostgresDriver
                const result = await connection.query("SELECT VERSION()")
                const dbVersion = result[0]["version"].replace(
                    /^PostgreSQL ([\d\.]+) .*$/,
                    "$1",
                )
                const versionGreaterOfEqualTo12 = VersionUtils.isGreaterOrEqual(
                    dbVersion,
                    "12.0",
                )

                expect(isGeneratedColumnsSupported).to.eq(
                    versionGreaterOfEqualTo12,
                )
            }),
        ))
})