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';

describe('other issues > joining empty relations', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should return empty array if its joined and nothing was found', () =>
		Promise.all(
			connections.map(async function (connection) {
				const post = new Post();
				post.title = 'Hello Post';
				await connection.manager.save(post);

				// check if ordering by main object works correctly

				const loadedPosts1 = await connection.manager
					.createQueryBuilder(Post, 'post')
					.leftJoinAndSelect('post.categories', 'categories')
					.getMany();

				expect(loadedPosts1).not.to.be.undefined;
				loadedPosts1.should.be.eql([
					{
						id: 1,
						title: 'Hello Post',
						categories: [],
					},
				]);
			}),
		));

	it('should return empty array if its joined and nothing was found, but relations in empty results should be skipped', () =>
		Promise.all(
			connections.map(async function (connection) {
				const post = new Post();
				post.title = 'Hello Post';
				await connection.manager.save(post);

				// check if ordering by main object works correctly

				const loadedPosts1 = await connection.manager
					.createQueryBuilder(Post, 'post')
					.leftJoinAndSelect('post.categories', 'categories')
					.leftJoinAndSelect('categories.authors', 'authors')
					.getMany();

				expect(loadedPosts1).not.to.be.undefined;
				loadedPosts1.should.be.eql([
					{
						id: 1,
						title: 'Hello Post',
						categories: [],
					},
				]);
			}),
		));
});