import 'reflect-metadata';
import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { DataSource } from '../../../src';
import { UserEntity } from './entity/UserEntity';
import { UserToOrganizationEntity } from './entity/UserToOrganizationEntity';
import { OrganizationEntity } from './entity/OrganizationEntity';

describe('github issues > #1703 Many to Many with association table returns odd values.', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
				enabledDrivers: ['postgres'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should work as expected', () =>
		Promise.all(
			connections.map(async (connection) => {
				const user1 = new UserEntity();
				const user2 = new UserEntity();
				const user3 = new UserEntity();
				await connection.manager.save(user1);
				await connection.manager.save(user2);
				await connection.manager.save(user3);

				const organization1 = new OrganizationEntity();
				const organization2 = new OrganizationEntity();
				const organization3 = new OrganizationEntity();
				await connection.manager.save(organization1);
				await connection.manager.save(organization2);
				await connection.manager.save(organization3);

				const userOrganization1 = new UserToOrganizationEntity();
				userOrganization1.role = 'owner';
				userOrganization1.user = user1;
				userOrganization1.organization = organization1;
				await connection.manager.save(userOrganization1);

				const userOrganization2 = new UserToOrganizationEntity();
				userOrganization2.role = 'owner';
				userOrganization2.user = user2;
				userOrganization2.organization = organization2;
				await connection.manager.save(userOrganization2);

				const userOrganization3 = new UserToOrganizationEntity();
				userOrganization3.role = 'owner';
				userOrganization3.user = user2;
				userOrganization3.organization = organization3;
				await connection.manager.save(userOrganization3);

				await connection.manager
					.createQueryBuilder(OrganizationEntity, 'organization')
					.leftJoinAndSelect('organization.users', 'users')
					.getMany();

				// console.log(organizations);
			}),
		));
});