import 'reflect-metadata';
import { DataSource } from '../../../src';
import { createTestingConnections, closeTestingConnections } from '../../utils/test-utils';
import { Post as PostgresPost } from './entity/postgres/Post';
import { Post as SqlitePost } from './entity/sqlite/Post';

describe('github issues > #3991 Migration keeps changing @CreateDateColumn/@UpdateDateColumn timestamp column to same definition', () => {
	describe('postgres', () => {
		let connections: DataSource[];
		before(
			async () =>
				(connections = await createTestingConnections({
					enabledDrivers: ['postgres'],
					schemaCreate: false,
					dropSchema: true,
					entities: [PostgresPost],
				})),
		);
		after(() => closeTestingConnections(connections));

		it('should recognize model changes', () =>
			Promise.all(
				connections.map(async (connection) => {
					const sqlInMemory = await connection.driver.createSchemaBuilder().log();
					sqlInMemory.upQueries.length.should.be.greaterThan(0);
					sqlInMemory.downQueries.length.should.be.greaterThan(0);
				}),
			));

		it('should not generate queries when no model changes', () =>
			Promise.all(
				connections.map(async (connection) => {
					await connection.driver.createSchemaBuilder().build();
					const sqlInMemory = await connection.driver.createSchemaBuilder().log();
					sqlInMemory.upQueries.length.should.be.equal(0);
					sqlInMemory.downQueries.length.should.be.equal(0);
				}),
			));
	});

	describe('sqlite', () => {
		let connections: DataSource[];
		before(
			async () =>
				(connections = await createTestingConnections({
					enabledDrivers: ['sqlite', 'sqlite-pooled'],
					schemaCreate: false,
					dropSchema: true,
					entities: [SqlitePost],
				})),
		);
		after(() => closeTestingConnections(connections));

		it('should recognize model changes', () =>
			Promise.all(
				connections.map(async (connection) => {
					const sqlInMemory = await connection.driver.createSchemaBuilder().log();
					sqlInMemory.upQueries.length.should.be.greaterThan(0);
					sqlInMemory.downQueries.length.should.be.greaterThan(0);
				}),
			));

		it('should not generate queries when no model changes', () =>
			Promise.all(
				connections.map(async (connection) => {
					await connection.driver.createSchemaBuilder().build();
					const sqlInMemory = await connection.driver.createSchemaBuilder().log();
					sqlInMemory.upQueries.length.should.be.equal(0);
					sqlInMemory.downQueries.length.should.be.equal(0);
				}),
			));
	});
});