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

import { Post } from './entity/Post';
import { PostReview } from './entity/PostReview';

describe('github issues > #2588 - createQueryBuilder always does left joins on relations', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('Should allow joins with conditions', () =>
		Promise.all(
			connections.map(async (connection) => {
				const postRepo = connection.getRepository(Post);
				const postReviewRepo = connection.getRepository(PostReview);

				let post = new Post();
				post.title = 'My blog post';
				post = await postRepo.save(post);

				let reviews: PostReview[] = [];
				for (let i = 1; i <= 5; i++) {
					let review = new PostReview();
					review.comment = `I give it a ${i}`;
					review.rating = i;
					review.post = post;
					reviews.push(await postReviewRepo.save(review));
				}

				// Load the post
				let postFromDb = await postRepo.findOneBy({ id: post.id });
				expect(postFromDb).to.exist;
				expect(postFromDb!.reviews).lengthOf(5);

				const joinCondition = `${connection.driver.escape(
					'post_review',
				)}.${connection.driver.escape('postId')} = ${connection.driver.escape(
					'post',
				)}.${connection.driver.escape('id')} AND ${connection.driver.escape(
					'post_review',
				)}.${connection.driver.escape('rating')} >= 3`;

				postFromDb = await postRepo
					.createQueryBuilder('post')
					.where(`post.id = :postId`, { postId: post.id })
					.leftJoinAndSelect('post.reviews', 'post_review', joinCondition)
					.getOne();
				expect(postFromDb).to.exist;
				expect(postFromDb!.reviews).lengthOf(3);
			}),
		));
});