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

describe.skip("github issues > #838 Time zones for timestamp columns are incorrectly fetched and persisted in PostgreSQL", () => {
    let connections: DataSource[]
    let postgresConnection: DataSource
    const testDateString = "1989-08-16T10:00:00+03:00"

    before(async () => {
        connections = await createTestingConnections({
            entities: [__dirname + "/entity/*{.js,.ts}"],
            enabledDrivers: ["postgres"],
        })
        postgresConnection = connections.find(
            (connection) => connection.driver.options.type === "postgres",
        )!
    })

    beforeEach(() => reloadTestingDatabases(connections))

    after(() => closeTestingConnections(connections))

    it("should return date & time stored in PostgreSQL database correctly", async () => {
        // await postgresConnection.query(`INSERT INTO "flight" ("id", "date") VALUES (1, '1989-08-16 14:00:00.000000 +03:00');`);
        // const results = await postgresConnection.query(`SELECT date FROM "flight" WHERE id = 1`);
        // console.log(results);
        await postgresConnection.query(
            `INSERT INTO "flight" ("id", "date") VALUES (1, '${testDateString}');`,
        )
        const flight = await postgresConnection.manager.findOneBy(Flight, {
            id: 1,
        })
        expect(flight!.date.toISOString()).to.equal(
            new Date(testDateString).toISOString(),
        )
    })

    it("should persist date & time to the PostgreSQL database correctly", async () => {
        const testDate = new Date(testDateString)
        await postgresConnection.manager.save(new Flight(1, testDate))

        const results = await postgresConnection.query(
            `SELECT "date" FROM "flight" WHERE id = 1`,
        )

        expect(results[0].date.toISOString()).to.equal(testDate.toISOString())
    })
})