import 'reflect-metadata';
import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { DataSource } from '../../../src/data-source/DataSource';
import { Post } from './entity/Post';

describe.skip('github issues > #1147 FindOptions should be able to accept custom where condition', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
				schemaCreate: true,
				dropSchema: true,
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should properly query using custom sql', () =>
		Promise.all(
			connections.map(async (connection) => {
				for (let i = 1; i <= 5; i++) {
					const post1 = new Post();
					post1.title = `post ${i}`;
					await connection.manager.save(post1);
				}

				// this test is not valid anymore, because functionality behind it was removed

				// const posts = await connection.manager.find(Post, { where: "Post.title LIKE '%3'" });
				// posts.length.should.be.equal(1);
				// expect(posts[0].title).to.be.equal("post 3");
			}),
		));
});