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

describe("github issues > #175 ManyToMany relation doesn't put an empty array when the relation is empty", () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should return post with categories if they are attached to the post', () =>
		Promise.all(
			connections.map(async (connection) => {
				const category1 = new Category();
				category1.name = 'category #1';
				await connection.manager.save(category1);

				const category2 = new Category();
				category2.name = 'category #2';
				await connection.manager.save(category2);

				const postWithCategories = new Post();
				postWithCategories.title = 'post with categories';
				postWithCategories.categories = [category1, category2];
				await connection.manager.save(postWithCategories);

				const loadedPost = await connection.manager
					.createQueryBuilder(Post, 'post')
					.leftJoinAndSelect('post.categories', 'categories')
					.where('post.title = :title', {
						title: 'post with categories',
					})
					.addOrderBy('categories.id')
					.getOne();

				expect(loadedPost).not.to.be.null;
				loadedPost!.should.be.eql({
					id: 1,
					title: 'post with categories',
					categories: [
						{
							id: 1,
							name: 'category #1',
						},
						{
							id: 2,
							name: 'category #2',
						},
					],
				});
			}),
		));

	it('should return post with categories even if post with empty categories was saved', () =>
		Promise.all(
			connections.map(async (connection) => {
				const category1 = new Category();
				category1.name = 'category #1';
				await connection.manager.save(category1);

				const category2 = new Category();
				category2.name = 'category #2';
				await connection.manager.save(category2);

				const postWithoutCategories = new Post();
				postWithoutCategories.title = 'post without categories';
				postWithoutCategories.categories = [];
				await connection.manager.save(postWithoutCategories);

				const justPost = new Post();
				justPost.title = 'just post';

				const loadedPost = await connection.manager
					.createQueryBuilder(Post, 'post')
					.leftJoinAndSelect('post.categories', 'categories')
					.where('post.title = :title', {
						title: 'post without categories',
					})
					.getOne();

				expect(loadedPost).not.to.be.null;
				loadedPost!.should.be.eql({
					id: 1,
					title: 'post without categories',
					categories: [],
				});
			}),
		));

	it('should return post with categories even if post was saved without categories set', () =>
		Promise.all(
			connections.map(async (connection) => {
				const category1 = new Category();
				category1.name = 'category #1';
				await connection.manager.save(category1);

				const category2 = new Category();
				category2.name = 'category #2';
				await connection.manager.save(category2);

				const justPost = new Post();
				justPost.title = 'just post';
				await connection.manager.save(justPost);

				const loadedPost = await connection.manager
					.createQueryBuilder(Post, 'post')
					.leftJoinAndSelect('post.secondaryCategories', 'secondaryCategories')
					.where('post.title = :title', { title: 'just post' })
					.getOne();

				expect(loadedPost).not.to.be.null;
				loadedPost!.should.be.eql({
					id: 1,
					title: 'just post',
					secondaryCategories: [],
				});
			}),
		));
});