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

describe('github issues > #71 ManyToOne relation with custom column name persistence fails', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should persist successfully entity successfully with its many-to-one relation', () =>
		Promise.all(
			connections.map(async (connection) => {
				const kollektion = new Kollektion();
				kollektion.name = 'kollektion #1';

				const artikel = new Artikel();
				artikel.name = 'artikel #1';
				artikel.nummer = '1';
				artikel.extrabarcode = '123456789';
				artikel.saison = '------';
				artikel.kollektion = kollektion;

				await connection.manager.save(artikel);

				const loadedArtikel = await connection.manager
					.createQueryBuilder(Artikel, 'artikel')
					.innerJoinAndSelect('artikel.kollektion', 'kollektion')
					.where('artikel.id=:id', { id: 1 })
					.getOne();

				expect(kollektion).not.to.be.null;
				expect(loadedArtikel).not.to.be.null;
				loadedArtikel!.should.be.eql({
					id: 1,
					nummer: '1',
					name: 'artikel #1',
					extrabarcode: '123456789',
					saison: '------',
					kollektion: {
						id: 1,
						name: 'kollektion #1',
					},
				});
			}),
		));
});