import { DataSource, Equal } from '../../../src';
import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { User } from './entity/User';
import { Photo } from './entity/Photo';

describe('github issues > #2031 Advanced find options with FKs', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
				enabledDrivers: ['postgres', 'sqlite-pooled'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('find operators should work with relational columns as well', () =>
		Promise.all(
			connections.map(async (connection) => {
				const user = new User();
				user.firstName = 'Timber';
				user.lastName = 'Saw';
				user.age = 25;
				await connection.manager.save(user);

				const photo = new Photo();
				photo.description = 'Tall trees';
				photo.uri = 'www.pictures.pic/1';
				photo.userId = user.id;
				await connection.manager.save(photo);

				const photos = await connection.manager.find(Photo, {
					where: { userId: Equal(user.id) },
				});
				photos.should.be.eql([
					{
						id: 1,
						description: 'Tall trees',
						uri: 'www.pictures.pic/1',
						userId: 1,
					},
				]);
			}),
		));
});