import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { DataSource } from '../../../src';
import { assert } from 'chai';
import { User } from './entity/User';
import { TournamentUserParticipant } from './entity/TournamentUserParticipant';
import { TournamentSquadParticipant } from './entity/TournamentSquadParticipant';

describe('github issues > #1972 STI problem - empty columns', () => {
	let connections: DataSource[];

	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [__dirname + '/entity/*{.js,.ts}'],
				enabledDrivers: ['postgres'],
			})),
	);

	beforeEach(() => reloadTestingDatabases(connections));

	after(() => closeTestingConnections(connections));

	it('should insert with userId', () =>
		Promise.all(
			connections.map(async (connection) => {
				// create user
				const user = new User({
					name: 'test',
				});
				await connection.manager.save(user);

				// create user participant
				const tournamentUserParticipant = new TournamentUserParticipant({
					user,
				});
				await connection.manager.save(tournamentUserParticipant);

				// find user participant in the DB
				const result = await connection.manager.findOneBy(TournamentUserParticipant, {
					id: tournamentUserParticipant.id,
				});
				if (result) {
					assert(result.user instanceof User);
				}
			}),
		));

	it('should insert with ownerId', () =>
		Promise.all(
			connections.map(async (connection) => {
				// create user
				const user = new User({
					name: 'test',
				});
				await connection.manager.save(user);

				// create tournament squad participant
				const tournamentSquadParticipant = new TournamentSquadParticipant({
					users: [user],
					owner: user,
				});
				await connection.manager.save(tournamentSquadParticipant);

				// find squad participant in the DB
				const result = await connection.manager.findOneBy(TournamentSquadParticipant, {
					id: tournamentSquadParticipant.id,
				});

				if (result) {
					assert(result.owner instanceof User);
				}
			}),
		));
});