import "reflect-metadata";
import {closeTestingConnections, createTestingConnections, reloadTestingDatabases} from "../../utils/test-utils";
import {Connection} from "../../../src/connection/Connection";
import {Post} from "./entity/Post";
import {expect} from "chai";

// todo: fix this test

describe("github issues > #176 @CreateDateColumn and @UpdateDateColumn does not read back in UTC", () => {

    let connections: Connection[];
    before(async () => connections = await createTestingConnections({
        entities: [__dirname + "/entity/*{.js,.ts}"],
    }));
    beforeEach(() => reloadTestingDatabases(connections));
    after(() => closeTestingConnections(connections));

    it("should return dates in utc", () => Promise.all(connections.map(async connection => {

        const post1 = new Post();
        post1.title = "Hello Post #1";
        post1.date = new Date(1484069886663); // stores "2017-01-10 17:38:06.000" into the database
        // post1.localDate = new Date(1484069886663); // stores "2017-01-10 22:38:06.000" into the database

        // persist
        await connection.manager.save(post1);

        const loadedPosts1 = await connection.manager.findOne(Post, { where: { title: "Hello Post #1" } });
        expect(loadedPosts1!).not.to.be.empty;

        // loadedPosts1!.date.toISOString().should.be.equal("2017-01-10T17:38:06.000Z");
        // loadedPosts1!.localDate.toISOString().should.be.equal("2017-01-10T17:38:06.000Z");

        // also make sure that local date really was saved as a local date (including timezone)

        // const rawPost = await connection.manager
        //     .createQueryBuilder(Post, "post")
        //     .where("post.title = :title", { title: "Hello Post #1" })
        //     .getRawOne();

        // const date = !(rawPost["post_date"] instanceof Date) ? new Date(rawPost["post_date"]) : rawPost["post_date"];
        // date.toISOString().should.be.equal("2017-01-10T12:38:06.000Z");

        // const localDate = !(rawPost["post_localDate"] instanceof Date) ? new Date(rawPost["post_localDate"]) : rawPost["post_localDate"];
        // localDate.toISOString().should.be.equal("2017-01-10T17:38:06.000Z");
    })));

});