import 'reflect-metadata';
import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { DataSource } from '../../../src/data-source/DataSource';
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: DataSource[];
	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.null;

				// 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");
			}),
		));
});