import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { DataSource } from '../../../src';
import { EntitySchema } from '../../../src';
import { Post, PostSchema } from './entity/Post';
import { expect } from 'chai';

describe('github issues > #3803 column option unique sqlite error', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				entities: [new EntitySchema<Post>(PostSchema)],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('should create unique constraints defined in EntitySchema', () =>
		Promise.all(
			connections.map(async (connection) => {
				const queryRunner = connection.createQueryRunner();
				const table = await queryRunner.getTable('post');
				await queryRunner.release();

				// MySQL stores unique constraints as unique indices

				expect(table!.uniques.length).to.be.equal(1);
				expect(table!.uniques[0].columnNames[0]).to.be.equal('name');
			}),
		));
});