import 'reflect-metadata';
import { DataSource } from '../../../src/data-source/DataSource';
import { closeTestingConnections, createTestingConnections } from '../../utils/test-utils';
import { User } from './entity/User';

describe('github issues > #3422 cannot save to nested-tree table if schema is used in postgres', () => {
	let connections: DataSource[];
	before(async () => {
		connections = await createTestingConnections({
			entities: [__dirname + '/entity/*{.js,.ts}'],
			enabledDrivers: ['postgres'],
			dropSchema: true,
		});
	});
	after(() => closeTestingConnections(connections));

	it('should not fail when using schema and nested-tree', () =>
		Promise.all(
			connections.map(async (connection) => {
				await connection.query('CREATE SCHEMA IF NOT EXISTS admin');
				await connection.synchronize();
				const parent = new User();
				await connection.manager.save(parent);
				const child = new User();
				child.manager = parent;
				await connection.manager.save(child);

				const user = await connection.manager.getRepository(User).findOne({
					where: {
						id: child.id,
					},
					relations: {
						manager: true,
					},
				});
				user!.id.should.be.equal(child.id);
				user!.manager.id.should.be.equal(parent.id);
			}),
		));
});